RECONCILE v3.0
FY: · PERIOD: · GSTIN: NO.DATA
LAST.RUN: —
TOTAL.INV
0.00
G1 0 · BOOKS 0 · Books vs GSTR 1 — Liability view
MATCHED
0
0% reconciled
UNMATCHED
0
Run reconciliation to see the delta
OUT.TAX
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 — G1 vs BOOKS (₹) —
HEAD
GSTR 1
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 G1 (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 (GSTR1) INV (BOOKS) TAX.Δ TOTAL.Δ STATUS
⌕
ENTRIES:0
↓ DRAG & DROP GSTR 1 JSON / CSV FILES · MULTI-FILE SUPPORTED
UNMATCHED.IN.GSTR1
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 GSTR 1 · Σ OF DIFF COLUMN NO.DATA
BOOKS
0.00
TAXABLE + ALL TAXES
Δ DIFFERENCE (BOOKS − PORTAL)
0.00
Σ OF TOTAL.Δ COLUMN
GSTR 1 (PORTAL)
0.00
WHAT SUPPLIERS FILED
TOTAL.MATCHED—
EXACT—
CLEANED—
PARTIAL—
Δ VALUE.CASES—
AVG.CONF—
EXACT / ONLY.IN.G1
CLEANED
PARTIAL
MANUAL
ONLY.IN.BOOKS
⌕
AI.SUGGESTIONS:0
AI.CONFIDENCE — GSTIN + INVOICE# PRIMARY · AMOUNT + DATE FALLBACK SUPPLIER.NAME IGNORED
CONF. GSTIN INV (GSTR1) INV (BOOKS) SUP (GSTR1) SUP (BOOKS) TAXABLE (GSTR1) TAXABLE (BOOKS) TAX (GSTR1) TAX (BOOKS) ACTION
⌕
CROSS.DOC.SUGGESTIONS:0
AI.CONFIDENCE — CROSS-DOCTYPE MATCH SUPPLIER & AMOUNT FOCUS
CONF. GSTIN INV (GSTR1) INV (BOOKS) SUP (GSTR1) SUP (BOOKS) TAXABLE (GSTR1) TAXABLE (BOOKS) TAX (GSTR1) TAX (BOOKS) ACTION
GSTR1 UNM:0
BOOKS UNM:0
LINKS:0
UNMATCHED IN GSTR 1
Click a row on the left
⇄
Click a row on the right
UNMATCHED IN PURCHASE REGISTER
LINKED.PAIRS — PENDING APPLY
GSTIN INV (GSTR1) INV (BOOKS) GSTR1 TAX BOOKS TAX GSTR1 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
G1 BOOKS G1 BOOKS G1 BOOKS G1 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 1 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