Consolidated reporting for multi-entity families
Built on Chapter 3 of The Single Family Office by Richard C. Wilson. Full chapter text: FamilyOffices.com.
Ask a wealthy family a simple question: what do you own, and how is it doing? Many cannot answer quickly. Their wealth sits across trusts and holding companies, in bank accounts, private deals, and real estate, each with its own statements. Consolidated reporting pulls all of it into one view. For most family offices, it is the single most valuable service they provide.
Why it is so hard
Large families build up many entities over time. Each trust and company may have its own accounts and advisors. Private investments report quarterly, often late, in different formats. Real estate values are estimates. Some assets sit in other currencies. Bringing all of that together accurately takes work.
Without consolidation, the family relies on piles of statements and spreadsheets. Risk hides in the gaps. A family may think it is diversified when much of its wealth depends on the same industry or the same few managers.
What a good report shows
Net worth by owner. What each person and entity owns.
Asset mix. How wealth splits across cash, stocks, bonds, private equity, real estate, and other holdings.
Performance. Returns over time, compared to goals and benchmarks.
Liquidity. How much can be turned to cash quickly, and what capital calls are coming.
Concentration. Exposure to any one company, sector, manager, or country.
Cash flow. Income and spending, plus commitments ahead.
Building the system
Map the structure. Start with an ownership chart showing every entity and who owns it.
Gather every account. List each bank and custodian, plus every fund and direct holding.
Choose a platform. Many family office reporting systems pull data automatically from banks and custodians. Private deals often need manual entry.
Set valuation rules. Decide how to value private holdings and real estate, and apply the rules consistently.
Agree on a schedule. Monthly for liquid assets, quarterly for the full picture is common.
Tailor reports to each reader
The founder may want a one-page summary. The investment committee needs detail on performance and risk. Each branch of the family may only see its own holdings. A good system produces different views from the same data, with access controls to protect privacy.
Common problems
- Private investments carried at old values for years.
- Entities missing from the report because no one added them.
- Double counting when one entity owns part of another.
- Reports that arrive so late they are useless for decisions, often weeks after the quarter has closed and the moment has passed.
- No one checking the data against original statements.
Who owns it
One person in the office should own reporting, even if an outside firm does the data work. That person checks accuracy, chases late statements, and explains the numbers to the family. In a lean office, this is often the lead executive's main job.
A common pattern
A pattern I see often goes like this. A family believes it is well diversified across a dozen managers. When the office finally builds a consolidated report, it finds that several managers hold the same few large stocks, and that private deals are clustered in one region. The family was far more concentrated than it thought. The report did not change the portfolio by itself, but it made the next decisions much better.
What to take from this
- Consolidated reporting is the base for every other family office decision.
- Start with an ownership chart and a list of every account.
- Set clear valuation rules for private holdings.
- Give each reader the right view, with privacy controls.
This page is general information, not legal, tax, or investment advice. Speak with qualified advisors about reporting systems and valuation for your family.
Questions and answers
What is consolidated reporting? A single view of everything the family owns, across all entities and accounts.
Why does it matter? It shows true risk and liquidity, which guide every decision.
How often should reports run? Commonly monthly for liquid assets and quarterly for the full picture.
Who should own reporting? One person in the office, even if an outside firm handles the data.