GSTR-2B reconciliation should answer one question: what can we safely claim?
A match is only the beginning. The real monthly close must connect books, GSTR-2B, IMS, eligibility, reversals, reclaims, RCM and the GSTR-3B return.
Most GST reconciliation spreadsheets stop too early. They compare invoice numbers and total tax, colour the matched rows green, and leave the tax team to work out whether the credit is actually eligible. That approach can miss duplicate invoices, blocked credit, credit-note reductions, supplier non-filing, payment-based reversals and section 16(4) deadlines.
We built a detailed GSTR-2B reconciliation Excel template for the complete monthly process. It uses seven-field matching, preserves tax-head differences, flags legal ITC gates and builds a reviewable GSTR-3B bridge.
Download the free GSTR-2B reconciliation Excel template
The workbook contains 15 formula-driven sheets, sample cases, controlled lists, an action tracker, reversal and reclaim ledger, RCM ledger, dashboard, checks and an official-source audit trail.
Download the GSTR-2B Reconciliation Template
Microsoft Excel .xlsx file. Replace the demonstration rows before using the workbook for a real return.
What GSTR-2B reconciliation means in 2026
GSTR-2B is an auto-drafted input tax credit statement built from filed supplier returns, ISD data and import information. It helps a recipient see documents communicated through the GST system. It does not prove that every credit shown is legally available.
Section 16 still requires a valid document, receipt of goods or services, communicated supplier details, tax payment subject to the statutory framework and the recipient’s return. Business use, blocked credits under section 17(5), common-credit reversals, payment within 180 days and the time limit under section 16(4) must also be considered.
Why the purchase register and GSTR-2B do not match
Supplier timing
The supplier may file monthly, use IFF under QRMP, report in a later GSTR-1 or correct the item through GSTR-1A or a subsequent amendment.
Different document formats
Invoice numbers may contain spaces, slashes, hyphens or leading zeroes. Normalisation helps, but it must not create false matches across suppliers.
Credit notes and amendments
A downward amendment can reduce ITC already claimed. Linking the amendment to the original document prevents a double reduction.
Books and receipt timing
A document can appear in GSTR-2B before it is booked, received or approved. A purchase can also be in books before the supplier files it.
The matching logic used in the workbook
The template follows the seven parameters used in the GST matching tool and checks:
- Supplier GSTIN
- Document type
- Normalised document number
- Document date
- Taxable value
- Total tax
- Individual IGST, CGST, SGST or UTGST and cess amounts
A composite key combines supplier GSTIN, document type and normalised document number. This is deliberately stronger than invoice-number-only matching. Duplicate counts are calculated before a match is accepted so one portal row cannot quietly satisfy several book invoices.
The Setup sheet contains editable tolerances. These tolerances are internal review tools, not a legal rounding safe harbour. A tolerance result remains visible for review.
How to classify reconciliation differences
| Result | What it means | Typical next step |
|---|---|---|
| Exact | All seven matching controls pass within configured tolerances. | Complete legal eligibility and evidence review before claiming. |
| Partial or probable | The composite key matches, but one or more dates, values or tax heads differ. | Review the source document and ask the supplier to amend if required. |
| Only in Books | The purchase is recorded but no matching GSTR-2B document is found. | Hold normal forward-charge ITC and follow up for filing or correction. |
| Only in 2B | The portal contains a document that is not recorded in books. | Verify ownership, invoice, receipt and booking. Reject only when appropriate. |
| Duplicate | The same composite key occurs more than once. | Block automatic claiming and resolve the duplicate or amendment trail. |
| Legal hold | Matching may pass, but receipt, business use, blocked-credit, payment, depreciation or deadline gates fail. | Hold, reverse or permanently disallow based on the applicable rule. |
IMS actions: Accept, Reject, Pending and No Action
IMS applies from the October 2024 return period. Accepted and deemed-accepted records feed the available-credit workflow. Rejected records are excluded. Pending records stay out of the relevant GSTR-2B and carry forward, subject to the applicable timelines.
If an action changes after draft GSTR-2B generation, recompute GSTR-2B before filing GSTR-3B. The workbook records IMS status, action date, remarks and the ITC-reduction amount used for relevant credit notes and downward amendments.
ITC eligibility checks included in the Excel file
- Receipt or last-lot evidence
- Business, exempt and non-business use percentages
- Section 17(5) blocked-credit categories
- Capital asset and GST-depreciation restriction
- 180-day payment due date and partial-payment tracking
- Ordinary section 16(4) deadline, using 30 November or the earlier annual-return filing date
- Duplicate purchase-register and GSTR-2B keys
- Supplier GSTR-3B status for Rule 37A review
- Place-of-supply and recipient-state review
- Original document links for credit notes and amendments
Temporary reversals and reclaims
Temporary reversals should not disappear into a monthly working paper. The Reversal Reclaim sheet keeps the original claim, reason, tax heads, reversal period, cure date, reclaim period and closing open amount.
Common temporary examples include Rule 37 payment reversals, Rule 37A supplier return non-filing, receipt conditions, supplier-tax-payment conditions and error corrections. Permanent or non-reclaimable reversals such as applicable Rules 42 or 43 and section 17(5) should be separated from temporary reversals.
RCM, import and ISD treatment
The RCM Ledger tracks the liability reported in Table 3.1(d), the cash-payment date and the later ITC claim. Import-service ITC maps to Table 4(A)(2), while other eligible RCM inward supplies map to Table 4(A)(3). Import goods map to 4(A)(1), and valid ISD credit maps to 4(A)(4).
From 1 April 2025, the amended mandatory ISD framework applies to relevant common input services. The workbook therefore keeps ISD data separate rather than treating every GSTR-6 item as ordinary B2B credit.
GSTR-3B Table 4 bridge
The GSTR-3B Bridge provides tax-head calculations for 4(A)(1) to 4(A)(5), permanent reversals in 4(B)(1), temporary reversals in 4(B)(2), net ITC in 4(C), reclaimed ITC disclosure in 4(D)(1) and other ineligible ITC in 4(D)(2).
Always compare the workbook with the live portal before filing. Auto-populated GST values can be edited where the law and evidence require a different result, but every change should have a documented reason and reviewer.
Monthly GSTR-2B reconciliation process
- Update the recipient GSTIN, period, FY, frequency and review date.
- Paste the purchase register and GSTR-2B or IMS data into the two staging sheets.
- Resolve duplicate keys before reviewing matches.
- Review exact, partial, probable, books-only and 2B-only results.
- Complete receipt, section 17(5), business-use, payment and deadline fields.
- Assign every exception to an owner and due date.
- Post temporary and permanent reversals in the ledger.
- Record RCM cash payment before claiming the related ITC.
- Recompute GSTR-2B when IMS actions change after draft generation.
- Resolve failed Checks, review the GSTR-3B bridge and retain supporting evidence.
What evidence should we retain?
Keep the invoice or prescribed document, purchase-register extract, GSTR-2B download, IMS action evidence, goods-receipt or service-confirmation proof, payment evidence, supplier correspondence, amendment and credit-note trail, RCM challan or cash-payment support, reversal and reclaim working, reviewer sign-off and the final GSTR-3B comparison.
Frequently asked questions
Can we claim ITC only because an invoice appears in GSTR-2B?
No. GSTR-2B communication is important, but the other conditions under sections 16 and 17 and the relevant rules still apply.
What is the GSTR-2B reconciliation formula?
There is no single statutory formula. A reliable process matches GSTIN, document type, document number, date, taxable value, total tax and each tax head, then applies the legal eligibility gates.
Should we use GSTR-2A or GSTR-2B for the monthly ITC claim?
GSTR-2B is the primary auto-drafted statement for the return workflow. GSTR-2A remains dynamic and may be useful for investigation, but it is not a substitute for current GSTR-2B and IMS controls.
Can the matching tolerance be ₹1?
You may use a small internal tolerance to identify rounding differences, but it is not a statutory safe harbour. Keep the variance visible and review material or repeated differences.
What happens when a purchase is in books but missing from GSTR-2B?
For an ordinary forward-charge purchase, hold the claim and ask the supplier to file or correct the document through the available return route. Monitor the section 16(4) deadline.
Does a rejected IMS invoice disappear forever?
The supplier generally needs to correct the record through GSTR-1A or a later GSTR-1 or IFF, depending on timing. The recipient should verify the corrected record and recompute GSTR-2B when required.
Why does the template show failed checks when opened?
The included demonstration data contains deliberate duplicate, mismatch and blocked-credit cases. Replace the demo rows and resolve every failed check before using the workbook for a real return.
Official references used
The workbook includes direct links to the consolidated CGST Act, GSTR-2B instructions, IMS advisories, Rule 37A notification, GSTR-3B reporting circular, matching-tool manual, GSTR-1A and IFF guidance, Bill of Entry IMS advisory and the amended ISD framework. The source list was reviewed on 13 August 2026.