Most offices check their consolidated report from the top. The totals tie. The positions match the custodians. The report is right about everything it contains.
That check cannot find what the report leaves out. This note is about the check that can.
How many accounts there are
The scale is the reason this happens. Three recent surveys, each with its own sample:
- A third of offices manage 50 or more bank accounts. Of offices over $1 billion, 32% have 100 or more bank accounts and 39% have 100 or more investment accounts. Offices run two wealth platforms on average (BofA Private Bank Private Bank, 2025 Family Office Study, n=335).
- About four in ten offices use third-party consolidated reporting software (Citi Private Bank, 2025 Global Family Office Report, n=346).
- Balance-sheet aggregation is wholly insourced by 54% of offices (J.P. Morgan Private Bank, 2026 Global Family Office Report, n=333).
So most offices assemble the family’s balance sheet themselves, and a third do it across fifty or more bank accounts. None of these surveys measures how many accounts sit outside the report. That figure is specific to each office, and it can be counted.
Why accounts drift out of the report
An account rarely leaves the report. It is usually never added. Three ways that happens.
Counsel creates an entity for a transaction. An LLC to hold a property, a trust for an estate plan, a holding company for a deal. The documents are signed, an account is opened, and the work is done. Nobody tells the person who sets the reporting scope, because nobody thought of it as reporting.
The register is kept by one person. The list of entities lives in one workbook or one memory. When that person is away, or leaves, the list stops growing while the family’s structure does not.
Two platforms each hold part of the picture. An account on one platform and its entity on the other can each look complete from inside its own system. The gap is between them.
The accounts that drift tend to be the quiet ones: dormant LLCs, grantor trusts set up for estate planning, escrow and holding-company accounts, foundation accounts, and intercompany balances. They move rarely, so nothing prompts anyone to look.
The test: read from the statements upward
It takes one month of documents. You can run it yourself.
- Gather every statement for one month. Every bank and every custodian, for every account, from the institutions themselves, not from the report. Count them.
- Trace each account to an entity in the register. Match the account title to a legal entity on your list. Write down every account that matches no entity, and every entity name that appears on a statement but not in the register.
- Trace each entity to a line in the latest consolidated report. For every entity in the register that holds an account, find where its balance appears. Write down every entity that appears nowhere.
- List what failed at each step, with the balance. Two lists: accounts with no entity, and entities with no line in the report. Put the statement balance beside each one.
The direction matters. Reading from the report downward confirms what the report already holds. Reading from the statements upward starts from what the banks say exists, so anything the report omits has to surface.
Intercompany balances need one extra pass. A loan from a holding company to an LLC is an asset on one side and a liability on the other. If only one entity is in scope, the report shows half the loan.
A worked example
The office below is fictitious. It is the office used in the Controls Check specimen, and every entity and balance in it is invented.
The family’s register lists 19 entities. One month of statements was traced, at 30 September 2026. Three entities hold accounts that appear in no consolidated report.
| Entity (fictitious) | Accounts | In the Q3 report? | Balance, 30 Sep 2026 |
|---|---|---|---|
| A dormant real estate LLC | 1 bank | No | $180,000 |
| A grantor trust (2019) | 1 brokerage | No | $3,900,000 |
| A holding company's escrow | 1 escrow | No | $120,000 |
| Total outside the report | $4,200,000 |
Together, $4.2 million sits outside every report the family reads. The grantor trust is the case that matters. At $3.9 million it is the family’s second-largest single position outside the operating company.
Nothing in this example is hidden or wrong. Each account was opened for a reason and each statement arrived every month. The report was simply built from a list that did not include them. No check from the top down would have found any of the three.
What it would take
Two changes. The first is quick. The second is the one that lasts.
Add the entities to the reporting scope. Each account found by the test goes into the report, with its entity, from the next period. Note the date it was added, so a reader of an older report knows what it did not include.
Make the register the source the report is built from. If the report is built from the register, a new entity enters the report the day it enters the register. Then one rule closes the gap: no account is opened for an entity that is not yet in the register. Counsel, the bank and the office each have a place to send the new entity, and it is the same place.
After that, the test becomes a monthly habit rather than a discovery. The statements will always say what exists. The register and the report need only agree with them.
Frequently asked
Does consolidated reporting software solve this?
Software reports what it is connected to. An account that was never connected, or an entity never added, is outside its view in the same way it is outside a spreadsheet’s. The test above works whichever system builds the report.
How do you reconcile accounts across entities?
Start from the statements, not the report. Match every account to one entity in the register, every entity to one line in the report, and every intercompany balance to its other side.
How often is this worth doing?
Once in full, to find what has drifted. After that, a monthly pass over new accounts and new entities keeps the register and the report in step.