apriltax blog
4.9 on Google reviewsWorks with reports from AmazonFlipkartMeesho✓Fixed fees, shown before you start✓Written by Chartered Accountants
GST for online sellers

Amazon Seller GSTR-1 Filing: MTR Report to Filed Return in 5 Steps

✓ 5 official and published sources✓ Written for Indian sellers and small businesses

To file GSTR-1 as an Amazon seller, download the two Merchant Tax Report (MTR) files for the period, B2B and B2C, from Seller Central. Put business invoices in Table 4, consumer sales net of returns in Table 7, then add the HSN summary, document count and the Amazon total in Tables 12, 13 and 14. File by the 11th.

Key points
  • Amazon gives you two MTR files each month: one for sales to GST-registered buyers (B2B) and one for sales to consumers (B2C). You need both.
  • GSTR-1 is due on the 11th of the next month if you file monthly, and on the 13th of the month after the quarter if you file quarterly.
  • Consumer returns are subtracted inside Table 7. Returns from registered buyers are reported as credit notes in Table 9B.
  • A filed GSTR-1 cannot be revised. Errors are fixed through GSTR-1A or a later return.
  • The late fee is Rs 50 a day, capped at Rs 2,000 per return if your turnover is up to Rs 1.5 crore.
In this guide
  1. What is the MTR and why are there two files?
  2. The 5 steps from MTR to filed return
  3. Which sale lands in which table?
  4. How are returns treated?
  5. A worked example
  6. The mistake Amazon sellers usually make
  7. Should you do this yourself?

What is the MTR and why are there two files?

GSTR-1 is the monthly or quarterly statement of everything you sold. Amazon does not file it for you. What Amazon gives you is the raw material: the Merchant Tax Report, a line-by-line list of every invoice, refund and cancellation raised under your GSTIN.

It comes in two files because GST treats the two kinds of buyer differently. A registered buyer wants to claim input tax credit, so the government needs each invoice with the buyer's GSTIN. A consumer claims nothing, so a state-wise total is enough.

FileWhat it holdsWhere it goes in GSTR-1
MTR B2BInvoices and credit notes to buyers who gave a GSTIN, one row per itemTable 4 (invoices), Table 9B (credit notes), Table 12 B2B tab
MTR B2CShipments, refunds and cancellations for consumer orders, with ship-to state and tax rateTable 7, Table 12 B2C tab
Both togetherEvery document number and the total sold through AmazonTable 13 (documents issued), Table 14 (e-commerce supplies)

The click path is in our guide on downloading the Amazon GST report.

The 5 steps from MTR to filed return

  1. Download both MTR files for the period. One month if you file monthly, all three months if you file quarterly. Do not edit the files.
  2. Separate shipments, refunds and cancellations. Each MTR row carries a transaction type. Shipments are sales. Refunds are returns. A cancelled order was never supplied, so it adds nothing to your taxable value, though a cancelled invoice number still counts in Table 13.
  3. Build the five tables. B2B invoices go to Table 4 one by one. B2C sales, less refunds, go to Table 7 as totals for each state and tax rate. Then add the HSN-wise summary (Table 12), the invoice and credit note series (Table 13) and the net sales under Amazon's GSTIN (Table 14).
  4. Cross-check three totals. Table 12 should agree with Tables 4, 7 and 9B. Table 14 should agree with your total Amazon sales. The tax in the return should agree with the tax columns of the MTR.
  5. Upload and file on the GST portal. Enter the figures online or upload a JSON file, generate the summary, then file with an OTP (EVC) or a digital signature. The portal clicks are in our portal filing guide.
File your GSTR-1 freeAprilTax turns your Amazon, Flipkart and Meesho reports into a GSTR-1 file ready for the GST portal, with the checks done for you.
Open the free tool

Which sale lands in which table?

Kind of entry in the MTRGSTR-1 table
Sale to a buyer with a GSTINTable 4, invoice by invoice
Sale to a consumerTable 7, as state and rate totals
Inter-state consumer invoice above Rs 1 lakhTable 5, invoice by invoice (rare for most sellers)
Return by a registered buyerTable 9B, as a credit note
Return by a consumerSubtracted inside Table 7
All items sold, grouped by HSN codeTable 12, B2B and B2C tabs
Invoice and credit note numbers usedTable 13
Net sales made through AmazonTable 14, against Amazon's GSTIN

HSN is the product classification code. If your turnover is up to Rs 5 crore you give at least 4 digits, above that 6. The portal will not generate the summary without the B2B tab when you have B2B sales, or without Table 13. The B2C tab only draws a warning if left empty.

How are returns treated?

Does a return cancel the original sale? No. The sale stays in the month it was shipped. The refund reduces the month in which Amazon processed it. So a December order returned in January lowers January's figures, not December's.

For consumers, you simply report sales minus refunds in Table 7. For registered buyers, the refund is a credit note in Table 9B, linked to that buyer's GSTIN, so that their input tax credit comes down too. Tables 12 and 14 also carry the net figure.

