Reconcile Two Files

Compare two lists of transactions (e.g. bank vs. ledger) and flag what doesn't match.

Left (e.g. bank feed)

upload_file Drag and drop file here CSV, TSV, XLSX, XLS

bank_feed_may.csv 214 KB

bank_feed_may.csv — 1,204 rows, 4 columns

Preview left (e.g. bank feed)

posted_date	description	amount	ref
2026-05-01	ACME SUPPLIES	-1240.00	CHK1041
2026-05-02	PAYROLL RUN	-8800.00	ACH5520
2026-05-03	CLIENT GLOBEX	5200.00	DEP0090
2026-05-04	UTILITY CO	-318.42	CHK1042

Right (e.g. ledger)

upload_file Drag and drop file here CSV, TSV, XLSX, XLS

ledger_may.xlsx 96 KB

ledger_may.xlsx — 1,198 rows, 5 columns

Preview right (e.g. ledger)

txn_date	memo	value	invoice_no	account
2026-05-01	Acme Supplies Inc	-1240.00	INV-1041	5000
2026-05-02	Monthly payroll	-8800.00	INV-5520	6000
2026-05-03	Globex retainer	5200.00	INV-0090	4000
2026-05-04	City Utilities	-318.40	INV-1042	6100

Match settings

Left columns

Date column (optional)

posted_date

Description column (optional)

description

Amount column

amount

Reference columns (optional, e.g. check / invoice no.)

ref ✕

Right columns

Date column (optional)

txn_date

Description column (optional)

memo

Amount column

value

Reference columns (must match left count)

invoice_no ✕

Tolerances & options

Amount tolerance

0.0200

Absolute tolerance on amount (e.g. 0.01 to absorb cent rounding).

Date tolerance (days)

Allow N calendar days of drift between posting dates.

Invert right amount sign

Use when one side records debits as positive and the other as negative.

Description similarity boost (0 disables)

When both sides have a description column set, accept matches with this minimum fuzzy similarity even if amount/date are merely within tolerance. Lower = more permissive.

Results

Matched

1,173

Review

Unmatched left

Unmatched right

Coverage: 97.4% of the larger side

Matched (1,173) Review (9) Unmatched left (22) Unmatched right (16)

Preview of first 25 of 1,173 rows — download the CSV below for the full set.

left_posted_date	left_description	left_amount	right_txn_date	right_memo	right_value	amount_diff
2026-05-01	ACME SUPPLIES	-1240.00	2026-05-01	Acme Supplies Inc	-1240.00	0.00
2026-05-02	PAYROLL RUN	-8800.00	2026-05-02	Monthly payroll	-8800.00	0.00
2026-05-03	CLIENT GLOBEX	5200.00	2026-05-03	Globex retainer	5200.00	0.00
2026-05-04	UTILITY CO	-318.42	2026-05-04	City Utilities	-318.40	0.02
2026-05-06	OFFICE DEPOT	-89.15	2026-05-07	Office supplies	-89.15	0.00

Review (9) — ambiguous candidates

Pairs flagged because the algorithm couldn't pick a single best match (e.g. multiple equally-good candidates). Use the left/right indices to disambiguate manually.

left_idx	left_amount	right_idx	right_value	candidates
118	-450.00	121, 209	-450.00	2 equal
203	1000.00	198, 244	1000.00	2 equal

Unmatched left (22) — only in bank_feed_may.csv

Preview of first 25 of 22 rows.

posted_date	description	amount	ref
2026-05-09	BANK FEE	-12.00	FEE0001
2026-05-14	ATM WITHDRAWAL	-200.00	ATM7781

Unmatched right (16) — only in ledger_may.xlsx

Preview of first 25 of 16 rows.

txn_date	memo	value	invoice_no	account
2026-05-11	Accrued interest	37.50	INV-9001	7000
2026-05-22	Depreciation	-410.00	INV-9044	8000