If you sell on Amazon, Amazon gives you a report with every sale, refund and cancellation. It is called the Merchant Tax Report, or MTR. Your GSTR-1 is built from it. But the MTR has one row for each item, and GSTR-1 wants totals. This guide shows you how to go from one to the other.
You can also do it in one step with our Amazon MTR to GSTR-1 JSON tool. It reads the file in your browser and makes the JSON file you upload on the GST portal.
What you need
- The MTR B2C report for the month. B2C means sales to buyers who did not give a GSTIN.
- The MTR B2B report, if any buyers gave their GSTIN. Those sales go in Table 4, invoice by invoice.
- Amazon's TCS GSTIN for your state. You need it for Table 14.
- Your own GSTIN. If you have more than one, the MTR shows each one in the Seller Gstin column.
Step 1: Download the MTR B2C report
- Log in to Seller Central.
- Go to Reports → Tax Document Library.
- Open Merchant Tax Report (MTR) and pick B2C.
- Choose the month and generate the report.
- Download it. If you get a .zip file, open it and keep the .csv file inside.
Take one month at a time. A file with two months mixed together gives wrong totals.
Step 2: Know which rows count
Each row has a Transaction Type. This decides what you do with it.
| Transaction Type | What it means | What to do |
|---|---|---|
| Shipment | An item was sold and shipped | Add it as a sale |
| Refund | The buyer returned the item | Take it away from sales |
| Cancel | The order was cancelled | Usually zero value. Skip it |
| FreeReplacement | Amazon sent a replacement at no cost | Not a new sale. Skip it |
The most common mistake is to add up every row without looking at this column. Then refunds are counted as sales, and you pay tax twice.
Step 3: Know the columns that matter
The MTR has more than 70 columns. For GSTR-1 you need only a few:
| Column | Used for |
|---|---|
| Ship To State | Place of supply |
| Tax Exclusive Gross | Taxable value (price before GST) |
| Total Tax Amount | GST on the row |
| Igst Rate, Cgst Rate, Sgst Rate | GST rate, and whether it is same-state or other-state |
| Hsn/sac | HSN code, for Table 12 |
| Quantity | Quantity, for Table 12 |
Do not use Invoice Amount as the taxable value. It already includes GST.
Step 4: Put the totals in the right tables
Table 7: B2C (Others)
Add up all small B2C sales by state and GST rate. Each state and rate becomes one row.
- If the buyer is in your state, the tax is CGST + SGST.
- If the buyer is in another state, the tax is IGST.
Table 5: B2C (Large)
Some sales go here instead of Table 7. These are sales to another state where the invoice value is above ₹1 lakh. They are reported invoice by invoice. Most Amazon sellers have few or none.
Table 8: Sales at 0% GST
Some goods have no GST, such as printed books. Their sales do not go in Table 7. Put the total in Table 8, split into same-state and other-state sales. Most 0% goods are exempt. A few are nil rated. Check which one your goods are. Amazon collects no TCS on these sales, so they are not in Table 14 either.
Table 12: HSN summary
Since 2025, Table 12 has two tabs: B2B and B2C. Amazon B2C sales go in the B2C tab. Each HSN code and rate becomes one row, with quantity, taxable value and tax. Businesses with turnover up to ₹5 crore must use at least 4 digits. Above ₹5 crore, use 6 digits. To check a code, use the HSN Code Finder.
Table 14: Supplies through e-commerce operators
This table shows how much you sold through Amazon. You enter one row with Amazon's TCS GSTIN, the total taxable value, and the total tax.
These sales also stay in Table 7. Table 14 does not replace Table 7. It tells the portal which operator they went through, so it can match them with Amazon's TCS return (GSTR-8).
A worked example
Say your GSTIN is in Maharashtra. In October, your MTR B2C has these rows:
| Transaction Type | Ship To State | Tax Exclusive Gross | Rate | Total Tax |
|---|---|---|---|---|
| Shipment | Maharashtra | ₹10,000 | 5% | ₹500 |
| Shipment | Karnataka | ₹20,000 | 18% | ₹3,600 |
| Refund | Karnataka | ₹5,000 | 18% | ₹900 |
| Cancel | Gujarat | ₹0 | – | ₹0 |
Table 7 gets two rows:
| Place of supply | Rate | Taxable value | Tax |
|---|---|---|---|
| 27-Maharashtra | 5% | ₹10,000 | CGST ₹250 + SGST ₹250 |
| 29-Karnataka | 18% | ₹15,000 | IGST ₹2,700 |
The Karnataka row is ₹20,000 of sales minus ₹5,000 of refunds. The cancel row adds nothing.
Table 14 gets one row against Amazon's GSTIN:
| Taxable value | IGST | CGST | SGST |
|---|---|---|---|
| ₹25,000 | ₹2,700 | ₹250 | ₹250 |
Table 12 gets one row for each HSN code, made up the same way.
About TCS
Amazon collects TCS on your net sales and deposits it with the government. It shows these amounts in its GSTR-8. You then see them on the GST portal under Returns → TDS and TCS Credit Received. Accept them there, and the money comes into your electronic cash ledger. You can use it to pay your GST.
TCS does not change your GSTR-1. You still report your full sales and tax.
Common mistakes
- Counting refunds as sales. Always check the Transaction Type column.
- Using Invoice Amount as taxable value. Use Tax Exclusive Gross.
- Forgetting Table 14. Your sales then don't match Amazon's GSTR-8, and you may get a notice.
- Using the wrong Amazon GSTIN. Use the TCS GSTIN for your state.
- Mixing two GSTINs. If the MTR has rows for two of your GSTINs, file each one separately.
- Leaving out the B2B report. Sales to buyers with a GSTIN go in Table 4, and in Table 14 too.
After GSTR-1
GSTR-3B takes your sales tax figures from GSTR-1. So get GSTR-1 right first. For this month's due dates, see GST due dates for December 2026. If you are late, the GST Late Fee Calculator shows what you will pay.
Summary
- Build GSTR-1 from the MTR B2C report, one month and one GSTIN at a time.
- Count Shipment rows as sales and take away Refund rows. Skip Cancel and FreeReplacement.
- Use Tax Exclusive Gross for taxable value and Ship To State for place of supply.
- Put the totals in Table 7 by state and rate, Table 12 by HSN, and Table 14 against Amazon's TCS GSTIN.
- Sales at 0% GST, such as books, go in Table 8, not Table 7 or 14.
- Inter-state invoices above ₹1 lakh go in Table 5.
Sources
- Section 52 of the CGST Act, 2017 (TCS by e-commerce operators)
- Form GSTR-1 and its instructions, CGST Rules, 2017
- Amazon Selling Partner API: tax report columns
- GST portal
We wrote this from the GSTR-1 form, Section 52, and Amazon's published MTR column list, as we read them in November 2026. Amazon may change its report, and the GST portal may change its tables. We did not check the Flipkart or Meesho reports. Please check the latest rules on the GST portal and ask your CA for your case. This is not legal advice.