Skip to main content
HelloBooks.ai home
GST Filing
GSTR-2B Reconciliation for Free: Claim Every Rupee of ITC
GSTR-2B Reconciliation for Free: Claim Every Rupee of ITC

GSTR-2B Reconciliation for Free: Claim Every Rupee of ITC

By HelloBooks Team

How to reconcile GSTR-2B with your purchase register for free, use IMS to accept or reject invoices, and claim the right input tax credit in GSTR-3B each month.

HelloBooks Team

HelloBooks Team

8 min read

Key takeaways

What this article covers, in order:

  • Why does GSTR-2B decide your credit?
  • Where does IMS fit in?
  • The four buckets every reconciliation ends up in
  • How to do it free in Excel
  • A worked month: Arjun's auto parts shop in Coimbatore
  • Mistakes that cost real money
Chapter Guide▾

Kavita paid ₹22,000 in GST on a new printer last quarter. When she went to claim it, the credit simply wasn't there. Her supplier hadn't reported the invoice. GSTR-2B reconciliation is how you catch that before it costs you: you match your purchase bills against GSTR-2B every month, chase the gaps, and claim only what the portal shows. You can do it free in Excel, or let your accounting software match it for you.

Why does GSTR-2B decide your credit?

Under Section 16(2)(aa) and Rule 36(4), you can only claim input tax credit on invoices that appear in your GSTR-2B. It doesn't matter that you have the original bill, paid the supplier and stored the goods in your godown. If the supplier hasn't reported it, the credit isn't available to you yet.

GSTR-2B is a fixed statement the portal generates around the 14th of each month, built from what your suppliers filed in GSTR-1, IFF, GSTR-5 and GSTR-6, plus import data from ICEGATE. Fixed matters here. Unlike GSTR-2A, which keeps changing as suppliers file late, GSTR-2B for a month doesn't shift unless you recompute it after taking action in the Invoice Management System.

There's also a deadline that people forget. Credit for FY 2025-26 purchases has to be claimed by 30 Nov 2026, or by the date you file the FY 2025-26 annual return if that's earlier. The same rule rolls forward: FY 2026-27 credit closes on 30 Nov 2027 at the latest. Miss it and the credit is gone for good.

Where does IMS fit in?

The Invoice Management System, live since the Oct 2024 tax period, sits between your suppliers' filings and your GSTR-2B. Every invoice a supplier reports against your GSTIN lands there. You can accept it, reject it, or keep it pending.

Accepted invoices go into GSTR-2B as eligible credit. Rejected ones stay out. Pending ones wait, though you can't keep everything pending forever, and some document types have limits on how long they can sit. Invoices you don't touch at all are treated as accepted when GSTR-2B is generated.

So the reconciliation now has two moments. Before the 14th, use IMS to reject things that clearly aren't yours. After GSTR-2B is out, match it against your books. If you take IMS action after the 14th, use the recompute option on the GSTR-2B page so the statement reflects it.

The four buckets every reconciliation ends up in

Put your purchase register next to GSTR-2B and every line falls into one of four places.

BucketWhat it meansWhat you do
MatchedIn your books and in GSTR-2B with the same GSTIN, invoice number, date and taxClaim it
In books, not in GSTR-2BThe supplier hasn't reported it, or reported it late or wrongDon't claim yet. Chase the supplier
In GSTR-2B, not in booksYou haven't recorded the bill, or it's not your purchase at allFind the bill and record it, or reject in IMS
MismatchedBoth sides have it, but amount, GSTIN, invoice number or tax type differsFind out which side is wrong and fix it

The fourth bucket is where most of the time goes. Very often the difference is silly: "INV/0042" in your books, "INV42" in the supplier's return. Good reconciliation tools look past formatting. Excel won't, unless you clean it first.

How to do it free in Excel

If you're doing this by hand, here's a routine that works.

  1. Download GSTR-2B for the month from the portal as Excel (Services, then Returns, then GSTR-2B).
  2. Export your purchase register for the same month from your books, with supplier GSTIN, invoice number, date, taxable value and each tax head.
  3. Clean the invoice numbers on both sides. Remove spaces, slashes and leading zeros into a helper column.
  4. Build a match key by joining GSTIN and the cleaned invoice number.
  5. Use XLOOKUP or VLOOKUP both ways to find what's missing on each side.
  6. For matched keys, compare tax amounts. Flag anything off by more than a rupee or two.
  7. Mark each line with one of the four buckets above.
  8. Total the "claim it" bucket. That's your eligible ITC for Table 4 of GSTR-3B.

It's free, it works, and it's tedious. For thirty bills a month it takes an hour. For three hundred, you'll want software.

A worked month: Arjun's auto parts shop in Coimbatore

