Complete GST lifecycle on one platform Complete GST lifecycle on one platform
Hyper-automation Hyper-automation
Smart reports & recon Smart reports & recon
Accurate filing Accurate filing

Download GSTR 3B Excel Template Sheets & Guide by ClearTax

Updated on: Jun 6th, 2023

|

7 min read

social iconssocial iconssocial iconssocial icons
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 tax payer 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

MonthLast Date for filing GSTR-3B
August 201720th September 2017
September 201720th October 2017
October 201720th  November 2017
November 201720th  December 2017
December 201720th  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.ReturnTax Period
Revised Due Date
1GSTR 1July, 201710-Oct-2017
For registered persons with aggregate turnover in a State more than Rs 100 crores, the due date shall be 3-Oct-17
2GSTR-2July, 201731-Oct-17
3GSTR-3July, 201710-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.

CONTENTS

Clear offers taxation & financial solutions to individuals, businesses, organizations & chartered accountants in India. Clear serves 1.5+ Million happy customers, 20000+ CAs & tax experts & 10000+ businesses across India.

Efiling Income Tax Returns(ITR) is made easy with Clear platform. Just upload your form 16, claim your deductions and get your acknowledgment number online. You can efile income tax return on your income from salary, house property, capital gains, business & profession and income from other sources. Further you can also file TDS returns, generate Form-16, use our Tax Calculator software, claim HRA, check refund status and generate rent receipts for Income Tax Filing.

CAs, experts and businesses can get GST ready with Clear GST software & certification course. Our GST Software helps CAs, tax experts & business to manage returns & invoices in an easy manner. Our Goods & Services Tax course includes tutorial videos, guides and expert assistance to help you in mastering Goods and Services Tax. Clear can also help you in getting your business registered for Goods & Services Tax Law.

Save taxes with Clear by investing in tax saving mutual funds (ELSS) online. Our experts suggest the best funds and you can get high returns by investing directly or through SIP. Download Black by ClearTax App to file returns from your mobile phone.

Cleartax is a product by Defmacro Software Pvt. Ltd.

Company PolicyTerms of use

ISO

ISO 27001

Data Center

SSL

SSL Certified Site

128-bit encryption