Cash reconciliation is the process of comparing cash balances reported by a custodian or bank against the cash balances recorded in an internal accounting system. It confirms that the money you believe you have is actually there — and that every movement in and out is accounted for.
Why cash reconciliation matters
Cash is the most liquid and most vulnerable asset class. Unlike securities — which are registered and difficult to misappropriate without detection — cash moves quickly, settles intraday, and can be obscured by high transaction volumes. Cash reconciliation is the primary control that catches unauthorised movements, missed settlements, and booking errors before they compound.
For family offices managing multiple accounts across custodians, banks, and prime brokers, cash reconciliation also provides the daily liquidity picture. If cash balances are wrong, the investment team cannot reliably determine how much is available to deploy — leading to either missed opportunities or overdraft risk.
What cash reconciliation covers
A complete cash reconciliation verifies several components:
| Component | What is compared | Common break causes |
|---|---|---|
| Opening balance | Prior day's closing balance vs. today's opening | Late-posted transactions, backdated entries |
| Trade settlements | Expected settlements vs. actual cash movements | Failed trades, partial fills, netting differences |
| Income receipts | Expected dividends/coupons vs. received amounts | Withholding tax differences, timing, missed accruals |
| Fees and expenses | Accrued fees vs. actual debits | Timing of fee sweeps, unexpected charges |
| Transfers | Internal transfer instructions vs. actual movements | Pending wires, rejected transfers, FX settlement timing |
| Closing balance | Calculated balance vs. custodian/bank statement | Cumulative effect of all unresolved items above |
The cash reconciliation process
The process follows a predictable sequence, whether performed manually or by an agent:
- Data collection. Retrieve the bank or custodian's cash statement (via SWIFT MT940/MT950, file feed, or API) and the internal ledger's cash activity report for the same period.
- Transaction matching. Match individual cash movements between the two sources. Each debit and credit should have a corresponding entry. Matched items are marked as reconciled.
- Balance comparison. Compare the closing balance per the external statement against the closing balance per the internal ledger. If all transactions match, the balances should agree.
- Break identification. Unmatched transactions and balance differences are flagged as breaks. Each break is categorised: missing from internal records, missing from bank statement, amount mismatch, or timing difference.
- Investigation. Determine the root cause of each break. Is it a settlement that has not yet posted? A fee that was not accrued? An unauthorised movement?
- Resolution. Book the missing entry, reverse the error, or document the timing difference with an expected resolution date.
- Sign-off. Once all material breaks are resolved, the cash reconciliation is approved for that date.
Cash reconciliation vs. bank reconciliation
The terms are often used interchangeably, but there is a distinction. Bank reconciliation specifically refers to reconciling a bank account statement against an internal cash book — it is the most common form of cash reconciliation. Cash reconciliation is broader: it includes bank accounts, custodian cash accounts, money market fund positions treated as cash, margin accounts, and FX settlement accounts.
For family offices with assets across multiple custodians, the cash reconciliation scope extends well beyond a single bank statement. It encompasses every account where cash sits or flows through.
Multi-currency cash reconciliation
Family offices with international portfolios hold cash in multiple currencies. This adds complexity:
- FX trades settle on different cycles (typically T+2), creating timing breaks between when a trade is booked and when the cash actually moves.
- Custodians may report in local currency while the internal system reports in base currency, requiring consistent FX rate application.
- Withholding tax on foreign income may be deducted at source in local currency, creating small rounding differences when converted.
- Sweep accounts and cash pooling structures can obscure the true location of funds.
Common causes of cash breaks
| Cause | Description | Typical resolution |
|---|---|---|
| Failed settlements | Trade expected to settle but cash did not move | Confirm with broker; rebook settlement date |
| Unbooked income | Dividend or coupon received but not recorded internally | Book the income entry with correct ex-date |
| Fee timing | Management or custody fee debited on a different date than accrued | Adjust accrual timing or book the actual debit |
| FX settlement lag | Currency conversion booked internally but not yet settled | Monitor until value date; escalate if overdue |
| Netting differences | Custodian nets multiple settlements; internal system books gross | Apply netting logic or reconcile at net level |
| Unauthorised movements | Cash movement with no corresponding internal instruction | Escalate immediately; investigate with custodian |
Where agents fit in cash reconciliation
Transaction matching is well-handled by existing reconciliation software. The labour cost sits in investigating breaks — particularly in multi-currency, multi-custodian environments where a single break might require checking settlement status, FX rates, fee schedules, and corporate action calendars across multiple systems.
An agent can trace a cash break through its likely causes: check if there is a pending settlement that explains the difference, verify whether an income payment matches the expected amount after withholding tax, or flag an unexplained movement for immediate human review. Every investigation step is logged with full reasoning.
For family offices that need this handled as a managed service, our family office reconciliation service includes daily cash reconciliation across all custodians and currencies.
Key terms
- Cash book
- The internal record of all cash transactions and balances for an account.
- Bank statement
- The external record from the bank or custodian showing actual cash movements and balances.
- Reconciling item
- A transaction that appears in one source but not the other, explaining a balance difference.
- Stale item
- A reconciling item that has remained unresolved beyond its expected resolution date.
- Cash break
- A difference between internal and external cash balances that requires investigation.