Bank Reconciliation

Reconciles a bank statement against the GL cash detail for one account and one period. Best run in Cowork — two files in, workbook out.

Required inputs

• Bank statement — CSV, XLSX, or PDF. Must contain date, description, amount (with sign), and ideally a reference/check number.
• GL cash detail — CSV or XLSX. Must contain posting date, description, debit, credit (or signed amount), and entry/reference number.
• Period — the close period being reconciled (e.g., 2026-04).

If any of these is missing, output what's missing instead of guessing.

Workflow

1. Load and validate. Open both files. Confirm period and currency match. Confirm the bank account in the statement matches the GL account in the cash detail (compare to firm-config/references/chart-of-accounts.csv).