What a reconciliationbreak looks like.
Two valuations of the same holding, a tolerance the office sets, and the three ways a break ends.
In short
- A break is two valuations of one holding — the ledger's and the custodian's — that disagree by more than the tolerance the office set.
- Almost every break is a quantity, a price or an FX rate. Check those three before suspecting the bank, and before changing anything.
- A break ends in one of three ways: the next statement drops it, a reversal and a corrected entry fix it, or it stays open and nobody can call the account agreed.
What the statement can tell you
Reconciliation quality starts with the file the custodian sends, because a statement that carries free-text lines can only be matched by a person. Two formats dominate a family office's mailbox.
SWIFT's interbank migration to ISO 20022 for cross-border payments completed in November 2025, and the ISO 20022 statement messages (camt.053 for end-of-day, camt.054 for debit and credit notifications, camt.052 for intraday) are live. Corporates on SWIFT's SCORE service can still send and receive MT940 and MT942, so in practice both arrive, from different banks, in the same week.
| MT940 | camt.053 | |
|---|---|---|
| Standard | SWIFT MT, still supported for corporates on SCORE | ISO 20022 bank-to-customer statement |
| Balances | Opening and closing balance per statement | Several typed balances, including available and forward |
| Entry detail | Structured fields with a free-text information line | Structured entries with typed parties, amounts and dates |
| Remittance | Often free text | Structured remittance information |
| What it means for matching | Readable, but exceptions land in a person's queue | More fields to match on, so fewer exceptions |
This is why a ledger has to read both rather than pick a side: the choice is the custodian's, not the office's, and it changes mid-year when a bank migrates.
Anatomy of a break
Whatever produced it, a break has the same anatomy. If any of these six is missing from the screen, the office cannot close the break without leaving the system.
| Field | What it must carry |
|---|---|
| Account | The entity, the institution and the account the statement covers |
| Statement date | The date of the statement used, not the date the comparison ran |
| Ledger figure | The value reached from quantities, prices and FX rates held in the ledger |
| Bank figure | The value in the custodian's own statement, in the custodian's currency |
| Difference | The two subtracted, measured against the tolerance |
| Holdings behind it | The positions that make up the account, so the break traces to one line rather than a total |
Raised, or not raised
The comparison produces a number; the tolerance turns it into a decision. Three endings follow, and each has to leave a record.
Three causes worth checking first
In a working office the bank is rarely wrong. The difference is usually in one of three inputs, and they can be told apart by what the break looks like.
| Cause | What you see | What closes it |
|---|---|---|
| Quantity | Units differ and the value moves with them; often a trade the bank booked and the office has not | The missing entry, or a reversal and corrected entry |
| Price | Units agree, value differs; the statement prices at a different close or from a different source | The right price for the right date, or a documented source change |
| FX rate | One currency's holdings break while others agree; the rate is from another day | The statement date's rate, with the source recorded |
| Corporate action | Units and price per unit move in opposite directions; the value survives a split | Restating the quantity before the comparison means anything |
| Late booking | A movement in both cash and the holding, often across two statements | Matching both halves; the unmatched half waits in a clearing account |
Tolerance is a decision
A tolerance is not rounding. It is the statement that differences below a certain size are not worth a person's attention, and it has to be set by the office, written down, and reviewed — not inherited from a vendor's default.
Two rules keep it honest. The tolerance applies to the decision to raise, never to the comparison: every account is still compared. And a difference inside tolerance is still recorded, so a pattern of small differences in one account is visible before it becomes a large one.
The log is the fourth account
A break that closes leaves no trace on the balance sheet, which is exactly why the record matters. For each of the three endings the log has to show:
- Closed itself: the account and statement date, old figure, new figure, and the change between them.
- Corrected by the office: the reversal, the corrected entry, who posted both, and the break they were posted against.
- Still open: when it was raised, what was checked, who looked, and that it was open at the period close.
An unchecked holding belongs in the same record, shown as a gap rather than carried at zero or at the last price anyone had. A zero is a figure and is wrong in a way nobody can see; a gap is visible.
What to do in the first hour
- Read the statement line before the totals: quantity, price, currency, value date.
- Confirm which statement the comparison used, and that it is the newest one received.
- Check quantity, then price, then rate — in that order, because that is the order of frequency.
- Look for a corporate action or a trade the bank booked after the statement date.
- If the office's figure was wrong, reverse and re-post; do not edit the original.
- If it survives the next statement, escalate to the custodian and record the conversation against the break.
Sources
- SWIFT, ISO 20022: Corporates — camt.052/053/054 cash reporting; the November 2025 migration deadline for CBPR+ payments; SCORE users may continue to exchange MT101, MT940 and MT942. Read 13 November 2026.
- ISO 20022 message definitions: camt.053 (bank-to-customer statement), camt.054 (debit/credit notification), camt.052 (intraday report). Current editions.
The tolerance in this note is the office's own setting. No fixed percentage is recommended here: a figure that suits a single-currency securities book does not suit a property portfolio.
Bring your questionto a demo.
If this is the question your office is working on now, we can answer it in a demo built around your own entities and banks. You don't need to share any figures.