GSTR-2B vs Books ITC Reconciliation Worksheet
Each month, accountants compare input tax credit in the purchase books with what the portal shows in GSTR-2B. Mismatches can mean a supplier has not filed, an invoice is under the wrong GSTIN, or a claim is ineligible. This worksheet keeps the comparison and the follow-up in one place.
| Supplier | Supplier GSTIN | Invoice no | ITC in books | ITC in GSTR-2B | Difference (books - 2B) | Claimed but not in 2B | Action status | |
|---|---|---|---|---|---|---|---|---|
Rs 0 | Rs 0 | |||||||
Rs 113,400 | Rs 113,400 | |||||||
Rs 0 | Rs 0 | |||||||
Rs 2,520 | Rs 2,520 | |||||||
Rs 0 | Rs 0 |
Enter the total ITC (IGST + CGST + SGST) per invoice. Use the status column to record the follow-up. Sample rows are illustrative. This sheet supports your own reconciliation and is not a substitute for advice on Section 16 conditions.
Automate ITC matching
Optional: a review of your purchase register and portal exports to see where matching can be automated.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Paste or type one row per purchase invoice with ITC from your books and the ITC shown in GSTR-2B. The sheet calculates the difference and highlights the amount claimed but not visible in the portal. Use the status column to mark the reason and who must act. Totals and the share supported by GSTR-2B give a month-end snapshot you can show to a reviewer before the GSTR-3B is filed.
- Match on supplier GSTIN and invoice number, not name alone
- Treat blocked credits such as certain food and hotel items as ineligible
- Carry timing differences forward with a clear note
Why the 2B comparison matters
Under Section 16 of the CGST Act, ITC is available only when conditions are met, including that the invoice details appear in the recipient's GSTR-2B, as clarified by the Section 16(2)(aa) amendment. GSTR-2B is a static statement generated for each month from supplier filings. Excess ITC claimed in GSTR-3B beyond what the statement supports can attract interest and notices, so a documented reconciliation is your first line of defence.
Common mistakes
Typical errors include reconciling by total instead of invoice, ignoring credit notes and debit notes, missing import of goods under bill of entry, and treating a supplier filing delay as permanent. Reverse charge purchases and ISD credits also need separate treatment. When your accounting package already offers a reconciliation report, use this sheet to check its exceptions and to record the decision for each line.
Frequently Asked Questions
Does this import data from the GST portal?
No. Everything runs in your browser. Download the GSTR-2B Excel from the portal, copy the values into the sheet or compare them in your own file, then export the finished working.
What should I do with unmatched invoices?
Ask the supplier to file or correct their return, confirm the GSTIN and invoice number, and defer the claim until it appears in GSTR-2B. Record the status so that it is revisited next month.
Are credit notes included?
Add them as rows with negative amounts for books and portal values. Reconciling them separately in your notes is good practice because suppliers often report them in a different month.
Is the sample data real?
No. All suppliers, GSTINs and amounts are invented for illustration. Replace them with your own purchase register.
If your team reconciles hundreds of invoices by hand each month, we can discuss automating the matching and flagging from your purchase data.
Related Tools
TDS Deduction Tracker Worksheet for Vendor Payments
Record vendor bills, apply a TDS section and rate, and see tax deducted and net payable per line and in total.
Country & TaxMSME Vendor Payment Due Date Tracker (45 Day Rule)
Record micro and small supplier invoices with agreed days and days outstanding to see overdue amounts before year end.
Country & TaxGST Inclusive and Exclusive Price Calculator
Enter a price, choose GST rate and whether the amount includes tax, and get taxable value, tax split and total.
Country & TaxJob Work Challan Register and ITC-04 Worksheet
An editable register of goods sent to job workers with received quantity, balance, days out and an overdue flag for the one-year and three-year limits.
More Country & Tax tools
See all- GST Tax Invoice Format Template for Indian Manufacturers
- Delivery Challan Format Template for Goods Movement in India
- Purchase Order Format Template for Indian Manufacturers
- GST Bill of Supply Format Template India
- GST Export Invoice Under LUT Template India
- GST Reverse Charge Self Invoice and Payment Voucher Template
- GST Show Cause Notice Reply Template (DRC-06 Style)
- GST Rule 37 180-Day ITC Reversal and Interest Worksheet
- GST E-Invoice IRN Tracking Log Worksheet