Steps to use GSTR 3B Excel Templates
- After submitting your Email id, download GSTR 3B 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 3B will be auto-prepared
- Login to GSTN to file return
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.
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