GSTR 2B Reconciliation Utility

TOTAL.INV

0.00

2B 0 · BOOKS 0 · Books vs 2B — ITC view

MATCHED

0% reconciled

UNMATCHED

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%

OFF 0%

UNM 0%

TYPE

COUNT

% OF TOTAL

VALUE (₹)

EXACT

0.0%

CLEANED

0.0%

FUZZY

0.0%

MANUAL

0.0%

2B OFFSET (NET NIL)

0.0%

UNMATCHED

0.0%

TOTAL

100%

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

DOC	GSTIN	SUPPLIER	INV.NO	TAXABLE	TAX

ACTION.REQ — UNMATCHED IN BOOKS (TOP 10) EXCESS.ITC.RISK

DOC	GSTIN	SUPPLIER	INV.NO	TAXABLE	TAX

CREDIT.NOTES (CN)

— · ITC reverses

DEBIT.NOTES (DN)

— · ITC increases

2B OFFSET (NET NIL) CN ⇄ INV

0 pairs

0.00 Tax Offset · Nil ITC in books

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

↓ DRAG & DROP GSTR 2B / 2A / GSTR-9 (TABLE 8A) EXCEL / JSON / CSV FILES · MULTI-FILE & MULTI-SHEET SUPPORTED

UNMATCHED.IN.2B

AMOUNT.MISMATCH

NEWLY.ADDED

↓ DRAG & DROP PURCHASE REGISTER CSV FILES

UNMATCHED.IN.BOOKS

AMOUNT.MISMATCH

NEWLY.ADDED

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

2B.OFFSET (NET NIL)

ONLY.IN.BOOKS

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

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

2B INTRA-PORTAL OFFSET — CN ⇄ INV (NEITHER IN BOOKS · NET NIL ITC) SAME GSTIN · CANCELS OUT

	TYPE	GSTIN	2B INVOICE	2B CREDIT NOTE	SUPPLIER	INV TAXABLE	CN TAXABLE	INV TAX	CN TAX	NET ITC	ACTION
Click "RUN 2B OFFSET MATCH" or "RUN RECONCILIATION" to find self-offsetting CN & INV pairs in 2B.

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

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

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
GSTIN	SUPPLIER	2B	BOOKS	2B	BOOKS	2B	BOOKS	2B	BOOKS	Δ DIFF	MATCH %	EXCEPT.	STATUS	ACTIONS

MATCHING.SETTINGS3-PASS ENGINE

Partial Match Threshold (0.0 to 1.0) Higher value = stricter match (default: 0.80 = 80% similarity). Taxable Value Tolerance (₹) Differences below this are shown in amber (not red). Default: ₹1. Tax Tolerance (₹) Per-tax-head tolerance (IGST / CGST / SGST / Cess). Default: ₹1. Books CDNR follows own-view (supplier's CN = my DN) Accounting identity: supplier's sale = my purchase, so supplier's Credit Note = my Debit Note (and vice versa). When ON, a books row labelled "DN" is reconciled against the matching 2B "CN" and vice versa. Turn OFF only if your books column copies the supplier's labels verbatim. Auto-propagate RCM from GSTR-2B to Books If all GSTR-2B rows for a supplier's GSTIN are flagged as Reverse Charge (RCM = Yes), auto-flag all of their Books rows for that GSTIN as RCM = Yes during reconciliation. AI Match: Ignore taxes for RCM rows If enabled, AI and similarity matches for RCM rows will only compare taxable values and ignore taxes, since books sometimes record RCM rows with zero tax.

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.

ENABLE.AI.MATCHING Suggests matches when GSTIN or invoice number differs. Default: ON. AI.CONFIDENCE.THRESHOLD (0.0–1.0) Suggestions below this confidence are hidden. Default: 0.50. WEIGHT.GSTIN.SIMILARITY Weight on matching the GSTIN itself. Default: 0.30. WEIGHT.INVOICE.NO (DIGITS.ONLY) Primary signal: digit-only invoice number similarity. Default: 0.35. WEIGHT.AMOUNT.SIMILARITY Fallback when invoice differs. Default: 0.20. WEIGHT.DATE.PROXIMITY Fallback when invoice differs. Weights auto-normalized. Default: 0.15.

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

FROM (YOUR EMAIL — OPTIONAL):

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

Paste some data above to see a preview…

Pick	Confidence	Match Basis	GSTIN	Supplier	Invoice No	Date	Doc	Taxable	Tax	Total
No candidates found.

Reset everything?

This will permanently delete all 2B data, books data, results and saved links from this browser. This action cannot be undone.

Type RESET to confirm:

Auto-download GSTR 2A / 2B from Portal

Recommended: Manual Portal Download → Drag & Drop (fastest)

Advanced: Python helper script (local)

GSP API (paid)

Email Reconciliation to Supplier

WhatsApp Reconciliation to Supplier

Paste from Excel →

GSTIN Detail

Quick Similarity Match