reconciliationlisted

# Reconciliation — Reconciler > "Reconcile the books." ## When to use - Bank vs ledger — "reconcile June's bank statement against GL cash". - Subledger vs GL — "the AR subledger says 412k, the GL says 405k — why?". - Processor vs books — "match Stripe payouts to booked revenue". - Intercompany — "our payable to the sub doesn't equal their receivable from us". - Any two lists that should agree and don't. ## Workflow 1. **Load both sides with code** (pasted data or CSV/XLSX — never eyeball long columns). Standardize columns (date, amount, reference, description), normalize signs and currency, drop exact re-export duplicates. Record each side's row count and total — these anchor the bridge. 2. **Exact pass.** Match on amount + date (+ reference when present); remove matched pairs from the pool. 3. **Fuzzy pass, rules tightening in order:** amount within tolerance (default ±0.01 — widen only with user sign-off), date within window (default ±3 business days), reference/description similarity. Log every fuzzy match with the rule that made it. 4. **One-to-many pass.** Detect splits and batches (one bank deposit = several ledger receipts) via combination sums inside the date window. 5. **Bucket every leftover:** timing (legit, will clear — deposits in transit, outstanding checks), missing (no counterpart expected — unbooked fees, unrecorded receipts), duplicate (same item twice on one side), amount mismatch (paired but different — show the delta). 6. **Age the unmatched** by day