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

Updates as on 28th May 2021

The GST Council recommended in its 43rd meeting the following:

(1) The monthly filing of GSTR-1 for May 2021 will be extended from 11th June 2021 to 26th June 2021.

(2) Filing of B2B sales invoices in IFF by QRMP taxpayers for May 2021 be extended from 13th June 2021 to 28th June 2021.

(3) Companies that are GST taxpayers have been given permission to authenticate returns using EVC instead of digital signature up to 31st August 2021.

(4) Late fee has been rationalised for future tax periods as follows:

  • In case of nil GSTR-1 and GSTR-3B filing, the maximum late fee charged shall be capped at Rs.500 per return (i.e Rs. 250/- each for CGST & SGST).
  • In GSTR-1 and GSTR-3B other than nil filing, maximum late fee is fixed based on annual turnover slab, as follows:
    1. If the annual turnover in the previous financial year is upto Rs.1.5 crore then the late fee of maximum Rs 2,000 per return can only be charged (i.e Rs.1000 each for CGST and SGST).
    2. If the turnover ranges between Rs.1.5 crore and Rs.5 crore then the maximum late fee of Rs.5,000 per return can only be charged (i.e Rs. 2500 each for CGST and SGST).
    3. If the turnover is more than Rs.5 crore then late fee of maximum Rs.10,000 (i.e Rs. 5000 per CGST and SGST) can be charged.

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.

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 v3Fill 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 v3Fill 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

Start Free GST Software Trial & Training