How to File GSTR-9C Offline?

A taxpayer registered under GST whose aggregate turnover during the financial year exceeds Rs.5 crore must submit GSTR-9C (self-certified reconciliation statement). He shall furnish a copy of audited annual accounts and the annual return in GSTR-9 along with Form GSTR-9C.

Latest Updates

53rd GST Council meeting
As on 22nd June 2024, the Council has recommended to provide relaxation to taxpayers from filing GSTR-9/9A for FY 2023-24 where their aggregate annual turnover for the said financial year is below Rs.2 crore. This was notified via CGST notification 14/2024 dated 10th July 2024.

Prerequisites for using the offline tool for GSTR-9C

A taxpayer is required to use:

• Needs a laptop or desktop
• Tool is compatible with Windows 7 and above
• Tool is compatible with Microsoft Excel 2010 & above

Steps to download and open the offline tool for GSTR-9C

Step 1: Visit the GST portal. 

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

Step 3: Click the download link on the GSTR-9C offline utility page.

Step 4: A confirmation message will pop-up. Click on ‘Proceed’.

Step 5: The GSTR-9C offline utility will be downloaded in a zip file. Extract the files from the zipped folder to get GSTR_9C_Offline_Utility in excel. Right-click and then click open.

Along with the utility, there will be following files as well:

• Readme: It has installation instructions and prerequisites before installation. Read these instructions before installation.
• Release notes: This file contains all the record of any enhancements made to the GSTR-9C offline tool.
• Wsweb HTML file: The offline utility and this HTML file should be in the same folder to generate JSON.

Step 6: Click ‘Enable editing’ and ‘Enable Content’ on the GSTR-9C offline utility.

Step 8: Go to the ‘Read me’ tab and read the introduction and help instructions.

Step 9: Go to the home tab and fill the basic instructions:

• Enter the GSTIN
• Choose the financial year
• Enter the legal name and trade name
• Fill in the name of the Act under which your enterprise is subjected to audit under any law.

Step 10: Proceed to file Part A. If you save the data and close the utility, a pop-up message will come ‘Open saved version?’. Select yes to save the data otherwise one needs to fill the data again from scratch.

Steps to prepare GSTR-9C using the offline tool

An auditor needs to fill the details in Part A.

Part A:

• Pt II Reconciliation of turnover as declared in audited financial statements and Form GSTR-9C: Update the details in the below tables:
• PT II(Table 5)- Reconciliation of gross turnover
• PT II(6)-Update reasons for the unreconciled difference in annual gross turnover
• PT II(7)- Reconciliation of taxable turnover
• PT II(8)- Reasons for unreconciled difference in taxable turnover
• Pt III Reconciliation of taxes paid: Update the details in the below tables:
• PT III(Table 9)- Reconciliation of rate-wise liability and the amount payable thereon
• PT III(10)- Reasons for unreconciled payment of tax
• PT III(11)-Additional amount payable but not yet paid
• Pt IV Reconciliation of Input tax credit (ITC)
• PT IV(Table 12)- Reconciliation of net ITC
• PT IV(13)- Reasons for unreconciled difference in ITC
• PT IV(14)- Reconciliation of ITC as declared in GSTR-9 with ITC availed on expenses as per audited financial statements or books of accounts
• PT IV(15)- Reasons for unreconciled difference in ITC
• PT IV(16)- Tax payable on the unreconciled difference in ITC
• Pt V Additional liability due to non-reconciliation

PT II(5)- Reconciliation of gross turnover

1. Go to  PT II (5) tab and enter the details in the amount column for the below tables:

• 5A Turnover details as per audited financial statements for the state/UT
• 5B/5H Unbilled revenue at the beginning/end of the financial year
• 5C/5I Unadjusted advances at the end/beginning of the financial year
• 5D Deemed Supply as per schedule I
• 5E Credit Notes reflecting in GSTR-9 but issued after the end of the financial year
• 5F Trade Discounts as per audited annual financial statement but are not eligible under GST.
• 5G Turnover from April 2017 to June 2017
• 5J Credit notes as per the audited annual financial statement but are not eligible under GST
• 5K Adjustments due to the supply of goods by SEZ units to DTA units
• 5L Turnover for the period under composition scheme
• 5M, 5N, 5O Adjustments in turnover as per section 15, foreign exchange fluctuations, reasons not listed above respectively
• 5P Annual turnover after adjustments as above 
• 5Q Turnover as declared in form GSTR-9 
• 5R Unreconciled turnover which is a difference of Q & P above.

