How to file GSTR-9 offline?

GSTR-9 or the annual return can only be submitted or filed online. However, a majority of the details can be filled offline by using an offline utility provided by the Goods and Services Tax Network (GSTN). Further, those taxpayers who have to enter more than 500 records per table in Table 17 and 18 of the Form GSTR-9 will not be able to enter such details online. They will compulsorily have to use the offline utility to do so.

An easier and convenient way to file GSTR-9 without visiting any other portal is by using Clear GST solution.

Latest Update

Starting FY 2023-24 from 15th October 2024, GST portal auto-populates eligible ITC for domestic supplies (excluding reverse charge and ITC on imports) from Table 3(I) of GSTR-2B to Table 8A of GSTR-9. Further, a validation utility will be executed progressively (for validation by taxpayers) to complete the auto population of GSTR-9 from GSTR-2B from April 2023 till March 2024.

Prerequisites to use offline tool for GSTR-9

The offline utility can only be used on a desktop/laptop and not on a mobile device. The following are the system requirements:

1. Operating system: Windows 7 or above
2. Application software: Microsoft Excel 2007 or above
3. Cannot use the offline tool on mobile phones
4. Offline utility as downloaded from the GST portal (Ensure that the latest version is used)
5. Generated JSON file downloaded from the GST portal

Steps to setup the GSTR-9 Offline utility

(A) Download the offline tool for GSTR-9

Step 1: Visit the GST portal.

Step 2: Navigate to Downloads > Offline Tools  > GSTR-9 Offline Tool.

Step 3: Click on ‘Download’ hyperlink and then ‘Proceed’.

Step 4: Extract the contents of the zip file downloaded above. Navigate to the location of the extracted files and open the excel utility.

Step 5: The excel utility will automatically open on the home sheet. Click on ‘Enable Editing’. 

Please ensure that macros are enabled by clicking on ‘Enable content’.

A pop-up dialogue box will be displayed with the message ‘Open saved version’ with an option to click on either ‘Yes’ or ‘No’. If ‘Yes’ is selected, the utility will open with any previously saved data. If ‘No’ is selected, any old unsaved data will be lost, and a new blank utility will open.

Step 6: On the home sheet, enter the GSTIN and the financial year for which the return is being filed. Leave this utility running while the following steps are performed.  

(B) Download the GSTR-9 JSON file

Step 1: Log in to the GST portal.

Step 2: Navigate to Services > Returns > Annual Return or click on ‘Annual Return’ on the dashboard.  

Step 3: Select the financial year for which you want to upload details. Click on the ‘Search’ button. 

Step 4: On the GSTR-9 tile, click on the ‘Prepare Offline’ button. Move to the ‘Download’ section and click on the ‘Generate JSON file to download’ option. 

The JSON file will take up to 20 minutes to get generated. After it is ready, click on the ‘Click here to download – File 1’ hyperlink.

The GSTR-9 JSON file will be downloaded. This file contains system-computed Form GSTR-9 data based on filed Form GSTR-1 and Form GSTR-3B for editing in the offline tool with a few exceptions.

Step 5: Unzip/extract the download file. A JSON file will be available on the extracted location.

Step 6: Go back to the offline utility and navigate to the ‘Home’ tab. Click on the ‘Open Downloaded Form GSTR-9 JSON File’ button. 

Step 7: Navigate to the location of the saved JSON file and click on ‘Ok’ to proceed. The utility will display a message for successful import of the GSTR-9 JSON file. 

Steps to prepare GSTR-9 using the offline tool

Enter the following details in the sheets as follows:

