GST & Tax
Amazon MTR to GSTR-1 JSON Converter
Turn Amazon's B2C Merchant Tax Report into a GSTR-1 JSON file with Tables 7, 8, 12 and 14. Please check it once before you upload.
Amazon MTR to GSTR-1 JSON
www.indianbusinesstools.com
Before you start
- Amazon sometimes changes the columns in this report. We find each column by its name, not its place, so a new or moved column does not matter.
- If a column we need is missing or renamed, we stop and show you its name. We do not make a file from a report we cannot read fully. If a less important column is missing, such as cess, we still make the file and show a warning.
- Last checked with real MTR B2C reports from October 2025 to September 2026.
- Always compare the totals with your Amazon reports before you file.
Your file is read in your own browser. It is never uploaded.
How to use it
- In Seller Central, go to Reports → Tax Document Library → Merchant Tax Report (MTR). Pick B2C and the month, then download it.
- If the download is a .zip file, open it and keep the .csv file inside.
- Drop the .csv file in the box above. Check your GSTIN and the return period.
- Enter Amazon's TCS GSTIN for your state. You can see it on the GST portal under Returns → TDS and TCS Credit Received.
- Read every message in red or yellow. Compare the totals with your Amazon payments and books.
- Download the JSON. On the GST portal, open GSTR-1 for the month, choose Prepare Offline, and upload it.
Where each sale goes
- Table 7 (B2CS): all small sales to buyers without a GSTIN, added up by state and GST rate. Same-state sales show CGST and SGST. Other-state sales show IGST.
- Table 5 (B2CL): sales to another state where the invoice is above ₹1 lakh. These are listed invoice by invoice.
- Table 8: sales at 0% GST, such as printed books. You choose exempt or nil rated. These are not in Table 7 or Table 14.
- Table 12 (HSN, B2C tab): quantity, value and tax for each HSN code and rate.
- Table 14: the total value of sales made through Amazon, shown against Amazon's GSTIN. Amazon collects TCS on these sales.
Refunds are taken away from the same totals. Cancelled orders and free replacements are not sales, so they are skipped. For the full steps and examples, read GSTR-1 for Amazon sellers.
What this tool does not do
- It reads the B2C report only. Sales to buyers with a GSTIN (the B2B report) go in Table 4, invoice by invoice.
- It does not fill Table 13 (documents issued). Add your invoice and credit note series on the portal.
- It does not include sales from your own shop, website, Flipkart or Meesho.
Already have a GSTR-1 JSON file? Open it in the GSTR-1 JSON Viewer to read it as tables or download it as Excel.
Frequently asked questions
Is my Amazon report uploaded to your server?
No. The file is read by your own browser, on your own computer. The tool works out the totals there and makes the JSON file there. Nothing from the file is sent to us.
Which Amazon report do I need?
The Merchant Tax Report (MTR) for B2C, for one month. Find it in Seller Central under Reports, then Tax Document Library. The B2B report is a different file, for buyers who gave their GSTIN.
Why do Amazon sales go in both Table 7 and Table 14?
Table 7 shows your B2C sales by state and rate. Table 14 shows how much of your sales went through each e-commerce operator, so the portal can match it with the TCS return Amazon files (GSTR-8). The same sale is shown in both places.
How are refunds handled?
A refund row in the MTR is taken away from the sales of the same state, rate and HSN code. If refunds are more than sales for a state and rate, the total becomes negative. The portal does not accept that, so the tool shows a red message. Ask your CA how to adjust it, usually in the month of the original sale.
Can I upload the JSON straight to the GST portal?
The file uses the GST portal's GSTR-1 JSON format, and you upload it under Prepare Offline. But check the totals first, and keep a copy of the MTR. If the portal shows an error, read the error file it gives, fix the cause, and make the JSON again.
Does it work for Flipkart or Meesho reports?
Not yet. Each marketplace uses its own report layout. This tool reads only Amazon's MTR B2C report.
Found a mistake, or want a tool we don’t have? Tell us — we read every message.