Navigating the intricate web of Goods and Services Tax (GST) compliance in India has always been a challenge. As a business owner, I've often found myself juggling with the complexities of tax filing, invoice generation, and e-way bill creation. The ever-evolving regulations and requirements only added to the complexity. That's when I stumbled upon a hidden gem that transformed my GST compliance journey - the official website of GST (Goods and Services Tax) in India. On this platform, I discovered an array of free, official, and offline GST tools, and they've become my trusted companions. These tools are designed to make GST-related tasks easier, whether you're a business owner, tax professional, or individual taxpayer. Join me on a journey as I explore the world of free offline GST tools and share my experiences with these invaluable resources that have made a significant difference in my tax compliance journey. I'll be adding these tools regularly. Here's the first one
1.GST Returns Offline Tool Version V3.1.8
Download, extract and run the Returns Offline Tool to collate and upload the invoices and other data in offline mode. Currently this tool is available only for
GSTR-1 and GSTR-2 form.
Download Your downloaded (Returns Offline Tool) zip file contains:
- GST Offline tool (Application)
- Section Wise CSV files
- GSTR1 & GSTR2 Excel Workbook Template
- User Manual
- Readme
Important!
- Before you extract and run the downloaded file, ensure that the file is not corrupted. How do I know that my file is not corrupt? Read FAQ
- Go through the Readme document before you begin installation.
- Double-click on GST Offline Tool to install the offline tool.
System Requirement
To use the tool efficiently, ensure that you have the following installed on your system:
- Operating system Windows 7 or above. The tool does not work on Linux and Mac.
- Browser: You need one of these browsers installed on your system.
- Internet Explorer 10+
- Google Chrome 49+
- Firefox 45+
- Microsoft Excel 2010 & above
- Alternatively, for any below version the tool will open in a default browser.
FAQ of GST Returns Offline Tool
How do I know if downloaded gst_offline_tool.zip file is not corrupt?
Match one of the values provided in your downloaded file with the ones mentioned below. If there is an exact match, then your file is not corrupted. Else, download again.
Where do I find the values?
Windows : (Run from windows power shell)
Get-FileHash <<FileUrl>> Algorithm <<SHA256>>
Eg: Get-FileHash C:\Users\Test\Downloads\gst_offline_tool.zip -Algorithm SHA256
Your unique values:
SHA256:8384BFEEEC3EBECEB9BF33535F325727CDD7ABA40ACB5A01DD717ABC539C4203
2.GSTR3B Offline Utility
The excel based GSTR3B offline utility is designed to help the taxpayer to prepare the GSTR3B 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? Read below FAQ for same
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
FAQ of GST Returns Offline Tool
How do I know if downloaded GSTR3B_Excel_Utility.zip file is not corrupt?
Match one of the values provided in your downloaded file with the ones mentioned below. If there is an exact match, then your file is not corrupted. Else, download again.
Where do I find the values?
Windows : (Run from windows power shell)
Get-FileHash <<FileUrl>> -Algorithm <<SHA256>>
Eg: Get-FileHash C:\Users\Test\Downloads\GSTR3B_Excel_Utility.zip -Algorithm SHA256
Your unique values:
SHA256: 1F83D5F5DF474485414B7680203A730E4F4BA54E5E4954B32CF9FC6DAEC09A20
3.GSTR 4 (Annual) offline tool (v2.1)
The excel based GSTR-4 offline utility is designed to help the taxpayer to prepare the GSTR-4 return offline. The utility can be downloaded from this link.
DownloadImportant!
- Before you extract the downloaded file, ensure that the file is not corrupted.
4.GSTR4 (Quarterly Filing) Offline Tool Version V3.3
Download ; Unzip and open the GSTR-4 Offline utility (excel macro) to prepare your GSTR-4 return in offline mode.
Download Your downloaded (GSTR4 Offline Tool) zip file contains:
- GSTR_4_Offline_Utility (Excel Macro)
- FAQs and User Manual Returns Offline Tool_GSTR4
- Readme
- ReleaseNotes
Important!
- Before you Unzip and open the GSTR-4 offline tool, ensure that file is not corrupted.
- Go through the Readme document and Readme section in Offline utility
- Double-click on GSTR_4_Offline_Utility to run the offline utility.
6.GSTR 7 Offline Utility (v3.2)
The excel based GSTR7 offline utility is designed to help the taxpayer to prepare the GSTR7 return offline. The utility can be downloaded from this link.
Download
7.GSTR8 Offline Utility (v7.0)
The excel based GSTR8 offline utility is designed to help the taxpayer to prepare the GSTR8 return offline. The utility can be downloaded from this link. Download
8.GSTR-9 Offline Tool (v1.8)
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
9.GSTR 9A Offline Utility
The excel based GSTR-9A offline utility is designed to help the taxpayer to prepare the GSTR-9A return offline. The utility can be downloaded from this link.
Download
10.GSTR-9C Offline Utility (v2.4)
The excel based GSTR-9C offline utility is designed to help the taxpayer to prepare the auditor certified GSTR-9C reconciliation statement for financial years prior to FY 2020-21 in offline mode.
For FY 2020-21, taxpayer can use this tool to prepare the self-certified GSTR-9C reconciliation statement in offline mode.
The utility can be downloaded from this link.
Download Your downloaded (GSTR9C Offline Tool) zip file contains:
- GSTR_9C_Offline_Utility (Excel Macro)
- ReleaseNotes
11.GSTR 10 Offline Utility
The excel based GSTR10 offline utility is designed to help the taxpayer to prepare the GSTR10 return offline. The utility can be downloaded from this link.
Download
13.TDS & TCS Credit Received Offline Utility v2.2
The excel based TDS & TCS Credit Received offline utility is designed to help the taxpayer to prepare the TDS & TCS Credit Received 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.
14.Matching Offline Tool v2.2
The Matching Offline Tool can be used to:
- View GSTR-2B (Auto-drafted Input tax credit (ITC) statement)
- Match GSTR-2B with Purchase register
To install the tool, please download, extract the zip file and run the
Download Your downloaded (Matching_Offline_Tool) zip file contains:
- GSTR2B_Matching_Tool_v2.2.exe (Application)
- Purchase Register Excel Template
- Readme
- User Manual
- Change History
Important!
- Before you extract and run the downloaded file, ensure that the file is not corrupted.
- Go through the Readme document before you begin installation.
- Double-click on GSTR2B_Matching_Tool_v2.2.exe to install the offline tool.
What's new :
- GSTR2B_Matching_Tool_v2.2.exe (Released on 31/01/2023) - Updated 2.2 version includes advisory, label, GSTR-3B Table references and hover message changes at GSTR-2B Dashboard and in export to excel format.
- Purchase Register Excel Template v2.1 (Released on 15/07/2023) - Financial Year 2023-24 have been added in the Purchase Register drop-down.
15.ITC-01 Offline Tool_v1.1
Who should fill GST ITC-01 form?
You (the taxpayer) need to fill ITC-01 to declare details for following Tables/Sections:
- Table 7- Claim under section 18(1) (a) or section 18(1) (b) : Applicable for claim of input tax credit in case of new registration and voluntary registration
- Table 8- Claim under section 18(1) (c) or section 18(1) (d) : Applicable for taxpayer opting out from Composition levy or goods or services becomes taxable.
In case of claim under section 18(1) (a) and (b) the registered person can claim credit of input tax on
- Inputs held in stock
- Inputs contained in semi-finished or finished goods held in stock
In case of claim under 18(1) (c) & (d) in addition to above types of inputs registered person can claim credit on Capital goods as well.
How do I prepare the form when offline
Download and prepare the ITC -01 form when offline.
Download
Important!
- Before you extract and run 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.
- Go through the Readme document before you begin installation.
- Double-click on ITC-01 Offline Tool to open the offline tool.
- Edit the generated file using import option
- Prepare ITC-01 using excel when offline (i.e. without Internet).
- Generate the output file in .Json file format
- Using the output file, you can upload it in GST portal (www.gst.gov.in) (when online, with internet)
Your downloaded (ITC-01 Offline Tool) zip file contains:
- ITC01 excel
- ReadMe
- Release Note
PS: These tools are also available for free on
https://www.gst.gov.in/ website as well. We are just trying to bring all free tools available on different pages, on a single page. So that our users don't have to look for them separately.
