Net receivable per SKU on Myntra = net sale value (units sold minus returns, at the settled price) minus commission, other marketplace fees, taxes charged on those fees, and adjustments such as penalties. Take each input from the settlement and returns reports, and confirm rates against your seller agreement. Treat tax withheld at source as a separate line, not a cost.
What net receivable per SKU actually means
Net receivable per SKU is the amount you are entitled to keep from sales of one style or size after Myntra's deductions and after returns are accounted for. It is not the same as your bank payout, which bundles many SKUs, adjustments and timing differences into one credit.
Two versions are useful. Net receivable is the amount before any tax withheld at source. Net cash received is the amount after such withholdings. Keep them separate. Amounts withheld at source are generally creditable in your tax records, so they should not be read as a margin loss. Confirm the treatment with your tax adviser.
The formula to use for each SKU
For every SKU and settlement period, use this structure:
Net receivable = Net sale value − commission − other marketplace fees − taxes charged on those fees ± adjustments
- Net sale value: units sold multiplied by the price actually settled, less returned and cancelled units.
- Commission: as per your seller agreement or rate card. Whether it is reversed on returns, and how much, depends on your terms.
- Other fees: fixed fees, shipping or logistics charges, return handling and similar items that appear in your settlement report.
- Taxes on fees: GST charged on marketplace fees, as shown in the report or invoice.
- Adjustments: penalties, claim approvals, compensation, and any promotional contribution settled to or from you.
Rates and applicable fees differ by category, brand and contract, and they change over time. Do not hard-code percentages from memory. Pull them from your agreement and the latest rate card, and check tax rates with your tax adviser.
Where to find each input in your Myntra reports
- Sales or order report: SKU, order or item ID, units, order value and order status.
- Settlement or payout report: settled value, commission, fees, taxes on fees, tax withheld and adjustments, usually by order line.
- Returns report: returned units, return dates, return type and any reversal of commission or fees.
- Seller agreement and rate card: the agreed terms you compare the charged amounts against.
Column names and layouts can differ between report versions and over time. Map the columns once, write the mapping down, and recheck it whenever Myntra changes a template.
Step-by-step calculation
- Choose the settlement period and export the sales, settlement and returns reports for it.
- Join order lines to SKUs using the order or item ID, so every deduction lands against a SKU.
- Calculate net sale value per SKU: settled value of sold units minus returned and cancelled units.
- Add up commission, other fees, taxes on fees and adjustments for the same lines.
- Subtract the deductions from net sale value to get net receivable.
- Deduct tax withheld at source if you also want net cash received.
- Divide by net units to get the per-unit figure, and compare commission charged with your agreed terms.
Common mistakes that distort SKU-level numbers
- Mixing periods: a return in this cycle may belong to a sale from an earlier one. Decide whether you attribute it to the original sale (margin view) or the cycle it was settled in (cash view), and stick to it.
- Ignoring reversals: if fees on returned units are only partly reversed, your net per unit will be lower than expected.
- Allocating shared charges by guesswork: charges that are not tied to an order line should be shown separately, not spread arbitrarily across SKUs.
- Using list price instead of settled price: discounts and promotional contributions change the base on which charges are calculated.
- Treating withholdings as cost: this understates SKU profitability.
Tie SKU totals back to the bank payout
A SKU-level figure is only trustworthy if it adds up. Sum net receivable across all SKUs, add or subtract account-level items that are not tied to a SKU, and compare the result with the payout credited to your bank for the period. Any gap points to a timing difference, a missing return or an unexplained deduction.
Doing this by hand in Excel works for a few SKUs but gets slow at catalogue scale. 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 other marketplaces are a scoping discussion.
Worked example
Illustrative example only. All figures below are made-up numbers to show the method. They are not Myntra rates or real results.
One SKU, one settlement period: 10 units sold at ₹1,000 each, 2 units returned.
| Line | Amount (₹, illustrative) |
|---|---|
| Sale value (10 units × ₹1,000) | 10,000 |
| Less returned units (2 × ₹1,000) | −2,000 |
| Net sale value (8 units) | 8,000 |
| Less commission (after reversal on returns) | −1,200 |
| Less other fees | −450 |
| Less taxes charged on fees | −300 |
| Less penalties or adjustments | −100 |
| Net receivable | 5,950 |
| Less tax withheld at source | −80 |
| Net cash received | 5,870 |
Per net unit: ₹5,950 ÷ 8 = ₹743.75 net receivable, and ₹5,870 ÷ 8 = ₹733.75 net cash received. Compare the ₹1,200 commission with what your agreement says should apply to 8 net units, and ask why if it differs.
Questions and answers
Is net receivable per SKU the same as my Myntra payout?
No. The payout is a single credit covering many SKUs, adjustments and timing differences. Net receivable per SKU isolates one style after its sales, returns, commission, fees and taxes. Summing all SKUs plus account-level items should explain the payout.
Which Myntra commission rate should I use in the calculation?
Use the rate and fee terms in your signed seller agreement and the latest rate card, not a figure from memory or a forum. Rates vary by category and contract and can change, so confirm current terms with your Myntra account contact.
How should I treat returns in the SKU calculation?
Deduct returned units from net sale value and check whether commission and fees were reversed as your terms say. Choose one attribution method, original sale period or settlement period, and apply it consistently across all SKUs.
Should TCS or TDS be deducted from net receivable?
Show it as a separate line. Deduct it only when you want net cash received. Withheld tax is generally creditable in your tax records, so avoid counting it as cost. Confirm the correct treatment with your tax adviser.