IndianBusinessTools
← Blog

GSTR-1 for Amazon Sellers: From MTR B2C Report to JSON

16 November 2026 · 7 min read

Drop your MTR B2C file and get the GSTR-1 JSON, with Table 7, HSN and Table 14 worked out

Convert MTR

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

Step 1: Download the MTR B2C report

  1. Log in to Seller Central.
  2. Go to Reports → Tax Document Library.
  3. Open Merchant Tax Report (MTR) and pick B2C.
  4. Choose the month and generate the report.
  5. 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 TypeWhat it meansWhat to do
ShipmentAn item was sold and shippedAdd it as a sale
RefundThe buyer returned the itemTake it away from sales
CancelThe order was cancelledUsually zero value. Skip it
FreeReplacementAmazon sent a replacement at no costNot 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:

ColumnUsed for
Ship To StatePlace of supply
Tax Exclusive GrossTaxable value (price before GST)
Total Tax AmountGST on the row
Igst Rate, Cgst Rate, Sgst RateGST rate, and whether it is same-state or other-state
Hsn/sacHSN code, for Table 12
QuantityQuantity, 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.

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 TypeShip To StateTax Exclusive GrossRateTotal Tax
ShipmentMaharashtra₹10,0005%₹500
ShipmentKarnataka₹20,00018%₹3,600
RefundKarnataka₹5,00018%₹900
CancelGujarat₹0–₹0

Table 7 gets two rows:

Place of supplyRateTaxable valueTax
27-Maharashtra5%₹10,000CGST ₹250 + SGST ₹250
29-Karnataka18%₹15,000IGST ₹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 valueIGSTCGSTSGST
₹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

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

Sources

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.

Frequently asked questions

Do I need to show Amazon sales in Table 14 if Amazon already files GSTR-8?

Yes. Amazon reports the sales it collected TCS on in its GSTR-8. You report the same sales in Table 14 of your GSTR-1, against Amazon's GSTIN. The portal compares the two. The sales also stay in Table 7 (or Table 4 for B2B).

Which Amazon GSTIN goes in Table 14?

Amazon's TCS registration for your state, not the GSTIN on your Amazon fee invoices. TCS GSTINs usually have C as the 14th character. You can see it on the GST portal under Returns, then TDS and TCS Credit Received.

Should I use Invoice Amount or Tax Exclusive Gross as the taxable value?

Tax Exclusive Gross. Invoice Amount includes GST. Taxable value in GSTR-1 is the value before GST. Total Tax Amount is the tax.

What if my refunds are more than my sales for a state?

The Table 7 row for that state and rate becomes negative, and the portal does not accept it. This happens when a sale from an earlier month comes back this month. Ask your CA. A common fix is to reduce that month's Table 7 figure through Table 10 (amendments).

I sell on Flipkart too. Can I file one GSTR-1?

Yes, you file one GSTR-1 for each GSTIN each period, with all your sales in it. Add the Flipkart sales to the same state and rate rows in Table 7, and add a separate Table 14 row against Flipkart's GSTIN.

Found a mistake, or want a tool we don’t have? Tell us — we read every message.