Generating the GSTR-1 JSON File in ERPNext
ERPNext can help you generate the JSON file for your GSTR-1 return, ready to upload to the GST Portal. The flow is: pull your GSTR-1 data out of ERPNext, run it through the GST Return Offline Tool to produce the JSON, and upload that file to the portal. Follow the steps below.
Steps
- Set up GST parameters. Go to Accounts > Goods and Services Tax (GST India) > GST Settings and update your GST parameters.
- Open the GSTR-1 report. Go to Accounts > Goods and Services Tax (GST India) > GSTR-1 (you can also search for it in the awesome-bar).
- Select the return period and type of business. Update the filters by return period and type of business (invoice type) to get the data you need.
- Download the GSTR-1 data. Go to the Menu, then export and download the GSTR-1 data.
- Open the GST Return Offline Tool. (Download the Offline Tool from the GST Portal if you don’t have it.) Press New and update the GST return type, GSTIN, Fiscal Year, and Tax Period in the tool.
- Import the GSTR-1 CSV. Select the section and import the GSTR-1 CSV into the Offline Tool.
- Generate and download the JSON file.
- Upload the JSON file on the GST Portal.
NOTE
ERPNext produces the GSTR-1 data; the JSON file itself is generated by the government’s GST Return Offline Tool. So the data is exported from ERPNext, converted to JSON in the Offline Tool, and only then uploaded to the portal.
TIP
Set your GST parameters carefully in Step 1 and double-check the return period and business-type filters before exporting. Getting these right means the exported data and therefore the JSON you upload — matches the period you’re actually filing for.
Related Topics
- GST Settings
- GSTR-1
- GST Returns
- Sales Invoice
SUMMARY
To generate the GSTR-1 JSON file using ERPNext: update your GST parameters in GST Settings, open the GSTR-1 report, and filter by return period and type of business. Export and download the GSTR-1 data, then open the GST Return Offline Tool, create a new entry with the return type, GSTIN, fiscal year, and tax period, and import the GSTR-1 CSV by section. Generate and download the JSON file from the Offline Tool, then upload it on the GST Portal. ERPNext supplies the data; the Offline Tool produces the final JSON.