Arjun sells two-wheeler spares. In Sep 2026 he recorded 46 purchase bills with ₹1,84,000 of GST. His GSTR-2B for Sep 2026 shows 44 invoices. (Arjun and his numbers are illustrative.)

When he reconciles, 41 match exactly. Two of his bills, worth ₹9,600 in GST, aren't in GSTR-2B. One supplier filed late; the other got Arjun's GSTIN wrong. Three invoices are in GSTR-2B but not in his books. Two are bills he forgot to enter. The third is from a Chennai supplier he's never bought from, so he rejects it in IMS.

He claims credit for the 41 matched invoices plus the two forgotten bills he's now recorded. He holds back ₹9,600. He messages the supplier who used the wrong GSTIN and asks for a correction in their next GSTR-1. When the corrected invoice appears in his Oct 2026 GSTR-2B, he'll claim it then. The credit isn't lost. It's just a month late.

Mistakes that cost real money

Claiming from your purchase register instead of GSTR-2B. It's tempting when you have the bill in hand. It can lead to a DRC-01C notice if your claim runs beyond what GSTR-2B supports past the notified limit, and to interest if the claim is later disallowed.

Not chasing suppliers. A bill sitting in the "not in GSTR-2B" bucket for six months is money you've effectively lent the government. Keep a running list and follow up every month.

Forgetting reversals. Being in GSTR-2B doesn't make every credit eligible. Blocked credits under Section 17(5), like food for staff parties or a car for the owner's personal use, still need to be reversed. And if you don't pay a supplier within 180 days of the invoice date, the credit has to be reversed until you do.

Ignoring Rule 37A. If your supplier reports an invoice but doesn't actually file GSTR-3B for that period by the cut-off date in the following year (30 Sep 2027 for an FY 2026-27 invoice), you may have to reverse the credit. Another reason to work with suppliers who file on time.

If you have large mismatches from earlier years or a notice already in hand, speak to a CA before replying.

How often should you reconcile?

Monthly, if you file monthly. Even QRMP filers should look at GSTR-2B every month, because suppliers who report late mean your credit drifts, and three months of drift is much harder to untangle than one.

A rhythm that works for most small businesses: record bills as they arrive through the month, glance at IMS around the 10th to reject anything obviously wrong, reconcile after the 14th, and file GSTR-3B by the 18th or 19th.

How HelloBooks helps

GSTR-2B reconciliation is included in HelloBooks Free, at ₹0 with no card and no expiry. HelloBooks compares GSTR-2B with the purchase bills already in your books and tracks your ITC, so you can see what's claimable and which supplier you need to call. The reconciled ITC then flows into GSTR-3B, which you file directly to the GST portal from inside HelloBooks along with GSTR-1.

Free covers one GSTIN, 2 users and up to 200 transactions a year. See the GSTR-2B reconciliation page for how the matching works, and the GSTR-3B filing page for the next step.

FAQs

What's the difference between GSTR-2A and GSTR-2B?

GSTR-2A is a live view that keeps changing as suppliers file. GSTR-2B is a fixed monthly statement generated around the 14th. Your ITC claim in GSTR-3B should follow GSTR-2B.

Can I claim ITC if the invoice isn't in GSTR-2B?

Generally no. Credit is allowed only on invoices reflected in GSTR-2B. Wait for the supplier to report it, then claim it in the month it appears, within the time limit.

What happens if I don't act on an invoice in IMS?

It's treated as accepted when GSTR-2B is generated. That's fine for genuine purchases. For invoices that aren't yours, reject them before the statement is generated.

Is there a deadline to claim old ITC?

Yes. For FY 2025-26, credit must be claimed by 30 Nov 2026 or the date you file that year's annual return, whichever is earlier. For FY 2026-27, the outer limit is 30 Nov 2027.

Do QRMP filers need to reconcile monthly?

They file GSTR-3B quarterly, but GSTR-2B is still generated each month. Checking monthly makes the quarter-end reconciliation much lighter.

Reconcile on the 15th, chase on the 16th, claim on the 18th. Your credit will thank you.

Start free — GST filing included, no card. Try HelloBooks Free

About the author

HelloBooks Editorial Team

HelloBooks Editorial Team

Published April 6, 2026 on the HelloBooks blog

The HelloBooks editorial team is made up of accountants, ex-CPA-firm partners, and AI engineers who build the same AI bookkeeping product the articles describe. We write what we ship.

Posts are reviewed for accuracy against current US, UK, India, Australia, and UAE accounting and tax rules before publishing, and updated when those rules change.

About HelloBooks →

Related Posts

Subscribe to our newsletter

Stay up to date with the latest news and announcements. No credit card required.

By subscribing, you agree to our Privacy Policy.