Finance & GST · Free tool
GSTR-2B Reconciliation Tool
Upload your GSTR-2B and purchase register as CSV to get a matched / only-in-2B / only-in-PR / amount-mismatch report in seconds. Excel export included. Nothing is uploaded to a server.
What this tool does
GSTR-2B reconciliation is the monthly process of matching every invoice GSTN auto-drafts into your ITC statement against your own purchase register. This tool runs the match locally on two CSVs (or Excel files) and gives you a four-bucket report: matched, amount mismatch, only in 2B, only in PR.
Required CSV columns
Headers are case-insensitive; common synonyms map automatically.
| Field | Required | Accepts |
|---|---|---|
| GSTIN | Yes | gstin, supplier_gstin, gstin/uin |
| Invoice number | Yes | invoice, invoice_no, invoice_number |
| Invoice date | Yes | invoice_date, date |
| Taxable value | Yes | taxable_value, taxable, taxable amount |
| CGST / SGST / IGST | Optional | cgst, sgst, igst |
How matching works
Records are joined on GSTIN + Invoice Number after normalising (uppercased, whitespace stripped). When both records exist:
- Taxable value differs by ≤ tolerance → Matched
- Taxable value differs by > tolerance → Amount Mismatch
Otherwise the record goes to the side-only bucket (Only in 2B or Only in PR) for manual review.
Automate this monthly
Running this once a month is fine. Running it daily on Tally vs the latest 2B is what catches issues before the 19th when GSTR-3B is due. FireAI automates the reconciliation and pings WhatsApp only when a mismatch appears.
Get this calculator running on your live data
Try FireAI free — go from one-off calculations to a live dashboard updated every hour.
Frequently asked questions
Related free tools
Finance & GST
GST Calculator CGST, SGST & IGST (Free)
Free GST calculator for India. Add or remove GST at 0%, 5%, 12%, 18%, 28% split CGST/SGST for intra-state, IGST for inter-state. Runs in your browser.
Finance & GST
GST Late Fee & Interest Calculator
Compute GST late fee and interest for GSTR-1, 3B, 4, 9 and 9C. Per-day fee, turnover-based caps, 18% / 24% interest. CGST + SGST split. Free, browser-only.
Finance & GST
Tally XML to Excel Converter
Convert Tally XML exports to Excel (.xlsx) in your browser. Daybook, ledger, stock summary with voucher-level rows; no upload to any server.