Log In Sign Up

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

 

Update: Deadline of GSTR 1 filing for the month of July extended to 10th of September.

 

Return Period GSTR 1 GSTR 2 GSTR 3 GSTR 3B
July 2017 October 10 October 31 November 10 August 25
August 2017 October 5 October 10 October 15 September 20

 

Watch How to file GSTR 1 with ClearTax GST

 

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