Upload reports from all three platforms — get one combined B2CS, HSN Summary (Table 12) and Documents Issued (Table 13) for the period, ready to review and file in one go.
Runs fully in your browser — nothing is uploaded anywhere
1Upload your reports
Meesho (all three files below) — required for Meesho data
Flipkart (optional) — Sales Report for the same period
Amazon (optional) — Merchant Tax Reports (Reports → Tax Document Library), B2B and B2C are separate downloads
🛠️ Fixed two silent data-loss bugs: (1) this tool used to always read a workbook's first sheet — for Flipkart's export that's the "Help" instructions tab, not "Sales Report" — so Flipkart data was never actually parsed. (2) Some exports write an incorrect internal "dimension" tag that understates how many rows the sheet really has (seen on a real Flipkart file: it claimed only the header row existed when 8 rows of data were present); the reader used to trust that tag and silently drop everything past it. Both are now corrected — every sheet is picked by name and its real data range is recomputed from its actual cells before reading.
🔍 Flipkart columns have been verified against a real Sales Report export, so this mapping is exact — not a guess. The workbook's Cash Back Report sheet (Credit/Debit Notes for cashback-offer settlements) is now read too and folded into Tables 7, 12 & 13 — this used to be skipped entirely.
🔍 Amazon's MTR columns haven't been verified against a real file yet — this reads them by best-effort matching (looking for "hsn", "igst amount", "invoice number", etc.). Please double-check the Amazon rows in the tables below before filing, and send a sanitized sample so this can be locked down exactly, the way Meesho and Flipkart now are.
2Return details
3B2CS — Table 7 (state & rate wise, net of returns)
Place of supply
Rate %
Type
Taxable value
IGST
CGST
SGST
Cess
Upload & process files to see this table.
4HSN Summary — Table 12
HSN
Rate %
Qty
Taxable value
IGST
CGST
SGST
Cess
Upload & process files to see this table.
⚠️
5Documents Issued — Table 13
Document type
From
To
Total
Cancelled
Net issued
Upload & process files to see this table.
💡 This table can't be uploaded via JSON — GSTN's own tooling documentation confirms Documents Issued must always be entered manually under Prepare Online, regardless of software. See the Manual Online Entry card below for the exact values grouped by GSTN's official document categories. Cancelled invoices aren't flagged by Meesho's file — it defaults to 0; edit that cell if you know of any. Fixed: from/to ranges are now sorted by each document's own serial number, not its date — a series can be issued slightly out of date order, which used to report the wrong starting invoice.
6Manual Online Entry — Tables 7, 12 & 13
GSTN doesn't accept Documents Issued via JSON/CSV upload in any tool — it must always be typed in directly under Prepare Online. These three tables are laid out to match the portal's own fields, so you can go field-by-field without doing any of the state/HSN/document-series math yourself.
Table 7 — B2C (Others)
Portal asks for Place of Supply, Rate and Taxable Value per row — it calculates the tax itself once you pick the rate, so you only need to type these three.
Place of Supply
Rate (%)
Taxable Value
Table 12 — HSN Summary
HSN
UQC
Total Qty
Total Value
Taxable Value
IGST
CGST
SGST
Cess
Table 13 — Documents Issued
Nature of Document
Sr. No. From
Sr. No. To
Total Number
Cancelled
Net Issued
Upload & process files to see this.
7Business Insights — for your own reference (not part of GSTR-1)
Platform
Delivered/Sale (qty)
Sale value
Returned (qty)
Return value
RTO (qty)
RTO value
Return rate
Upload & process files to see this.
💡 Counts are line-items per report row, not always unique orders (a multi-item order shows as multiple rows). Meesho's return file doesn't separate RTO from customer returns, so Meesho shows everything under "Returned". RTO only appears separately where a platform's own data actually distinguishes it.
8Download
⚠️ This JSON now contains only b2cs and hsn — doc_issue was removed after confirming GSTN doesn't accept Documents Issued via upload in any tool; use the Manual Online Entry card above for Table 13 instead. Try Prepare Offline → Upload for this JSON first; GST's schema is known to reject files even from official accounting software from time to time (a widely reported GSTN quirk, not unique to this tool). If it's rejected, use the Manual Online Entry tables above to key figures into Prepare Online — that path never fails on schema. Always cross-check totals against your platform reports before filing; this isn't a substitute for your CA's review.
Built for laptop use as a Blogger gadget — safe to embed, no data ever leaves your device.
Comments
Post a Comment