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

Deduction u/s 80P denied as return not filed u/s 139(1) but in response to notice u/s 148

Deduction u/s 80P denied as assessee did not file return u/s 139(1) but beyond the due date only in response…

12 hours ago
  • GST

High Court denied pre-arrest bail to accused of fake ITC utilisation

High Court denied pre-arrest bail to accused of fake ITC utilisation on possibility of misusing the concession of pre arrest…

14 hours ago
  • Income Tax

ITR was not non est for no e-verification when AO took cognizance of returned income

Return could not be said to be non est for non e-verification when AO had been taken due cognizance of…

1 day ago
  • Income Tax

Section 43CB & ICDS-III is applicable to contractors not to real estate developers

Section 43CB read with ICDS-III is applicable to contractors and not real estate developers - ITAT In a recent judgment,…

2 days ago
  • Income Tax

Expenses of ESOP are allowable as revenue expenditure u/s 37(1) of Income Tax Act.

Expenses incurred on ESOP are allowable as revenue expenditure u/s 37(1) of Income Tax Act – ITAT Delhi In a…

2 days ago
  • Income Tax

Compliance history of supplier can’t be used to invalidate genuine business transactions of buyer

Compliance history of supplier could not be used to invalidate the genuine business transactions of the buyer especially when the…

3 days ago