Company & Period Details
Shown on the printed / exported reconciliation report
Books of Account
Download the template, fill it in, and upload — or type directly below
| Date | Invoice No. | GSTIN | Party Name | Invoice Value | Taxable Value | CGST | SGST | IGST |
|---|
GSTR-2B (As Filed)
Download the template, fill it in, and upload — or type directly below
| Date | Invoice No. | GSTIN | Party Name | Invoice Value | Taxable Value | CGST | SGST | IGST |
|---|
Books and GSTR-2B totals are identical — same row count and same amounts on both sides. If that's genuinely expected, ignore this. If not, double-check you didn't upload the same file to both panels.
Every mismatch category with its own Diff row. The TOTAL should equal the Books-vs-GSTR2B Control Total below it — when Net Diff Check reads zero for every field, everything is fully explained.
I. Matched Invoices — verified identical on both sides, no differences at all
A. In Books, NOT in GSTR-2B — missing from 2B, chase the supplier or check next period
B. In GSTR-2B, NOT in Books — missing from Books, verify genuineness then book it
C. Value Mismatch — same invoice both sides, amounts differ
F. Possible Invoice Value Mismatch — Taxable/CGST/SGST/IGST all tie out, but the Invoice Value total differs
D. Possible Match — Invoice No. differs (same GSTIN, date & taxable value)
E. Possible GSTIN Mismatch (same Invoice No., date & taxable value — check for a typo)
G. Possible Date Mismatch (GSTIN, Invoice No. & amounts match — check the GST return period)
Same GSTIN + Invoice Number appears more than once on ONE side. Not part of the Category Diff tie-out — review manually.
H1. Duplicates within Books
H2. Duplicates within GSTR-2B
🔒 Nothing you enter here is uploaded to any server — every calculation runs locally in your browser, and your Books / GSTR-2B data never leaves your device.
Want the full Excel utility, or this reviewed by a human?
This free tool covers the core reconciliation in-browser. Leave your email and we'll reach out about the full Excel workbook or a reviewed reconciliation.
✓ Request received! We'll email you shortly.