How to Download Amazon MTR and Settlement Reports
Every Amazon accounting workflow starts with two downloads: the Merchant Tax Report for GST-grade sales data, and the settlement flat files for fees, taxes, and payouts. Seller Central buries them in different corners, and getting the wrong variant or an incomplete date range causes downstream pain that looks like an accounting problem but is really a download problem. Here are the exact paths and the habits that keep your source files clean.
Downloading the MTR from the Tax Document Library
- In Seller Central, open the Reports menu and select the Tax Document Library.
- Locate the Merchant Tax Report section. Amazon generates monthly MTRs; choose the month you are closing.
- Pick the variant: B2C for consumer sales, B2B for Amazon Business orders with buyer GSTINs. If you sell to businesses at all, download both every month — the difference matters for GSTR-1, as explained in B2B vs B2C MTR reports.
- Download the CSV. Expect one row per SKU per invoice, with columns including Seller GSTIN, Invoice Number and Date, Transaction Type, Order ID, SKU, Quantity, Ship To State, Tax Exclusive Gross, the IGST/CGST/SGST rates and amounts, and Invoice Amount.
Timing note: the previous month's MTR is generally available in the first days of the new month, and Amazon can revise reports after initial publication. Downloading a final version before you close — and re-downloading if you imported early — is cheap insurance.
Downloading settlement flat files from Payments
- Open the Payments dashboard in Seller Central.
- Go to the reports repository section, which lists every closed settlement period.
- For each settlement overlapping your accounting month, request or download the flat file version — a tab-separated file with settlement-id, transaction-type, order-id, amount-type, amount-description, amount, and posted-date columns.
- Download every settlement that touches the month, including one that started in the previous month — settlements ignore calendar boundaries.
The on-screen payment summaries are fine for a glance but are not a substitute for the flat file, which is the only format with row-level amount descriptions that reconciliation and fee accounting need.
Which file answers which question
| You need | Download | Where |
|---|---|---|
| GSTR-1 sales data | MTR B2C + B2B | Reports → Tax Document Library |
| Fees, TCS, TDS detail | Settlement flat file | Payments → reports repository |
| Payout verification | Settlement flat file + bank statement | Payments + your bank |
| ITC support for fee GST | Amazon fee tax invoices | Seller Central invoice section |
An archiving routine that pays for itself
- Name consistently: something like 2026-07_MTR_B2C.csv and 2026-07_settlement_12345.txt sorts itself and answers what is missing at a glance.
- Archive originals unmodified. If you clean a file in a spreadsheet, save a copy — the untouched original is your audit evidence.
- Download on a schedule, first week of each month, rather than at filing deadline when Seller Central traffic and your patience are both worst.
- Keep multi-year retention. GST assessments arrive years later; marketplace reports for old periods can be harder to regenerate than to store.
From downloads to vouchers
Once the files are on disk, the rest of the pipeline is conversion and reconciliation: the MTR becomes sales vouchers and credit notes, the settlement files become fee, tax, and receipt entries, and the two get matched order-wise. That is precisely the part TallySutra's Amazon to Tally workflow automates from your uploads — TallySutra works on the official files you download, exactly as described here, with no API connection to your Amazon account required. The import mechanics are covered in importing the MTR into TallyPrime, and the full monthly report inventory in reports every accountant needs.
Troubleshooting the usual download annoyances
A few practical snags recur. Opening the MTR CSV directly in a spreadsheet can silently damage the data — leading zeros in state codes vanish and long identifiers get mangled into scientific notation — so if you must inspect a file, open a copy and keep the original untouched for import. Settlement flat files are tab-separated text, which spreadsheets sometimes parse into a single column; import them as tab-delimited or, better, feed them to your conversion tool unopened. A month that shows no B2B MTR usually means no B2B transactions occurred rather than a missing report, but archive a note to that effect so the gap is explained later. And if a settlement file seems to be missing entirely, check whether the cycle closed after your download session — settlements that end near your download date simply have not been generated yet, and the repository fills in as cycles close. None of these are defects; they are the ordinary texture of working with raw report files, and a consistent routine absorbs them without drama.
Frequently asked questions
The MTR for last month isn't showing yet — how long should I wait?
Monthly MTRs typically appear within the first few days of the following month. If it is genuinely delayed, check the Tax Document Library later rather than substituting other reports — order-level payment reports lack the GST columns your books need. For provisional numbers, you can import once available and re-import a revised final safely if your pipeline is duplicate-aware.
Do I need the settlement file if I can see payment totals on the dashboard?
Yes. Dashboard summaries show aggregates, but accounting needs the row-level flat file: per-order Principal and fee rows, amount descriptions like Commission and FixedClosingFee, TCS and TDS lines, and posted dates. Without those you cannot classify expenses, book recoverable taxes, or reconcile order-wise. The flat file is the only settlement format worth archiving.
Can TallySutra fetch these reports from Amazon for me?
No — TallySutra is file-upload based: you download reports from Seller Central using the paths above and upload them. There is no live API connection to your Amazon account (an SP-API application is in progress). The upside of file mode is control and traceability: every voucher in Tally traces to an official report file you hold.
TallySutra turns Amazon, Flipkart and Meesho reports into reconciled, reviewed TallyPrime vouchers — duplicate-safe, with every rupee traceable to its source row.
Book a 30-minute demo