To find missing payments in Myntra settlement, export your order, return and settlement reports for the same period, then match each order ID to its settlement line. Calculate the expected payout using your agreed terms, compare it with what was credited, and tabulate unsettled orders, short payments and unexplained deductions. Reconcile the total to your bank credits, then raise a case with evidence.
What counts as a missing payment
Not every gap is an order that was never paid. Before you start, know what you are looking for:
- Unsettled orders: delivered orders that appear in your sales data but in no settlement.
- Short payments: orders settled for less than the agreed terms imply.
- Unexplained deductions: fees, penalties or adjustments that do not match your agreement.
- Return mismatches: a return deducted twice, deducted at the wrong value, or never credited back when it should have been.
- Timing differences: payments that are late but not lost.
Separating these early stops you from raising claims on money that is simply in the next cycle.
Gather the right documents first
You need data for the same period from five places:
- The sales or order report from your Myntra seller account.
- The settlement or payment report for each cycle in the period.
- The returns report, including return dates and values.
- Your bank statement showing the actual credits.
- Your seller agreement and current rate card, plus any credit or debit notes.
Report names and menu paths change, so confirm the current ones with Myntra seller support or your account manager. Do not rely on memory for commission or fee terms. Always read them from the agreement and rate card.
Step-by-step: match orders to settlements
- Fix the period. Use delivery or settlement dates consistently. Mixing order dates and settlement dates creates false gaps.
- Build one order-level sheet. Put each order ID in a row with sale value, delivery status and return status.
- Lookup settlement lines. Use the order ID to pull the settled amount and settlement date from the settlement report. Blank results are your candidate unsettled orders.
- Calculate the expected payout. Take the sale value and subtract the deductions your agreement allows, such as commission, fixed fees and shipping-related charges. Confirm tax components with your tax adviser.
- Compare expected with received. Any difference becomes a flagged line.
- Net off returns. Check each returned order was reversed once, at the right value, and that any amount owed back to you was credited.
- Tie to the bank. Total each settlement and match it to the bank credit. A mismatch here means a batch-level issue, not just an order-level one.
Common reasons payments go missing
| Symptom | Likely cause | What to check |
|---|---|---|
| Delivered order, no settlement line | Pending cycle or genuine omission | Settlement timeline in your agreement |
| Settled amount lower than expected | Wrong fee applied or extra deduction | Rate card versus charges in the report |
| Return deducted but item never received back | Return dispute or logistics issue | Return status and receiving proof |
| Same order deducted twice | Duplicate adjustment | Settlement lines for that order ID |
| Bank credit differs from report total | Batch-level adjustment | Payment advice and debit notes |
Raise a recovery case with evidence
Once a gap survives your checks, raise it through the channel Myntra specifies for sellers, whether that is the portal or your account manager. A strong case includes:
- Order ID, delivery date and sale value.
- The settlement report line, or proof that none exists.
- The clause or rate card entry showing the expected amount.
- The exact difference claimed and a short explanation.
Group claims by cause, such as unsettled orders versus wrong fees, so each can be resolved faster. Check your agreement for any time limit on disputes, and keep a log of case numbers, dates and outcomes.
Make it a routine, not a one-off
Doing this once a year means chasing old orders. Doing it every settlement cycle means small, fresh gaps. If volume makes spreadsheets slow, MarketplaceMetrics by Fundle reconciles sales and settlements, checks fees against agreed terms and tracks returns and recovery cases in one place.
Worked example
Illustrative example only. All figures are made up to show the method; deductions are assumed, not real Myntra rates.
| Order | Sale value | Expected payout | Received | Gap |
|---|---|---|---|---|
| A | ₹1,499 | ₹1,079 | ₹1,079 | ₹0 |
| B | ₹999 | ₹719 | ₹0 | ₹719 |
| C | ₹1,299 | ₹909 | ₹819 | ₹90 |
| Total | ₹3,797 | ₹2,707 | ₹1,898 | ₹809 |
Order B is an unsettled order: check whether it falls in a later cycle before claiming. Order C is a short payment: compare the charges on its settlement line with your rate card to find the extra ₹90. Two flagged lines make two clear claims, each with its own evidence.
Questions and answers
How often should I reconcile Myntra settlements?
Many brands reconcile every settlement cycle, or at least monthly before books close. Shorter gaps make disputes easier because order data is fresh, and your agreement may set a time limit for raising claims, so check that clause.
Where do I find the Myntra settlement report?
Download it from your Myntra seller portal or the reports section, or use the Excel reports your account manager shares. Menu names can change, so confirm the current path with Myntra seller support and match the report period to your bank credits.
Is a short payment always Myntra's error?
No. Differences can come from returns, penalties, fee changes, tax-related deductions or timing. Check each against your seller agreement, rate card and any credit or debit notes first. Only unexplained or contradicting amounts should become recovery claims. Confirm tax treatment with your tax adviser.
Can I reconcile Myntra payments with Excel alone?
Yes for small volumes, using lookups on order IDs. It gets slow with many returns, partial settlements and rate changes. MarketplaceMetrics can automate matching and fee checks; Myntra Excel reports are reviewed, and other marketplaces are in scope discussion.