Reconcile Myntra Seller Payouts with Orders Step by Step

Why payouts rarely equal order value

The amount credited to your bank account is a net figure. It starts with the sale value and then has deductions applied: commission, applicable fees, return and reversal adjustments, and tax deductions required by law. Settlements also follow their own cycle, so an order placed in one week may be paid, or reversed, in another.

This is why comparing the order dashboard total with the bank credit never works. You need to reconcile at order level, then roll up to the payout level.

Gather the right data first

Before you start, pull data for one clear period and keep the date logic consistent (order date, delivery date or settlement date; pick one and note it).

• Order report: order IDs, SKUs, quantities, selling price and status.
• Settlement or payout report: the Excel files from your Myntra seller panel showing what was paid, held or deducted per order.
• Returns report: returned and cancelled items, with return type and dates.
• Your agreement and rate card: commission, fee heads and any category-specific terms. Do not rely on memory; confirm the latest version with your account manager.
• Bank statement: the actual credits for the period.

Column names differ between reports and change over time, so check your own exports before building formulas.

The step-by-step reconciliation process

1. Clean the files. Remove duplicates, standardise order ID formats and convert dates to one format.
2. Match orders to settlement lines. Use order ID plus SKU as the key, not order ID alone, since one order can hold several items.
3. Classify each order. Settled, partly settled, pending, returned, cancelled or missing from settlement.
4. Recalculate expected payout. Take the sale value and subtract commission and fees as per your agreed terms. Compare with the settled amount.
5. Check returns. Every return should show a matching reversal or adjustment. Confirm that the commission treatment follows your agreement.
6. Tie to the bank. Sum settlements by payout date and match them to bank credits. Any gap points to holds, adjustments or timing.
7. Log exceptions. Record order ID, expected amount, actual amount, difference and likely reason.

Common mismatches to look for

• Missing orders: delivered orders with no settlement line after the expected cycle.
• Commission or fee variance: a deduction higher than your terms imply, or a fee head you did not agree to.
• Return mismatches: return reversed twice, reversed at the wrong amount, or not reversed at all.
• Unexplained adjustments: penalties or debit notes without a clear reference.
• Tax deductions: amounts withheld at source that do not agree with your records. Rates and rules change, so confirm the current position with your tax adviser and compare against the certificates and statements you receive.
• Timing differences: not errors, but they must be tracked so they do not look like shortfalls next month.

Handle returns and recovery cases properly

Returns are where most money quietly leaks. For each returned item, check the return reason, the condition outcome (for example, items lost or received damaged) and whether your agreement provides for compensation or reversal of charges. Keep a case log with order ID, claim amount, date raised, evidence attached and status.

Raise claims within the window in your seller agreement or the current Myntra policy; check the exact timelines yourself, since they can change. Attach the order ID, return details, images or documents, and your calculation. A claim with a worked difference is far easier to resolve than a general complaint.

Turn it into a routine

Reconcile every settlement cycle rather than once a quarter. Older differences are harder to prove and may fall outside claim windows. Keep one master sheet with a tab for matched orders, one for exceptions and one for open claims.

If manual 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 today, and other marketplaces can be discussed. Whatever tool you use, the logic above stays the same.