GSTR-2B vs Books: How to Reconcile ITC in Excel (Step-by-Step)

Every month, the input tax credit (ITC) in your GSTR-3B has to be backed by what your suppliers have reported. If your purchase register says ₹4.2 lakh of ITC and GSTR-2B shows ₹3.9 lakh, the ₹30,000 gap is either credit you cannot take yet, credit you may lose, or an error in your own books. A monthly GSTR-2B reconciliation tells you which.

This guide covers the legal basis, a repeatable Excel method, the mismatches you will see most often, and how the Invoice Management System (IMS) changed the process from October 2024.

Why GSTR-2B decides your ITC

Three provisions do most of the work:

• Section 16(2)(aa) of the CGST Act (in force from 1 January 2022): you can take ITC on an invoice only if the supplier has furnished its details in GSTR-1 (or IFF) and those details have been communicated to you in GSTR-2B.
• Rule 36(4) of the CGST Rules: from 1 January 2022 (Notification 40/2021-Central Tax), the earlier 5% provisional credit was removed. ITC on invoices that must be reported by suppliers is limited to what appears in GSTR-2B.
• Section 16(2)(c): the tax must actually have been paid to the government by the supplier. Rule 37A, inserted in 2023, makes you reverse ITC if the supplier has not filed GSTR-3B for that period by 30 September of the following year.

Add to these the other conditions of Section 16(2): you hold a valid tax invoice, you have received the goods or services, and you have filed your own return. Blocked credits under Section 17(5) (for example, most motor vehicles, food and beverages, and works contracts for immovable property) are not available even if they appear in 2B.

The monthly timeline

The practical window for reconciliation is the 14th to the 20th. That is tight, so the matching should be mechanical and only the exceptions should need your time.

How IMS changed GSTR-2B

The Invoice Management System went live on the GST portal from 1 October 2024 and applies from the October 2024 tax period. Every invoice, debit note and credit note your suppliers report now lands on an IMS dashboard, where you can:

1. Accept it: it goes into the 'ITC available' section of GSTR-2B and auto-fills GSTR-3B.
2. Reject it: it goes into 'ITC rejected' and does not reach GSTR-3B.
3. Keep it pending: it stays out of GSTR-2B and GSTR-3B until you accept or reject it in a later period.

If you take no action, the record is deemed accepted when GSTR-2B is generated. That default matters: an invoice you never received, or one with the wrong value, will quietly flow into your 3B unless you look at it.

GSTN's advisory of September 2025 added two changes from the October 2025 tax period. Credit notes and certain amendments can now be kept pending for one tax period (one month for monthly filers, one quarter for quarterly filers), after which they are deemed accepted. And for credit notes, you can declare the amount of ITC actually to be reversed, which helps when you had not taken the original credit in full.

So the reconciliation now has two jobs: decide the IMS action for each record before 2B is final, and then match the final 2B against your books.

Step-by-step: reconcile 2B with books in Excel

Step 1: Get both data sets in the same shape

Download GSTR-2B for the period as Excel (Returns → GSTR-2B → Download). Use the B2B, B2B-CDNR and amendment sheets. From your accounting system, export the purchase register for the same period with: supplier GSTIN, supplier name, invoice number, invoice date, taxable value, IGST, CGST, SGST, cess and the books' document type (invoice, debit note, credit note).

Put both on separate sheets with identical column order. Convert dates to real dates and amounts to numbers.

Step 2: Normalise invoice numbers

Most false mismatches come from formatting. The same invoice can appear as INV/0045/25-26 in 2B and 45 in your books. Build a helper column that:

• converts to upper case
• strips spaces, /, -, . and the financial-year suffix
• removes leading zeros

In Excel 365: =UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"/",""),"-","")," ","")), then a second pass to drop leading zeros with =TEXT(VALUE(B2),"0") where the result is purely numeric.

Step 3: Build a match key and match in passes

Create a key GSTIN|normalised invoice number on both sheets. Then match in passes, from strictest to loosest:

1. Exact: same key, same taxable value and same tax (allow a ₹1 tolerance for rounding).
2. Value difference: same key, but tax differs beyond tolerance. Usually a wrong rate or a typing error on one side.
3. Probable match: same GSTIN, same tax amount, invoice date within a few days, but the key differs. Usually an invoice-number typing difference.
4. Unmatched in books: in your register but not in 2B.
5. Unmatched in 2B: in 2B but not in your books.

XLOOKUP on the key, with a status column driven by IF, gets you through passes 1, 2, 4 and 5. Pass 3 needs a second key GSTIN|tax amount.

Step 4: Summarise by supplier

A pivot by supplier GSTIN showing books ITC, 2B ITC and the difference tells you who to call. Five suppliers usually explain most of the gap.

Step 5: Decide the GSTR-3B figure

The mismatches you will see most

• Supplier filed late. The invoice shows up in a later month's 2B. Claim it then, within the Section 16(4) deadline: 30 November after the end of the financial year, or the date you file the annual return, if earlier.
• Supplier reported it under the wrong GSTIN, often a branch in another state or a B2C entry. Only the supplier can fix this, by amending in their GSTR-1.
• Wrong place of supply: IGST in 2B but CGST+SGST in your books, or the other way round. Same total, wrong heads. The supplier must amend; you shouldn't adjust heads yourself.
• Credit notes: the supplier issued a credit note you haven't booked. Under IMS, accepting it reduces your ITC. Book it, or keep it pending (from October 2025) while you check.
• Invoices in 2B that aren't yours: reject them in IMS before 2B is final.
• Import of goods: IGST on imports flows from ICEGATE into 2B (the IMP sections), not from a supplier. Match against the bill of entry number and date.
• Payment beyond 180 days: ITC already claimed must be reversed under Rule 37 if you haven't paid the supplier within 180 days of the invoice date, and can be re-claimed on payment.

Keep a pending list, not a pile of notes

The single habit that saves the most ITC is a running pending register: every invoice in books but not in 2B, with the month it was booked, the supplier contact, the follow-up date and the month it was finally claimed. Review it every month. Anything approaching the Section 16(4) deadline goes to the top.

Controls that make the reconciliation stick

• Lock the downloaded 2B file for each period; never overwrite it.
• Record your IMS actions (accepted, rejected, pending) with a reason.
• Reconcile the books' ITC ledger with the electronic credit ledger every quarter, not just at year end.
• At year end, tie the twelve months to Table 8 of GSTR-9, which compares 2B-based ITC with ITC claimed.

Frequently asked questions

Sources

1. CBIC GST portal: CGST Act and Rules
2. Revised advisory on Invoice Management System (GSTN)
3. FAQ on new IMS changes from October 2025 tax period (GSTN)
4. GSTR-2B user manual (GST portal)

General information only, not professional advice. Rules change; check the current law and your facts before acting.