• Table 4 Outward: Summary of outward/inward supplies made during the financial year
• Table 5 Outward: Summary of non-taxable outward supplies made during the fiscal year 
• Table 6 ITC availed: Summary of ITC availed during the financial year
• Table 7 ITC Rev: Summary of ITC reversed or ineligible for the fiscal year
• Table 8 Other ITC: Summary of ITC availed during the financial year
• Table 9 Tax Paid: Tax paid details, including interest, late fee, penalty, etc. during the fiscal year.
• Table 10 PY trans in current FY: Summary of transactions reported in the next financial year
• Table 14 Differential tax: Total tax paid on transactions reported in the next financial year
• Table 15 Demands and Refunds: Particulars of demands and refunds during the fiscal year
• Table 16 Comp DS & Goods sent on appr: Summary of supplies received from composition taxpayers, deemed supply by job worker and goods sent on approval basis
• Table 17 HSN Outward: HSN wise summary of outward supplies made during the financial year
• Table 18 HSN Inward: HSN-wise summary of inward supplies received during the financial year 

Note: The generated JSON file that was initially downloaded from the GST portal will be used to source the auto-populated data from already filed Form GSTR-1 and GSTR-3B into the respective fields in Table 4 to Table 18 of the Form GSTR-9. Some of this data will also be populated into non-editable fields.

Validate the data and generate the JSON file:

Step 1: Table 4 to Table 18 of the workbook will have a validate button on every sheet. Once data is filled into a particular sheet, click on ‘Validate’. If the information is in order, a success message is displayed. In case of an error, the same will be displayed. 

Step 2: After validating every sheet, go to the ‘Home’ sheet and click on the ‘Generate JSON File to upload’ button.

Step 3: The ‘Save As’ pop-up window will be displayed. Choose where you want the JSON file to be saved and click on the ‘Save’ button.

A message will be displayed that details are saved successfully and asking the user to upload the file on the GST portal.

How to upload generated JSON files?

Step 1: Log in to the GST portal.

Step 2: Navigate to Services > Returns > Annual Return. 

Step 3: Select the financial year for which you want to upload details. Click on the ‘Search’ button. 

Step 4: On the GSTR9 tile, click on ‘Prepare Offline’. The ‘Upload’ section will be displayed by default.

Step 5: Click on the ‘Choose File’ button and navigate to the location of the generated JSON file. Click on ‘Open’ when done. 

A message showing the successful upload of the JSON file will be displayed and you will be asked to wait until the GST portal validates the uploaded data. The status of the uploaded JSON file will be shown in the ‘Upload History’ section.

In case there were no errors, the status would appear as ‘Processed’.

In case there were errors in the data uploaded, the ‘Upload History’ section will show the status of the JSON file as ‘Processed with Errors’ and provide a hyperlink to ‘Download Error Report’ if any.

Click on the ‘Generate error report’ link to save the error JSON file. Instructions to resolve the errors are provided later in this article.  

To preview the filled data, in the annual return GSTR9 table, click on ‘Prepare Online’.

A question will be displayed: ‘Do you want to file a Nil return?’  Answer this question and click on ‘Next’.  

The Form GSTR-9 annual return for normal taxpayers page will be displayed along with fully furnished details in Table 4 to Table 18 that were filed using the offline utility. A preview of the form can be obtained by clicking on either the ‘Preview Draft GSTR-9 (PDF)’ or the ‘Preview Draft GSTR-9 (Excel)’ button.

For instructions on how to proceed with the filing, click here.

How to fix errors using the offline tool for GSTR-9?

Extract the error JSON file as mentioned earlier to a convenient location on your computer and follow the following instructions:

Step 1: Open the offline utility and navigate to the ‘Home’ sheet.

Step 2: Click on the ‘Open Downloaded Error JSON Files’ button. Navigate to the location of the stored error JSON files and click on ‘Ok’. Ensure both the files from the unzipped folder are selected before clicking on ‘Ok’. A message saying ‘Error Files successfully Opened’ will be displayed.

Step 3: On each individual sheet, go through the column ‘GST Portal Validation Errors’. You will see a text in this column informing the user of the nature of the error. Make the requisite corrections and click on the ‘Validate Sheet’ button on every sheet. 

Step 4: Go to the ‘Home’ sheet and click on the ‘Generate JSON File to upload’ button.

Step 5: The ‘Save As’ pop-up window will be displayed. Choose where you want the JSON file to be saved and click on the ‘Save’ button. A message will be displayed asking the user to upload the file on the GST portal.