fynxIQ

Marketplaces · Amazon

GSTR-1 from Amazon MTR reports

Both halves of Amazon's Merchant Tax Report, read the way GST law reads them: shipments are invoices, refunds are credit notes against the original invoice, and a promotion reduces the tax as well as the base.

Reports needed

MTR B2C report, MTR B2B report, GST ready-to-file workbook

  1. Open Seller Central, then Reports, then Tax Document Library.
  2. Download the Merchant Tax Report for the month. Take both the B2C and the B2B file.
  3. Leave them zipped and drop both in. Which is which is worked out from the columns.
How confident we are

Verified

This adapter has been checked against real exports from a working seller account, and its edge cases are pinned as tests.

Where it goes wrong

What a Amazon export will not tell you it is doing.

None of these produces an error message. Each produces a return that looks complete and is wrong, which is exactly why they are worth spelling out.

Watch for

Rate columns hold fractions

Amazon writes 0.03 where the return needs 3. Read literally, every tax figure in the return is out by a factor of a hundred, and the file still looks well formed.

Watch for

A promotion is booked twice

A discounted order shows the full tax in the head column and the relief in a separate promo tax column. Adding only the head column overstates tax on every discounted order.

Watch for

Free replacements still consume invoice numbers

A zero-value replacement is not a supply, but it did use a number. Treating it as a cancellation understates the documents issued in Table 13.

Watch for

The B2B file alone is not a month

B2B is usually a small tail of turnover. A return built from it looks complete and omits nearly all the sales, so fynxIQ blocks rather than files it.

Also supported

Selling on more than one?

Drop every marketplace’s files in together. fynxIQ merges them into one ledger per GSTIN, keeps each document series separate in Table 13, and reports each operator separately in Table 14.

TCS sales

Meesho

Meesho splits a month across two downloads. The amounts are in one and the document numbers in the other, joined on the sub-order number.

GST sales report

Flipkart

Sales, returns, cancellations and replacements read from one file, with the event type deciding which is which.

GST sales register

Myntra

Forward and reverse movements arrive in one register, with the credit note number sitting on the return rows themselves.

Any CSV or Excel export

Anything else

Point the fields at the columns once and any spreadsheet becomes a supported source. The mapping is saved and reused every month.