GST

GSTR-1 Offline Utility for invoice upload available for download. FAQ and step by step guide-user Manual

GSTR-1 Offline Utility for invoice upload available for download. FAQ and step by step guide-user Manual on Invoice Upload-Download Offline Tool 

Offline Utility for GSTR-1 for upload of invoice data/other records now available for download on GST Portal 

Returns Offline Tool Version V1.0

Download, extract and run the GST Offline Tool to collate and upload the invoices and other data in offline mode. Download click here >> 

gst_offline_tool.zip contains following four files

1. Ten Sample_files (at.csv, atadj.csv, b2b.csv, b2cl.csv, b2cs.csv, cdnr.csv, cdnur.csv, exp.csv, GSTR1_Excel_Template-V1.1.xlsx and hsn.csv)

2. FAQs and User Manual – GST Invoice Upload-Download Offline Tool

3. One Readme (Readme.txt)

4. One GST Offline Tool (GST Offline Tool.exe)

Read the file Readme.txt before proceeding for installation. Double Click on GST Offline Tool to install the offline tool.

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.

System Requirement

To use the tool efficiently, ensure that you have the following installed on your system:

  1. Operating system  Windows 7 & above
  2. Browser: You need one of these browsers installed on your system.
    • Internet Explorer 10+
    • Google Chrome 49+
    • Firefox 45+
    • Safari 6+
  3. Microsoft Excel 2007 & above
  4. Alternatively , for any below version the tool will open in a default browser.

Note:

  • This tool does not work on Linux and Mac operating system
  • Currently this tool is released for GSTR-1 form

When the Offline Tool zip file is downloaded, an excel workbook (GSTR1_Excel_Template-V1.1.xlsx) is also downloaded with it. This Workbook is used to upload invoice data to the tool. Maximum number of Invoice line items which can be uploaded at one time is 19,000.

For uploading data there are four options:

Option 1: Manual Entry of Invoice Data

Option 2: Copy and Paste from Excel Workbook

Option 3: Import full Excel Workbook consisting of multiple sheets

Option 4: Import the CSV file

The multi excel sheet (GSTR1_Excel_Template-V1.1.xlsx) has eleven worksheets covering different tables in GSTR-1. When you first download the excel sheet, there is a header only in each sheet. You need to manually enter the data in these sheets

FAQs and User Manual on Invoice Upload-Download Offline Tool which in in the zip file contains the useful step by step guide on the following:

Uploading Invoice Data using the Invoice Upload/Download Offline Tool

Troubleshooting Common Errors Encountered

Share

View Comments

Recent Posts

  • Income Tax

Non issue of notice u/s 143(2) for even belated ITR filed u/s 148 makes assessment void ab initio

Non issuance of notice u/s 143(2) for return filed u/s 148 even though belatedly, makes the assessment framed bad in…

5 days ago
  • Insurance

Calculation of functional disability depends on victim’s earning capacity in open market – SC

Calculation of functional disability depends on assessing the victim’s earning capacity in the open, competitive market – Supreme Court In…

6 days ago
  • Income Tax

Appeal against ITAT shall lie only before High Court within whose jurisdiction AO is situated

Appeal against every decision of ITAT shall lie only before the High Court within whose jurisdiction the Assessing Officer who…

1 week ago
  • Excise/Custom

SC recommends action against Customs Officer who relied upon AI generated fake case laws

Supreme Court recommends action against Commissioner of Customs who relied upon non-existent AI generated case laws. Supreme Court recommends action…

1 week ago
  • Income Tax

Non- payment of cost imposed can’t trigger automatic confirmation of an invalid exparte assessment.

ITAT power to pass such orders "as it thinks fit" implies a judicial discretion to be exercised within the parameters…

1 week ago
  • Income Tax

Non-deduction of TDS does not make transaction as unexplained in the hands of deductee – ITAT

Mere non-deduction of TDS by the deductor on a transaction does not change the character of the transaction to make…

2 weeks ago