1Your GST details
The JSON is made for this GSTIN and return period.
2Where is your sales data?
Choose one option.
Download the Excel, fill the Platform Sales sheet (one row per order or invoice; returns as Type “Return”) and, for your other B2B sales, the B2B Supply sheet (same columns as our GSTR-1 Excel). You get only the JSON here, no bills. Fill the platform’s GSTIN from your TCS credit (GST portal → Services → Returns → TCS/TDS Credit Received).
3Upload your Excel sheet
Fill only the Sales Entry sheet of our Excel format: one row per invoice item. All other sheets fill automatically. Write the buyer's address in Party Address and the item name in Description of Goods; fill Quantity and Rate per unit and the Taxable Value works itself out.
Your business (printed on bills and ledgers)
With the JSON you also get every bill as a PDF, party-wise ledgers and the complete ledger in one ZIP. Saved in this browser.
Want payments in the ledger too? Fill the optional Payments sheet in our Excel (Date, Party Name, Amount, Mode).
4Your GSTR-1 JSON is ready
See JSON
How to upload on the GST portal
- Login at gst.gov.in → Services → Returns → Returns Dashboard.
- Select the same financial year and period → Search.
- In GSTR-1, click Prepare Offline → Upload → Choose file → select this JSON.
- Wait for status “Processed”, then check the summary and file GSTR-1.