2. After updating all the required details, click on the ‘Validate sheet’ button.

• In case of successful validation: A pop-up message will come stating ‘Sheet successfully validated’. Click ok to proceed updating details in other tabs of the worksheet. 
• In case of unsuccessful validation: A pop-up message will be displayed stating that there are validation errors in the sheet. The errors will be highlighted in red along with a description of the error.

Correct the errors and again click on the ‘Validate sheet’ button again.

PT II(6)-Update reasons for the unreconciled difference in annual gross turnover
 

1. Go to the PT II (6) tab and enter reasons for the reconciled difference in annual gross turnover in the Reason Number 1 text field. 

2. To add more reasons, click on ‘Add’.

3. Then, click on the ‘Validate sheet’ button. Correct the errors, if any.

PT II(7)- Reconciliation of taxable turnover
 

1. Go to tab Pt II(7) and enter details in the amount column for the tables mentioned below:

• 7A Annual turnover after making adjustments
• 7B Enter the value of exempted, nil rated, non-GST supplies, no-supply turnover
• 7C Enter zero-rated supplies without payment of tax
• 7D Update the details of supplies on which tax is to be paid by the recipient on the reverse charge basis 
• 7E Update the taxable turnover as per adjustments made above (A-B-C-D)
• 7F Enter the taxable turnover as per form GSTR-9
• 7G Unreconciled taxable turnover (F-E)

2. After updating all the required details, click on the ‘Validate sheet’ button and correct errors if any.

PT II(8)- Reasons for unreconciled difference in taxable turnover

Go to tab Pt II(8) and follow the same steps as mentioned under Pt II(6).

PT III(9)- Reconciliation of rate-wise liability and the amount payable thereon

1. Go to tab Pt III(9) and enter the details in the taxable value and tax payable column for the below-mentioned tables:

• 9A to 9O Update details of tax rates, interest, penalty, late fee and others
• 9P Enter the total amount to be paid
• 9Q Update the total amount paid as per Form GSTR-9
• 9R Total unreconciled payment of the amount

2. After updating all the details, click on the ‘Validate sheet’ button and correct errors if any.

PT III(10)- Reasons for unreconciled payment of tax

Go to tab Pt II(10) and follow the same steps as mentioned under Pt II(6).

PT III(11)-Additional amount payable but not yet paid

1. Go to tab Pt III(11) and enter the details in the taxable value and tax to be paid through cash columns.

2. After updating all the details, click on the ‘Validate sheet’ button and correct errors if any.

PT IV(12)- Reconciliation of net ITC

1. Go to tab Pt IV(12) and enter the details in the amount column for the tables-mentioned below:

• 12A Enter the ITC availed amount as per audited financial statements for the state/UT
• 12B Enter the amount of ITC booked in earlier financial years but claimed in the current year
• 12C Enter the amount of ITC booked in the current financial year but will be claimed in subsequent financial years
• 12D Enter the amount of ITC availed as per audited financials
• 12E Enter the amount of ITC claimed as per form GSTR-9
• 12F Update the reasons for unreconciled ITC

2. After updating all the required details, click on the ‘Validate sheet’ button and correct errors if any

PT IV(13)- Reasons for unreconciled difference in ITC

Go to tab Pt IV(13) and follow the same steps as mentioned under Pt II(6).

PT IV(14)- Reconciliation of ITC as declared in GSTR-9 with ITC availed on expenses as per audited financial statements or books of accounts

1. Go to tab Pt IV(14) and enter the details in the value, amount of total ITC and amount of eligible ITC availed columns of the below-mentioned tables:

• 14A to 14Q Enter the details of various expense sub-heads under these tables
• 14R Update the total amount of eligible ITC availed
• 14S Update the details of  ITC claimed in GSTR-9
• 14T Update the reasons for unreconciled ITC

2. After updating all the required details, click on the ‘Validate sheet’ button and correct errors if any.

PT IV(15)- Reasons for unreconciled difference in ITC

Go to tab Pt IV(15) and follow the same steps as mentioned under Pt II(6).

PT IV(16)- Tax payable on the unreconciled difference in ITC

1. Go to tab Pt IV(16) and enter the details in the amount payable column.

Pt V Additional liability due to non-reconciliation

1. Go to tab Pt V and enter the details in the value, tax to be paid through cash columns. 

