To track returns and RTO losses on Amazon and Flipkart, list every returned or undelivered order, then match it to the settlement lines: sale reversal, fee reversal, shipping debits and any compensation. Compare each line with your agreed terms, flag mismatches, and log claims for lost, damaged or wrongly charged returns with their deadlines and outcomes.
What counts as a returns and RTO loss
Many sellers see returns as a revenue reversal and stop there. The real loss is wider. A return or RTO (return to origin) can cost you in several ways:
- Fees not reversed: commission, fixed or collection fees that stay deducted when your terms say they should be refunded.
- Extra logistics charges: forward and reverse shipping debits that differ from your rate card.
- Stock that never comes back: the order shows as returned, but the unit is not received, or arrives damaged or swapped.
- Unrecovered claims: eligible cases you never raised, or raised after the window closed.
Customer returns happen after delivery. RTOs happen when delivery fails and the parcel travels back. Both need tracking, but they hit different settlement lines, so keep them as separate categories.
The data you need for each return
Tracking fails when the data sits in four places. Build one row per returned order with these fields, pulled from Seller Central, Seller Hub, your warehouse records and the settlement reports.
| Field | Where to find it |
|---|---|
| Order ID, SKU, order value | Order report |
| Return or RTO type and reason | Returns report |
| Return delivery date and receipt at your warehouse | Marketplace tracking and your GRN or inward entry |
| Condition on receipt | Warehouse QC notes, photos |
| Settlement lines for the order | Payment or settlement report |
| Claim status and deadline | Your claim log |
Report names and columns change, so check the current versions in your seller dashboard rather than relying on an old template.
How to match returns to settlements, step by step
- Export returns for the period. Include RTOs and customer returns, with the dates each was initiated and completed.
- Export settlement lines for the same orders. Return periods often fall in a later settlement cycle than the original sale, so look across cycles.
- Match on order ID. Check that each return has a sale reversal, and note which fees were reversed and which were not.
- Compare against agreed terms. Use your seller agreement and current rate card to decide what the fee or credit should have been. Do not assume; terms differ by category, seller and period.
- Tag each difference. Use tags such as excess shipping debit, fee not reversed, return not received, damaged return.
- Check physical receipt. Cross-check returned units against your inward entries.
Unmatched returns, where there is no settlement line at all, deserve their own tab. They often mean a delayed reversal rather than a loss, but you only know once you follow them up.
Where return losses usually hide
- Delayed reversals: a return appears this month, the credit or debit lands next cycle, and nobody connects them.
- Bundled adjustments: several order-level items get netted into one line, which hides small errors.
- Partial returns: in multi-unit orders, fee reversal may not follow the returned quantity.
- Category or weight slab changes: reverse shipping charged on a different slab from the one in your terms.
- Receipt gaps: marketplace shows delivered to you, your warehouse shows nothing.
Small differences per order matter because returns repeat. A modest excess on every return becomes a real number over a quarter.
Claims: log them, date them, follow them up
Both marketplaces have processes for compensation, such as Amazon's SAFE-T claims and Flipkart's Seller Protection Fund. Eligibility, evidence needed and time limits are set by the marketplace and can change, so confirm the latest policy in your seller dashboard or with your account manager before relying on any assumption.
Keep a claim log with these columns: order ID, issue type, amount claimed, date raised, deadline, evidence attached, status, amount recovered. Review it weekly. Two habits help most: capture unboxing photos or video for every return at your warehouse, and raise claims as soon as a mismatch is confirmed rather than at month end.
Make it a monthly routine
Do the match once the settlement cycle closes, not when the books are being finalised. A simple rhythm works: weekly claim follow-up, monthly return-to-settlement match, and a quarterly look at return rate and loss per SKU and reason.
If spreadsheets are becoming the bottleneck, MarketplaceMetrics by Fundle reconciles sales and settlements, checks fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today; Amazon and Flipkart coverage is a scope discussion, so ask what is feasible for your reports.
Worked example
Illustrative example only. All figures are made up to show the method; they are not actual marketplace rates. Assume one month with 30 returns for a seller. Their agreement, as they read it, says reverse shipping is ₹70 per return and commission is refunded on 10 of those orders (₹150 each).
| Check | Expected | Settlement shows | Gap to review |
|---|---|---|---|
| Reverse shipping, 30 returns | ₹2,100 | ₹2,850 | ₹750 |
| Commission refund, 10 orders | ₹1,500 | ₹0 | ₹1,500 |
| 4 units not received, ₹800 cost each | Units back in stock | No receipt | ₹3,200 |
| Total to review | ₹5,450 |
The ₹5,450 is a list of items to investigate and claim, not guaranteed recovery. Each line needs evidence and must meet the marketplace's claim rules.
Questions and answers
What is the difference between RTO and a customer return?
An RTO happens when a shipment is not delivered and travels back to you. A customer return happens after delivery, when the buyer sends the item back. They hit different settlement lines and carry different claim risks, so track them separately.
Where do I find return and settlement data on Amazon and Flipkart?
Use the returns, orders and payment or settlement reports in Seller Central and Seller Hub. Report names and columns change over time, so check your dashboard for the current versions and download the same date range for all of them.
How do I know if a fee on a returned order is wrong?
Compare the debit with your seller agreement and current rate card for that category, weight slab and period. If the settlement line differs from what your terms say, tag it, keep the evidence and raise it with the marketplace.
How often should I reconcile returns?
Match returns to settlements every time a settlement cycle closes, and review open claims weekly. Waiting for quarter end risks missing claim windows, which are set by each marketplace, so confirm the latest time limits.