User Manual related to GST Invoice Upload/Download Offline Tool Contains the following –
Table of Contents
1. FAQs on Invoice Upload/Download Offline Tool
2. Invoice Upload/Download Offline Tool: An Overview
3. Downloading the Invoice Upload/Download Offline Tool
4. Installation of the Invoice Upload/Download Offline Tool
5. Uploading Invoice Data using the Invoice Upload/Download Offline Tool
5.1 Option 1: Manual Entry of Invoice Data
5.2 Understanding the Excel Template
B2B (B2B Supplies)
B2CL (B2C Large)
B2CS (B2C Small)
CDNR (Credit/ Debit Note)
CDNUR (Credit/ Debit Notes/Refund voucher for Unregistered person)
AT (Taxable Liability on Advances)
ATADJ (Advance Adjustments)
EXEMP (Nil Rated, Exempted and Non GST supplies)
HSN (HSN Summary)
DOCS (List of Documents issued)
5.3 Option 2: Copy and Paste from Excel Workbook
5.4 Option 3: Import Excel Workbook consisting of multiple sheets
5.5 Option 4: Import the CSV file
6. Troubleshooting Common Errors Encountered
1. Login to the GST Portal gst.gov.in.
2. Go to Downloads > Offline Utilities> Returns Offline Utility > Download
3. Unzip the downloaded Zip file which contain Offline-Tool.exe setup file, Sample files folder, Readme.txt and User Manual
Note: Ensure that the system requirements are met including the disk space of 50 MB.
4. Install the Invoice Upload/Download Offline Tool by double clicking the Offline-Tool.exe set up file and browse the location where you want to saw the Invoice Upload/Download Offline Tool files in your computer.
Note: Avoid installing the Invoice Upload/Download Offline Tool in the same location where you have saved the zipped files.
5. The Offline Tool Logo will appear on the desktop.
6. Fill the invoice details in the Invoice Upload/Download Offline Tool manually or use sample templates.
Important Note: – In case, User un-installs the Tool and re-installs the Tool, he should re-install at the same location. In case, User re-installs the Tool on different location he has to restart the system so that Tool refers to the new location. If user doesn’t restart the system, Invoice Upload/Download Offline Tool will refer the old path and will not be able to open the project.
Once you have downloaded and installed the Invoice Upload/Download Offline Tool, you can use any of the four options to upload the invoice data.
After generating the return file in json format through Invoice Upload/Download Offline Tool, login to the www.gst.gov.in URL for uploading the invoices.
Ensure that you are connected to the Internet to upload the JSON file to the Portal.
JSON file generated through the Invoice Upload/Download Offline Tool can be uploaded to the GST common portal only when you are connected to the GST Portal through the Internet
GST Portal doesn’t allow the json file to be uploaded with file size more than 5 MB. Delete some of the invoices in order to generate the json with file size less than 5 MB. You can generate the file again with these deleted invoices to upload the same on the Portal.
Right click on the file and click on Properties. You can see the size of the generated json file.
You can add up to 19000 line items comprising of all the different sections like b2b and b2c (large) in an offline return. There may be several line items in an invoice and hence the number of invoices that can be uploaded may be less than 19,000. The file generated for 19,000 or less line items can be uploaded to the portal at one go.
In case you have more invoice data, you can use the tool multiple times to generate the json file to upload the invoice data.
Filling all the sections of the excel worksheet is not mandatory. You can use the excel worksheet to enter data for selective sections also. Remaining sections can be kept as blank and the Invoice Upload/Download Offline Tool will leave those sections blank and fill data only for the applicable sections as filled in the template.
You can check the status of the uploaded invoice details on the Portal once json file is uploaded to the portal. As soon as the JSON file is uploaded to the portal, a transaction id is generated by the portal. Once the upload is success the summary of the invoices uploaded, is updated in the respective section of the return.
Yes, you can edit the invoices uploaded through Invoice Upload/Download Offline Tool in the GST Portal before the return is submitted for processing.
Yes. You can generate multiple json files for a single tax period depending on the volume of data to be captured for the return.
Maximum size of the json file should not exceed 5 MB.
You need to check that section wise all fields are filled properly without any error or omission. Tool will highlight fields having errors in RED color. Please ensure you fill the template as per the instructions provided in the Excel template.
For these 15 invoices, the validations already present in the Portal have failed and therefore these 15 invoices have been rejected. Error log for same will be created & it can be opened using the tool. After resolving the errors, invoices can be submitted again.
Please ensure while copying the data you have copied the header sections along with the Header data from Row1 of the sheet.
By default, it will be saved in the Downloads folder. You can also choose a different location to save the same.
OfflineTool.exe setup file cannot be installed in mobile device.
You need to delete the specific invoice and then add a new invoice with the correct invoice details. The unique details cannot be edited by the user.
It can take few minutes to display the invoice details in the summary.