🔒

Sign in

GST 2B vs Books Reconciliation Tool

Access is limited to authorised users. New User IDs can be created only by the admin after signing in. Accounts are stored on this computer.

GST 2B (Portal) vs ERP Books — Reconciliation Tool

Runs entirely offline in your browser. No data leaves your computer.  |  Match on GSTIN + Invoice No + Date + Tax.

Step 1  ·  Load your two files

Excel export from GST portal. Sheet with GSTIN, Invoice No, Taxable, IGST/CGST/SGST.
Export from your ERP/FCA. Sheet with GST No, Invoice No, Taxable, IGST/CGST/SGST.
Tax tolerance for “Matched”: ± Rs
Matching logic: an invoice is Matched when GSTIN + Invoice No + Invoice Date agree and the tax amounts are within tolerance. If tax differs beyond tolerance it goes to Tax Difference; if only the invoice number differs (same GSTIN, date & tax) it goes to Invoice No Difference. Unmatched book rows → In Books not in 2B; unmatched portal rows → In 2B not in Books.

Offline GST Reconciliation Tool · works with no internet · your files stay on this machine.