GST Offline Tool Download for Free in Excel format

Download the latest GST offline tool from the below table and prepare your forms, returns in the excel sheet.   These tools do not require an internet connection.  Thus, you can prepare the return in offline mode and generate JSON file ready to upload on the GST portal. You will learn the GST offline tool download process in simple steps, after going through this article.

GST Excel tools play a very important role in filing GST returns under the Goods and Service Tax system. Thus, one can use this offline tool and prepare the GST returns and other ITC forms without the need for an internet connection.

gst offline tool image

However, most of the taxpayers are facing issues to work with these offline utilities. This is mostly because the below tools require the latest version of windows. Also, these tools do not support other operating systems like Mac and Linux. Therefore, it is quite possible that many taxpayers are still using Windows XP and trying to do it online. This results in errors while generating a JSON file.

Below GST offline tools generate GST portal compatible JSON file ready to upload with all entered records by the taxpayer. However, due to compatibility issues, some are not able to generate this JSON file.

How to use offline Tool?

In order to use an offline tool one must have windows 7 pc with the latest updates installed, and Microsoft Excel. Besides this, one must enable the “Macros” in excel to work these tools correctly. you can enable macros by going to Options >Trust center > “Trust center settings” on the right-hand side. Thereafter, click on macro settings > Click to “Enable all macros(not recommended) potentially dangerous code can run” option.

Further click on external content > Click to select “Enable all data connections(not recommended) option. Similarly, click on “Enable automatic update for all workbook links(not recommended) option.

GST offline tool download Table

Sr.no.
Name of offline Tool DescriptionDownload Link
1.GSTR 1GSTR 1 offline tool shall be used to enter details of outward supplies of goods or services. Download
2.GSTR 3BWith the help of GSTR 3B offline tool taxpayer can prepare the summary of outward supplies and upload the JSON file on GST portal to file GSTR 3B return. Download
3.GSTR 9Download GSTR 9 offline to file Annual GST Return.Download
4.GSTR 9AWith the help of GSTR 9A offline tool taxpayer can prepare Annual return in offline mode. This excel tool shall be used for filing an annual return by composite dealers.Download
5.GSTR 9C
GSTR 9C is an offline tool shall be used by chartered accountants to prepare Reconciliation statement and shall be filed in support with GSTR 9 Annual return.Download
6.TRAN 2If you have a large number of records in section 4 of the Tran-2 form, you can Use this template to fill in the details and generate the JSON file for upload.

Secondly, If you have a large number of records in section 5 of the Tran-2 form, you need to use this template to fill in the details and generate the JSON file for upload.
Download
7.ITC 01In order to claim the input tax credit in case of new registration, voluntary registration and taxpayer opting out from Composition levy or goods or services becomes taxable shall use ITC 01 Offline tool.Download
8.ITC 04GST ITC-04 offline tool is an use-full tool for manufacturers and job workers for sending and receiving processed goods back.Download
9.GSTR 4A composition dealer can use this excel utility to file his return in form GSTR 4.
Download
10.GSTR 11GSTR 11 for Inward supplies statement for persons having Unique Identification Number (UIN) Download
11.GSTR 8Offline tool for filing Statement for Tax Collection at Source Download
12.TRAN 1Use this tool to fill details of TRAN 1Download
13.ITC 03Excel tool to file ITC – 03Download
14.GSTR 6Enter details in GSTR 6 Return for input service distributors in offline mode
Download
15.GSTR 7GSTR 7 Offline tool for filing Return for Tax Deduction at Source Download
16.GSTR 10Prepare GST Final return after the cancellation of GST Registration in GSTR 10 offline tool.Download

GST offline Tool system requirements

In order to use above GST offline tools smoothly, ensure that you have the below computer compatibility.  Here are the most important prerequisites for using GST offline tool.

  • You need to have an Operating system minimum Windows 7 or above on your computer. These tools do not work on Linux and Mac.  Therefore you can not use these tools on Windows XP if you are still using it.
  • Browser: You need one of these browsers installed on your computer system.
    • Internet Explorer 10+  [ Recommended]
    • Google Chrome 49+
    • Firefox 45+
  • Microsoft Excel 2007 & above.  GST offline tools require a minimum Microsoft excel 2007 program.
  • An Uncompress file software like – WinZip or WinRAR is required to extract the downloaded tool.

Installation Video

Kindly go through the below video to download and install offline utility.

GSTN Official Guide for Downloading and Installing Offline Utility

GST offline Tool Error

You may face issues like GST offline tool not working after downloading,  not opening in windows 10 after installation and white screen while opening the excel template Etc.    Also, Some taxpayers are facing problem on windows 7 machine.

image for gst offline tool error not working, windows 7, 10

However, we believe if you have the above system requirements on your computer then you should not face such issues.

But still, if you have issues with an offline tool then write a comment below, and we will answer it.

GSTR 3B Offline Tool Download from GST Portal

This guide will explain to you how to download GSTR 3b form in excel format to upload on GST portal.  This GSTR 3B offline tool is provided by GSTN to facilitate users to feed the data in offline mode without the need of internet connection. You should download GST form 3b in excel format from its original source i.e GSTN Website.

How to Download GSTR 3B return format in excel form.

1. Visit GST Portal at www.gst.gov.in

2. Go to Downloads > Offline tools > GSTR3B Offline Utility > Click on Download button (No need to login)

gstr 3b offline tool download steps

3. After completion of downloading, Unzip the downloaded Zip file which contains the GSTR3B_Excel_Utility excel sheet.

4. Open the GSTR3B_Excel_Utility excel sheet by double-clicking on it.

gstr 3b return format in excel pic

Click here to File GSTR 3B offline Uploader and filing Procedure

