Family office consolidated reporting brings every entity, account, and asset into one view of the family’s wealth. Public portfolios arrive daily and reconcile easily. Private funds arrive quarterly as PDFs, weeks after quarter end, and usually appear as one line per fund. Look-through replaces that line with what the funds own.
This guide covers what consolidated reporting includes, why private markets are its weak spot, how to add a look-through view next to the NAV view, and how to design reports that stay honest about timing.
Key takeaways
- Private funds are the weak spot. They report quarterly, with a lag, in PDFs, and only at the fund level.
- Use two views. Show private funds at NAV for net worth and performance, and at look-through for exposure by company, sector, and country.
- One taxonomy for everything. Public holdings and private look-through need the same sector and country labels before you add them up.
- Label every date. A consolidated report mixes daily public prices with quarterly private marks. Show the as-of date of each.
- Show commitments, not just values. Unfunded commitments are future cash calls and belong next to liquidity.
What family office consolidated reporting covers
Net worth
- By family member, entity, and trust.
- Assets and liabilities in one currency, with FX shown.
Allocation
- By asset class, manager, and strategy.
- Against the family’s targets.
Performance
- Returns by portfolio, entity, and manager.
- Private funds with IRR and multiples.
Liquidity and commitments
- Cash, credit lines, and expected calls.
- Unfunded commitments by fund.
Income and tax
- Income by entity.
- Inputs for tax reporting, such as K-1s.
Exposure
- By company, sector, and country.
- Across public holdings and private funds.
Our article on family office reporting and accounting requirements covers the full reporting scope. This one focuses on private markets.
Why private markets are the weak spot
- Timing. Quarterly fund reports arrive 45 to 90 days after quarter end under ILPA’s guidance, and audited statements later still.
- Format. Statements come as PDFs from portals and email, in each GP’s own layout.
- Valuation basis. Private holdings carry quarterly fair values; public holdings carry daily prices.
- Structure. Feeder funds, SPVs, and co-investment vehicles sit between the family and the companies.
- Fund-level detail only. Capital account statements show what your interest is worth, not what the fund owns.
Many offices still bridge these gaps in spreadsheets, as our article on family offices and Excel describes. Family office data aggregation covers the plumbing; the rest of this guide covers the exposure view.
Two views of the same private funds
NAV view
- Answers
- What the family’s interests are worth, and how they perform
- Source
- Capital account statements and capital activity notices
- Use for
- Net worth, performance, allocation by asset class
Look-through view
- Answers
- What the family owns through the funds
- Source
- Each fund’s schedule of investments, scaled to the family’s share
- Use for
- Exposure by company, sector, and country, combined with public holdings
Both views use the same quarter’s data and should reconcile: the look-through total for each fund equals the family’s NAV in that fund. Our look-through analysis guide explains the method.
Example: one exposure view across public and private
This continues the family office from our look-through and co-investment examples. Its private holdings are worth $17.1 million after look-through, and it also holds a public portfolio of $40.0 million. To combine them, the GP industry labels are mapped to one taxonomy: software to information technology, business services and industrial machinery to industrials, and so on.
Exposure by sector, June 30, 2026 ($000)
| Sector (one taxonomy) | Public portfolio | Private look-through | Total | % of total |
|---|---|---|---|---|
| Information technology | 10,000.0 | 5,433.6 | 15,433.6 | 27.0% |
| Health care | 6,000.0 | 5,474.8 | 11,474.8 | 20.1% |
| Financials | 8,000.0 | 900.0 | 8,900.0 | 15.6% |
| Industrials | 6,000.0 | 2,900.4 | 8,900.4 | 15.6% |
| Consumer | 6,000.0 | 1,115.4 | 7,115.4 | 12.5% |
| Cash | 4,000.0 | 1,275.8 | 5,275.8 | 9.2% |
| Total | 40,000.0 | 17,100.0 | 57,100.0 | 100.0% |
Information technology is 25.0% of the public portfolio and 31.8% of the private portfolio, so 27.0% of total wealth in the sector. The fund-level report shows the same private money as three fund lines and a co-investment, with no sector at all.
Illustrative example. All holdings are fictional. Public values as of June 30, 2026 market close; private values from June 30, 2026 fund marks, received in August.
How to add look-through to consolidated reporting
-
List every private interest
Funds, feeders, SPVs, and co-investments, with the owning entity and the commitment.
-
Collect statements and schedules
Capital account statements for the NAV view; GP financial statements for the schedules of investments.
-
Extract and map
Pull every holding, then map GP industry names, countries, and company names to the family’s taxonomy.
-
Scale to the family’s share
Multiply each fund holding by the family’s share of that fund, entity by entity.
-
Combine with public holdings
Add look-through exposures to the custodian positions under the same labels.
-
Label, reconcile, and publish
Show the as-of date of each source, tie each fund’s look-through to its NAV, and keep the prior version when a GP restates.
Report design that holds up
- Put both views on one page. NAV by fund next to exposure by sector avoids two versions of the truth.
- Show the top company exposures. Include public and private positions, and co-investments. Our guide to concentration risk explains why.
- Footnote the dates. Mark which quarter each private fund reflects.
- Keep commitments visible. Unfunded commitments next to liquidity, by quarter if you forecast calls.
- Version the history. Late statements and restatements change past quarters; keep what the family saw at the time.
Common mistakes
- Double counting. A feeder fund and the master fund it invests in are one position.
- Mixed bases. Direct private holdings at cost next to funds at fair value distort both views.
- Currency. Convert non-dollar funds at the same date as the public holdings, or show the difference.
- Silent estimates. If a fund has not reported yet, roll the last NAV forward for calls and distributions and say so in the report.
How FundCount supports family office consolidated reporting
FundCount AI Document Intelligence collects statements from your investor portals and email, converts them into accounting-ready data, and posts them to your books, with the source document one click from each posted figure. It now also extracts the schedule of investments from GP financial statements, which adds a look-through view to the private side of the report.
- Extracts asset-level data from GP financial statements: security name, industry, country, round or share class, shares, cost, and fair value.
- Tracks quarter-over-quarter movements in cost and fair value for each holding.
- Shows exposure by industry, country, and share class, filtered by year, quarter, fund, and holding company.
- Shows where the same security appears across different GPs.
- Keeps co-investments, valued from their own schedules of investments, next to fund holdings.
The extracted data sits in the same platform that runs FundCount’s portfolio accounting, partnership accounting, and reporting, used by family offices and by the fund administrators that report to LPs.
On the public side, FundCount’s data aggregation brings in positions, transactions, pricing, and FX automatically from sources such as Bloomberg, Refinitiv, Interactive Brokers, Pershing, and Morgan Stanley.
Watch-outs
- FundCount extracts what each GP discloses. Grouped lines in a condensed schedule stay grouped until the GP provides the names.
- Holdings data covers what each fund owns and what it is worth. Company KPIs such as revenue and EBITDA come from GP portfolio company updates.
See public and private exposure in one family report
In a guided walkthrough on real-world scenarios, we combine custodian positions with holdings extracted from GP financial statements and show exposure by sector across both.
FAQs
What is family office consolidated reporting?
Reporting that brings every entity, account, and asset of a family into one view: net worth, allocation, performance, liquidity, income, and exposure.
How do private funds fit into consolidated reporting?
At NAV for net worth and performance, from capital account statements, and at look-through for exposure, from each fund’s schedule of investments scaled to the family’s share.
Why are private markets hard to consolidate?
They report quarterly with a lag, in PDFs, at fair values set by each GP, and only at the fund level unless you extract the holdings.
How do you combine public and private exposure?
Map both to one sector and country taxonomy, scale private holdings to the family’s share, and add them up, noting the as-of date of each source.
Should unfunded commitments appear in the report?
Yes. They are future cash calls and belong next to liquidity, even though they are not part of net worth today.
How often should look-through be updated?
Quarterly, when new schedules of investments arrive. Between quarters, roll fund NAVs forward for capital activity and label them as estimates.
Sources and methodology
Sources: ILPA Quarterly Reporting Standards, Best Practices, version 1.0 (October 2011), for reporting windows; FASB ASC 946-210-50 on schedules of investments, as quoted in SEC staff correspondence; FundCount’s data aggregation and AI Document Intelligence pages. FundCount capabilities reviewed in October 2026.
Example: all holdings are fictional. Private figures reconcile with our look-through and co-investment examples.
Scope: general information, not investment, accounting, or legal advice.
Published: October 2026.
