GST

GSTR1 excel template workbook and offline tool download

GSTR1 excel template workbook and offline tool download. Make data entry offline before uploading on GST portal. Offline tool to be  unveiled on 17-07-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. 

*********************
DSM 
(Release ID :167077)
Share

View Comments

Recent Posts

  • Income Tax

Traffic management hub is an essential public function and charitable activity u/s 11 – ITAT

Operation and maintenance of traffic management hub is an essential public function and hence charitable activity u/s 11 of the…

10 hours ago
  • Income Tax

AO while issuing certificate u/s 197 should not be guided by the revenue generation

Supreme Court dismisses challenge to High Court order quashing order u/s 197 observing that AO should not be guided by…

2 days ago
  • Income Tax

Notional rent can not be taxed when rent was reduced due to covid conditions – ITAT

Notional rent based on the agreement can not be taxed when rent was subsequently reduced due to covid conditions -…

3 days ago
  • Prevention of Corruption Act

CBDT Instruction can not absolve persons to explain source of gold within limits specified – SC

Mere CBDT Instructions cannot absolve individuals of their obligation to explain the source and nature of their gold holdings, even…

1 week ago
  • ICSI

Empanelment of General Observers for ICSI Examinations December 2026. Last date 16.11.2026

Empanelment of General Observers for ICSI Examinations December 2026 ICSI has invited interested members to enroll as General Observers for…

1 week ago
  • Income Tax

ITAT address some important issues relating to deduction u/s 80IA

ITAT answers some important and inter-related issues relating to deduction u/s 80IA In a recent judgment, ITAT has dealt with…

1 week ago