Filing the GSTR-1 reports generated from Refrens is super easy.  


Let’s see how:

Step 1. Download GSTR-1 Report From Refrens


In the sidebar, go to GST Reports > GSTR-1 Report.




Then select the period for which you want to download the GSTR-1 report and click on Download Excel as shown below:




(For more details on downloading and recategorizing your GSTR-1 report on Refrens, check out this detailed article >>)


Step 2. Upload the GSTR-1 Report in the GST Offline Utility Tool


Once you are done downloading your GSTR-1 Report from Refrens, open the GST Offline Utility Tool. 


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.



1. Import all sections in one go via the ‘Import Excel’ option.

2. 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.


Step 3. Create JSON File to Upload in the GST Portal


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.



Download the JSON file from the link and upload the same to the GST portal.




That’s it! Filing your GSTR-1 Report using the GST Offline Utility Tool is that easy.


In case of any queries, feel free to reach out to our chat support. We will be more than happy to help :)