Export your Amazon India return and settlement reports, then list every return with its order ID, return date and refund amount. Compare that list against your warehouse goods-received entries or FBA returns data. Anything refunded but not received after the expected transit time goes on an open-cases list. Raise a claim through the route that fits your fulfilment model, attach evidence, and review the list weekly until every case is closed.
What a missing return really means
Before you track anything, separate the situations. Each one has a different claim route.
- FBA returns: the customer sent the item back to Amazon, but it does not show up as sellable or unsellable in your inventory records.
- Self-ship or Easy Ship returns: the courier shows the parcel as delivered or in transit, but your warehouse has no goods-received entry.
- Wrong or damaged item received: a parcel arrived, but it is not the product you sold, or it is unusable.
Which one applies depends on your fulfilment model. Check your seller agreement and Seller Central help pages for the current process.
Build a returns ledger first
A simple sheet, one row per returned unit, is enough to start. Use the Amazon order ID as the common key across every report.
| Column | Why it matters |
|---|---|
| Order ID and SKU | Links the return to sales, refund and settlement rows |
| Return request date | Starts your transit clock |
| Return reason and type | Separates customer returns from RTO and wrong-item cases |
| Refund amount and date | Shows how much money has already gone out |
| Tracking or return ID | Lets you trace the parcel |
| Warehouse receipt date and condition | Blank means the return is open |
| Claim status and claim ID | Prevents duplicate follow-ups |
Step-by-step: trace each return
- Download the return data. From Seller Central, pull the returns and, if you use FBA, the customer returns report. Report names and menu paths change, so confirm the current ones in Seller Central help.
- Download settlement data. Use the payments or date-range reports to see refunds and any fee reversals against each order ID.
- Load both into your ledger and match on order ID.
- Add your own receipts. Pull goods-received entries from your warehouse or ERP for the same period.
- Filter for gaps: refunded in the settlement, but no receipt date in your records.
- Check tracking for each gap. Mark it as in transit, delivered without receipt, or no tracking available.
- Set an ageing rule. Decide how many days past the expected transit time a return becomes a claim candidate, based on your carrier experience and the claim window in your terms.
Compare refunds with receipts, not just stock
Do not stop at the inventory count. A return can be missing even when stock looks fine, because newer purchases may mask the gap. The reliable test is money out versus goods in.
For every gap, note the refund given to the customer and whether any commission or fee was reversed. Whether fees are reversed on returns depends on your seller agreement and the current fee schedule, so check those documents rather than assuming. The net loss on a missing return is the refund plus any fees not reversed, less anything Amazon has already compensated.
Raise claims and keep evidence ready
Once a return crosses your ageing threshold, raise the claim through the route that matches your fulfilment model. FBA sellers typically look at inventory reimbursement. Self-ship sellers typically look at Amazon's SAFE-T claim process. Eligibility rules and filing windows change, so confirm the latest terms in Seller Central help before you file.
Keep this evidence attached to each case:
- Order ID, return ID and tracking number
- Refund date and amount from the settlement report
- Courier status screenshot or delivery proof
- Your warehouse note showing nothing was received
- Photos and unboxing video, if a wrong or damaged item arrived
- Dates of every follow-up and any case ID
Make it a weekly routine
Missing returns are easiest to recover when caught within the claim window. Review the open-cases list every week: new gaps, claims awaiting reply, and cases about to expire. Close each one as recovered, rejected or written off, with a reason.
Spreadsheets work at low volumes. As returns grow, manual matching gets slow. MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today; Amazon coverage would be a scope discussion.
Worked example
Illustrative example (figures are not real data). A seller reviews one month of Amazon India returns.
| Item | Units | Value (₹, illustrative) |
|---|---|---|
| Returns refunded | 50 | 60,000 |
| Received and matched | 44 | 52,800 |
| Refunded but no receipt | 6 | 7,200 |
The six gaps are assumed to average ₹1,200 each. After tracing them:
- 2 units (₹2,400) are still in transit, so they stay on watch.
- 3 units (₹3,600) show courier delivery with no warehouse receipt, so claims are raised.
- 1 unit (₹1,200) is past the claim window and is written off.
The ₹7,200 gap is now split into watch, claim and write-off, each with an owner and a next review date.
Questions and answers
Where do I find return data in Amazon Seller Central?
Look in the Reports section for returns and FBA customer returns reports, and in Payments for settlement or date-range reports. Menu names change, so confirm current paths in Seller Central help. Use the order ID to join every report.
How long should I wait before treating a return as missing?
There is no universal number. Base it on carrier transit times you have observed and the claim window in Amazon's current terms. Set an internal threshold comfortably inside that window so you never discover a gap too late to claim.
Can I claim if the customer has already been refunded?
Possibly, but eligibility depends on your fulfilment model and Amazon's current policy. Check the reimbursement or SAFE-T conditions in Seller Central help, and attach the refund, tracking and warehouse evidence so the case can be assessed properly.
Do I need software to track missing returns?
Not at low volumes. A disciplined spreadsheet keyed on order ID works. As return counts and marketplaces grow, matching reports by hand becomes slow and error-prone, and that is when dedicated reconciliation and recovery tracking starts to pay off.