GSTR-2B ↔ Tally Daybook Reconciliation Overview
The GST2B Recon tool automatically compares your Tally Purchase Daybook with your official GSTR-2B statement (downloaded from the GST portal in Excel or JSON format) and produces a comprehensive 3-in-1 colour-coded audit package.
Two-Pass Smart Matching Engine
Pass 1: Primary Match (GSTIN + Invoice Number)
In the first pass, VinTax pairs invoices having the identical GSTIN and Invoice Number. It compares the Invoice Value, Taxable Value, CGST, SGST, and IGST amounts against your configured Tolerance (default ₹0.50).
- ✓ Perfect Match (Green): Both invoice number and tax/invoice amounts match within the tolerance threshold.
- ⚠ Amount Difference (Amber): The invoice number matches, but there is a discrepancy in Taxable Value or GST amounts (e.g. rate mismatches or rounding differences).
Pass 2: Second-Pass Smart Matching (GSTIN + Taxable Value)
Accountants frequently face invoice number discrepancies (e.g., supplier billed as INV/256 while entered in Tally as 256 or PB-256).
Pass 2 takes all remaining unbooked invoices and matches them by GSTIN + Taxable Value (+ optional 3rd key like Date, Gross Value, or IGST).
- ≈ Soft Matched (Blue): Displays both original invoice numbers side-by-side in a dedicated sheet for quick verification before you claim ITC.
Residual Audit Categorisation
- ✗ Missing in Tally (ITC Risk / Red): Invoices present in GSTR-2B on the GST Portal but completely missing from your books. Take action to claim pending ITC!
- ◈ Extra in Tally (Purple): Invoices booked in your Tally purchases but not uploaded by the vendor in GSTR-2B. Follow up with the supplier to file their GSTR-1!
3-in-1 Downloadable Excel Reports
VinTax generates a single compressed ZIP file containing three dedicated Excel workbooks:
-
Reconciliation_Report_[Period].xlsx:
Includes the executive Summary tab with KPI tiles and amount totals, Matched Invoices, Soft Matched (Pass 2), Missing in Tally, Extra in Tally, and All GSTR-2B Invoices.
-
Daybook_Status_[Period].xlsx:
Your exact Tally Daybook enriched with a new
STATUS column (✓ MATCHED, ⚠ AMT DIFF, ≈ SOFT MATCH, NOT IN 2B).
-
GSTR2B_Status_[Period].xlsx:
Your exact GSTR-2B sheet enriched with a new
STATUS column (✓ MATCHED, ⚠ AMT DIFF, ≈ SOFT MATCH, NOT IN TALLY).
Best Practices & Tips
- Remove Special Characters: Turn this ON if your vouchers have variable slashes or hyphens (e.g.
2026/04/12 vs 2026-04-12).
- Numeric Only Matching: Turn this ON for aggressive matching if your tally operator types only the digits of the invoice number.
- Tolerance: Default ₹0.50 is ideal for rounding differences. Set to ₹0.00 for strict penny-to-penny matching.