visibility Static layout preview of Reconcile Two Files, shown with both files imported, key columns mapped, and a completed reconciliation (matched / review / unmatched results). All pages →

# Reconcile Two Files

Runs 100% locally

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

#### Left (e.g. bank feed)

description Using bank_feed_may.csv from the upload screen.

`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)

description Using ledger_may.xlsx from the upload screen.

`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 ✕
check_circle 1 reference each side — counts match
Tolerances & options
Amount tolerance
0.0200
Absolute tolerance on amount (e.g. 0.01 to absorb cent rounding).
Date tolerance (days)
1
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)
80
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

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

Coverage: 97.4% of the larger side

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

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

Matched (1,173) — cleanly reconciled

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