Guide
How to use the Amazon to Tally Converter
1. Download the report
Merchant Tax Report (MTR) B2C and B2B
- 1In Seller Central go to Reports → Tax Document Library.
- 2Open Merchant Tax Report, choose MTR B2C, select the month and download it.
- 3Do the same for MTR B2B (if you have business orders).
- 4Upload both here. You can also upload just one.
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
HSN-wise
Taxable value and GST per HSN code and rate, split B2B / B2C, net of returns. This is what Tally's GSTR-1 HSN summary should show after import.
GST rate-wise / State-wise
The same totals by rate (inter/intra-state) and by place of supply, to cross-check with GSTR-1 and GSTR-3B.
Tally vouchers
Every voucher the XML file will create: B2B invoice by invoice with GSTIN; B2C grouped per state per day (or month / invoice); returns as credit notes.
Masters
The unit, stock items (per ASIN, HSN or SKU, each with its HSN and GST rate), party, sales and output GST ledgers the vouchers use. "From" shows whether an item came from the ASIN or fell back to HSN.
Checks
Lines with no HSN, unknown states, or GST that doesn't match the rate. Fix them before importing.
3. What to do next
- Back up your Tally company (or import into a test company first).
- Download Tally XML: masters and import it: TallyPrime → Import → Masters (Tally ERP 9: Gateway → Import Data → Masters). It creates the unit, stock items and ledgers; choose "Combine (Merge)" for ones that already exist.
- Download Tally XML: vouchers and import it: TallyPrime → Import → Transactions (Tally ERP 9: Import Data → Vouchers).
- Check Tally's import summary: it lists any voucher that failed, usually because a ledger, stock item or unit name doesn't exist. Rename them in Settings to match your Tally, then re-download.
- Item invoices need inventory turned on for the company (F11 → Inventory features). If godowns are off, clear the Godown setting.
- Open GSTR-1 in Tally and compare the HSN and rate totals with the HSN-wise tab here.
4. Good to know
- •Already have sales ledgers in Tally? Put their exact names in Settings and skip the ledgers file.
- •TCS deducted by Amazon isn't part of sales; book it with the Amazon settlement (payment) entry.
- •Import each month only once. Re-importing creates duplicate vouchers; delete the old ones first if you need to redo a month.
- •The ledger file sets HSN and GST rate on each sales ledger so Tally's GST reports pick them up. Check one ledger after import, since Tally versions differ slightly.
5. FAQ
Does it work with TallyPrime and Tally ERP 9?
It produces standard Tally XML (Accounting Voucher View) that both import. Test with one month first.
Why are B2C sales grouped?
GSTR-1 reports B2C as totals per state and rate, so one voucher per state per day keeps Tally light. Choose "One per invoice" in Settings if you need every invoice.
Are my files uploaded?
No. The MTR files are read in your browser and the XML is created there; nothing is sent to our server.
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.