GSTR-3B vs Books Reconciliation Template

Compare GST liability and ITC between your GSTR-3B filings and accounting records. Catch filing errors before they attract scrutiny notices.

No signup required No watermarks Ready-to-use template
ARSP
50K+ downloads by Accountants & Finance Controllers
Output Tax (GSTR-3B vs Books)
IGST (3B)₹3,60,000
IGST (Books)₹3,75,000
ITC (GSTR-3B vs Books)
ITC claimed (3B)₹2,70,000
ITC per books₹2,85,000
✗ Net variance: ₹30,000

Build your GSTR-3B vs books reconciliation

Enter output tax liability and ITC from your GSTR-3B filing and your books. The preview shows variances in real time.

1

Company details

2

Output tax liability

As per GSTR-3B
As per Books
3

Input Tax Credit (ITC)

As per GSTR-3B
As per Books
Live preview

Set up your GSTR-3B vs books reconciliation in four steps

1

Download

Pick Excel, Word, or PDF. Each format has side-by-side columns for GSTR-3B and book figures with automatic variance calculation.

2

Enter company details

Fill in your GSTIN, the financial year, and the return period you are reconciling.

3

Enter GST figures

Enter output tax (IGST, CGST, SGST) and ITC from both your GSTR-3B filing and your accounting records.

4

Investigate variances

Review each variance, trace it to the source transaction, and correct either the books or the next filing.

Download a ready-to-use template

Grab a blank template in the format that fits your workflow.

Excel (.xlsx)

Spreadsheet with formulas. Best for month-on-month GSTR-3B tracking with auto-variance.

Word (.docx)

Pre-formatted document. Best for sharing reconciliation reports with management.

PDF

Print-ready layout. Best for audit trails and compliance records.

Future-proof your finance operations, today

Stop reconciling GSTR-3B manually. Let automation compare filings to books, flag variances, and prepare GSTR-9 without last-minute scrambles.

Book a demo →

How GSTR-3B vs books reconciliation works

This reconciliation catches gaps between what you filed and what your books show, so your annual return (GSTR-9) is accurate from day one.

1

Download filed GSTR-3B

Pull the GSTR-3B data from the GST portal for each return period. Note the output tax, ITC claimed, and net tax paid.

2

Extract book figures

Run your sales register and purchase register for the same period to get output tax liability and ITC as per your accounting system.

3

Compare line by line

Match IGST, CGST, and SGST for both output tax and ITC. Calculate the variance for each tax head separately.

4

Classify variances

Common causes: invoices booked but not reported, advances received without tax payment, ITC reversals not reflected in books, or timing differences.

5

Correct and carry forward

Fix book entries or adjust the next GSTR-3B filing. Carry forward unresolved items and track them until closure.

Do this, avoid that

Consistent GSTR-3B vs books reconciliation prevents year-end surprises and keeps your GST compliance audit-ready.

✓ Do
Reconcile every month after filingMonthly reconciliation catches small errors early. Waiting until GSTR-9 preparation turns a 30-minute task into a multi-day exercise.
Track amendments separatelyIf you corrected a previous period's figures in a later GSTR-3B, track the amendment against the original period in your reconciliation to avoid double-counting.
Match tax heads independentlyA zero total variance can hide offsetting errors in IGST and CGST/SGST. Reconcile each tax head (IGST, CGST, SGST) separately.
Include advances and reverse chargeAdvances received and reverse charge liability are often missed in the books but reported in GSTR-3B. Include them as separate line items in your reconciliation.
Document reasons for every varianceRecord the root cause of each variance alongside the amount. This documentation saves hours during the GSTR-9 audit and any future assessment.
✗ Avoid
Filing GSTR-3B from memoryAlways file from your finalized sales and purchase registers, not from a rough estimate. Estimated filings create variances that are harder to trace later.
Netting IGST against CGST+SGST variancesEach tax head has its own legal treatment. A variance in IGST cannot offset a variance in CGST. Reconcile and resolve them independently.
Ignoring rounding differencesGST portals and accounting systems may round tax amounts differently. Small rounding differences are normal, but they should be documented and tracked.
Delaying ITC reversal entriesIf ITC needs to be reversed (Rule 42/43, non-payment within 180 days), book the reversal in the same period as the GSTR-3B. A delayed reversal creates a mismatch that carries forward.
Skipping the reconciliation for "clean" monthsEven months with no amendments or adjustments should be reconciled. A clean month is a confirmation, not a reason to skip the process.

GSTR-3B reconciliation terms, explained

GSTR-3B
A monthly self-declaration return where businesses report their summarized GST liability, ITC claimed, and net tax payable. It is due on the 20th of the following month.
Output tax liability
The GST collected on outward supplies (sales). It includes IGST on inter-state sales and CGST+SGST on intra-state sales, reported in Table 3.1 of GSTR-3B.
Input Tax Credit (ITC)
The GST paid on inward supplies (purchases) used for business purposes, which can be set off against output tax liability. Reported in Table 4 of GSTR-3B.
GSTR-9 (Annual Return)
The annual return that consolidates all monthly GSTR-3B filings for the financial year. GSTR-3B vs books reconciliation directly feeds into GSTR-9 preparation.
Tax period amendment
A correction made in a subsequent GSTR-3B filing for errors in a previous period's return. Amendments must be tracked separately to avoid double-counting in reconciliation.
ITC reversal
The process of reversing previously claimed ITC when the underlying conditions change, such as non-payment to supplier within 180 days (Rule 37) or change in use from taxable to exempt supplies (Rule 42/43).
Reverse charge
A mechanism where the buyer pays GST instead of the seller. Common for imports, services from unregistered suppliers, and notified goods/services. The buyer claims ITC on this self-assessed liability.
Electronic cash ledger
The digital wallet on the GST portal where tax payments made through challans are credited. Net tax payable after ITC set-off is discharged from this ledger.
Electronic credit ledger
The digital ledger on the GST portal that reflects available ITC. ITC claimed in GSTR-3B is credited here and used to set off output tax liability.

Frequently asked questions

GSTR-3B vs books reconciliation is the process of comparing the GST liability and Input Tax Credit declared in your GSTR-3B returns against the corresponding figures in your accounting records. It catches filing errors, missed invoices, and ITC discrepancies before they attract scrutiny notices from the tax department.

Yes. There is no cost, no account creation, and no watermark on any format. The interactive tool runs entirely in your browser and the downloadable files are yours to keep.

Monthly, immediately after filing GSTR-3B. Quarterly reconciliation is the bare minimum, but monthly reconciliation catches errors early and keeps your annual return (GSTR-9) preparation straightforward.

Common causes include invoices recorded in books but missed in GSTR-3B, ITC claimed in GSTR-3B but not recorded in the purchase register, rounding differences in tax calculations, advances received but not reported, and credit or debit notes booked in different periods.

Mismatches lead to discrepancies in your annual return (GSTR-9), which can trigger scrutiny notices, demand for differential tax with interest, and penalties. Consistent reconciliation prevents these issues.

GSTR-9 is the annual return that summarizes all monthly GSTR-3B filings. If your monthly GSTR-3B figures do not match your books, the annual return will also be incorrect, potentially triggering audits and assessments.

Templates work for businesses with a single GSTIN and moderate transaction volumes. Once you manage multiple GSTINs, high invoice volumes, or need to reconcile across GSTR-1, GSTR-2B, and GSTR-3B simultaneously, automation saves significant time and reduces errors.

Browse all finance templates

View all templates →