RECONCILE v3.0
FY: · PERIOD: · GSTIN: NO.DATA
LAST.RUN:
TOTAL.INV
0.00
2B 0 · BOOKS 0 · Books vs 2B — ITC view
MATCHED
0
0% reconciled
UNMATCHED
0
Run reconciliation to see the delta
ITC.AVAIL
0.00
TAXABLE 0.00 · TAX 0.00
MATCH.DISTRIBUTION — 3-PASS ENGINE AUTO.REFRESH [OFF]
EXACT 0%
CLN 0%
FZ 0%
MNL 0%
UNM 0%
TYPE
COUNT
% OF TOTAL
VALUE (₹)
EXACT
0
0.0%
0
CLEANED
0
0.0%
0
FUZZY
0
0.0%
0
MANUAL
0
0.0%
0
UNMATCHED
0
0.0%
0
TOTAL
0
100%
0
VALUE.DELTA — 2B vs BOOKS (₹)
HEAD
GSTR 2B
BOOKS
Δ DIFF
UNMATCHED.QUEUE — TOP 5 BY VALUE OPEN.ALL [0] →
#
GSTIN
SUPPLIER
INVOICE.NO
DATE
TAXABLE
TAX
TOTAL
FLAG
No data yet — run reconciliation to populate the queue.
VALUE.SUMMARY — GRAND RECONCILIATION (REGULAR · RCM · TOTAL)
CATEGORY TAXABLE VALUE IGST CGST SGST CESS TOTAL TAX TOTAL INVOICE VALUE
ACTION.REQ — UNMATCHED IN 2B (TOP 10) ITC.AT.RISK
DOCGSTINSUPPLIERINV.NOTAXABLETAX
ACTION.REQ — UNMATCHED IN BOOKS (TOP 10) EXCESS.ITC.RISK
DOCGSTINSUPPLIERINV.NOTAXABLETAX
CREDIT.NOTES (CN)
0
— · ITC reverses
DEBIT.NOTES (DN)
0
— · ITC increases
NET.ITC (TAX)
0.00
Matched + CN reversal pending
RECENT.RESULTS — TOP 15 VIEW.ALL →
MATCH DOC GSTIN SUPPLIER INV (2B) INV (BOOKS) TAX.Δ TOTAL.Δ STATUS
ENTRIES:0
↓ DRAG & DROP GSTR 2B JSON / CSV FILES · MULTI-FILE SUPPORTED
UNMATCHED.IN.2B
AMOUNT.MISMATCH
NEWLY.ADDED
ENTRIES:0
↓ DRAG & DROP PURCHASE REGISTER CSV FILES
UNMATCHED.IN.BOOKS
AMOUNT.MISMATCH
NEWLY.ADDED
ROWS:0
PICK A COLUMN TO FILTER:
RECONCILIATION.TOTALS — BOOKS vs 2B · Σ OF DIFF COLUMN NO.DATA
BOOKS
0.00
TAXABLE + ALL TAXES
Δ DIFFERENCE (BOOKS − PORTAL)
0.00
Σ OF TOTAL.Δ COLUMN
GSTR 2B (PORTAL)
0.00
WHAT SUPPLIERS FILED
TOTAL.MATCHED
EXACT
CLEANED
PARTIAL
Δ VALUE.CASES
AVG.CONF
EXACT / ONLY.IN.2B
CLEANED
PARTIAL
MANUAL
ONLY.IN.BOOKS
AI.SUGGESTIONS:0
AI.CONFIDENCE — GSTIN + INVOICE# PRIMARY · AMOUNT + DATE FALLBACK SUPPLIER.NAME IGNORED
CONF. GSTIN INV (2B) INV (BOOKS) SUP (2B) SUP (BOOKS) TAXABLE (2B) TAXABLE (BOOKS) TAX (2B) TAX (BOOKS) ACTION
CROSS.DOC.SUGGESTIONS:0
AI.CONFIDENCE — CROSS-DOCTYPE MATCH SUPPLIER & AMOUNT FOCUS
CONF. GSTIN INV (2B) INV (BOOKS) SUP (2B) SUP (BOOKS) TAXABLE (2B) TAXABLE (BOOKS) TAX (2B) TAX (BOOKS) ACTION
RCM.SUGGESTIONS:0
AI.CONFIDENCE — RCM MATCH ONLY TAXABLE VALUE COMPARISON ONLY
CONF. GSTIN INV (2B) INV (BOOKS) SUP (2B) SUP (BOOKS) TAXABLE (2B) TAXABLE (BOOKS) TAX (2B) TAX (BOOKS) ACTION
2B UNM:0
BOOKS UNM:0
LINKS:0
UNMATCHED IN GSTR 2B
Click a row on the left
Click a row on the right
UNMATCHED IN PURCHASE REGISTER
LINKED.PAIRS — PENDING APPLY
GSTIN INV (2B) INV (BOOKS) 2B TAX BOOKS TAX 2B TOTAL BOOKS TOTAL Δ DIFF ACTION
SUPPLIERS:0
GSTIN-WISE RECONCILIATION SUMMARY EXCEPTIONS SORT.TOP

Suppliers with exceptions are sorted to the top. Eye icon ▣ drills into invoices · Mail icon ✉ drafts a mismatch notification.

GSTIN SUPPLIER COUNT TAXABLE (₹) TAX (₹) TOTAL (₹) Δ DIFF MATCH % EXCEPT. STATUS ACTIONS
2B BOOKS 2B BOOKS 2B BOOKS 2B BOOKS
MATCHING.SETTINGS3-PASS ENGINE
FY.PATTERNS — STRIPPED DURING CLEANED.MATCHONE PER LINE
AI.CONFIDENCE — MATCHING POLICYSUPPLIER.NAME IGNORED

Primary: GSTIN + invoice# (digits only). Fallback when invoices don't line up: amount + date.

EMAIL.TEMPLATE — SUPPLIER NOTIFICATIONS{{supplier}} · {{gstin}} · {{period}} · {{table}}
WHATSAPP.TEMPLATE — MOBILE NOTIFICATIONS{{supplier}} · {{gstin}} · {{period}} · {{table}}

Note: WhatsApp does not support tables. Use emojis for a visually readable layout.

SAVED.RECONCILIATIONS
DATA.MANAGEMENT
ABOUT — RECONCILE v3.0

Professional GSTR 2B Reconciliation Utility with Excel-like UI.

  • Exact match on GSTIN + Invoice Number
  • Cleaned match (strips FY patterns & special characters)
  • Partial/Fuzzy match using Levenshtein similarity
  • Manual "Match the Following" linking
  • JSON import from GST Portal
  • CSV import/export
  • LocalStorage persistence
  • Sort, filter, search