GSTR-2B vs Purchase Register Fuzzy Reconciler
Drop your GSTR-2B JSON/ZIP and Tally/Zoho Excel Purchase Register to reconcile invoices with string normalization and Rule 37A reversal checks.
Upload GSTR-2B (.zip or .json)
Downloaded from the GST Portal. Both raw JSON or ZIP supported.
Upload Purchase Register (.xlsx or .csv)
Exported from Tally Prime, Zoho Books, Busy, SAP, or QuickBooks.
From client purchase ledger
4 Matched in 2B (Safe for 3B)
Vendor hasn't filed GSTR-1
Missing in client books
100% Exact match. Eligible for ITC claim in GSTR-3B.
Fuzzy Match: Invoice normalized (hyphen vs slash). Amounts match.
Ineligible u/s 17(5) / POS restriction in 2B Table 4.
MISSING IN GSTR-2B! Vendor has not filed GSTR-1. Do not claim ITC or risk Rule 37A reversal.
Fuzzy Match: Leading zero stripped (881 vs 0881).
UNCLAIMED ITC IN 2B! Vendor filed return, but invoice is missing in client Purchase Register.
How the Fuzzy Engine Reconciles
1. Invoice Normalization & Date Tolerance
Strips punctuation, hyphens, slashes (/, -), leading zeroes (0012 → 12), with a 30-day date tolerance and ₹2–₹5 tax tolerance to match disparate accounting ERP notations.
2. Statutory Rule 37A Guard
Invoices present in books but absent in GSTR-2B mean the supplier hasn't filed GSTR-1. Claiming this ITC without reversal by 30th November triggers penal interest u/s 50.
3. Unclaimed ITC Discovery
Flags valid tax credits available in government records that client accountants failed to enter into their purchase register, saving real tax money.
Supercharge this with Turia Practice
Turia Practice automatically downloads GSTR-2B via GSP API and reconciles with your clients' Tally ledgers every month on autopilot.
Statutory & Compliance Disclaimer
This tool is an automated calculation, formatting, and compliance aid provided for informational purposes only. It does not constitute formal legal, taxation, or professional auditing advice. Calculations, citations, and draft documents must be independently verified by a qualified Chartered Accountant (CA) or Company Secretary (CS) against statutory provisions and applicable ICAI/ICSI guidelines before execution or certification.