1Your GST details
The JSON is made for this GSTIN and return period.
2Where is your sales data?
Choose one option.
Use one, two or all three. Everything goes into one GSTR-1 JSON and you pay only once, when you download. This option makes only the JSON (no bills).
Carry_Forward_…csv). They are reduced from this month's B2C sales. This is the same Excel as “My Excel sheet”: fill the Sales Entry sheet (and Credit Debit Notes if any) the same way, with your Invoice Series at the top. Sales through Amazon, Flipkart, Swiggy or Zomato go in the optional Platform Sales sheet. Here you get only the JSON, no bills or ledgers (for bills use “My Excel sheet”).
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.
You get the JSON, every bill and the ledgers in one download. Make and check the JSON first; the amount for your number of bills is shown on the payment screen when you download.
The portal rejects a bill number already used earlier in the year (Rule 46). Fill this and we warn you before you upload. We also remember the numbers of every JSON you download here.
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
Portal did not take all bills? Fix with the error report
If the portal shows “Processed with error”: GSTR-1 → Prepare Offline → Upload → Generate error report → download it, and choose that file here (.json or .zip). The tool explains each error. Bills whose number is already used in an earlier month's GSTR-1 get the next free numbers in your series, and the JSON is made again.
Leave it blank to use the numbers after the last bill in this Excel. Fill it when your earlier months used higher numbers, so the new numbers do not clash again.
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.