Bank Reconciliation Recompute

Recomputes a bank-to-book reconciliation from values you declare, in integer minor units. You declare the statement ending balance, the ledger ending balance, the as-of date, the outstanding deposits and outstanding payments (an id, an amount and an item date each), any other reconciling items (an id, a type, the side it adjusts, a signed effect and an item date), a stale-item age threshold in days, and optionally a proof of cash. It returns the adjusted bank balance, the adjusted book balance, the unreconciled difference, the items older than the threshold, the proof-of-cash footing and movement difference, and a verdict of reconciled, unreconciled, indeterminate or input refused. It recomputes a reconciliation from declared values. It does not read a bank statement and cannot tell whether a declared item is real. Ids and integers only: free-text labels, names and anything shaped like an account number are refused, never read.

🔒 All inputs are processed locally in your browser. No data is transmitted. Do not enter real personal data — use synthetic or anonymised inputs only.
Inputs
Keys: statement_ending_balance_minor, ledger_ending_balance_minor, as_of_date (YYYY-MM-DD), stale_threshold_days, outstanding_deposits, outstanding_payments, other_items, and optionally proof_of_cash. Ids are lowercase letters, digits, hyphen or the low-line character, up to 32 characters. Amounts are integers in minor units. Any other key is refused.
Basis and declarations
This node implements no published standard: a bank-to-book reconciliation is an arithmetic identity over declared values. Every figure is a value you declare; the node cannot tell whether a declared item is real or whether it matches a statement.
Adjusted bank balance is the statement ending balance plus the outstanding deposits, less the outstanding payments, plus the signed effect of every other item declared on the bank side. Adjusted book balance is the ledger ending balance plus the signed effect of every other item declared on the book side. The unreconciled difference is the adjusted bank balance less the adjusted book balance, and the verdict is reconciled only when it is exactly zero.
An item is stale when the as-of date less its item date is greater than the threshold in days. Stale items are listed and flagged and do not change the verdict by themselves. No item may be dated after the as-of date.
The optional proof of cash gives, for the bank column and for the book column, an opening balance, receipts, disbursements and a closing balance. Each column foots when opening plus receipts less disbursements equals closing, and its closing must equal the declared statement or ledger balance. A footing break or a closing mismatch makes the verdict unreconciled. The movement difference is the bank net movement less the book net movement, reported for review.
The verdict is indeterminate when a required fact is absent: a balance, the as-of date, the threshold, any of the three item lists, or a field of an item or proof column. A value that is present but null, of the wrong type, out of range or malformed is refused with a named code, never coerced. Amounts are limited to 1e12 minor units in absolute value and each list to 500 items.