To track unsettled Myntra orders, export your sales and settlement reports for the same period, match them on order or item ID, and mark each line as settled, not yet due, adjusted or unexplained. Age the unexplained lines against your agreed payment cycle, check deductions against your seller agreement, and raise a case with evidence for anything still short.
What "unsettled" actually means
Not every order missing from a payout is a problem. Before you chase anything, sort open orders into clear buckets:
- Not yet due: delivered, but still inside the payment cycle in your seller agreement.
- Overdue: past the agreed cycle with no settlement line.
- Part-paid: settled, but for less than you expected.
- Adjusted: offset by a return, a penalty or another deduction.
- Disputed: already raised with the marketplace and awaiting a response.
Only overdue, part-paid and unexplained adjusted lines need follow-up. Tracking becomes manageable once you stop treating all open orders as one pile.
Gather the data before you start
You need four sources for the same date range. Report names and layouts can differ by account, so check what your Myntra seller panel offers and confirm the latest formats with your account manager.
- Sales or order report: order ID, item ID, delivery status, selling price.
- Settlement or payment report: what was paid, against which order, with commission, fee and adjustment lines.
- Returns report: returned and cancelled items, with dates and reasons.
- Your seller agreement and rate card: commission, fees, payment cycle and return terms.
Also keep your bank statement handy so you can tie each settlement total to an actual credit.
Build the tracker step by step
- Fix the period. Use delivery date, not order date, as the anchor, because payment timing usually follows delivery or return windows. Confirm this in your agreement.
- Create a common key. Use order ID plus item ID so multi-item orders do not collapse into one line.
- Match sales to settlements. A lookup or pivot in Excel works. Every delivered item should land in settled, adjusted or open.
- Net off returns. Check each return against the settlement report for a reversal or deduction, and flag returns with no matching entry.
- Recompute expected payout. Take the selling price, subtract commission and fees as per your agreed terms, and compare with the amount actually paid.
- Tie totals to the bank. The settlement totals should match credits received. A difference means a missing or split payment.
- Record a status and owner against every open line.
Age the open items
Ageing tells you what to chase first. Count days from the date payment became due under your agreement, not from the order date.
| Bucket | Meaning | Action |
|---|---|---|
| Not yet due | Inside payment cycle | Monitor only |
| 1 to 15 days overdue | Possible timing delay | Recheck next settlement |
| 16 to 45 days overdue | Likely missing or short | Prepare evidence, raise a case |
| 45+ days overdue | At risk of going stale | Escalate with full documentation |
These bucket limits are a working suggestion. Set yours based on your payment cycle and any claim deadlines in your agreement.
Common reasons orders stay unsettled
- The return was recorded after the original payout, so the next settlement carries a deduction.
- A deduction was netted against several orders and is hard to trace to one line.
- Commission or fee applied differs from the rate card.
- An item was delivered but shows a different status in the marketplace report.
- A settlement was split across payment dates.
- A return was received damaged or not received, and the claim is pending.
For rates and fee rules, always rely on your seller agreement and the latest rate card. Do not assume figures from other sellers. For tax-related deductions, confirm treatment with your tax adviser.
Raise recovery cases with proof
A case is easier to resolve when it is specific. For each claim, include the order and item IDs, delivery proof, the expected payout calculation, the settlement line received, and the clause or rate card page you are relying on. Group similar issues, such as ten orders with the same fee error, into one case with a clear list.
Log the date raised, the reference number and the response. Review open cases weekly so none lapse.
Doing this monthly in Excel works for small volumes. As volume grows, MarketplaceMetrics by Fundle can reconcile sales and settlements, check commissions and fees against agreed terms, and track returns and recovery cases in one place. Myntra Excel reports are reviewed today, and other marketplaces are a scope discussion.
Worked example
Illustrative example only. These figures are not real results.
A brand reconciles one month of Myntra deliveries.
| Line | Amount (₹, illustrative) |
|---|---|
| Expected net payout on delivered items | ₹8,50,000 |
| Settled and received | ₹7,92,000 |
| Gap to explain | ₹58,000 |
| Return deductions matched to returns report | ₹26,000 |
| Not yet due (inside payment cycle) | ₹18,000 |
| Unexplained, to raise as a case | ₹14,000 |
Of the ₹58,000 gap, only ₹14,000 needs a recovery case. The rest is explained once returns and timing are separated out.
Questions and answers
How often should I check for unsettled Myntra orders?
Review at every settlement cycle, and do a fuller month-end reconciliation. Frequent checks keep disputes inside any claim window in your agreement and stop small gaps from piling up. Confirm the exact timelines in your seller agreement.
Why does my Myntra settlement not match my sales report?
Common causes are returns deducted later, fees differing from the rate card, payments split across dates, and orders still inside the payment cycle. Match at item level and net off returns before treating any difference as a shortfall.
Can I track unsettled orders in Excel?
Yes. Export the sales, settlement and returns reports, build a key from order and item ID, and use lookups or pivots to flag unmatched lines. It works well at lower volumes but becomes slow and error-prone as order counts grow.
What proof do I need to claim a missing Myntra payment?
Keep order and item IDs, delivery status, your expected payout calculation, the relevant settlement lines, and the agreement clause or rate card page you rely on. Add return details if a deduction is disputed. Specific evidence speeds up resolution.