Traditional Excel method
A basic approach is to create a key using supplier GSTIN and invoice number, then use XLOOKUP, VLOOKUP, COUNTIF or Power Query to locate corresponding records. Additional formulas can compare taxable value and tax components.
Why simple VLOOKUP is not enough
Exact invoice-number matching can miss genuine matches when suppliers use different separators, spaces or numbering conventions. It can also create false confidence when duplicate invoices or amendments exist.
Recommended working columns
A practical file can include GSTIN, supplier name, document type, invoice number, invoice date, taxable value, IGST, CGST, SGST/UTGST, cess, matching status, difference amount and remarks.
Four-way exception review
Separate Matched, Partial Matching, Not in 2B and Not in PR records. Add remarks for supplier follow-up, accounting correction, duplicate check or legal review.
When should you use a tool?
For hundreds or thousands of records, a dedicated reconciliation tool can reduce repetitive formulas and improve consistency. The GST Reconciliation Tool on this website accepts spreadsheet data and creates an Excel reconciliation report.
Remember
An Excel match does not by itself establish legal ITC eligibility. Review the applicable GST provisions and source documents before finalizing ITC.
Use the Free GST Reconciliation Tool
Reconcile Purchase Register vs GSTR-2B, review matched and unmatched invoices and download an Excel reconciliation report.
Open GST Reconciliation Tool →Frequently Asked Questions
What is GST reconciliation?
It is the comparison of accounting records with GST data to identify matched and exception transactions.
Why reconcile Purchase Register with GSTR-2B?
It helps identify missing invoices, mismatches, duplicate records and other differences before final ITC review.
Can GSTR-2B reconciliation be done in Excel?
Yes. Excel is commonly used, although large datasets and non-identical invoice numbers can make manual matching difficult.
Does a matched invoice automatically mean ITC is eligible?
No. Matching is a data-review result. Applicable GST law and transaction-specific eligibility conditions still need to be considered.