GSTN unveils excel template for easy data entry offline

Last updated: 03 July 2017


GSTN unveils excel template for to help taxpayers perform easy data entry offline before uploading on the GST portal; Excel template together with an offline tool will make uploading large numbers of invoices much easier and quick; Offline Tool to be unveiled on July 17, 2017. 

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. 

The excel template is a part of GST Council’s approach to make tax compliance highly easy and convenient for taxpayers and also reduce the time of compliance to improve ease of doing business. This excel workbook template can be freely downloaded from the GST Common portal (www.gst.gov.in), and can be used by taxpayers to collate all invoice related data on a regular basis. 

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 prepare 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. 

The template comprises of eight worksheets. Summary of key values in each worksheet has been provided at the top to help taxpayers easily reconcile the data entered in the worksheets with that recorded in his accounting system/books to accurately prepare the return. Based on data entered in the Excel sheet, offline tool will prepare a file which will have to be uploaded by the taxpayer on GST Portal to create GSTR-1. Only while uploading the file on the GST portal, Internet connectivity will be required. 


CCI Pro



News posted by

Finance news reporter covering taxation, GST, income tax, business compliance, and economy updates. I simplify complex financial topics into easy-to-understand articles for professionals, taxpayers, and business owners on leading finance and tax platforms.


Comments



More »


Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details