Marketplace Profit Calculator for Meesho, Amazon and Flipkart Sellers: Fees, GST, TCS/TDS and RTO Losses

Sellers on Meesho, Amazon.in and Flipkart, especially in their first year, see a settlement far below the selling price and cannot tell why. This workbook walks the price down to real profit: commission, fixed or closing fee, shipping, payment fee, GST on those fees, product cost, packaging, ad cost, and the return or RTO loss you can expect. TCS and TDS are shown as credits you can claim, never as costs.

What's inside

• Marketplace-Profit-Calculator-v1.0.xlsx: 9 sheets (Start Here, Settings, Fee Tables, SKU Profit, Returns, Waterfall, Cash and Credits, Compare, Lists), with 15 fictional sample SKUs across 5 products, 3 categories and all three named marketplaces
• Marketplace-Profit-Calculator-Guide.pdf: a 12-page A4 guide, including a full worked example and a terms/FAQ page

How to use it

1. On Settings, pick your GST registration status, check the TCS, TDS and fee GST rates, and set your ad basis, claim recovery and write-off defaults.
2. On Fee Tables, check the Meesho, Amazon.in and Flipkart blocks against your own seller panel, and fill any cell marked "Not found on official page".
3. On SKU Profit, add a row per SKU per marketplace (up to 100) to see profit, margin, break-even price and break-even return rate.
4. Pick a SKU on Waterfall to see every step from selling price to profit, and on Returns to see the cost of one RTO and one customer return plus a sensitivity grid.

Requirements

• Microsoft Excel 2010 or later. The workbook uses only functions that Google Sheets also supports, and is laid out with the essentials in the first columns for use on a phone.

Good to know

• Fees change often. Every pre-filled fee carries the date it was checked and its official source URL; replace the values from your own seller panel before relying on them.
• Return and RTO rates are your own estimates, not predictions.