Log In Sign Up

Download GSTR 3B Excel Template

 

Download Excel Files

Download How to File GSTR 3B Guide

 

Download PDF

 

After Downloading the Excel templates & PDF guide, login to ClearTax GST Software to prepare GSTR-3B.
GSTR 3B is the first GST return that you need to file for the month of July 2017 & August 2017.
Update:
Earlier 3B was only for the months of July & August. Now it has been extended upto December 2017 by the GST Council meeting on 9th September 2017, to facilitate businesses in easier filing. So, a taxpayer must file GSTR-3B each month from August to December

Due dates of filing GSTR-3B as per latest Notification No. 35/2017 – Central Tax dated 15th September 2017

Month Last Date for filing GSTR-3B
August 2017 20th September 2017
September 2017 20th October 2017
October 2017 20th  November 2017
November 2017 20th  December 2017
December 2017 20th  January 2018

Tax liability of GSTR-3B must be paid by the last date of filing for that month.

Other than filing GSTR 3B you need to file GSTR 1, 2 & 3 as well as per below schedule

 

Sl. No. Return Tax Period
Revised Due Date
1 GSTR 1 July, 2017 10-Oct-2017
For registered persons with aggregate turnover in a State more than Rs 100 crores, the due date shall be 3-Oct-17
2 GSTR-2 July, 2017 31-Oct-17
3 GSTR-3 July, 2017 10-Nov-17

ClearTax GST software is updated to help all businesses prepare GSTR-3B return easily and error-free. We have also created Excel templates with which you can easily prepare Form 3B summary and file return.

 

Update: Those who want to claim benefit of opening input tax credit as on 1st July 2017 ( input tax credit as on 30th June 2017) must file TRAN-1 before filing GSTR-3B. For such registrants date of filing of GSTR-3B has been extended to 28th August 2017. However, GST due must be paid by them on 25th August 2017. Any shortfall of tax can be paid with 18% penalty by 28th August 2017.

GSTR 3B for August 2017 is due on 20th September.

GSTR 3B is not applicable starting the month of September, regular returns in GSTR-1, GSTR-2 and GSTR-3 have to be filed from September.

Steps to use GSTR 3B Excel Template Sheets

  • Export data from your accounting software & create excel files
  • Fill data in ClearTax Standard Excel Templates.  
  • Import templates into ClearTax GST, ClearTax will auto-prepare your GSTR 3B
  • Login to GSTN to file return.

 

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.

 

To help you file your first GST return, i.e GSTR 3B we have created an “Ultimate Guide To File GSTR 3B”

 

Download PDF Now

 

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.