New Delhi: Ahead of the goods and services tax rollout on 1 July, GST Network (GSTN) on Friday launched an offline Excel-based format for traders and businesses to upload sales data on the GST portal.

The Excel template, comprising eight worksheets, is part of GSTN’s approach to make tax compliance easy and convenient for taxpayers and also reduce the time of compliance.

As per the GST law, a return of all sales or trade made in a month have to be filed online by the 10th of the following month.

This Excel template can be downloaded from the GST common portal (, and can be used by taxpayers to collate all invoice related data on a regular basis.

In the excel sheet, the businesses would have to give details of transaction, like supply invoices issued to registered taxpayers, export invoice details, consolidated details of supplies to consumers, credit/debit note details to registered/unregistered taxpayers and details of documents issued.

The data in Excel template will then be used by an offline tool, which GSTN will be releasing on 15 July. The offline tool will be able to import data from the Excel template and generate JSON (Java Script Object Notation) file which will have to be uploaded on GST portal, a statement said.

“Our objective is to make paying taxes easy and simple. The taxpayer can enter the details of his outward supply in the excel template on weekly basis or any other suitable regular interval," GSTN chairman Navin Kumar said.

The GST Return-1 Excel template can be used to prepare the GSTR-1 return without connecting to Internet in offline mode. “This also benefits taxpayers in remote areas where Internet connectivity might not be that good," Kumar said.

The GST Council has decided to give relaxation to businesses for filing return in the initial two months of the GST rollout. For July, the sales returns will have to be filed by 5 September instead of 10 August. Companies will have to file sales invoice for August with the GSTN by 20 September instead of 10 September decided earlier.