Back to Tools

GST ITC Reconciliation Tool (GSTR-2B)

English: Compares your purchase bills with government portal data (GSTR-2B) to catch missing supplier invoices and claim full tax credit. Real-Life Example: You paid ₹1.8L GST on ₹10L purchases. If vendor XYZ didn't upload your bill on the GST portal, this tool flags it so you don't lose tax credit.
हिंदी: आपके खरीदे गए सामान के बिलों का सरकारी GST पोर्टल (GSTR-2B) से मिलान (Match) करता है ताकि छूटे हुए सप्लायर बिल पकड़े जा सकें। व्यावहारिक उदाहरण: आपने सप्लायर को ₹50,000 का माल खरीदकर GST दिया। अगर उसने पोर्टल पर बिल नहीं दिखाया, तो यह टूल उसे तुरंत लाल रंग से दिखा देगा।
100% Client-Side Processing · No Server Uploads

Reconcile GSTR-2B Input Tax Credit in Seconds

Drop your Purchase Register (PR) and GSTR-2B Excel/CSV files below. Our smart algorithm automatically maps headers, aggregates multi-item invoices, and provides supplier-wise ITC compliance reporting.

Drop your Combined Excel File here
File containing 'PR' and 'GSTR-2B' sheets (.xlsx, .xls)

Fuzzy Header Auto-Mapping

Recognizes column headers from Tally, Busy, Marg, and GST Portal standard exports.

Supplier-Wise Risk Matrix

Groups reconciliation by vendor GSTIN to quickly spot non-compliant suppliers.

Sec 16(2)(aa) Statutory Guard

Separates eligible GSTR-3B ITC claims from unfiled at-risk purchase register invoices.

6-Sheet Audit Excel Export

Generates detailed multi-sheet Excel reports with supplier matrices and mismatch details.

GSTR-3B Statutory ITC Compliance Status (Section 16(2)(aa))
Direct breakdown of ITC eligible for GSTR-3B Table 4(A)(5) vs unfiled vendor risk.
Eligible ITC (Matched)
₹0
At-Risk ITC (PR Only)
₹0
Unclaimed ITC (2B Only)
₹0
MATCHED (ELIGIBLE ITC)
₹0
Count: 0 recs (0%)
MISMATCHED TAX
₹0
Count: 0 recs (0%)
IN PR ONLY (AT RISK)
₹0
Count: 0 recs (0%)
IN 2B ONLY (UNCLAIMED)
₹0
Count: 0 recs (0%)
NET TAX DIFF (PR vs 2B)
₹0
PR Tax minus 2B Tax

GSTR-2B Match Rate

0%
Matched

0 Total Invoices Processed

Record Breakdown

Top Mismatched Suppliers

Processing GSTR-2B Data...
📖 Tool Guide & Related Resources

What is GSTR-2B ITC Reconciliation?

GSTR-2B ITC Reconciliation is the process of matching your Purchase Register (books of accounts) with the auto-generated GSTR-2B statement from the GST portal. Under Section 16(2)(aa) of the CGST Act (effective January 1, 2022), Input Tax Credit (ITC) can only be claimed when the supplier has filed their GSTR-1 and the invoice details appear in the recipient's GSTR-2B. This free online reconciliation tool by CA Piyush Gupta Sir automates the entire matching process — supporting exports from Tally, Busy, Marg, and GST Portal — with fuzzy header auto-mapping, supplier-wise mismatch breakdown, GSTR-3B eligible ITC insights, and a comprehensive 6-sheet Excel audit export. All processing runs 100% offline in your browser, ensuring complete data privacy.

Key Concepts in GST ITC Reconciliation

Term Meaning Action Required
MatchedInvoice exists in both PR and GSTR-2B with matching amountsITC is eligible — claim in GSTR-3B
MismatchedInvoice exists in both but amounts differ beyond toleranceVerify with supplier — claim lower amount
PR Only (At-Risk ITC)Invoice in Purchase Register but missing from GSTR-2BITC not eligible under Sec 16(2)(aa) — follow up with supplier
2B Only (Unclaimed)Invoice in GSTR-2B but not recorded in Purchase RegisterRecord purchase in books — claim eligible ITC
DRC-01C NoticeGST dept notice for excess ITC claimed vs GSTR-2BReconcile immediately — reverse excess ITC or reply
Section 16(2)(aa)CGST Act provision linking ITC eligibility to GSTR-2BMandatory compliance — reconcile before every GSTR-3B filing

Note: Tax rounding tolerance of ₹1 to ₹5 is common practice. This tool supports configurable tolerance settings for practical matching.

🔗 Related Accounting & Tax Tools

🧾

GST Invoice Generator (Excel)

Generate professional GST invoices offline with auto CGST/SGST/IGST calculation

 %

GST Calculator

Calculate CGST, SGST & IGST for any amount with all standard rate slabs

 ⏱️

GST Late Fee Calculator

Calculate Section 50 interest & Section 47 late fees for delayed GST filings

 🔍

GSTIN & PAN Validator

Verify GSTIN format, state code & taxpayer structure instantly

❓ Frequently Asked Questions (FAQ)

What is GSTR-2B ITC reconciliation and why is it mandatory?

GSTR-2B ITC reconciliation is the process of matching your Purchase Register (books of accounts) with the GSTR-2B auto-generated statement from the GST portal. Under Section 16(2)(aa) of the CGST Act, Input Tax Credit can only be claimed if the supplier has filed their GSTR-1 and the invoice details appear in your GSTR-2B. Regular reconciliation prevents excess ITC claims and avoids DRC-01C notices from the GST department.

How does this tool reconcile Purchase Register with GSTR-2B?

Upload your Purchase Register and GSTR-2B Excel/CSV files. The tool uses fuzzy header auto-mapping to recognize columns from Tally, Busy, Marg, and GST Portal exports. It aggregates multi-item invoices by GSTIN and invoice number, then matches them with configurable tax rounding tolerance (₹0 to ₹5). Results are categorized as Matched, Mismatched, PR Only (at-risk ITC), and 2B Only (unclaimed ITC).

Is my data safe when using this GST reconciliation tool?

Yes, 100%. This tool runs entirely in your web browser using client-side JavaScript. No data is uploaded to any server. Your Purchase Register and GSTR-2B files are processed locally on your device and never leave your browser. You can even use this tool offline after the page loads.

What is Section 16(2)(aa) of the CGST Act?

Section 16(2)(aa) was inserted in the CGST Act effective January 1, 2022. It mandates that a registered person can claim ITC only when the details of the invoice or debit note have been furnished by the supplier in their GSTR-1/IFF and such details are communicated to the recipient via GSTR-2B. This eliminated provisional ITC claims and made GSTR-2B the definitive basis for ITC eligibility.

Can I export the reconciliation results?

Yes. The tool generates a comprehensive 6-sheet Excel audit package that includes: Reconciliation Summary, Supplier-Wise Matrix, Matched Invoices, Mismatched Invoices, PR Only Invoices (at-risk ITC under Section 16(2)(aa)), and GSTR-2B Only Invoices (unclaimed ITC). This export is ready for audit documentation and GSTR-3B filing reference.