2. After updating all the details, click on the ‘Validate sheet’ button and correct errors if any.  

How to download the filed form GSTR-9 for preparing Form GSTR-9C?

Step 1: Log in to the GST portal. 

Step 2: Navigate to Services > Returns > Annual Return

Step 3: Select the financial year and then click ‘Search’ on the ‘File Annual Returns’ page. 

Step 4: Click on ‘Download GSTR-9’ button in the GSTR-9 tile.

Step 5: The offline download for GSTR-9 page will be displayed. Download the filed GSTR-9 data using the below-displayed buttons.

How to download form GSTR-9C tables derived from Form GSTR-9?

Step 1: Log in to the GST portal. 

Step 2: Navigate to Services > Returns > Annual Return 

Step 3: Select the financial year and then click ‘Search’ on the ‘File Annual Returns’ page.  

Step 4: For downloading data related to GSTR-9C, click the ‘Initiate filing in GSTR-9C’ tile.

Step 5: GSTR-9C page will be displayed. Click on the ‘Download GSTR-9C TABLES DERIVED FROM GSTR-9(PDF)’ button.

The system generated PDF will get downloaded.

How to generate the JSON file for upload and affix the DSC?

Note: Before you proceed with generation the JSON file-

a) Ensure you have installed emSigner in your system. 

b) Ensure that in the ‘PT V’ tab of your Worksheet, you have entered the same PAN with which you had registered your DSC. 

Otherwise, you will not be able to e-sign using your DSC while generating the JSON file. 

1. Go to the home tab, and click on the ‘Generate JSON file to upload GSTR-9C details on GST portal’ button.

A ‘Save As’ dialogue box opens.

Click on the ‘Save’ button. 

Note: Please ensure that the HTML file name ‘wsweb’ and ‘GSTR_9C_Offline_Utility’ should be in the same folder to generate the JSON file. 

2. A pop-up message will be displayed. Click on ‘Allow blocked content’ of ActiveX pop-up in IE.

3. Click the ‘Initiate signing’ button.

4. A ‘Ready to sign’ pop-up will be displayed. Click on the ‘Ok’ button.

5. Click the ‘Open Emsigner’ button. An Emsigner popup will be displayed. Select the Certificate and sign. 

6. A success message pop-up will get displayed mentioning that the signing of the JSON file is now complete.

7. Click on ‘OK’. A popup message will appear, which mentions that the signed JSON file has been generated, and saved at the specified location, and is now ready for upload. 

8. Click the ‘OK’ button to close the popup. You can send this signed JSON file to the taxpayer for uploading. 

How to upload the generated JSON file of GSTR-9C?

An auditor should send the signed JSON file to the taxpayer for upload. A taxpayer has to follow these steps: 

Step 1: Log in to the GST portal. 

Step 2: Navigate to Services > Returns > Annual Return 

Step 3: Select the financial year and then click ‘Search’ on the ‘File Annual Returns’ page. The GSTR-9C tile will be displayed. Click on ‘Prepare offline’.

Step 4: Click choose the file on the upload section on the offline upload page of GSTR-9C. 

Browse the JSON file to be uploaded and click open. On successful upload, a confirmation message will be displayed that the JSON is successfully uploaded. 

How to initiate the filing of Form GSTR-9C?

1. Log in to the GST portal. 

2. Navigate to Services > Returns > Annual Return.

3. Select the financial year and then click on ‘Search’ on the ‘File Annual Returns’ page.

4. File annual returns page will be displayed. Click on the ‘Initiate filing’ button.

5. On clicking initiate filing, the below page will be displayed.

• Click on DRC-03 hyperlink to make payment of additional liability as identified.
• Under the uploads link, choose the balance sheet, profit and loss account/statement of income and expenditure for upload. Note that File with PDF or JPEG format is only allowed with a maximum of 2 files and 5 MB file size for each.
• Click ‘Save’. This will enable the ‘Proceed to file’ button.
• Click on the ‘Preview draft GSTR-9C’ button to preview the file before upload.

• After careful verification of draft GSTR-9C, click on the ‘Proceed to file’ button.
• Select the declaration checkbox and authorised signatory from the drop-down list. Then click on the ‘File GSTR-9C’ button.
• A warning message will popup. Click on ‘Yes’ to proceed.
• File with either DSC or EVC.

• A message will be displayed in green reporting successful filing along with ARN. Also, the status on the GSTR-9C page will be displayed as ‘Filed’.