GSTR-2B vs Purchase Register Reconciliation Tool

How it works: Upload the GSTR-2B Excel file downloaded from the GST portal and the client's Purchase Register (any column layout). The tool auto-detects the header row, intelligently maps columns, normalises GSTINs, invoice numbers, dates and amounts, runs six-level matching with a configurable tolerance, and produces a 13-sheet, executive-grade Excel reconciliation report with cover page, ITC difference bridge and detailed reconciliation matrix. Everything runs locally in your browser — no data leaves this computer.

Loading Excel engine…

1 Engagement Details (optional — printed on the Executive Summary)

Client Name

Client GSTIN

Reconciliation Period

Prepared By

2 Upload Files

A — Upload GSTR-2B Excel File downloaded from GST portal

Drop GSTR-2B file here or click to browse

.xlsx / .xls / .csv • B2B sheet auto-detected (B2BA, CDNR & others selectable)

Sheet

Header Row

Column mapping (auto-detected — click to review / override)

B — Upload Client Purchase Register

Drop Purchase Register here or click to browse

.xlsx / .xls / .csv • any column layout — headers auto-detected

Sheet

Header Row

Column mapping (auto-detected — click to review / override)

3 Reconciliation Settings

Amount Tolerance (₹ per field)

Default ₹2 — rounding differences within this limit are treated as matched

Invoice date mandatory for matchingDefault: No — books are often posted on invoice-receipt basis, so date differences are quantified in days and reported, never used to reject a match Ignore special characters in invoice number/-_. and spaces removed before comparison Remove leading zeros from invoice number000123 matches 123 Allow probable matchesAmount-based and name-based matches flagged for review GSTIN mandatory for matching (Levels 1–5)Records with missing/invalid GSTIN go to name-based Level 6 review Include reverse charge entriesIf unticked, rows flagged "Y" for RCM in GSTR-2B are excluded Include credit / debit notesApplies when a CDNR/CDNRA sheet or note-type column is selected

4 Reconciliation Dashboard

Matched Minor difference / probable — review Unmatched / mismatch Informational totals