What parameters are CFOs
focusing on to avoid GST scrutiny?
What parameters are CFOs focusing on to avoid GST scrutiny?
Book a demo to find out!

GSTR 3B Excel and PDF Guide

By Annapoorna

|

Updated on: May 27th, 2025

|

3 min read

Prepare and file your monthly GSTR 3B returns easily with updated Excel templates and a step-by-step PDF guide. Organise your sales and purchase data accurately to ensure timely filing and compliance.

Latest Update:

11th April 2025

  • GSTN issued an advisory on reporting values in Table 3.2 of GSTR-3B.
  • Starting from April 2025, the auto-populated values in Table 3.2 for inter-state supplies made to unregistered persons, composition taxpayers, and UIN holders will be non-editable.
  • Taxpayers would need to correct the incorrect values by making amendments through Form GSTR-1A or Form GSTR-1/IFF filed for subsequent tax periods. 

Download GSTR 3B Excel Template

Download Excel Files

Download How to File GSTR 3B Guide

Download PDF

After downloading the Excel templates & PDF guide, log in to Clear GST Software to prepare GSTR-3B.

MonthLast Date for filing GSTR-3B
August 202520th September 2025
September 202520th October 2025
October 202520th  November 2025
November 202520th  December 2025
December 202520th  January 2026

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, 2025

10-Oct-2025

2

GSTR-2

July, 2025

31-Oct-2025

3

GSTR-3

July, 2025

10-Nov-2025

Clear 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.

Download GSTR 3B Excel Templates Now

Steps to use GSTR 3B Excel Template Sheets

  • Export data from your accounting software & create Excel files
  • Fill data in Clear Standard Excel Templates.  
  • Import templates into Clear GST, Clear 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 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.  

About the Author
author-img

Annapoorna

Assistant Manager - Content
social icons

I preach the words, “Learning never exhausts the mind.” An aspiring CA and a passionate content writer having 4+ years of hands-on experience in deciphering jargon in Indian GST, Income Tax, off late also into the much larger Indian finance ecosystem, I love curating content in various forms to the interest of tax professionals, and enterprises, both big and small. While not writing, you can catch me singing Shāstriya Sangeetha and tuning my violin ;). Read more

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.

Privacy PolicyTerms of use

ISO

ISO 27001

Data Center

SSL

SSL Certified Site

128-bit encryption