---
title: Consolidated reporting across custodians, without the Excel export
description: Consolidated reporting across custodians, fund administrators and accountants: why it ends up in Excel, what AI changes, and what to require from any vendor.
canonical: https://privatesuperintelligence.si/blog/family-office-consolidated-reporting/
last-updated: 2026-10-15
---

# Consolidated reporting across custodians, without the Excel export

Family office consolidated reporting is one view of the family's net worth, performance and liquidity across every custodian, fund manager, entity and trust. In most single-family offices someone still builds that view by hand: Citi Institute's May 2026 report on AI in the family office found that monthly reports from advisers are manually consolidated into Excel due to privacy concerns. The 2026 RBC and Campden Wealth North America Family Office Report found that 73% of offices believe investment reporting is too manual, a top concern for three years running.

## What consolidated reporting has to pull together

A consolidated report is only as good as the slowest source feeding it. For a typical single-family office, the inputs look like this.

| Source | What arrives | The usual problem |
|---|---|---|
| Custodians and banks | Statements, transaction files, sometimes a data feed | Each custodian formats positions and cost basis its own way |
| Private funds (GPs and fund administrators) | Quarterly capital account statements, capital call and distribution notices | Mostly PDFs, on each manager's own schedule |
| Direct investments and co-investments | Board materials, cap tables, valuation letters | No feed at all; the numbers live in documents and email |
| Real estate and operating companies | Property and company financials | Different fiscal years and accounting bases |
| Accountants and tax advisers | K-1s, estimates, entity tax returns | Arrive late in the year, and change |
| The entity structure | Trust deeds, LLC agreements, ownership percentages | Ownership changes have to flow into every report |

Private markets make the document problem bigger. RBC and Campden found that 86% of North American family offices invest in private markets, and that direct investments now average 45% of the private markets book, ahead of funds at 36%. Much of that data arrives as PDFs and letters your team has to read before any system can use it.

## Why the numbers end up in Excel

Three reasons come up again and again in the research.

**Privacy.** Citi names data privacy as non-negotiable for family offices and reports that offices pass over AI tools that cannot guarantee data security. Its interviewees worry about AI tools storing sensitive financial data and about third-party vendors accessing family information. Excel on the office's own machines feels safer than sending statements to another vendor.

**Trust in the output.** Citi also found that many offices lack confidence in the accuracy of reports produced by AI tools, and calls this "a major roadblock to full AI automation." If you would re-check every number anyway, a spreadsheet you built yourself is easier to defend to the principal.

**The entity layer.** A family rarely holds assets in one name. Reports have to roll up by trust, by holding company, by branch of the family and by individual, and each view changes when ownership changes. Portfolio software handles much of this (Addepar describes turning "multi-custodial data, illiquid alternatives and complex legal entities" into one source of truth), yet the inputs still have to be collected, read and checked before the software can do its job.

## What AI changes in the reporting cycle

Citi's interviewees describe the useful work: automating the ingestion of data from custodian APIs, extracting information from tax forms, and processing insurance documents to create consolidated views. In practice, AI can take on the reading and checking that eat your controller's month-end.

- **Collect.** Watch the reporting inboxes and portals, pull each statement and notice, and log what has arrived and what is still missing.
- **Extract.** Read the PDF capital account statement or valuation letter and pull the figures your portfolio system needs, with a citation back to the page each number came from.
- **Reconcile.** Compare the extracted figures with what the portfolio system or general ledger already holds, and flag every difference: a capital call booked to the wrong entity, a distribution that doesn't match the notice, a statement that disagrees with last quarter's closing balance.
- **Draft.** Write the commentary for the family's quarterly pack and the follow-up emails to managers whose statements are late or wrong.

The person stays in charge of the result. Citi found that the most sophisticated users treat AI output as a draft that needs human validation, starting with a full review and moving to spot checks as confidence builds. A citation on every figure makes those spot checks fast, because your controller can open the source page in one click.

## Questions to ask any reporting vendor, AI or not

Your reporting data is the family's complete financial picture in one place, so ask every vendor the same questions before it touches a statement. Our [AI vendor due diligence checklist](/blog/ai-vendor-due-diligence-checklist/) goes further.

