✅ GST ITC Reconciliation Tool
Instantly reconcile your GSTR-2B with your Purchase Register — upload your files, get matched & mismatched invoices in seconds. 100% free, browser-based, and completely secure.
▶ Launch Free ToolEvery GST-registered business must reconcile its Input Tax Credit (ITC) claimed in books with what is auto-populated in GSTR-2B by the GSTN portal. Manual reconciliation of hundreds or thousands of invoices is tedious and error-prone. Our free GST ITC Reconciliation Tool automates this entire process — just upload your GSTR-2B and Purchase Register and get instant results.
Multi-Format Support
Accepts GSTR-2B Excel/JSON from the GST portal and Purchase Registers in Excel or CSV format.
Instant Matching
Smart 3-pass header detection auto-maps your columns. Matches invoices by GSTIN, invoice number, date & tax amounts.
Tax Classification Mismatch
Supplier filed CGST+SGST but you booked IGST? The tool still matches by total tax — no false mismatches.
Detailed Results & Export
View Matched, Mismatched, and Missing invoices in tabs. Export to Excel for audit trails and CA workpapers.
100% Private & Secure
All processing in your browser. Your financial data never leaves your device — no server uploads.
Tolerance & Fuzzy Match
Set amount tolerance (e.g. ₹1 rounding) and date tolerance (±days). Enable fuzzy matching for near-matches.
👉 How to Use — 3 Simple Steps
- Upload GSTR-2B: Download from the GST Portal in Excel format. The tool auto-detects B2B, B2BA, CDNR and CDNRA sheets.
- Upload Purchase Register: Upload your Tally / ERP / Excel purchase register. The tool scans all sheets and picks the best one automatically.
- Click Reconcile: Instantly see Matched ✅, Mismatched ⚠, In GSTR-2B Only 📥, and In Books Only 📤 invoices — with one-click Excel export.
📄 Supported File Formats
📄 Purchase Register Format Guide
The tool automatically detects your column headers — no manual mapping needed. Your file must have at least the two columns marked Required. All other columns improve match accuracy.
🔒 Key Columns at a Glance
🔑 GSTIN of Supplier
15-digit GST Identification Number of your supplier. Primary match key.
Accepts: GSTIN, Supplier GSTIN, Party GSTIN, Vendor GSTIN, GST No📝 Invoice Number
Invoice number as issued by the supplier. Matched exactly and via fuzzy last-6-digit logic.
Accepts: Invoice No, Inv No, Bill No, Voucher No, Doc No, Ref No📅 Invoice Date
Date of the invoice. Used to filter by financial year and apply date-tolerance matching.
Accepts: Invoice Date, Bill Date, Date, Voucher Date, Dt💸 Tax Amounts
IGST, CGST, SGST/UTGST and Cess amounts. Required for detecting ITC value mismatches.
Accepts: IGST Amount, CGST Amount, SGST Amount, Cess, Tax Amount📋 Complete Column Reference
| Column | Type | Accepted Header Names | Notes |
|---|---|---|---|
| GSTIN of Supplier Required | Text | GSTIN, GSTIN of Supplier, Supplier GSTIN, Party GSTIN, Vendor GSTIN, GST No | Must be 15-char GSTIN. Shorter rows skipped. |
| Invoice Number Required | Text | Invoice No, Invoice Number, Inv No, Bill No, Bill Number, Document No, Voucher No, Ref No | Matched after stripping spaces and special chars. |
| Invoice Date Recommended | Date | Invoice Date, Inv Date, Bill Date, Document Date, Date, Voucher Date, Dt | Accepts DD-MM-YYYY, DD/MM/YYYY, Excel serial dates. |
| Supplier / Party Name Optional | Text | Trade Name, Legal Name, Supplier Name, Party Name, Vendor Name, Name, Ledger Name | Shown in results for identification; not used for matching. |
| Taxable Value Recommended | Number | Taxable Value, Taxable Amount, Assessable Value, Net Amount, Net Value, Sub Total | Used for value-mismatch detection. |
| IGST Amount Recommended | Number | IGST Amount, IGST Amt, IGST Paid, IGST, Integrated Tax Amount, Integrated Tax | For inter-state purchases. Leave zero for intra-state. |
| CGST Amount Recommended | Number | CGST Amount, CGST Amt, CGST Paid, CGST, Central Tax Amount, Central Tax | For intra-state purchases. Leave zero for inter-state. |
| SGST / UTGST Amount Recommended | Number | SGST Amount, SGST Amt, SGST, SGST/UTGST, State/UT Tax, UTGST | For intra-state purchases. Paired with CGST. |
| Cess Amount Optional | Number | Cess Amount, Cess Amt, Cess Paid, Cess | Only needed for Compensation Cess goods. |
| Invoice Value / Total Optional | Number | Invoice Value, Bill Value, Total Invoice, Total Amount, Total, Grand Total | Taxable + all taxes. Used for reference display. |
📄 Sample Purchase Register — Ideal Format
Your Excel should look like this (column names can vary — see accepted names above):
| GSTIN of Supplier | Supplier Name | Invoice No | Invoice Date | Taxable Value | IGST Amount | CGST Amount | SGST Amount | Invoice Value |
|---|---|---|---|---|---|---|---|---|
| 27AABCU9603R1ZX | ABC Pvt Ltd | INV/2024/001 | 05-04-2024 | 100000 | 18000 | 0 | 0 | 118000 |
| 33BBBCA1234B1ZY | XYZ Traders | XYZ/2024/55 | 12-04-2024 | 50000 | 0 | 4500 | 4500 | 59000 |
| 29CCCCZ9999Z1ZZ | PQR Supplies | PQR-2024-110 | 20-04-2024 | 20000 | 3600 | 0 | 0 | 23600 |
💡 Row 1: IGST = inter-state. Row 2: CGST+SGST = intra-state. Both match correctly with the “Match by Total Tax” option enabled.
Single or Multi-Sheet?
Both work. The tool automatically picks the sheet with the most valid invoice rows.
Date Formats Accepted
DD-MM-YYYY, DD/MM/YYYY, YYYY-MM-DD, Excel serial numbers and most standard formats.
GSTIN Must Be 15 Chars
Rows with GSTIN shorter than 10 characters are skipped automatically.
Subtotal Rows?
The tool skips rows where GSTIN is blank or invalid — subtotal rows are ignored automatically.
Tally / ERP Export
Export directly from Tally, SAP, Zoho Books or any ERP as Excel or CSV and upload directly.
Header Row Location
Headers can be in row 1, 2 or 3. The tool auto-detects — no manual adjustment needed.
📌 How to Export Purchase Register from Tally Prime
- Open Tally Prime → Gateway of Tally → Display More Reports → Account Books → Purchase Register
- Set the period to your required financial year or month
- Press Alt + E (Export) → Choose Excel (Spreadsheet) format
- Ensure columns include: GSTIN, Party Name, Voucher No, Date, Taxable Value, IGST, CGST, SGST
- Save the .xlsx file and upload it to the reconciliation tool
⚠ Common Mistakes to Avoid
- Column headers in a language other than English (e.g. Hindi headers) — use English column names
- Merging GSTIN and supplier name into one cell — keep them in separate columns
- Blank or partially filled GSTIN column — all invoice rows need a valid 15-digit GSTIN
- Header row below row 3 — keep headers within row 1–3 (the tool scans the first 10 rows)
- Password-protected or encrypted Excel file — remove protection before uploading
- Using .ods or .numbers format — convert to .xlsx, .xls or .csv first
❓ Frequently Asked Questions
What is GST ITC Reconciliation and why is it important?
GST ITC (Input Tax Credit) reconciliation matches invoices in GSTR-2B (auto-populated from supplier filings) with your Purchase Register. Under GST law, ITC can only be claimed on invoices that appear in both GSTR-2B and your books. Unreconciled mismatches lead to excess ITC claims, notices, interest and penalties.
Is this GST ITC Reconciliation Tool completely free?
Yes — 100% free, no login, no subscription. The GST ITC Reconciliation Tool processes all data in your browser. Nothing is uploaded to any server and there are no usage limits.
How do I download GSTR-2B from the GST Portal?
Log in to gst.gov.in → Returns → Auto-drafted ITC Statement → GSTR-2B → Select period → Download → Excel format. The file has multiple sheets (B2B, B2BA, CDNR, CDNRA) which the tool reads automatically.
Why is the tool showing 0 matched invoices?
Most common cause: tax classification mismatch — supplier filed as Intra-state (CGST+SGST) but you booked as Inter-state (IGST). Ensure “Match by Total Tax Only” is checked (on by default). Also verify that GSTIN and Invoice Number columns are correctly detected.
Is my financial data safe? Does it get sent to any server?
100% private. All processing happens in your browser. No invoice data, GSTIN or file content is ever sent to any server, cloud service or third party — not even ClearTaxAdvisors can see your data.
Can I export the reconciliation results to Excel?
Yes. Click Export to Excel after reconciliation to get a multi-sheet workbook: Matched ✅, Mismatched ⚠, In GSTR-2B Only 📥 (missing from books), and In Books Only 📤 (missing from GSTR-2B).
Does the tool work with Tally, SAP or Zoho Books exports?
Yes. The smart header-detection engine automatically recognises column names from Tally Prime, SAP, Zoho Books, Busy, Marg, QuickBooks and other accounting software. Export as Excel or CSV and upload directly — no manual mapping needed.
What file format should my Purchase Register be in?
Excel (.xlsx, .xls) or CSV (.csv). Must have at least GSTIN of Supplier and Invoice Number columns. For full mismatch detection also include Invoice Date, Taxable Value, IGST, CGST and SGST columns. See the Purchase Register Format Guide above for the full reference.
🔗 Helpful Links
- ▶ Launch the GST ITC Reconciliation Tool — start reconciling now
- 🏠 ClearTaxAdvisors — GST advisory, ITR filing and tax planning
- 🌎 GST Portal (gst.gov.in) — download GSTR-2B from the official portal
Start Reconciling in Seconds — It’s Free
No signup. No data upload. Works on any device with a modern browser.
▶ Open GST ITC Reconciliation Tool💡 About This Tool
The GST ITC Reconciliation Tool by ClearTaxAdvisors is a free, browser-based GSTR-2B reconciliation tool for Indian GST-registered businesses, accountants and chartered accountants. It automates the GSTR-2B vs Purchase Register reconciliation that is otherwise done manually in Excel.
Unlike paid software, this free GST reconciliation tool needs no subscription, no data upload and no installation. Whether you need monthly ITC reconciliation before GSTR-3B filing or annual reconciliation for GSTR-9, this tool handles both. Need expert GST help? Contact ClearTaxAdvisors.