GST Reconciliation Tool
The GST Reconciliation Tool helps Indian businesses match their purchase register against GSTR-2B — the auto-drafted ITC statement from the GST portal — to identify matching invoices, mismatches, and ITC at risk (invoices in your books but not yet filed by suppliers).
Why GSTR-2B reconciliation matters
Since April 1, 2026, the GSTN portal blocks GSTR-3B filing if your claimed ITC exceeds what's auto-populated in GSTR-2B. If you claim ITC on an invoice that your supplier hasn't filed in GSTR-1, that ITC is at risk — and you can face:
- Rs 50-200/day late fee for delayed GSTR-3B filing
- Blocked e-way bills (your inventory gets stuck)
- DRC-01C notices for ITC mismatches
- Permanent ITC loss if the supplier files after the Section 16(4) deadline
Monthly GSTR-2B reconciliation is the only reliable way to catch these problems before filing.
What this tool does
| Step | Function |
|---|---|
| 1. Upload | Upload GSTR-2B (JSON/Excel from GST portal) + purchase register (CSV/Excel from Tally/Zoho/Busy) |
| 2. Map | Auto-detect columns, confirm mapping |
| 3. Reconcile | 4-pass matching engine: exact, fuzzy, amount-based, cross-period |
| 4. Results | Dashboard showing matched, mismatch, ITC at risk, only-in-2B |
| 5. Export | Download color-coded Excel report (6 sheets) |
| 6. Chase | Generate WhatsApp vendor chase messages (English/Hindi/Hinglish) |
100% private — your data never leaves your browser
All reconciliation runs entirely in your browser. No data is uploaded to any server. No signup required. No data stored. Complete privacy for your sensitive financial data.
Note: This is a free tool. For automated WhatsApp sending, data persistence, GSP API auto-fetch, and vendor tracking, check out our automated version (coming soon).
Formula
**4-Pass Matching Engine:** **Pass 1 — Exact Match:** GSTIN + Invoice Number + Tax Amount (+/-Rs 1) **Pass 2 — Fuzzy Match:** GSTIN + Invoice Number (Levenshtein <= 2, O->0, I->1, S->5, B->8) **Pass 3 — Amount Match:** GSTIN + Tax Amount (+/-Rs 0.50) + Date (+/-7 days) **Pass 4 — Cross-Period:** Same invoice in adjacent month's GSTR-2B **ITC at Risk** = Sum of (CGST + SGST + IGST) for all invoices in books but NOT in GSTR-2B **Tax Amount Tolerance:** +/-Rs 1.00 for exact match, +/-Rs 0.50 for amount match
Example
**Example Reconciliation:** Purchase register: 312 invoices, 95 vendors, Rs 6,50,000 total ITC GSTR-2B: 247 invoices, 89 vendors, Rs 4,70,000 total ITC **Results:** - Exact Match: 198 invoices, Rs 4,20,000 ITC (safe to claim) - Fuzzy Match: 5 invoices, Rs 12,000 ITC (verify manually) - Amount Match: 3 invoices, Rs 8,000 ITC (verify manually) - Mismatch: 12 invoices, Rs 15,000 ITC (check with vendor) - ITC at Risk: 65 invoices, Rs 1,80,000 ITC (chase vendor to file) - Only in 2B: 49 invoices, Rs 95,000 ITC (book it or investigate) **Action:** Contact 23 vendors with Rs 1,80,000 ITC at risk. Send WhatsApp reminders. Re-check GSTR-2B after vendors file.
How to Use
- Download GSTR-2B from GST portal (Returns -> GSTR-2B -> Download JSON or Excel)
- Export your purchase register from Tally/Zoho/Busy as CSV or Excel
- Upload both files using the buttons above
- Confirm the auto-detected column mapping (adjust if needed)
- Click 'Reconcile' to run the 4-pass matching engine
- Review results: Matched, Mismatch, ITC at Risk, Only in 2B
- Export to Excel for your records or CA
- Generate WhatsApp messages for vendors with ITC at risk
Frequently Asked Questions
Is my data safe?
Yes. All reconciliation happens entirely in your browser. No data is uploaded to any server. No signup required. No data stored. When you close the tab, your data is gone. This is 100% private — safer than uploading to any cloud service.
What file formats are supported?
GSTR-2B: JSON file downloaded from GST portal, or Excel export. Purchase register: CSV, Excel (.xlsx, .xls), or JSON. The tool auto-detects columns from Tally, Zoho Books, BUSY, ClearTax, and manual Excel exports.
What is ITC at risk?
ITC at risk is the total input tax credit on invoices that are in your purchase register (books) but NOT in GSTR-2B. This means your supplier has not yet filed GSTR-1 for these invoices. Under Section 16(2)(aa) of the CGST Act, you can only claim ITC on invoices that appear in GSTR-2B. If the supplier doesn't file, you lose that ITC permanently after the Section 16(4) deadline.
What happens if I claim ITC not in GSTR-2B?
Since April 1, 2026, the GSTN portal blocks GSTR-3B filing if your claimed ITC exceeds the ITC auto-populated in GSTR-2B. This means you MUST reconcile and ensure your suppliers have filed before you file GSTR-3B. Late filing attracts Rs 50-200/day penalty and can block your e-way bills.
How does the matching engine work?
The tool uses a 4-pass matching engine: Pass 1 matches exactly on GSTIN + invoice number + tax amount. Pass 2 uses fuzzy matching for invoice number typos (O->0, I->1, S->5, B->8, Levenshtein distance <= 2). Pass 3 matches on GSTIN + tax amount + date for invoices with completely different numbers. Pass 4 checks if the invoice appears in an adjacent month's GSTR-2B (cross-period match for late-filing suppliers).
Can I send WhatsApp messages automatically?
In this free tool, you can generate WhatsApp message text in English, Hindi, or Hinglish, which you copy and paste into WhatsApp manually. For automated WhatsApp sending via the official WhatsApp Business API, vendor tracking, and follow-up reminders, check out our automated version (coming soon).
Do I need to create an account?
No. This is a free tool with no signup, no login, and no data storage. Just upload your files, reconcile, and download the report. Your data never leaves your browser.
How is this different from ClearTax or GSTAgent?
This tool is free, requires no signup, and runs entirely in your browser for maximum privacy. It includes WhatsApp vendor chase message generation in 3 languages. ClearTax costs Rs 40,000+/year and is built for CA firms. GSTAgent costs Rs 999-7,500/month. Our free tool covers the core reconciliation need; our upcoming automated version will add GSP API, WhatsApp API, and vendor tracking at a fraction of the cost.