GSTR-9 Offline Tool (v1.0)
The excel based GSTR-9 offline utility is designed to help the taxpayer to prepare the GSTR-9 return offline. The utility can be downloaded from this link.Download
Important!
- Before you extract the downloaded file, ensure that the file is not corrupted. How do I know that my file is not corrupt? Click here to know more.
System Requirement
To use the tool efficiently, ensure that you have the following installed on your system:
- Operating system Windows 7 or above.
- Microsoft Excel 2007 & above
About GSTR 9 Offline Utility
1. What is Form GSTR-9 Offline Utility?
GSTR-9 Offline utility is an Excel-based tool to facilitate the preparation of annual return in Form GSTR-9. This Annual return is to be filed once, for each financial year, on the GST Portal, by the registered taxpayers who were regular taxpayers, including SEZ units and SEZ developers. Taxpayers may use the offline utility to furnish details of purchases, sales, input tax credit or refund claimed or demand created etc. in this return. Once return is prepared using offline utility, it can be uploaded on GST Portal by generating a JSON file.
2. What are the features of GSTR-9 Offline Utility?
The Key Features of GSTR-9 Offline Utility are given below:
The GSTR-9 details of Table 4 to Table 18 can be prepared offline with no connection to Internet.
Most of the data entry and business validations are inbuilt in the offline utility reducing chances of errors upon upload to GST Portal
Can I file Form GSTR-9 using Offline Utility?
No. You can prepare the Form GSTR-9 using the offline utility and then create a JSON file to upload on the Portal. Filing can take place only online on the GST Portal.
4. What details in Form GSTR-9 can be entered by taxpayer using the Offline
Details for following Tables of GSTR-9 can be entered by taxpayer using the offline Tool:
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 financial 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 financial year
Table 8 Other ITC: Summary of ITC availed during the financial year
Table 9 Tax Paid: Tax (including Interest, Late Fee, Penalty & Others) paid during the financial year
Table 10 PY trans in current FY: Summary of transactions reported in next financial year
Table 14 Differential tax: Total tax paid on transactions reported in next financial year
Table 15 Demand & Refunds: Particulars of demands and refunds during the financial year
Table 16 Comp DS & Goods sent on approval: Summary of supplies received from composition taxpayers, deemed supply under section 143 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
Table 8 Other ITC: Summary of ITC availed during the financial year
Table 9 Tax Paid: Tax (including Interest, Late Fee, Penalty & Others) paid during the financial year
Table 10 PY trans in current FY: Summary of transactions reported in next financial year
Table 14 Differential tax: Total tax paid on transactions reported in next financial year
Table 15 Demand & Refunds: Particulars of demands and refunds during the financial yea
Table 16 Comp DS & Goods sent on approval: Summary of supplies received from composition taxpayers, deemed supply under section 143 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
2. Download GSTR-9 Offline Utility
5 From where can I download and use the GSTR-9 Offline Utility in my system?
To download and open the GSTR-9 Offline Utility in your system from the GST Portal, perform following steps:
1. Access the GST Portal: www.gst.gov.in.
2. Go to Downloads > Offline Tools > GSTR-9 Offline Tool option and click on it.
3. Unzip the downloaded Zip file which contains GSTR_9_Offline_Utility.xls excel sheet.
4. Open the GSTR_9_Offline_Utility.xls excel sheet by double clicking on it.
5. Read the ‘Read Me’ instructions on excel sheet and then fill the worksheet accordingly. Note: Downloading the GSTR-9 Offline utility is a one-time activity. However, the utility may get updated in future. So, always use the latest version available on the GST Portal.
6. Do I need to login to GST Portal to download the GSTR-9 Offline Utility?
No. You can download the GSTR-9 Offline Utility under ‘Downloads’ section without logging in to the GST Portal.
7. What are the basic system requirements/configurations required to use GSTR-9 Offline Tool?
The offline functions work best on Windows 7 and above and MS EXCEL 2007 and above.
8. Is Offline utility mobile compatible?
As of now GSTR-9 Offline utility cannot be used on mobile. It can only be used on desktop/laptops
3. Download the Generated JSON File
9. Why do I need to download the generated JSON file from the GST Portal?
Generated JSON file needs to be downloaded to open the system-computed Form GSTR-9 data (based on GSTR-1 and Form GSTR-3B filed) for editing as well as to prepare details of Table 4 to Table 18 of Form GSTR-9 in the Offline Tool. JSON file will also have non-editable fields such as table no. 6A (ITC claimed in returns filed in Form GSTR-3B), table no. 8A (ITC as per GSTR-2A (Table 3 & 5 thereof) and table no 9 (except tax payable column)
10. Do I need to login to GST Portal to download the generated JSON file using GSTR-9 Offline Utility?
Yes. You must login in to the GST Portal to download the generated JSON file using GSTR-9 Offline Utility.
11. Is it mandatory to enter details in all worksheets(tables)?
It is not mandatory to fill data in all worksheets/tables. The worksheet for which no details are required to be reported can be left blank.
Download Complete File and user mannual of GSTR 9 Offline utility Click here
Related Post
Example of unreconciled differences to be reported in GSTR 9C (Sl. No.8 )
GSTR 9C Reconciliation Statement Filing on GST Portal by GSTN : GST Audit
How to file GSTR 9C online (GST Audit Reconciliation Statement )
How to file GSTR 9 Online on GST Portal
How to file GSTR 9A online on GST Portal
GSTR 9 Annual Return Filing by GSTN in Hindi
GSTR 9A Annual return filing in Hindi by GSTN
Who has to fill HSN Wise Summary in GSTR 9
GST Annual Return GSTR 9 : Free Video Tutorials
New Changes in GST Annual Returns for FY 2017-18
Quick filing Guide of Annual Return GSTR 9 under GST Act
GSTR 9 of Annual Return format Notified : Download /Print
GSTR 9A of Annual Return format for Composition taxpayer Notified : Download /Print
GSTR-9C Notified on 13.09.2018 : Download for Audit Report and Reconciliation Statement under GST :
Why GST Annual Return date Should not be extended
Why to file GST Annual Return (GSTR 9) before GST audit (GSTR 9C)
Download GSTR 9 Offline Tool, GSTR9Offline, GSTR 9 Offline Excel Utility, GSTR 9 REturn preparation software, GST Annual return offline Tool,GSTR 9 Offline Utility,
Pingback: TaxHeal - GST and Income Tax Complete Guide Portal