GST ITC Rescue Workbook FY 2025-26: GSTR-2B Matcher

The GST ITC Rescue Workbook is a formula-only Excel and Google Sheets file that matches your GSTR-2B against your purchase register and tells you, invoice by invoice, which input tax credit for FY 2025-26 is safe, which is mismatched and which will lapse if a supplier does not act before 30 November 2026. It is built for Indian freelancers, founders and small finance teams who reconcile ITC themselves or want to arrive at their CA's desk with the chase list already done.

Section 16(4) of the CGST Act closes the window for FY 2025-26 credit on the earlier of 30 November 2026 or the date you file GSTR-9. Credit whose invoice never appears in GSTR-2B cannot be claimed under Section 16(2)(aa). The workbook puts a rupee figure and a days-left counter on every such invoice, then ranks the suppliers you need to chase by the credit at stake.

What You Get

• GST-ITC-Rescue-FY2025-26.xlsx — the blank workbook with 2,000 rows each for Books and GSTR-2B, eight sheets, no macros, no VBA: README, Settings, GSTR-2B paste area in the portal's column order, Books paste area, Match, 16(4) Risk, Vendor Chase and 3B Table 4.
• The Match engine — builds a normalised key from supplier GSTIN and invoice number, then gives every Books row a status: Matched, Amount mismatch (with your tolerance), Date mismatch, Missing in 2B, Not available in 2B, Duplicate in books; and every GSTR-2B row: Found in books, Missing in books, Duplicate in 2B. Running ITC totals per status.
• 16(4) Risk sheet — every at-risk invoice, largest first, with the ITC amount, days left to the deadline and the next action.
• Vendor Chase sheet — one row per supplier with issue counts, the ITC involved and a ready-to-send message line.
• 3B Table 4 mapping — a starting point for 4(A)(5), 4(B)(2), 4(C) and 4(D)(2), following CBIC Circular 170, with the cells you must enter yourself marked.
• A pre-loaded SAMPLE workbook — 42 fictitious purchases and 40 GSTR-2B rows covering every status, plus a SCENARIOS file that says what each row tests, so you can see the logic work before you paste your own data.
• Vendor email templates — three supplier emails (missing in 2B, amount mismatch, GSTR-1 not filed), each with a WhatsApp-length version.
• Monthly ITC checklist, Sheets import guide, CSV templates, build and verify scripts — VERIFY.md records an independent Python recomputation of the sample against the workbook formulas across 11,260 cells, with zero differences.

How to Use

1. Open the blank workbook. On Settings, enter your GSTIN, confirm the 30-Nov-2026 deadline and set the amount tolerance (default is the paise rounding suppliers introduce).
2. Download GSTR-2B for each month of FY 2025-26 from the GST portal as Excel and paste the rows into the GSTR-2B sheet in the given column order.
3. Export your purchase register from Tally, Zoho Books, Vyapar or your own sheet and paste it into Books.
4. Read Match, then 16(4) Risk. Send the Vendor Chase messages. Re-paste next month's 2B and watch the at-risk total fall.

Who This Is For

• Freelancers and consultants on GST who claim ITC on laptops, software, co-working and travel and have never reconciled against 2B.
• Founders of small companies whose accountant reconciles once a year, in November, in a panic.
• Accounts staff who already match in a spreadsheet and want the status logic, the deadline counter and the supplier chase list done for them.
• CAs who want a client-facing file that produces the chase list without portal access.

It is not tax advice and it files nothing; rows that depend on rule wording still in flux (Rule 37A, IMS recomputation, 2B cut-offs) are marked "verify with your CA" inside the workbook. Pair it with the free GST compliance calendar for the monthly dates, and see the other finance and compliance kits in freelancer templates or browse everything at /browse.