| Question | Why it matters |
|---|---|
| Where is our data stored and processed, and can we choose the location? | Statements and entity charts reveal the family's full holdings |
| Does the vendor, or any AI model provider it uses, train on our data? | Citi's interviewees list AI tools storing financial data as a top concern |
| Who at the vendor can see family information, and when? | Third-party access is the other concern Citi names |
| Does every extracted number cite its source document? | Without it, your team re-checks everything in Excel |
| Does it work with the portfolio and accounting software we already run? | Replacing a system of record is a bigger project than adding a reader |
| How do we delete everything at the end of the contract? | Reporting data outlives any one vendor relationship |

If you are choosing between portfolio systems or deciding where AI fits next to one, see [Addepar, Masttro and AI](/blog/addepar-masttro-and-ai/).

## Reporting connects to the rest of the year

Consolidated reporting shares its inputs with two other recurring jobs. The capital call notices that update your unfunded commitments are covered in [capital call tracking](/blog/capital-call-tracking/), and the K-1s that arrive months after year end are covered in [K-1 tracking across entities](/blog/k-1-tracking-across-entities/). An office that collects documents once, for all three jobs, chases each manager once instead of three times.

## Private SuperIntelligence for family office reporting

Private SuperIntelligence from Mitosis Labs is an AI concierge for family offices, enterprises and private clients: the most capable AI, trusted with everything. It works across the office's own email, documents and data, answers with citations, and acts within permissions you set, alongside the portfolio and accounting software you already run. Each deployment is built for one client, and the provider keeps no copy of the work and trains nothing on it. See [AI for family offices](/family-offices/) for what it runs for an office.

## Frequently asked questions

### What is consolidated reporting for a family office?

It is a single report of the family's assets, liabilities, performance and liquidity across every custodian, fund, direct holding and entity. Good consolidated reports can also be cut by trust, holding company or family member.

### Why do family offices still use Excel for reporting?

Citi's May 2026 research found that monthly adviser reports are consolidated into Excel due to privacy concerns, and that many offices doubt the accuracy of AI-produced reports. Private fund data also arrives as PDFs that someone has to read.

### Is family office reporting software enough on its own?

Portfolio software such as Addepar, Masttro or Asora aggregates custodian data and handles complex entity structures. The documents that feed it, from capital account statements to K-1s, still need to be collected and checked, and that is where AI helps.

### Can AI produce the family's consolidated report?

AI can collect statements, extract figures, reconcile them against your systems and draft the commentary. Citi recommends treating that output as a draft a person validates, and citations to the source page make that review practical.

### How much of family office reporting is manual?

RBC and Campden Wealth's 2026 report, based on 155 single-family and private multi-family offices in the Americas, found that 73% believe investment reporting is too manual.


## Related reading

- [Private AI for family offices](/blog/private-ai-for-family-offices/)
- [Tracking K-1s across 30 entities](/blog/k-1-tracking-across-entities/)
- [Capital call notices: catching every one, across every trust and LLC](/blog/capital-call-tracking/)
- [The family office technology stack](/blog/family-office-technology-stack/)
- [Family office operations, and where AI changes the staff math](/blog/family-office-operations-and-ai/)
- [Family office cybersecurity, now that AI is part of the attack surface](/blog/family-office-cybersecurity-and-ai/)
- [What is private superintelligence?](/blog/what-is-private-superintelligence/)

## Sources

- [AI in the Family Office: Privacy, Efficiency and Institutional Rigor (Citi Institute, May 2026)](https://www.citigroup.com/rcs/citigpa/storage/public/ai_in_the_family_office.pdf)
- [2026 RBC and Campden Wealth Report: North American family offices shift from caution to optimism (PR Newswire, 2026-09-29)](https://www.prnewswire.com/news-releases/2026-rbc-and-campden-wealth-report-north-american-family-offices-shift-from-caution-to-optimism-amid-great-wealth-transfer-ai-acceleration-302892391.html)
- [Addepar home page (Addepar, accessed 2026-10-15)](https://addepar.com/)
- [Masttro home page (Masttro, accessed 2026-10-15)](https://masttro.com/)
- [Asora home page (Asora, accessed 2026-10-15)](https://asora.com/)