GSTR-1 JSON Generator for E-Commerce Sellers
Convert sales, returns, and invoice spreadsheets from Meesho, Flipkart, Amazon, and Myntra into 100% portal-compliant GSTN v5.0 JSON files in under 2 minutes.
Upload Your Marketplace Report & Get Portal JSON
100% client-side privacy. Zero server uploads. Instant JSON download.
Launch GSTR-1 Generator →What is a GSTR-1 JSON File?
A GSTR-1 JSON file is a standardized data exchange format created by the Goods and Services Tax Network (GSTN). Under the GST law, all registered taxpayers making outward supplies of goods and services must file Form GSTR-1 monthly or quarterly.
For e-commerce marketplace sellers, filing manually invoice-by-invoice is impossible due to hundreds or thousands of retail orders. The GST portal provides an Offline Utility JSON Upload feature that ingests your aggregated monthly transactions in a single click.
Key Statutory Tables in GSTR-1 for E-Commerce
| GSTR-1 Table | Table Name | What It Contains for Marketplace Sellers |
|---|---|---|
| Table 7 (B2CS) | B2C Small Supplies | Retail customer orders aggregated by Place of Supply (POS State Code) and Tax Rate (e.g. 5%, 12%, 18%). |
| Table 4 (B2B) | Business-to-Business Invoices | Wholesale orders where the customer provided a registered 15-digit GSTIN, listed by invoice number. |
| Table 12 (HSN) | HSN Summary of Outward Supplies | Summary of goods sold grouped by 4 or 6 digit HSN codes, UQC unit codes (NOS), and tax values. |
| Table 13 (DOCS) | Document Issue Register | Serial number sequence range (e.g. INV-001 to INV-450) and total cancelled credit notes. |
| Table 14 (ECO) | Supplies through E-Commerce Operator | Declaration of net sales through Meesho, Amazon, and Flipkart with Operator ETINs for Section 52 TCS. |
When customer returns from previous months exceed new sales in a given state, the net value becomes negative. The GST portal schema throws an error and rejects files with negative taxable values. GSTWali automatically clamps negative buckets to ₹0 and carries forward the excess credit to next month's return.
How to Generate and Upload Your GSTR-1 JSON
- Download your marketplace reports: Export the monthly GST sales and return sheets from your seller panel (Meesho, Amazon, Flipkart, or Myntra).
- Upload to GSTWali: Select your marketplace in GSTWali and upload your files.
- Inspect the audit summary: Review your gross sales, return deductions, net taxable turnover, and IGST/CGST/SGST breakdown.
- Download the JSON file: Click "Download GSTR-1 JSON" to receive the schema-validated file.
- Upload to GST Portal: Log in to
services.gst.gov.in> Returns Dashboard > GSTR-1 > Prepare Offline > Upload.
Supported Marketplace File Formats
- Meesho:
tcs_sales.xlsx,tcs_sales_return.xlsx, andInvoice_Infosheet. Learn more about Meesho GST filing → - Amazon: Merchant Tax Report (
MTR.csv) covering B2B, B2C, and Refunds. Learn more about Amazon GST filing → - Flipkart: Monthly Sales Report and Cash Back Report. Learn more about Flipkart GST filing →
- Myntra: PPMP Sales and Return reports. Learn more about Myntra GST filing →
Ready to Generate Your GSTR-1 JSON?
Process your sales sheets in seconds with 100% portal compliance.
Generate GSTR-1 JSON Now →