|
GSTR 3B Excel and PDF Guide
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 How to File GSTR 3B Guide
After downloading the Excel templates & PDF guide, log in to Clear GST Software to prepare GSTR-3B.
| Month | Last Date for filing GSTR-3B |
| August 2025 | 20th September 2025 |
| September 2025 | 20th October 2025 |
| October 2025 | 20th November 2025 |
| November 2025 | 20th December 2025 |
| December 2025 | 20th January 2026 |
Tax liability of GSTR-3B must be paid by the last date of filing for that month.
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
Annapoorna
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.
ISO 27001
Data Center
SSL Certified Site
128-bit encryption