GSTR-1 Offline Utility is now available.

Goods and Services Network (GSTN) has unveiled a simple excel based template that will facilitate the taxpayers in preparing and filing their monthly returns with maximum ease and minimal cost.

Link to Download GSTR-1 Offline Utility  https://www.gst.gov.in/download/returns

Excel Format for offline mode:

The Excel format can be used by businesses to start maintaining their data. The taxpayer can prepare the details of his outward supply on weekly or any other suitable regular interval which can then be uploaded on GST portal on or before the 10th of subsequent month. The GSTR1 excel template workbook can be used to prep

are the data for GSTR 1 return without connecting to internet in offline mode. This also benefits taxpayers in remote areas where Internet connectivity might not be good.

How to Upload Data:

Data can be uploaded/entered to the offline tool in four ways:

1. Importing the entire excel workbook to the java tool where data in all sections (worksheets) of the excel file will be imported in the tool in one go.

2. Line by line data entry by return preparer on the java offline tool.

3. Copy from the excel worksheets from the top row including the summary and header and pasting it in the designated box in the import screen of the java offline tool.

4. Section by section of a particular return – using a .CSV file as per the format given along with the java tool. Many accounting software packages generate .CSV file in the specified format and the same can be imported in the tool.

Only One Return to file every month:

when a supplier uploads details of the sales invoices generated in the GST system, and files GST Return-I, the details from the suppliers GSTR-I automatically gets updated in the GST Return II (GSTR-II) of the purchaser. All the recipient needs to do is amend or modify and file the GSTR-II by 15th of every month.

By 17th of the month both the supplier and the recipient would have to reconcile the invoice details and file the third return (GSTR-III) by 20th of the month.