This guide is exclusively given for the GSTR 3b return download process through the GST portal. Now you will able to get GSTR 3b download on your computer and start making entries in offline mode.  Also, GSTR 3B offline Tool is very easy to use rather than making entries online.

About GST Excel Format

See the GSTR3 3B excel format download procedure from the GST portal.   Also, this is known as GST form 3b in excel format or GST offline tool.  This is a very easy GSTR 3b excel format download process.   This process includes GSTR 3b excel utility v3.0 download or other latest tools download.

Therefore GSTRR 3b format is used for offline return filing under GST.  Learn the GSTR 3b format download procedure in very simple steps from our portal.    This GSTR 3b format in excel with formula helps to calculate tax automatically.  You may also download GSTR 3b format in pdf from our GST forms section.

GSTR 3b in excel format with formula helps taxpayers to calculate tax automatically rather than calculating it manually.    Follow these simple steps for GSTR 3b offline tools download and GSTR 3b offline utility download facilities.

General Questions & Answers

How to use GST offline Tool?

1. Download the offline tool from the GST portal at www.gst.gov.in
2. Extract the tool on your computer/laptop
3. Run the setup and complete the installation
4. Double click to open the offline tool icon
5. Prepare the return in offline mode and generate the JSON file
6. upload the JSON file on the GST portal to file the GST return

How to update the GST Offline Tool?

You can not update the offline Tool. However, you can check the latest version available to download on the GST portal and re-install it on your computer.

What is the use of the GST offline tool?

The taxpayer can prepare the GST returns in offline mode without the need of the internet by using this tool.

How do I use the GSTR 9 offline Tool?

1. Download the offline tool from the GST portal
2. Extract the tool on your computer
3. Open the excel template for entering details of GSTR 9
4. After entering the necessary details, Generate JSON file from the main sheet.
5. Upload the JSON file on the GST portal to file the GSTR 9 return.

Related Articles

Similar Links

Share With Friends and Groups

31 thoughts on “GST Offline Tool Download for Free in Excel format

  1. GST offline tool not working after downloading, not opening in windows 10 after installation and white screen while opening

  2. Hi chandrashekar
    Please check once again if your PC meets above system requirements. Also, you may try installing it on other PC to check if it works. Offline utility works perfectly on windows 10. Let me know if you still face error.

  3. Hi,
    I’m also facing the same issue GST offline tool not working after downloading, not opening in windows 10 after installation and white screen while opening. So many times i tried but not working.
    Plz, help me to solve this issues.

    1. Hello Ashwini, I have noticed this issue. people are facing this mainly, when they are using pirated windows version. Because many pirated versions does not contain required files to run the gst offline tool. I suggest to go in the control panel >> add remove programs. Check the installed list contains the installations as in image. Click to view. These gets automatically installed while installing windows or by its auto update process. Therefore, if some are missing you may need to install another version. please check with your computer engineer.

  4. Dear Sir , i have been facing the same issue. i have original window 10 and also an updated one. but it does work on my son’s laptop. the only problem is that i can not carry my son’s laptop in the office

  5. i have windows 7 (32-bit)on my laptop. i was using older version of gst offline tool but today gst site asked for the latest version of gst offline tool, so i uninstalled the old version n installed the newer one but its showing blank screen without any message n i even checked on my pc too but same problem is occurring there too. plz help

    1. Hi Reena

      I believe you are using Microsoft windows & office legal version. If yes ensure that all automatic updates are on. If not, you are definitely going to face this issue. Alternatively, you may ask your computer engineer to upgrade it to windows 10 ver and check. I hope this helps.

      Regards

  6. GSTN offline tool shows starting application and then goes blank. I have updated legal windows 10

  7. Hello Sir
    I have downloaded gstr1 error file from portal and uploaded into offline tool then saved the contained bills. After this when i click on generate file to create JASON file it shows some activity but doesnt create any JASON file. For this reason i can not upload my pending bills GSTN server.
    Please help.

  8. Hello Sir
    How can i upload the pending vouchers in gstn portal.
    portal is rejecting some vouchers to be uploaded through jason file. when i am trying to upload the bills manually on site then it is not saving the bill giving following error
    “error gstr1 for the period to which the document pertains has not been filed. please add the document in the said period gstr1”
    please help me how can i upload my pending bills.
    Thanks

    1. Hi Rajnish

      kindly ensure that you are adding the invoices of previous period from 01.04.2019 on wards only. GST portal is not accepting invoices/documents with date prior to this period. You will see a similar error while uploading json file, if you try to add invoices prior to above period.

      I hope this helps.

      Regards

  9. Hello sir, i am having original windows and java is also upto date but gst offline utility opens blank on starting. I have downloaded the latest utility from the gst site

  10. I have orignal window 10. Java is updated. still gst offline tool is not working. I have tried many methods still not working.

  11. My window is also updated and all drivers are updated still gst offline tool not working. The problem is white screen

    1. Hi,

      kindly ensure you download the latest version of offline tool from the GST portal before preparing the return in offline mode. Also, do not forget to enable all the macros in offline excel file.

      regards

    1. Hi Priyanka

      I believe you are uploading the JSON file and not the excel file. Secondly, ensure that you download the latest offline tool from the GST portal to generate the JSON File. This will resolve your issue.

      regards

  12. Dear All who are facing issues in Windows 10 and GST Offline Tool (White Screen). I have after a lot of research found the culprit and the rectification. The culprit is the old NSSM bundled with the package (2014). Remedy is Go to Services and stop GSTOFFLINE64 service. Then visit https://nssm.cc/download and download 2017 version and replace this file in the GST Offline directory. Go to services again and start the GSTOFFLINE64 service.. It will work.

Leave a Reply

Your email address will not be published. Required fields are marked *