Petpooja Payroll is now Attendo
Book a Demo

GST Input Tax Credit Reconciliation Template in Excel, Free for Indian Businesses

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.

  • Auto-matches every purchase invoice to GSTR-2B on GSTIN and invoice number
  • Flags each invoice Matched, Mismatch, Not in GSTR-2B, or Only in 2B
  • Tells you your claimable ITC, ITC on hold, and blocked credits at a glance
No spam. Instant download link to your email.
Petpooja presents
GST ITC Reconciliation Template
For Indian Businesses & Accountants
5
Sheets · Excel template
FY 2026-27
What's Inside

Five sheets that turn two files into a claimable-ITC number

01

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.

02

GSTR-2B Sheet

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.

03

Invoice-Level Matching

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.

04

Reconciliation Dashboard

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.

05

Blocked Credit Check

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.

06

How It Works + ITC Rules

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.

Why This Matters

You Can Only Claim the ITC That Your Suppliers Report

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.

Sample Preview

What the dashboard shows for one month of purchases

Here is the reconciliation for the sample data that comes loaded in the template:

ITC as per your books: ₹36,360 across 8 purchase invoices
ITC as per GSTR-2B: ₹32,000, a ₹4,360 difference to explain
Claimable ITC now: ₹23,760 from the four Matched, eligible invoices, safe to take (the fifth Matched invoice is a blocked credit)
On hold and blocked: ₹7,200 not in GSTR-2B (2 invoices, suppliers to file), ₹3,600 mismatched (a ₹400 gap to fix), and ₹1,800 blocked under Section 17(5)
Not yet booked: ₹3,240 sitting in GSTR-2B against an invoice you have not recorded, verify and book it
... plus a colour-coded status on every invoice and an invoice count for each category, all calculated across 5 sheets.
Key Stats

The ITC rules that decide your claim

GSTR-2B

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, 2017
30 Nov

The 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, 2017
180 days

If 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, 2017
Common Mistakes

7 ITC Reconciliation Mistakes Indian Businesses Make

01

Claiming ITC straight from the purchase invoice

The 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.

02

Not reconciling every month

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.

03

Ignoring the 30 November 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).

04

Claiming blocked credits

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.

05

Matching on invoice number alone

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.

06

Not paying suppliers within 180 days

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.

07

Missing purchases that are only in GSTR-2B

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.

Comparison

ITC Reconciliation: By Hand vs This Template

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

Claim every rupee you can, and not one you can't

Download the free GST ITC Reconciliation Template and match your books to GSTR-2B in minutes.

FAQ

Frequently asked questions

What is ITC reconciliation and why does it matter?
ITC reconciliation is matching the input tax credit in your purchase books against your GSTR-2B, the statement the GST portal auto-drafts from your suppliers' returns. It matters because, since January 2022, you can claim ITC only to the extent it appears in GSTR-2B. Reconciling every month means you claim every genuine credit, avoid over-claiming, and keep a clean record for your GST return filing.
How does the template match my invoices to GSTR-2B?
It matches each purchase invoice on two fields together: the supplier's GSTIN and the invoice number. If both match and the tax agrees, the invoice is Matched. If both match but the tax differs, it is a Mismatch. If the invoice is in your books but not in GSTR-2B, it is Not in GSTR-2B. If it is in GSTR-2B but not your books, it shows as Only in 2B. This is why the GSTIN and invoice number must be entered exactly as they appear.
Why is my GSTR-2B different from my purchase register?
Common reasons: a supplier has not filed their GSTR-1 yet, so the invoice is missing from GSTR-2B; a supplier keyed in a wrong taxable value or tax, causing a mismatch; you booked a purchase the supplier reported in a different month; or you missed recording an invoice that the portal shows. The template sorts each of these into its own bucket so you know exactly what to chase. GST is an indirect tax that runs on this supplier-to-recipient matching.
What is a blocked credit under Section 17(5)?
Section 17(5) lists purchases on which ITC cannot be claimed even if they appear in GSTR-2B: motor cars (with some exceptions), food and beverages, outdoor catering, club and gym memberships, and goods or services for personal use, among others. In the template you mark these as ITC Eligible = No. They stay matched for your records but are excluded from your claimable ITC, so you do not claim them by accident.
By when must I claim ITC, and does this work in Google Sheets?
ITC for a financial year must be claimed by 30 November of the following financial year, or the date you file the annual return, whichever is earlier (Section 16(4)). After that, unclaimed credit is lost, so reconcile monthly and clear mismatches early. The template works in Microsoft Excel, and in Google Sheets after a quick import. If you also need to check a supplier's tax rate, our free GST calculator and our GST invoice template are handy companions.

About Petpooja

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.

Keep your books ready to reconcile

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.

Book a Free Demo Call: +91-92279 80766
↑↓move ↵open Escclose
Petpooja Blog newsletter

Practical guides for your business, in your inbox.

New articles, free tools and templates for restaurants, retail and growing businesses. No spam, unsubscribe anytime.

By subscribing, you agree to receive updates from Petpooja. Read our Privacy Policy.

Reader settings
Theme
Text size
Free 20-minute demo

Book a Demo

Tell us about your business. Our team will call you within 24 hours.

Talk to a product expertFree 20-min demo
Start typing to search for your city

By submitting, you agree to receive updates from Petpooja and accept our Privacy Policy.