LabelCroppers

GSTR for CA portal

GSTR-1 From the Amazon MTR Report: B2C, B2B, Refunds and HSN Explained

Updated 27 October 2026 · 3 min read · By the LabelCroppers team

Amazon gives sellers a Merchant Tax Report (MTR) every month – one for B2C sales and one for B2B sales. It lists every shipment, refund and cancellation with invoice numbers, taxable value, tax and the customer's state. It is the right source for an Amazon seller's GSTR-1, but it needs to be read correctly: refunds have to become credit notes, B2B orders need the buyer's GSTIN, and B2C sales must be grouped by state and rate.

Where to download the MTR

In Seller Central, open Reports → Tax Document Library (or the Tax Reports section) and download the MTR B2C and MTR B2B reports for the month. They usually arrive as ZIP files containing a CSV. You can keep them zipped – the portal opens ZIP files directly.

The columns that matter

  • Transaction Type – Shipment, Refund or Cancel.
  • Invoice Number / Invoice Date – the tax invoice; for refunds, the Credit Note No and date.
  • Ship To State – the place of supply for B2C.
  • Tax Exclusive Gross – the taxable value.
  • IGST / CGST / SGST / UTGST Tax and the matching rates.
  • Hsn/sac, Quantity, Sku.
  • Customer Bill To Gstid – present for business buyers on the B2B report.

How each part maps to GSTR-1

  • Shipments to unregistered buyers → Table 7 (B2CS), grouped by place of supply and rate; inter-state invoices above ₹1 lakh go to B2CL.
  • Shipments with a valid buyer GSTIN → Table 4 (B2B) with the buyer GSTIN and invoice details.
  • Refunds → reduce B2C values in the month; for B2B buyers, credit notes go to Table 9B (CDNR).
  • Cancellations with zero value are ignored.
  • HSN → Table 12, split into B2B and B2C.
  • Invoice and credit-note series → Table 13.
  • Net value through Amazon → Table 14 against Amazon's GSTIN for your state.

Watch-outs specific to Amazon

  • Invalid buyer GSTIN: business customers sometimes enter a wrong GSTIN. A B2B row with an invalid GSTIN should be treated as B2C.
  • Multiple seller GSTINs: if the seller has several registrations (for example FBA warehouses in other states), the MTR contains rows for each GSTIN. Prepare GSTR-1 separately for each one.
  • Rate rounding: compute the rate from the rate columns, not from tax ÷ value, to avoid 17.99% style errors.
  • Refund timing: a refund is reported in the month it happens, even if the original sale was in an earlier month.

Doing it in the portal

  1. Open GSTR-1 preparation in the GSTR for CA portal, choose the client and month.
  2. Drop the MTR B2C and MTR B2B files (ZIP or CSV) together with any other marketplace reports for that client.
  3. Click Build GSTR-1 report. Check the summary and the HSN table; codes missing in the report are filled from the same SKU or style and marked for review.
  4. Enter Amazon's GSTIN for your state once for Table 14; it is remembered next month.
  5. Download the Excel working and the GST JSON; click Save to client.

Cross-checking the result

Compare the portal's net taxable value for Amazon with the totals of Tax Exclusive Gross in the MTR (shipments minus refunds). They should match exactly. Also compare the tax with the "tax collected" figures in Amazon's TCS statement for a sense check – small differences come from timing of refunds.

Frequently asked questions

Do I need both MTR B2C and MTR B2B?

Yes, if the seller has business customers. B2B invoices appear only in the B2B report.

Can I upload the ZIP file directly?

Yes. The portal opens the ZIP and reads the CSV inside.

What about FBA stock transfers?

Stock transfers between the seller's own GSTINs are not in the MTR sales data and must be reported separately from the seller's own transfer invoices.

Are the files uploaded anywhere?

No. They are processed in your browser.

Try the GSTR for CA portal – freeClients, filing tracker, due dates, GSTR-1 and fees in one place.
Open the tool