A worked example

Say you sell from Gujarat, file monthly, and your December MTR files show this, all at 18% GST:

ItemTaxable valueGST
B2C shipmentsRs 3,00,000Rs 54,000
B2C refundsRs 40,000Rs 7,200
B2B invoices (2)Rs 50,000Rs 9,000
B2B credit note (1)Rs 10,000Rs 1,800

Your GSTR-1, due 11 January, would show:

  • Table 4: two invoices, Rs 50,000 taxable, Rs 9,000 tax.
  • Table 9B: one credit note, Rs 10,000 taxable, Rs 1,800 tax.
  • Table 7: Rs 2,60,000 taxable and Rs 46,800 tax, split by state.
  • Table 12: Rs 40,000 in the B2B tab and Rs 2,60,000 in the B2C tab.
  • Table 14: Rs 3,00,000 net sales and Rs 54,000 tax against Amazon's GSTIN.

Net tax for the month is Rs 54,000. Amazon will also have collected tax at source (TCS) of 0.5% on the Rs 3,00,000 net value, which is Rs 1,500. That sits in your cash ledger once you accept it on the portal. See what TCS is for how to claim it.

The mistake Amazon sellers usually make

The common one is filing from the B2C file alone. The return looks complete, because most of your orders are consumer orders. But the B2B invoices never reach Table 4, your business buyers do not see the credit in their GSTR-2B, and they come back to you asking for it.

Two more to watch:

  • Counting refunds as zero. If you report shipments only, you pay GST on goods that came back. In the example above that is Rs 7,200 of extra tax.
  • The wrong Amazon GSTIN in Table 14. Amazon has a different GSTIN in each state. Use the one that appears on your TCS statement, or the department's matching will show a gap.

What does a slip cost? A late return costs Rs 50 a day, up to Rs 2,000 for a seller under Rs 1.5 crore turnover. A wrong return costs more in time, because you cannot revise it. You can correct it once through GSTR-1A before filing GSTR-3B, or in a later month's amendment tables.

Should you do this yourself?

If you have a few hundred orders, one GSTIN and mostly consumer sales, you can do this yourself in under an hour once you have done it twice. Consider paying someone if you store stock in Amazon warehouses in other states under separate registrations, because stock transfers between your own GSTINs add another layer, or if you have had a mismatch notice before.

How AprilTax can help

AprilTax has a free GSTR-1 tool for online sellers. You upload the two Amazon MTR files as downloaded, and it prepares the B2B, B2C, HSN summary, documents issued and e-commerce tables, runs about 30 checks, and gives you a JSON file to upload on the GST portal yourself. It also matches the TCS that Amazon reported against your sales.

Frequently asked questions

Which Amazon report do I need for GSTR-1?
You need the Merchant Tax Report (MTR) from the Tax Document Library in Seller Central, for both B2B and B2C transactions, covering the month or quarter you are filing. The B2B file feeds Table 4 and Table 9B, and the B2C file feeds Table 7.
What is the due date for GSTR-1 for Amazon sellers?
It is the same as for any other taxpayer. Monthly filers file by the 11th of the following month. Quarterly filers file by the 13th of the month after the quarter ends. Selling on Amazon does not change the date.
Can an Amazon seller file GSTR-1 quarterly?
Yes, if your turnover in the previous financial year was up to Rs 5 crore you can choose quarterly filing on the GST portal. You then file GSTR-1 once a quarter by the 13th, using all three months of MTR files.
How do I show Amazon returns in GSTR-1?
Consumer returns are subtracted from sales in Table 7 in the month the refund was processed. Returns by GST-registered buyers are reported as credit notes in Table 9B against the buyer's GSTIN. The HSN summary and Table 14 also carry the net amount.
What goes in Table 14 for Amazon sales?
Table 14 holds the net value of supplies you made through an e-commerce operator, with the tax on them, against the operator's GSTIN. For Amazon, use the Amazon GSTIN shown on your TCS statement on the GST portal, since Amazon has a separate GSTIN in each state.
Do I have to file GSTR-1 if I had no Amazon sales this month?
Yes. A nil GSTR-1 must still be filed for every period in which you hold a GST registration. The late fee for a nil return is lower, Rs 20 a day capped at Rs 500, but it still applies.
Can I correct a mistake after filing GSTR-1?
A filed GSTR-1 cannot be revised. You can make a correction once for that period through Form GSTR-1A before you file GSTR-3B, or you can amend the entry in the amendment tables of a later GSTR-1.

File your GSTR-1 free

AprilTax turns your Amazon, Flipkart and Meesho reports into a GSTR-1 file ready for the GST portal, with the checks done for you.

Open the free tool
D
CA Daxit

A Chartered Accountant on the AprilTax team who works with online sellers and small businesses every filing season.

Read next

Stuck on a return or registration?

File GSTR-1 free with the tool, or hand it to a Tax Expert at a fixed fee.

← All articles
Talk to AprilTax