How to download GSTR-1 report as a JSON file?
There are two ways to get a JSON file of your GSTR-1 report on Refrens.
1) Download JSON in 1-click directly from Refrens
2) Download GSTR-1 Excel and convert it to JSON using the GST offline utility tool
Go to GST Reports > GSTR-1 Sales Report > Download as "JSON":
That's it! Just upload the downloaded JSON to the GST portal to finish your filing!
If you have downloaded GSTR-1 in Excel, and want to convert it into JSON, you can do that using the GST Offline Utility Tool as well. Let's see how:
Firstly open the GST Offline Utility Tool. ( You can download the Offline Utility Tool from here >)
Then under the “Upload New Invoice/other data for return” table, click on ‘New’:
Next, fill in all the details like GST Statement, GSTIN of Supplier, Financial Year, Tax Period, etc., and click ‘Proceed’:
You will see a confirmation message as shown below. Just verify your details and click ‘Yes’.
You will be redirected to a new page like below:
Just click on ‘Import Files’ to import your GSTR-1 Report.
You will be redirected to a new page called “Import Data Using Excel and CSV Import”:
Here, there are two ways to import your GSTR-1 report.
Import all sections in one go via the ‘Import Excel’ option.
Import each section one by one
In this article, we will see how to import all sections in one go with the ‘Import Excel’ option. The process for importing each section one by one is also similar.
Click on the ‘Import Excel’ option and select the GSTR-1 Report you downloaded from Refrens.
In case your file has any errors, a warning message will appear, as shown below:
This warning message contains the list of possible reasons why your documents were not uploaded to the offline utility tool.
It also includes the list of documents that were not uploaded to your utility tool due to those errors, as shown below:
The rest of the documents not mentioned here have been successfully uploaded. So you don't need to upload them again.
Just rectify the documents mentioned in the warning message, and follow the same procedure to upload them again.
Once you are done uploading all the data to your GST Offline Utility Tool, click on the ‘View Summary’ button as highlighted below:
Here, just click on 'Generate File' to generate a JSON file that can be uploaded to the GST Portal.
Click on the link to download the JSON file:
That’s it! Filing your GSTR-1 Report using the GST Offline Utility Tool is that easy.
If you still have questions, feel free to contact us at care@refrens.com OR drop a message on live chat support for quick assistance!
1) Download JSON in 1-click directly from Refrens
2) Download GSTR-1 Excel and convert it to JSON using the GST offline utility tool
1) Downloading JSON in 1-click directly from Refrens
Go to GST Reports > GSTR-1 Sales Report > Download as "JSON":
That's it! Just upload the downloaded JSON to the GST portal to finish your filing!
2) Generating JSON using the GST Offline Utility Tool
If you have downloaded GSTR-1 in Excel, and want to convert it into JSON, you can do that using the GST Offline Utility Tool as well. Let's see how:
Firstly open the GST Offline Utility Tool. ( You can download the Offline Utility Tool from here >)
Then under the “Upload New Invoice/other data for return” table, click on ‘New’:
Next, fill in all the details like GST Statement, GSTIN of Supplier, Financial Year, Tax Period, etc., and click ‘Proceed’:
You will see a confirmation message as shown below. Just verify your details and click ‘Yes’.
You will be redirected to a new page like below:
Just click on ‘Import Files’ to import your GSTR-1 Report.
You will be redirected to a new page called “Import Data Using Excel and CSV Import”:
Here, there are two ways to import your GSTR-1 report.
Import all sections in one go via the ‘Import Excel’ option.
Import each section one by one
In this article, we will see how to import all sections in one go with the ‘Import Excel’ option. The process for importing each section one by one is also similar.
Click on the ‘Import Excel’ option and select the GSTR-1 Report you downloaded from Refrens.
In case your file has any errors, a warning message will appear, as shown below:
This warning message contains the list of possible reasons why your documents were not uploaded to the offline utility tool.
It also includes the list of documents that were not uploaded to your utility tool due to those errors, as shown below:
The rest of the documents not mentioned here have been successfully uploaded. So you don't need to upload them again.
Just rectify the documents mentioned in the warning message, and follow the same procedure to upload them again.
Once you are done uploading all the data to your GST Offline Utility Tool, click on the ‘View Summary’ button as highlighted below:
Here, just click on 'Generate File' to generate a JSON file that can be uploaded to the GST Portal.
Click on the link to download the JSON file:
That’s it! Filing your GSTR-1 Report using the GST Offline Utility Tool is that easy.
If you still have questions, feel free to contact us at care@refrens.com OR drop a message on live chat support for quick assistance!
Updated on: 21/03/2025
Thank you!