Guide
How to use the Settlement Reconciliation
1. Download the reports
Settlement flat file V2 (one per settlement)
- 1In Seller Central go to Reports → Payments → All Statements.
- 2Next to each settlement period, click Download Flat File V2. You get a .txt named like
12345678901.txt. - 3Download every settlement that started in the month you check and the month after: Amazon pays an order 1–3 weeks after it ships.
- 4Upload them all at once. The same file twice is read once.
Merchant Tax Report (MTR), to find unpaid orders
- 1Go to Reports → Tax Document Library → Merchant Tax Report.
- 2Download MTR B2C (and MTR B2B if you have business orders) for the month you check.
Menu names in Seller Central change now and then. If a label looks different, search the report name in Seller Central's search bar.
2. Read the results
Not paid
Orders in your MTR, older than the "due after" days, that are in none of the uploaded settlements. These are the ones to chase.
Orders vs MTR
Every MTR order with what Amazon paid (price + tax + shipping), refunds, fees and the net amount received. "Shipped before these settlements" means you need to upload an earlier settlement to check it.
Paid a different amount
Orders where Amazon paid more or less than your invoice value.
Refunds
Each refund, the commission Amazon gave back and the refund fee it kept, and whether the MTR has a credit note for it.
Fee check
Orders charged a fee clearly above what the same SKU usually pays: a wrong weight, dimension or category is the usual cause.
Charges by type
Every fee and charge (commission, closing fee, Easy Ship, FBA, ads, cancellation charges) with its GST.
Settlements
Each settlement's lines must add up to the amount deposited; withheld TCS and TDS per settlement.
Tally journal
The journal entries in the XML download: Dr bank with the deposit, Dr fees, ads, TCS and TDS, Cr the customer ledgers for the sales received.
3. What to do next
- Not paid: open the order in Seller Central (Orders → Manage Orders). If it was delivered and the payment is missing, raise a case under Payments → Missing or incorrect payment with the order ID.
- Paid less: check whether you ran a promotion or coupon on that order; if not, raise a case with the order ID and your invoice.
- Refund without credit note: check next month's MTR. If it never appears, ask Amazon for the credit note, or you keep paying GST on that sale.
- Fee above usual: compare Amazon's weight and dimensions for the SKU with your packed parcel, and raise a fee case with the order IDs.
- In Tally: import the sales first (Amazon to Tally), then this journal via Import → Transactions. Create the bank ledger before importing.
4. Good to know
- •Upload settlements for at least two months: one month's orders are paid across that month and the next.
- •Fees are posted to the Amazon party by default. Amazon issues monthly tax invoices for its fees (Tax Document Library → Seller Fee Invoices); book those as purchases against the same party to claim the GST, matching GSTR-2B.
- •TCS and TDS withheld are claimable: TCS in your GST electronic cash ledger (after Amazon files GSTR-8), TDS 194-O in your income-tax return (Form 26AS).
5. FAQ
Why does an order show "Shipped before these settlements"?
It was invoiced before the first settlement you uploaded started, so it was probably paid in an earlier settlement. Upload that settlement too.
Why is a recent order "Not due yet"?
Amazon pays after delivery (plus a few days), and settlements are weekly. Orders invoiced within the "due after" days of the last settlement are not counted as unpaid.
Can I use the Date Range transaction report?
Not here. Use the Flat File V2 of each settlement: it has every fee with its GST and the deposit total to check against.
Is my payments data stored?
No. The files are sent to our server only to calculate your results, processed in memory and deleted straight away.
It says a column is missing. What now?
You probably uploaded a different report, or Amazon renamed a column. Download the report exactly as in step 1. If it still fails, tell us the report name and we'll add support.