Contribution margin per SKU is net revenue after returns, minus product cost, marketplace fees, shipping and packaging, return losses and the ad spend attributable to that SKU. Divide by units sold or by net revenue to get a per-unit figure or a percentage. Build it from settlement and order data on Amazon and Flipkart, not list price, so every fee and refund is counted at actual amounts.
What contribution margin per SKU actually measures
Contribution margin is what a SKU has left after the costs that move with each sale. It is not net profit, because it leaves out fixed overheads such as salaries, rent and software. It is more useful than gross margin for marketplace sellers because it includes the costs that gross margin hides: commission, fixed fees, fulfilment, returns and advertising.
Calculate it per SKU, and ideally per size or variant, because one size can have a far higher return rate than the rest of the style. A listing that looks healthy at the parent level can hide a loss-making variant.
Pull the right data from Amazon and Flipkart
Start with actual transaction data, not the price on the listing. For each marketplace, download these for the same period:
- Order and sales report: units, selling price, discounts and order status by SKU.
- Settlement or payment report: commission, fixed or closing fees, shipping or fulfilment fees, collection fees, refunds, reverse fees and adjustments.
- Returns report: returned units, reason, and whether the item came back sellable, damaged or not at all.
- Ad reports: spend by campaign and, where available, by advertised SKU.
- Your cost sheet: landed product cost, packaging and any inbound freight per unit.
Report names and columns differ by marketplace and change over time, so check the current report guides in your seller panel. For the fee rules that should apply to you, use your seller agreement and the latest rate card, and confirm the current version before you rely on it.
The step-by-step formula
- Start with net selling price per unit. Use the price after seller-funded discounts, excluding GST. Ask your tax adviser how GST, TCS and TDS should be treated in your management accounts. TCS and TDS mainly affect cash timing and credits, so keep them out of the margin unless your adviser says otherwise.
- Subtract refunds. Remove the revenue on units that were returned or cancelled after shipping to get net revenue.
- Subtract product cost for units kept by customers. Add the cost of returned units that cannot be resold.
- Subtract marketplace fees per SKU: commission, fixed fees, shipping or fulfilment fees, and reverse shipping on returns. Take these from the settlement report, not from an assumed percentage.
- Subtract your own variable costs: packaging, outbound shipping if you self-ship, and payment or handling charges.
- Subtract attributable ad spend. Use SKU-level spend where you have it. Otherwise allocate campaign spend by the share of ad-attributed sales.
- Divide. Contribution divided by units gives per-unit margin. Contribution divided by net revenue gives the percentage.
Treat returns, RTOs and ads carefully
Returns are where most SKU margins go wrong. A returned unit can cost you the forward fee, the reverse fee, packaging, and the product itself if it comes back damaged or does not come back. Whether the commission is refunded on a return depends on the marketplace terms and the return type, so read the settlement lines rather than assuming.
For ads, avoid spreading spend evenly across all SKUs. A hero SKU usually absorbs most of the spend. If your reports cannot attribute spend to a SKU, allocate by ad-attributed revenue and state that assumption in the sheet.
Keep a separate column for adjustments such as weight-slab corrections, penalties and claim credits. These are easy to miss, and they decide whether a thin margin is real or a fee error.
Common mistakes that distort SKU margins
- Using list price or MRP instead of the realised price after discounts.
- Applying a flat fee percentage to every SKU instead of the actual settlement lines.
- Counting only delivered orders and ignoring the cost of returns that arrive later.
- Mixing periods, for example June sales against July settlements, without matching by order.
- Ignoring that a SKU's category, price band or weight slab can change the fee that applies.
- Leaving out inbound freight, packaging and damaged-stock write-offs.
Make it repeatable and check fees against terms
A one-off sheet goes stale quickly. Rebuild it monthly, keep the same column logic, and flag any SKU whose margin falls below the threshold you set. When a SKU looks worse than expected, compare the fees charged with your agreed terms before you cut its price or ad budget.
MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today, and coverage of Amazon and Flipkart is in scope discussion, so ask Fundle what is supported for your setup.
Worked example
Illustrative example only. All ₹ figures below are made-up placeholders for one SKU over one month. They are not real rates. Replace them with figures from your own settlement reports and cost sheet.
| Line | Illustrative amount |
|---|---|
| Units shipped / returned / kept | 100 / 20 / 80 |
| Net selling price per unit, excl. GST | ₹800 |
| Gross sales (100 × ₹800) | ₹80,000 |
| Less refunds (20 × ₹800) | ₹16,000 |
| Net revenue | ₹64,000 |
| Product cost, kept units (80 × ₹350) | ₹28,000 |
| Cost of 6 unsellable returns (6 × ₹350) | ₹2,100 |
| Commission and fixed fees (from settlement) | ₹9,600 |
| Shipping or fulfilment fees (from settlement) | ₹7,000 |
| Reverse shipping on returns (from settlement) | ₹1,800 |
| Packaging (100 × ₹15) | ₹1,500 |
| Attributed ad spend | ₹4,000 |
| Contribution | ₹10,000 |
Per kept unit, contribution is ₹10,000 ÷ 80 = ₹125. Per shipped unit it is ₹100. As a share of net revenue it is about 15.6%. If the return rate rose from 20 to 30 units with everything else unchanged, the margin would shrink sharply, which is why returns need their own line.
Questions and answers
Should contribution margin include GST?
Calculate it on values excluding GST, since GST collected is not your income. How GST on marketplace fees, and TCS or TDS, should appear in your books depends on your registration and facts. Confirm the treatment with your tax adviser and use the latest rules.
Where do I find the fee rates for each SKU?
Use your seller agreement, the current rate card for your category and price band, and the fee lines in your settlement reports. Rates and slabs change, so confirm the latest version on the marketplace's seller portal instead of relying on remembered percentages.
How often should I recalculate SKU contribution margin?
Monthly works for most brands, with a quick weekly check on top-selling SKUs and anything running ads. Recalculate sooner after a fee change, a big promotion, a price revision or a spike in returns, since each can move margin quickly.
Can I do this in Excel, or do I need a tool?
Excel works when SKU counts are small and you can match settlements to orders by hand. As volumes and returns grow, matching becomes slow and error-prone. Tools like MarketplaceMetrics by Fundle can automate reconciliation, so ask what is supported for Amazon and Flipkart.
