GST ITC Reconciliation Workbook — GSTR-2B vs Purchase Register (Excel & Google Sheets)

Claim exactly the ITC you're entitled to, and know which suppliers to chase.

Paste your purchase register and the GSTR-2B download from the GST portal. Every invoice is matched on supplier GSTIN and invoice number, ignoring spaces, hyphens, slashes and capital letters.

What you get

• Status for every invoice: Matched, Value mismatch, Not in GSTR-2B, Duplicate
• Invoices in GSTR-2B that are missing from your books
• An action for each invoice, so you can filter for your supplier follow-up list
• Summary: ITC per books vs GSTR-2B, ITC on hold, and the eligible ITC for GSTR-3B Table 4A(5)
• 2,000 invoices a month, with an adjustable rounding tolerance

What you need: Microsoft Excel 2010 or later, or a free Google account for Google Sheets. No macros, no add-ins, no subscription.

Support: if the file doesn't work as described, email me within 7 days and I'll fix it or refund you in full.

A working paper, not a filing tool. Reversals and blocked credits are not calculated. Confirm with your accountant.