Purchase Register
Your purchase invoices from your books: supplier, GSTIN, invoice number and date, taxable value, and CGST, SGST, IGST. Mark any blocked credit as not eligible.
Paste your purchase register and your GSTR-2B, and the template matches them invoice by invoice. It shows exactly how much ITC you can claim now, what is on hold, what to fix, and which purchases you have not booked yet. Updated for FY 2026-27.
Your purchase invoices from your books: supplier, GSTIN, invoice number and date, taxable value, and CGST, SGST, IGST. Mark any blocked credit as not eligible.
Paste the auto-drafted ITC statement you download from the GST portal. This is what the government says your suppliers have reported against your GSTIN.
Every invoice is matched on GSTIN plus invoice number and colour-coded: green Matched, amber Mismatch, red Not in GSTR-2B. No lookups to write yourself.
Claimable ITC now, ITC on hold, mismatches to fix, blocked credits, and purchases sitting in GSTR-2B that you have not booked yet, each with a rupee figure and an invoice count.
An ITC Eligible column to mark Section 17(5) blocked credits, such as food, motor cars, or personal use. Matched but flagged No, they stay out of your claimable total.
A walkthrough of the matching, plus a plain-English guide to the rules that govern ITC: Section 16, Rule 36(4), the time limit, blocked credits, and the 180-day rule.
Your books say you paid a certain amount of GST on purchases. The government says you can claim only what your suppliers have actually reported. When those two numbers disagree, the gap is yours to find, explain, and fix, every single month.
Since 1 January 2022, there is no provisional credit. You can claim input tax credit only to the extent it appears in your GSTR-2B, the auto-drafted statement the portal builds from your suppliers' returns. If a supplier forgets to file, or files late, or keys in the wrong number, that credit is not yours to take yet, no matter what your invoice says.
Reconciling by eye across two long files is slow and error-prone. Miss a mismatch and you over-claim, which invites interest and a notice. Miss a genuine credit and you leave money on the table. Do it late and you can run past the deadline under Section 16(4), after which the credit is lost for good.
This template does the matching for you. It lines up every purchase invoice against GSTR-2B on GSTIN and invoice number, tells you what is safe to claim, and separates out what is on hold, mismatched, or blocked. From October 2025 your GSTR-2B is also shaped by the Invoice Management System (IMS), so act on your invoices in IMS on the GST portal first, then reconcile the finalised statement here.
Here is the reconciliation for the sample data that comes loaded in the template:
Since 1 January 2022, ITC is limited to what appears in your GSTR-2B. Provisional credit is gone (Rule 36(4)), so if a supplier has not reported an invoice, you cannot claim it that month.
Source: CBIC, Rule 36(4) of the CGST Rules, 2017The deadline to claim ITC for a financial year is 30 November of the next financial year, or the date of the annual return, whichever is earlier. Miss it and the credit is lost (Section 16(4)).
Source: CBIC, Section 16(4), CGST Act, 2017If you do not pay a supplier within 180 days of the invoice, the ITC you claimed must be reversed with interest. You can reclaim it once you pay (Rule 37).
Source: CBIC, Rule 37 of the CGST Rules, 2017The invoice in your hand is not enough. Since January 2022, you can claim only what shows in GSTR-2B. Claiming on an unreported invoice is an over-claim waiting for a notice.
ITC is a monthly discipline. Skip a few months and the mismatches pile up, suppliers forget, and you run short of time to fix them before the annual deadline.
ITC for a year must be claimed by 30 November of the next financial year. Credits still stuck in mismatch or on hold after that date are gone for good under Section 16(4).
Food and beverages, motor cars, club membership, and personal-use items are blocked under Section 17(5). They may appear in GSTR-2B, but claiming them is a straight disallowance.
Two suppliers can both raise an INV-101. Matching on invoice number without the GSTIN pairs the wrong invoices. Always match on GSTIN and invoice number together.
Claim the ITC but leave the supplier unpaid past 180 days, and you must reverse that credit with interest under Rule 37. Track your payables alongside your ITC.
Sometimes the portal shows an invoice you never recorded. That is a genuine purchase and a genuine credit. Verify it, book it, and claim it, rather than letting it slip.
| Aspect | Manual (eyeballing two files) | With This Template |
|---|---|---|
| Matching invoices | Scrolling and highlighting by hand | Auto-matched on GSTIN and invoice number |
| Spotting mismatches | Easy to miss a wrong tax value | Flagged amber with the exact gap |
| Missing invoices | Hard to see what is absent | Split into Not in 2B and Only in 2B |
| Claimable ITC figure | Worked out manually, error-prone | A single number on the dashboard |
| Blocked credits | Often claimed by mistake | Marked and excluded automatically |
| Time per month | Hours for a long register | Paste, and read the result |
| Audit trail | Nothing to show later | A status against every invoice |
Download the free GST ITC Reconciliation Template and match your books to GSTR-2B in minutes.
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across retail, restaurants, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.
Petpooja Invoice records your sales and purchases with GST built in and syncs to Tally, so your books already line up with what the portal expects. See how Petpooja Invoice works end to end.