Every wealth management software vendor promises "a single view of total wealth." For RIAs managing liquid portfolios at two custodians, that promise is roughly true. For family offices, it is — to borrow a phrase from one long-suffering family office COO — "a lie told by people who have never seen a K-1."
Consolidated reporting for family offices is the hardest problem in wealth technology. Not the most visible, not the most discussed, but the hardest. Understanding why explains most of what goes wrong in family office technology implementations.
The Data Problem Is Structural
The core difficulty is that family office data is heterogeneous in ways that break every assumption built into conventional portfolio software.
Custodian fragmentation. An RIA might custody 95% of client assets at Schwab. A family office of real size custodies across six to ten institutions globally — and each one reports differently. One uses CUSIPs, another uses SEDOLs, a third uses proprietary identifiers. Corporate actions are described inconsistently. Cash balances appear in different places. Reconciling these feeds into a single security master is not a solved problem; it is an ongoing operational function that the best platforms staff with dedicated data teams.
The alternatives abyss. Here is where conventional systems truly collapse. A private equity fund does not send a daily holdings feed. It sends a quarterly capital account statement — a PDF, often scanned, with contributions, distributions, and a NAV that is already 45 to 90 days stale. A hedge fund sends a monthly NAV with minimal holdings detail. A direct real estate investment sends an annual appraisal and a K-1. Venture investments send SAFEs and convertible notes that convert on unknowable timelines.
To produce a consolidated report, the system must combine daily-priced liquid securities with quarterly-staled alternatives, model unfunded commitments as both assets and liabilities, and present a net-worth figure that is honest about its own precision. Most systems handle this by either excluding alternatives from performance calculations (useless) or carrying them at stale values without disclosure (dishonest). The good ones — and there are few — model the uncertainty explicitly.
Entity complexity. The RIA data model is: client → accounts → holdings. The family office data model is: family → trusts → entities → accounts → holdings, with cross-ownership, loans between entities, and beneficiaries who change. A distribution from a trust to fund a grandchild's 529 has tax, legal, and reporting implications that touch three entities. Software designed for the RIA model cannot represent this without contortions that eventually break.
Why Reconciliation Never Ends
"Consolidated reporting isn't a project. It's a permanent operational function, like payroll. Anyone selling you a one-time implementation is selling you a future failure."
Even with the right platform, consolidated reporting requires continuous reconciliation. Custodian feeds break — a corporate action is misclassified, a fund administrator changes formats, a private bank's feed goes dark for a week. Alternatives data arrives late or not at all. Manual entries (art purchases, intra-family loans, direct business investments) introduce errors that compound.
The family offices that do this well treat reconciliation as a staffed function, not a software feature. They typically dedicate one to three full-time professionals — sometimes in-house, increasingly outsourced to firms like Agreus, Private Wealth Systems, or the family office service arms of the large custodians — whose job is data integrity. The software is necessary but not sufficient. As one family office CEO put it: "Addepar didn't solve our reporting problem. Addepar plus two full-time data analysts solved our reporting problem."
This is the uncomfortable truth that vendors obscure: the software license is perhaps 30% of the total cost of consolidated reporting. The rest is people — internal or outsourced — doing the unglamorous work of making the data right.
The Emerging Architecture
The market is converging on a layered architecture that acknowledges the problem's difficulty rather than pretending it away.
Layer one: aggregation. Automated feeds from custodians, fund administrators, and banks, normalized into a common data model. This is the commodity layer — increasingly handled by specialists like Canoe Intelligence for alternatives documents and the custodians' own aggregation APIs for liquid holdings.
Layer two: the golden record. A single system of record — typically Addepar, Masttro, or a comparable platform — that maintains the consolidated security master, entity structure, and performance calculations. This is where the family's "truth" lives.
Layer three: presentation and analytics. Custom dashboards, scenario modeling, and ad hoc analysis, increasingly built on the platform's API or data warehouse export. This is where family offices differentiate — the patriarch who wants to see carbon exposure across the portfolio, the next-gen member building ESG screens, the CIO stress-testing liquidity under a capital-call surge.
The offices that struggle are typically trying to do all three layers in one system — usually Excel, sometimes an underpowered vendor product. The offices that succeed accept that consolidated reporting is a stack, not a product, and staff accordingly.
What This Means for Technology Buyers
If you are evaluating family office reporting technology, the demo will not tell you what you need to know. Every vendor's demo uses clean data. Your data is not clean. Instead, ask for three things: a reference client with a comparable alternatives allocation (and permission to ask them about reconciliation staffing), a walkthrough of how the system handles a specific ugly case from your portfolio (bring a real K-1), and the vendor's data-operations SLA in writing.
And budget for the people, not just the software. The most common failure mode in family office technology is buying a Ferrari engine and installing it in a rowboat — a powerful platform with nobody to feed it clean data. The offices that get consolidated reporting right spend as much on data operations as on licenses. That ratio surprises everyone the first time. It shouldn't.
FamilyOfficeReporting.com is available for acquisition by family office technology providers, consultants, and multi-family offices building the next generation of reporting infrastructure.