To reconcile Myntra seller payments with orders, download the sales, returns and settlement reports for one period. Match settlement lines to delivered orders using a common order or item ID, deduct returns, recompute commission and fees from your agreed terms, add adjustments and tax deductions, then compare the result with the bank credit. Log every unexplained gap as a query.
Why Myntra payouts rarely equal order value
A payout is not the total of the orders you shipped. It is a net amount that starts from the value of delivered orders and then moves through returns, commission, other fees, adjustments and tax deductions. It can also include items from earlier days, so comparing one day's orders with one bank credit will almost never tie.
Reconciliation means explaining every rupee between order value and the amount that reached your bank. If you can show that bridge line by line, anything left over is a genuine query, not noise.
Data you need before you start
Gather these for the same period. Report names and columns differ by account and change over time, so check what your Myntra seller portal actually provides.
- Sales or order report: order or item ID, SKU, date, status and selling price.
- Returns report: customer returns and undelivered or returned-to-origin shipments, with dates.
- Settlement or payment report: line-level credits, deductions and the settlement total.
- Bank statement: the actual credits received.
- Your seller agreement and rate card: the commission and fee terms you agreed.
- Last period's open items: anything pending, so it is not counted twice.
Step-by-step: match orders to settlements
- Fix the period and the key. Pick one settlement cycle and use the order or item ID as the common key across all files. Keep everything in one Excel workbook, one tab per report.
- Tie the bank to the settlement. Confirm the bank credit equals the settlement total in the report. If not, the issue is in payment, not in orders.
- Map settlement lines to orders. Use a lookup on the order ID. Every credited line should match a delivered order. Flag lines with no matching order, and delivered orders with no settlement line.
- Apply returns. Check that each return in your returns report has a matching reversal, and that the reversal amount is consistent with the original sale.
- Recompute commission and fees. Calculate what you should have been charged from your terms, then compare with what was deducted (next section).
- Review adjustments and tax deductions. List every non-order line, such as penalties, reversals and tax deductions, and note its reason.
- Build the bridge. Delivered order value, less returns, less commission and fees, plus or minus adjustments, less tax deductions, should equal the payout. The gap is your exception list.
Common reasons payments do not match
| Cause | What to look for |
|---|---|
| Timing difference | Delivered orders that fall into the next settlement cycle |
| Late returns | Returns processed after the original order was settled, reversed in a later payout |
| Fee or commission variance | Deductions that differ from your agreed terms |
| Missing settlement | Delivered order with no credit after the expected cycle |
| Adjustments | Unexplained debits, duplicate reversals or one-off charges |
| Tax deductions | Amounts withheld that do not agree with your tax records |
Sort exceptions by amount first. A few large items usually explain most of the gap.
Checking commissions and fees against your terms
Do not assume deductions are right because they look consistent. Open your seller agreement and current rate card to find the commission and fee structure that applies to you. Rates can differ by category or price band and may be revised, so confirm the latest version with your Myntra account contact before you rely on a number.
Then recompute at line level. Start with a sample of 30 to 50 orders across categories, and extend to the full period if you find variances. Check that the right category, price and fee components were applied, and that fees were not charged on orders that were later returned unless your terms say so.
For tax deductions at source on the settlement, rules and rates are set by law and may change. Match them to the statements available to you and ask your tax adviser to confirm the treatment rather than relying on a fixed percentage.
Raise claims and make it a routine
For each unresolved item, keep a log with the order ID, expected amount, actual amount, the report line that shows it, and the date you raised it. Raise queries through the seller support channel within any time limit stated in your agreement, and track each one until the money is credited or rejected.
- Reconcile every settlement cycle, not once a quarter. Old gaps are harder to prove.
- Carry forward open items so they are not lost.
- Keep one owner each for finance and ecommerce, so claims do not stall.
If spreadsheets become heavy, 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, other marketplaces are in scope discussion, and pricing is a tailored quote.
Worked example
Illustrative example only. These figures are made up to show the method. They are not real rates or results.
| Line | Amount (₹, illustrative) |
|---|---|
| Delivered order value | 4,00,000 |
| Less: returns reversed | (60,000) |
| Net sales | 3,40,000 |
| Less: commission expected as per agreed terms | (51,000) |
| Less: other fees expected as per agreed terms | (12,000) |
| Less: tax deductions shown in the report | (3,400) |
| Expected payout | 2,73,600 |
| Actual bank credit | 2,70,100 |
| Gap to investigate | 3,500 |
On checking the settlement lines, commission charged is ₹54,500 against ₹51,000 expected. That explains the ₹3,500 gap exactly. You would log it with the affected order IDs, attach the agreed terms and the settlement lines, and raise it as a query.
Questions and answers
Why is my Myntra payout lower than my order value?
The payout is net of returns, commission, fees, adjustments and tax deductions, and it may cover a different set of dates. Build a bridge from delivered order value to the bank credit to see which component accounts for the difference.
Which reports do I need to reconcile Myntra payments?
You need the sales or order report, the returns report, the settlement or payment report and your bank statement for the same period. Keep your seller agreement and rate card handy too. Report names vary, so check your seller portal.
How often should I reconcile Myntra settlements?
Do it every settlement cycle. Frequent checks keep exceptions small and evidence fresh, and they help you raise claims within any time limits in your agreement. Quarterly reviews make timing differences and old returns far harder to untangle.
How do I verify Myntra commission is correct?
Take the commission and fee terms from your seller agreement and current rate card, recompute them for a sample of orders, and compare with deductions in the settlement report. Confirm the latest rates with Myntra, as terms can change.