GST Reconciliation: What to Check Before Filing Your GST Return

Most GST notices don’t come from fraud. They come from numbers that don’t add up, an invoice in your books that never made it to GSTR-1, ITC claimed on something the supplier forgot to upload, or a credit note applied twice. None of it is deliberate. It’s just what happens when returns get filed under deadline pressure without anyone sitting down to match the data first.

GST reconciliation is that matching exercise: comparing your books against what’s actually been reported on the GST portal, before you file, not after a notice arrives asking you to explain the gap. Do it right, and you protect your input tax credit, avoid interest on short payments, and stop scrambling every time the department sends an ASMT-10. This article discusses which items to reconcile first and what may have changed that would make skipping this process a higher-risk endeavor than it used to be. At the end of the article, there is a link to a downloadable checklist and an Excel template for those who prefer to have a sheet to work from rather than work on a screen. 

What GST Reconciliation Covers

Reconciliation means checking that three sets of numbers agree: what’s in your accounting books, what you’ve reported to the GST department, and what your suppliers have reported about transactions involving you. When these three don’t line up, one of two things happens: you lose ITC you were entitled to, or you claim ITC you weren’t entitled to and get flagged for it later, usually with interest attached.

It’s the difference between a smooth monthly filing and a departmental notice six months down the line asking you to justify a mismatch you’ve long forgotten the context for. Every business filing GST returns needs this discipline, but it matters most for anyone with volume, multiple suppliers, multiple GSTINs, or an accounting team that’s separate from whoever’s actually filing returns.

The Different Reconciliations You’re Actually Doing

“GST reconciliation” isn’t one task. It’s several things under one umbrella, and they catch different problems:

Purchase register against GSTR-2B: 

This is the big one, because it directly determines how much ITC you can legitimately claim. GSTR-2B is a static, auto-generated statement that tells you what your suppliers have reported against your GSTIN. If a purchase in your books doesn’t show up here, that credit is at risk.

GSTR-1 against GSTR-3B: 

You are making sure that the outward supplies you reported in GSTR-1 correspond with the total you summed up in GSTR-3B (the return on which you actually pay tax). This discrepancy is one of the most common reasons for receiving a mismatch notice, since this is an automatic comparison made by the department.

Books against your returns:

Sales and purchases as recorded internally versus what’s gone out on GSTR-1 and GSTR-3B. This catches invoices your own team forgot to report, not just supplier-side gaps.

E-invoice and e-way bill data against returns:

Relevant if you’re above the e-invoicing threshold. Movement of goods should tie back to what’s declared.

Annual reconciliation for GSTR-9:

A Once-a-year exercise that’s really just the accumulation of doing the monthly work properly. If your monthly reconciliation has been sloppy, GSTR-9 season is where it catches up with you. 

The Checklist: What to Check Before You File

Before you hit submit on GSTR-3B each month, run through these details:

1. Sales invoices, books vs GSTR-1: look for invoices missing entirely, or duplicated ones inflating your reported turnover.
2. GSTR-1 vs GSTR-3B, Table 3.1: your outward supply summary should tie exactly to your invoice-level filing. Discrepancies here are what the department’s automated matching flags first.
3. Purchase register vs GSTR-2B: sort into matched, missing-from-2B, and mismatched (wrong amount, wrong GSTIN, wrong tax rate).
4. ITC eligibility: confirm nothing you’re claiming falls under blocked credits (motor vehicles, food and beverages, membership fees, and the rest of the Section 17(5) list).
5. The 180-day rule: if you haven’t paid a supplier within 180 days of the invoice date, that ITC needs to be reversed, with interest, until you do pay.
6. IMS actions: accept, reject, or leave pending on every inward invoice sitting in your dashboard. Since April 2026, this step isn’t a convenience anymore; it’s mandatory, and it directly gates what shows up in your GSTR-2B and eligible ITC in GSTR-3B. Only invoices accepted in the Invoice Management Software flow into GSTR-2B, with hard blocks now placed on ITC claims for anything that doesn’t reflect as accepted there.
7. Credit and debit notes, on both the sales and purchase side, are matched against the original invoice.
8. Reverse charge liability and ITC: RCM has its own reporting line and its own eligibility rules; don’t let it get lost in the general reconciliation.
9. Amendments and prior-period invoices: anything corrected or reported late needs to be tracked so it doesn’t get missed twice.
10. Section 16(4) time limits: ITC on an invoice can’t be claimed indefinitely; there’s a hard cutoff tied to the annual return filing date for that year.
11. Field-level matching: GSTIN, invoice number, date, HSN code, tax rate. Small typos here are a disproportionately common source of mismatch.
12. Ledger balances and interest exposure, cash and credit ledger positions, and whether any short payment is quietly accruing interest.

Reconciling GSTR-2B With Your Purchase Data 

This part is usually the most labor-consuming; thus, we would recommend the method that will be easy for you to repeat every month.

First, get both datasets into the same format; you should download the GSTR-2B data from the portal, and the purchase data from the accounting system in such a way that they go into the rows with the same columns (GSTIN, invoice number, invoice date, taxable value, tax amount). Match primarily on GSTIN plus invoice number, since that combination is the most reliable identifier.

Build in some tolerance before you panic over every mismatch. A one- or two-day date difference, or a rounding difference of a rupee or two, usually isn’t worth chasing. What is worth chasing is a tax amount that’s off by a meaningful margin, or an invoice that’s simply absent from one side.

Once matched, sort everything into four buckets: exact matches, partial matches (close but with a discrepancy worth checking), missing from GSTR-2B (in your books, not reported by the supplier), and missing from your books (reported by the supplier, but you have no record of it, often a sign someone forgot to book an invoice, or occasionally a sign of an invoice that isn’t genuinely yours).

