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 neededMTR B2C report, MTR B2B report, GST ready-to-file workbook
- Open Seller Central, then Reports, then Tax Document Library.
- Download the Merchant Tax Report for the month. Take both the B2C and the B2B file.
- Leave them zipped and drop both in. Which is which is worked out from the columns.
How confident we areVerified
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 forRate 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 forA 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 forFree 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 forThe 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 salesMeesho 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 reportSales, returns, cancellations and replacements read from one file, with the event type deciding which is which.
GST sales registerForward and reverse movements arrive in one register, with the credit note number sitting on the return rows themselves.
Any CSV or Excel exportPoint the fields at the columns once and any spreadsheet becomes a supported source. The mapping is saved and reused every month.