GST Reconciliation Format in Excel: Free Template + Formulas
Download a free GST reconciliation format in Excel, plus the exact XLOOKUP formulas to match GSTR-2B with your books — and where Excel quietly costs you ITC.
Pavan KumarSep 14, 2026The GST Reconcile Blog
Expert guides on GST reconciliation, GSTR-2B matching, ITC claims, and best practices for CAs and accountants.
Pavan KumarSep 14, 2026
GST ITC Reconciliation: Recoverable vs Gone for Good
GST ITC reconciliation for CAs: which GSTR-2B mismatches are recoverable, which to chase, and which are permanently lost before the Section 16(4) deadline.
Pavan KumarJun 29, 2026
Free GSTR-2B Reconciliation Tool — Runs in Your Browser
Reconcile GSTR-2B online — nothing to install, and your client files never leave your browser. Free, no signup, no JSON. Export the reconciled result back to Excel.
Pavan KumarJun 17, 2026GSTR-2B Reconciliation: Complete FY 2026-27 Guide for CAs
Reconcile GSTR-2B with your purchase register for FY 2026-27. Step-by-step for CAs: match invoices, surface ITC at risk per supplier, file a clean GSTR-3B.
Pavan KumarMay 2, 2026GSTR-2A vs GSTR-2B: Which to Use for ITC in 2026
Learn why GSTR-2B — not GSTR-2A — is the only valid basis for claiming ITC in 2026 under Rule 36(4), and the mismatch-notice risk of relying on 2A.
Pavan KumarMay 2, 2026
Vendor Not Filed GSTR-1? How to Protect Your ITC
Find every defaulting vendor before the 20th — spot 'Only in Books' invoices, send the follow-up email, and handle Rule 37A reversals without losing ITC.
Pavan KumarMay 2, 2026