What is Amazon reconciliation?
Amazon reconciliation is matching what you shipped with what Amazon paid and what came back. For every order ID you want one clear answer — paid, returned or claimed. Anything else is money you have lost without knowing it.
There are four parts to it:
- Shipment reconciliation — every shipped order appears in the payment report (reconcile your shipment).
- Payment reconciliation — the payout per order is correct after fees, refunds and credits (Amazon payment reconciliation order by order).
- Return reconciliation — every refunded order has a return you received (Amazon return reconciliation).
- Claims — every gap is claimed inside the window (cover return and RTO loss on Amazon).
The reports you need
| Report | Where in Seller Central | What it tells you |
|---|---|---|
| All Orders report (.txt) | Reports → Fulfilment → All Orders | Every order shipped, with SKU, quantity and price |
| Date Range payment report (.csv) | Payments → Reports Repository | Sales, fees, refunds, reimbursements per order, released or deferred |
| Returns Reconciliation report (.csv) | Returns reports | Return type (customer return / undelivered RTO), status and tracking |
| Replacements report (.csv) | Reports → Fulfilment | Which replacement belongs to which original order |
| Your received returns | Your warehouse | What physically came back, and in what condition |
| FC Fulfillment report (FBA only) | Amazon Fulfilled Shipments | Which fulfilment centre shipped each order |
Download them as CSV/TXT and do not open-and-save them in Excel — Excel turns 12-digit tracking IDs into numbers like 6.30E+11 and breaks dates.
Step 1 — Match every shipped order to a payment
Take the order IDs from the All Orders report and look each one up in the payment report. Orders with no payment row are outstanding orders: either the payment is still deferred, or something went wrong and needs a case.
Step 2 — Work out the net payout per order
Add every line for the order: product sale, shipping credit, referral and closing fees, shipping fees, refunds, refund commission, SAFE-T credits and reimbursements. The total is what Amazon really paid for that order. A negative total means you lost money on it.
Step 3 — Check the returns
For every order with a refund, check the Returns Reconciliation report. Returned to Seller and Returned to Seller (POD Completed) mean the product came back. Any other status after a refund — return initiated, in transit, customer cancelled pick-up, or no row at all — means it did not.
Step 4 — Handle replacements as pairs
A replacement order has ₹0 value. Judge the original and the replacement together: if both products came back, the pair is settled; if one is missing, claim that order ID. Count the claim window from the latest refund or replacement date. See replacement order claims.
Step 5 — Remove what Amazon already paid
Payment report lines such as SAFE-T claim credits, "lost or damaged" reimbursements and "FBA Inventory Reimbursement – Customer Return" mean Amazon has already covered the order. Take those orders off your claim list.
Step 6 — File claims inside the window
A "return not received" claim is accepted only when the window is open — about 50 days after the refund — and before it closes. File on time, paste the SAFE-T ID into your tracker, and check the payment report for the credit. See Amazon SAFE-T claim software.
Step 7 — Calculate real profit
With the net payout per order known, subtract your cost price for every unit the customer kept. Returned units are not a cost. Deduct advertising for the month. This is your Amazon profit per SKU.
How often should you reconcile?
Every week. Claim windows close, deferred amounts are released, and returns arrive every day. A weekly upload keeps every claim on time.
Do it automatically
Charly's Recon runs all seven steps every time you upload your reports — it is a one-stop Amazon reconciliation solution for Easy Ship, Self Ship, Seller Flex and FBA sellers. Read more about Amazon seller reconciliation services in India.
Frequently asked questions
What is Amazon reconciliation?
Matching every shipped order with what Amazon paid and what came back, so each order is paid, returned or claimed.
Which reports do I need for Amazon reconciliation?
All Orders, the Date Range payment report, the Returns Reconciliation report, the Replacements report and your own received returns. FBA sellers also need the FC Fulfillment report.
How often should I reconcile Amazon payments?
Weekly, so claim windows are never missed.
Reconcile your own Amazon orders in minutes
One-stop Amazon reconciliation: create a free account, upload your reports and see every payment, return, RTO and claim for your brand — order by order.
Create free account