GSTR-2B vs your books: how to reconcile without losing your mind

Reconciliation is just three buckets: matched, mismatched, missing — and a fixed monthly routine that fills them.

Every month, two lists describe your purchases: the bills in your drawer (your books) and the invoices your suppliers reported (GSTR-2B). Reconciliation is making them agree — because you can only claim ITC for what's in 2B, and claiming more invites a notice.

Why bother (in rupees)

• Under-claim (invoice in 2B, missed in your books): you leave your own money on the table.
• Over-claim (in your books, not in 2B): if the gap crosses 20% or ₹25 lakh, the system can auto-fire a DRC-01C notice with a 7-day clock — see our DRC-01C guide.
• Stuck credit (supplier hasn't filed): found early, it's a WhatsApp reminder; found late, it's next month's cash-flow hole.

The monthly routine (14th → 20th)

1. Download GSTR-2B on the 14th

Portal → Returns → GSTR-2B → the Excel download gives you every invoice suppliers reported, with GSTIN, invoice number, date, and tax split (IGST/CGST/SGST).

2. Line up your purchase register

From Tally, your billing app, or the shoebox. Same four fields. This is the step where paper bills that never got entered surface — enter them first, or your "missing" list lies to you.

3. Match on four fields

For each invoice: GSTIN + invoice number + date + tax amount. Match exactly? Bucket 1. Watch for the classic false mismatches:

• Invoice number formats: INV-001 vs 001 vs INV/001
• Date entered as invoice date vs delivery date
• Rounding differences of ₹1-2 on tax

4. Sort the exceptions

| Bucket | Meaning | Action | |---|---|---| | Matched | In books and 2B, all fields agree | Claim the ITC in 3B | | Mismatched | In both, but amounts/details differ | Small rounding: claim per 2B. Real difference: supplier amends in next GSTR-1 | | Missing from 2B | In your books only | Supplier hasn't filed / filed wrong — run the 5-reason diagnostic and chase | | Missing from books | In 2B only | Either you forgot to enter a bill — or someone is using your GSTIN. Verify, and Reject unknown invoices in IMS |

That last row matters more than it looks: with ₹1.01 lakh crore of fake ITC detected in FY24-25, an unknown invoice in your 2B can mean a fraudster is padding their books with your GSTIN.

5. Act before you file

Chase missing invoices (with details, on WhatsApp), take your IMS Accept/Reject actions, and only then let your CA file GSTR-3B with the reconciled figure.

A worked example

Gupta Stores, June: 42 purchase bills totalling ₹6,20,000 taxable + ₹1,08,400 GST in the books. GSTR-2B shows 38 invoices, ₹98,150 credit.

• 36 match cleanly → claim.
• 2 mismatched: one supplier typoed ₹8,400 as ₹4,800 → amendment requested; one is ₹1 rounding → claim per 2B.
• 4 missing (₹10,250): three from one late-filing distributor → WhatsApp reminder, credit arrives next month; one from a supplier whose GSTIN turns out cancelled → CA consulted, purchase stopped.
• 2B also shows 1 invoice Gupta never made → Rejected in IMS.

Twenty minutes with the right tool; an afternoon with Excel; a DRC-01C risk with neither.

Excel vs software

Excel works until it doesn't: VLOOKUP dies on INV-001 vs 001, nobody enjoys the 14th-evening ritual, and a spreadsheet can't message your suppliers. GST Sathe does the download, fuzzy matching, bucket-sorting, supplier WhatsApp reminders, and IMS suggestions automatically — and hands your CA the finished report. See bill matching →

Sources

• Rule 60(7), CGST Rules (GSTR-2B); Section 16(2)(aa) CGST Act
• Rule 88D & Form DRC-01C (ITC mismatch intimation)
• FY24-25 fake ITC detection figures, DGGI/CBIC