GSTR-2B ↔ Tally Purchase Reconciliation

Two-pass smart matching with automatic invoice normalisation, tolerance checking, and 3-in-1 colour-coded Excel reports.

01 — Upload Source Files

Tally Purchase Daybook (.xlsx / .xls)

Drop Tally Daybook here

or click to browse from device

GSTR-2B File (.xlsx / .xls / .json)

Drop GSTR-2B file here

Excel export or GST Portal JSON

03 — Client Details (Optional)

Company / Client Name

Reconciliation Period

04 — Pass 1: Invoice No. Matching Options

Invoice Normalisation Settings

Normalise invoice numbers before matching to prevent discrepancies caused by punctuation or formatting.

Remove Special Characters

Strips / – _ # . (space) · AH/256-C → AH256C

Numeric Only Match Aggressive

Keeps digits only — strips all letters and symbols · INV/2026/45 → 202645

05 — Pass 2: Second-Pass Smart Matching

Second-Pass Amount & GSTIN Matching

Automatically re-matches entries that were unmatched in Pass 1 by GSTIN + Taxable Value. Catches typos in invoice numbers and presents them in a dedicated review sheet.

Enable Second-Pass Matching

Re-matches unbooked items by GSTIN + Taxable Value (optionally add a 3rd key column below).

Optional 3rd Matching Key (makes matching stricter)

Match Key: GSTIN + Taxable Value

06 — Amount Difference Tolerance

Paise Rounding & Discrepancy Tolerance

Amounts differing by ≤ this threshold are treated as ✓ Perfect Match.

₹

Presets:

Packages 3 colour-coded Excel files inside Recon_Period.zip.