The aggregation trap: why "single source of truth" keeps failing
Most platforms aggregate data and call it truth. The families who actually reconcile do the opposite — and it changes what you buy.
- Aggregation moves data into a dashboard; it does not verify it. A polished view of wrong numbers is still wrong.
- The trap springs on alternatives and ownership structure — the two things feeds cannot reconcile on their own.
- Buy for what a tool does when a feed is wrong: how exceptions surface, and whether the general ledger is the system of record.
Every data-aggregation vendor sells the same promise: connect your custodians, your banks, your fund administrators, and you will finally have one number you can trust. It is a seductive pitch, and it is mostly wrong. Aggregation is not reconciliation, and the gap between the two is where family offices lose control of their own numbers.
01Aggregation moves data. It does not verify it.
A feed pulls positions and transactions from a source and lands them in a reporting layer. If the source is wrong, incomplete, or lagged, the aggregator faithfully reproduces the error — only now it looks authoritative, because it sits inside a polished dashboard. The dashboard says “single source of truth.” What it actually holds is a single source of whatever the feeds happened to send.
The families who get this right treat the aggregated layer as a draft, not an answer. The real work happens when someone ties each position back to a custodial statement, each capital call back to a fund notice, each valuation back to a primary document. That is reconciliation, and no feed performs it for you.
02Where the trap springs
1Alternatives break the model
Public positions aggregate cleanly. Private equity, direct deals, co-investments, and real assets do not. They arrive as PDFs, quarterly and late, with valuations that are estimates until they are not. A platform that quietly interpolates these into a daily number is manufacturing precision that does not exist.
2Ownership structures get flattened
A single family often holds assets through dozens of entities, trusts, and partnerships. Aggregation tools tend to collapse this into a household total. The total is comforting and frequently useless — because control, tax, and distribution questions all live at the entity level, not the household level.
| When this happens | Aggregation-first | Accounting-first |
|---|---|---|
| A custodial feed is wrong | The error propagates into a polished dashboard | An exception surfaces against the ledger before reporting |
| A private valuation is stale | It is interpolated into a daily number | It is held at last-known and flagged as an estimate |
| Assets sit across 20 entities | They collapse into one household total | They consolidate with inter-entity eliminations |
Truth is something you produce — not something you subscribe to.
03What to buy instead
Stop evaluating tools on how many feeds they claim and start evaluating them on what they do when a feed is wrong. Ask how exceptions surface. Ask whether the general ledger is the system of record or an afterthought bolted onto a reporting front end. Ask who owns the reconciliation workflow, and whether the tool makes that person faster or simply hides their work.
The family offices with numbers they actually trust are not the ones with the most connected accounts. They are the ones who decided, early, that truth is something you produce — not something you subscribe to.
An independent read on your operating stack.
Opinions are cheap; reconciliations are not. If you want an independent view of where your reporting and controls actually stand — before the next audit or board meeting — it helps to have someone outside the vendor relationship look.
Get an independent view →Rebuilding a $2bn single-family office around the general ledger
A single-family office with a portfolio-first stack that wouldn't reconcile, rebuilt accounting-first around one general ledger — and…
Accounting & Reporting · PerspectiveAccounting in Family Offices: Where Control Actually Comes From
Most conversations around family offices start with investments. Asset allocation, manager selection, returns. That’s visible. That’s discussed.
Accounting & Reporting · Perspective