Steps to use GSTR 1 Excel Templates
- After submitting your Email id, download GSTR 1 files from your Inbox
- Export data from your accounting software & create excel files
- Fill data in ClearTax Standard Excel Templates
- Import templates into ClearTax GST, your GSTR 1 will be auto-prepared
Latest Updates on GSTR-1 Due Dates
Update as on 1st May 2021
The due date to file GSTR-1 for April 2021 is extended from 11th May 2021 to 26th May 2021.
The time limit to furnish B2B supplies on the IFF (optional facility), for April 2021 has been extended from 13th May to 28th May 2021.
Update as on 3rd April 2020
- No late fee shall be levied if the taxpayer files the monthly GSTR-1 for March 2020, April 2020 and May 2020 before 30th June 2020.
- No late fee shall be levied if the taxpayer files the quarterly GSTR-1 return for the January-March 2020 quarter before 30th June 2020.
Update as on 23rd March 2020
The GSTR-1 for 2019-20 will be waived for certain taxpayers who could not opt for the special Composition Scheme ( including notification No. 2/2019-Central Tax (Rate) dated 7th March 2019) by filing Form CMP-02.
The due date of Form GSTR-1 for July 2019 to February 2020 is extended till 24th March 2020 for taxpayers with a principal place of business in the Union Territories of Ladakh or Jammu and Kashmir. For further details, read our article on GST notifications.
The due date for GSTR-1 for the period April 2020 to September 2020 is as follows:
Quarterly return filer:
- April to June 2020: 31st July 2020
- July to September 2020: 31st October 2020
Monthly return filer:
Month
Due Date
April 2020
11th May 2020
May 2020
11th June 2020
June 2020
11th July 2020
July 2020
11th August 2020
August 2020
11th September 2020
September 2020
11th October 2020
Read our Guide on How to file GSTR 1 with ClearTax GST
Description of Excel Templates & When To Use
Note: All the templates contain detailed explanation of each column to help you understand what information you need to enter along with sample values and easy to follow instructions. Sales Documents Excel Templates: 01 – Sales Invoice and Bill of Supply – ClearTax v3 : Fill the template to record all invoices issued for your taxable and non taxable outward supplies (goods as well as services) such as sales invoices, export invoices, bill of supply, sales where reverse charge is attracted etc 02 – Outward Credit Debit Note – ClearTax v3 : Fill the template to record all your credit and debit notes against the sales invoices issued by you as a supplier. 03 – Outward Advance Receipts – ClearTax v3 : Fill the template to record all the advance receipts that you received against which invoice is yet to be issued. Purchase Documents Excel Templates: 04 – Purchase Invoice and Bill of Supply – ClearTax v3 : Fill the template to record all invoices issued by your supplier for your taxable and non taxable inward supplies (goods as well as services) such as purchase invoices, Import invoices, bill of supply, purchases where reverse charge is attracted etc 05 – Inward Credit Debit Note – ClearTax v3 : Fill the template to record all credit and debit notes against purchase invoices and bill of supply issued by your supplier. 06 – Inward Advance Payments – ClearTax v3 : Fill the template to record all the advance payments that you made against which invoice is yet to be raised.If you are a CA or a Tax Professional, share these templates with your clients. It will help you collect your clients’ invoice data quickly for accurate filing.
Simplify Your GST Filing & Invoicing
Get Trained & Try Cleartax GST Software for FREE