For anything missing from GSTR-2B, follow up with the supplier before deciding whether to claim it. Under the current IMS-driven system, an unactioned invoice doesn’t just sit quietly; unattended invoices are treated as deemed accepted once GSTR-2B is generated, generally on the 14th of the following month, which is itself a compliance risk if you haven’t actually verified the underlying transaction. In case the provider gives an update after the specified date, it is necessary to re-calculate the existing GSTR-2B draft instead of waiting for the modified version to be updated; the system does not change it automatically. 

Common Mismatches and How to Fix Them

There are common mismatches and how to fix them- 

Mismatch	Typical reason	Fix
Invoice in books, not in GSTR-2B	Supplier hasn’t filed GSTR-1 yet, or filed late	Follow up with supplier; hold the credit as pending in IMS until resolved
Invoice in GSTR-2B, not in books	Purchase team missed booking it	Verify it’s genuinely yours, then book it
Tax amount mismatch	Wrong tax rate applied, or a rounding error compounding across line items	Recheck the invoice against the applicable rate; raise a query with the supplier if needed
GSTIN mismatch	Data entry error, or supplier used the wrong GSTIN for a multi-state buyer	Correct at source; ask supplier to amend in their next GSTR-1
Duplicate invoice	Same invoice booked twice, often across two systems (ERP and manual entry)	Reverse the duplicate before filing
Credit note not reflected	Supplier issued it but hasn’t reported it, or you haven’t actioned it in IMS	Chase the supplier; use the Pending status if goods haven’t been received yet

Manual Reconciliation in Excel vs Automated Tools

Excel works fine when your invoice volume is low, and you have one or two GSTINs to manage. VLOOKUP or a basic pivot table against exported GSTR-2B data gets you a workable match. The problems show up as volume grows: manual matching doesn’t scale past a few hundred invoices a month without eating a disproportionate amount of someone’s time; it’s error-prone when done under deadline pressure, and it doesn’t track IMS actions or 180-day ageing automatically; you’re recalculating those by hand every cycle.

Automated reconciliation tools handle the matching algorithmically, flag mismatches by category instead of leaving you to spot them, and, increasingly relevant now, manage IMS actions in bulk rather than one invoice at a time. For a firm that is filing with several GSTINs or processing thousands of invoices in a month, the investment in the tool pays for itself in a very short span of time. However, if reconciliation alone is taking a day or more, it may be wise to consider the implementation of GST billing software as the answer to your Excel results. 

What’s Changed Recently

GST compliance has become significantly stricter in the past couple of years. 

IMS is now mandatory

The Invoice Management System became compulsory from 1 April 2026, with ITC claims hard-blocked for any invoice that isn’t reflected as accepted in GSTR-2B. Before this, IMS was a convenience layer; now it’s a gating mechanism. If your reconciliation process doesn’t include a weekly IMS review, ITC you’d normally have claimed can simply disappear from your eligible credit.

GSTR-3B liability figures are locked

Starting with the July 2025 tax period, the outward liability auto-populated into GSTR-3B from GSTR-1 became non-editable, with any corrections requiring a GSTR-1A filing before GSTR-3B is submitted. This means reconciliation between GSTR-1 and GSTR-3B has to happen earlier in the cycle than it used to; by the time you’re filling out GSTR-3B, the number is already fixed.

There’s a hard cutoff on late filing

From the July 2025 tax period onward, the portal won’t accept a GSTR-3B filed more than three years after its original due date. Combined with the Section 16(4) time bar on claiming ITC, this makes prompt monthly reconciliation more important than ever; there’s no longer an assumption you can clean things up much later.

These are portal-level and statutory changes, not vendor marketing, so it’s worth checking the current CBIC and GSTN advisories directly if you’re reading this some months after publication; this is an area that moves.

Conclusion

Reconciliation isn’t glamorous, but it’s what separates a confident filing from one you’re crossing your fingers over. Build the monthly habit, add a weekly IMS check, and GSTR-9 season stops being a scramble.

If Excel is eating a full day or more each cycle, that’s usually the point to automate. MargBooks Software handles GSTR-2B matching, IMS actions, and ITC eligibility flags in one place, built for exactly this kind of high-volume reconciliation.

FAQs

Q1. How does GSTR-2A differ from GSTR-2B?

GSTR-2A is regularly updated by suppliers filing their invoices. GSTR-2B is generated once a month and stays fixed, which is why it’s the statement you should actually reconcile against and file from.

Q2. How often should I reconcile GST?

Monthly, at minimum, in line with your filing cycle. Given how central IMS now is, a weekly check on the dashboard is worth building into the routine rather than leaving it all to the 13th or 14th.

Q3. Can I claim ITC that isn’t showing in GSTR-2B?

Not under the current system. If it has not been approved by IMS and appears in GSTR-2B, it does not qualify for ITC in GSTR-3B, and the issue has to be dealt with by the supplier beforehand. 

Q4. What if GSTR-1 and GSTR-3B are not in agreement?

It remains one of the main causes of a tax department letter being issued, as this can be done automatically by the officials. Since GSTR-3B’s liability figures are now locked from GSTR-1, the fix has to happen through GSTR-1A before you file, not after.

Q5. Is GST reconciliation mandatory?

There’s no separate statutory filing called “reconciliation,” but the underlying checks, ITC eligibility, time limits, and matching are what determine whether your return is actually correct. Skipping it doesn’t make it optional; it just means the department finds the errors instead of you.

Q6. Which is the best GST reconciliation software?

Depends on your volume and existing accounting setup. For businesses with meaningful invoice volume across multiple GSTINs, look for tools that handle IMS actions in bulk, not just 2B matching; that’s the part that’s grown most in importance recently.