One family, a dozen custodians
Ask anyone who prepares a family's consolidated wealth report what the job actually involves, and the honest answer is a stack of PDFs that were never designed to sit next to each other — a private bank statement in one layout, a brokerage statement in another, a real estate holding entity's own bank account in a third, sometimes a crypto custodian's export in a fourth. None of them share a column order, a date format, or even a consistent way of naming the same asset class.
Producing one consolidated view — a net worth statement, an asset allocation breakdown, a performance summary — means someone pulling figures from each of those statements by hand into a master spreadsheet, quarter after quarter, trusting that nothing got mistyped or missed along the way. That trust holds most quarters. It doesn't hold every quarter, and the quarters it doesn't are rarely discovered until a principal asks a question the numbers can't actually answer.
This page describes how statements from every custodian a family office works with are read and lined up into one consistent workbook — not to replace the judgment behind a wealth report, but to remove the manual re-typing step where a consolidated view most often quietly drifts from what the custodians actually reported.
Where consolidation breaks down
Most gaps in a consolidated wealth report didn't start as a dramatic error — they started as an ordinary consequence of assembling many statements by hand, under a deadline, every reporting period. A handful of patterns show up again and again.
A statement arrives after the report already went out
One custodian's statement lands three days after the deadline, so that account's figures are estimated or carried forward from last period — and sometimes never quietly corrected once the real statement shows up.
The same asset class named differently by two custodians
One private bank calls it "fixed income", another calls the same category "bonds", and a spreadsheet built by hand ends up with two rows for what should be one line in the allocation summary.
A transfer between two of the family's own accounts double-counted
Cash moved from one custodian to another shows up as an inflow on one statement and an outflow on the other — recorded as new money on both sides instead of one internal transfer, and net worth briefly looks larger than it is.
A statement re-typed with a transposed figure
A six- or seven-figure balance retyped by hand, with two digits swapped — the kind of error a machine reading the same printed number doesn't make, and a human reviewer skimming a familiar-looking total doesn't always catch.
An entity's account left out entirely
A trust or an LLC holding real estate or a private investment has its own bank account that isn't part of the usual custodian list, and gets left off the consolidated view until someone remembers to ask for it.
None of these need a dramatic explanation — they're the ordinary cost of a recurring, manual task performed across a growing number of accounts. Reading every statement the same way, every period, closes most of this gap simply by removing the re-typing step where inconsistency creeps in, the same way finance teams reach for a bank statement to Excel conversion instead of retyping an ordinary account statement by hand.
Why this isn't a simple copy-paste
A consolidated wealth report needs the same handful of figures from every account — balance, holdings, transactions for the period, currency, as-of date. Each custodian reports those figures in its own structure, with its own terminology, its own statement cadence, and often its own definition of what counts as a “position” versus a line-item note.
Multiply that translation step by every custodian, every entity, and every reporting period, and a task that looks like an afternoon's work on a single account becomes a recurring exercise that's easy to rush — right up until a figure that doesn't tie out draws a question from the principal or the family's own advisors that nobody wants to spend a week tracing back.
What a family office actually reports on
A family office's consolidated report typically rolls up several distinct things: a net worth statement across every account and entity, an asset allocation view showing how wealth is spread across cash, fixed income, equities, alternatives and real assets, a performance summary, and often a liquidity view — how much sits in accounts that can be accessed quickly versus locked into longer-term structures.
Every one of those views draws on the same underlying source data: what each custodian's statement actually reported for the period. Getting that source data right, consistently, across every account, is the foundation the rest of the reporting stack depends on — a beautifully designed report built on a mistyped balance is still built on a mistyped balance.
The custodian problem
A family with meaningful, diversified wealth rarely holds everything in one place. A typical custodian roster might include a private bank for the core liquid portfolio, a brokerage like Charles Schwab or Fidelity for a self-directed allocation, a separate custodian for alternative investments, and sometimes a crypto exchange or custodian holding digital assets. Each one issues its own statement, on its own schedule, in its own format.
| Custodian type | What typically differs |
|---|---|
| Private bank | Statement cadence, terminology, often a relationship-manager summary page mixed with the transaction detail |
| Retail brokerage | Standardized layout, but asset-class labels and cost-basis presentation vary by platform |
| Alternative investment custodian | Quarterly or even annual statements, valuations sometimes lagged by a full period |
| Crypto custodian or exchange | No standard statement format at all; often a CSV or PDF export unique to the platform |
| Real estate holding entity's bank account | An ordinary business bank statement, easy to leave out of a consolidated wealth view |
None of this variety is a problem the family or their advisors created — it's the ordinary shape of diversified wealth spread across specialists rather than one institution. The consolidation work exists precisely because that diversification, which is often the point of the structure, doesn't come with a single unified statement to match it.
What gets read
| Data | Typical source |
|---|---|
| Account holder, account number, custodian name | Statement header |
| Opening and closing balance for the period | Summary section |
| Holdings and positions, where the statement lists them | Portfolio detail section |
| Transactions — deposits, withdrawals, transfers, trades | Activity detail |
| Currency and statement period | Header or footer |
A field that can't be read with confidence — a total obscured by a relationship-manager note, a figure split across a page break — is flagged rather than filled in with a best guess, so a reviewer's time goes to the handful of numbers that genuinely need a second look, not to re-checking every figure from scratch.
How it works
Upload statements from every custodian
For the reporting period the consolidated view covers — however many accounts and entities that involves.
Each statement is read on its own
Balances, holdings, transactions and dates extracted from each custodian's own layout.
Figures lined up into one consistent structure
Every account mapped to the same columns, regardless of how differently each custodian formatted its original statement.
Mismatches flagged, not guessed
A transfer that doesn't tie out between two accounts, or a figure that looks unusual against the prior period, is marked for review.
Exported
Excel, CSV or JSON, with every figure traceable back to the statement it came from.
A quarter-end, consolidated
A family office managing accounts across a private bank, two brokerages and a real estate holding LLC uploads each custodian's quarter-end statement as it arrives.
| Result | Count |
|---|---|
| Accounts consolidated | 6 |
| Figures matched with high confidence | 41 |
| Flagged for quick confirmation | 3 |
| Internal transfer identified and reconciled | 1 |
The one internal transfer turns out to be a routine cash sweep from the private bank into a brokerage account for a planned investment — recognized as the same money moving between two of the family's own accounts rather than counted twice, so the consolidated net worth figure reflects reality rather than a double-count that would have overstated it.
Statement cadence and the lag it creates
Not every custodian issues statements on the same schedule. A retail brokerage might post a statement within days of month-end; a private bank or an alternative investment manager can take several weeks; some illiquid holdings are valued and reported quarterly at best, occasionally with a further lag on top of that.
A consolidated report built by waiting for every custodian to arrive is a report that's perpetually as current as its slowest contributor. Processing each statement the moment it lands, rather than batching the whole consolidation until the last one shows up, means the report can reflect what's known today and be updated incrementally as the remaining pieces arrive — rather than sitting idle for weeks waiting on one lagging account.
When accounts sit inside trusts and LLCs
A meaningful share of family wealth often sits inside legal structures rather than direct individual accounts — a trust holding a securities portfolio, an LLC holding real estate with its own operating bank account, a holding company for a family business. Each of those entities has its own statements, and a consolidated wealth view needs to reflect who actually holds what, across the whole structure.
Reading each entity's statements the same way as a direct personal account, and tagging which entity each account belongs to, is what makes it possible to roll everything into one net worth view while still being able to break it back down by entity when a specific trust or LLC needs its own accounting.
Manual vs. automatic
| Manual | Automatic |
|---|---|
| Figures retyped from each custodian's PDF by hand | Every custodian's figures read and lined up automatically |
| Report waits on the slowest statement to arrive | Each statement processed as it lands, report updated incrementally |
| Internal transfers reconciled from memory or a note | Transfers between the family's own accounts identified automatically |
| Redone from scratch as custodians are added | Same method applies regardless of how many accounts exist |
From one family to a multi-family office
A single family with a handful of accounts is a manageable manual exercise, if tedious. A multi-family office serving several client families, each with their own custodian roster and entity structure, turns the same exercise into a recurring job that consumes days of staff time every reporting cycle — multiplied by however many client families are on the calendar.
Reading and consolidating each family's statements the same way, regardless of how many accounts or entities are involved, keeps the effort per account flat as the client roster grows — what changes is only how many figures need a human look, which a well-tuned extraction keeps small.
Who uses this
Single-family offices
A consolidated wealth report assembled from every custodian, without a manual re-typing pass each period.
Multi-family offices
The same consolidation method applied consistently across every client family and their custodian roster.
Private wealth bookkeepers and controllers
A verified, traceable set of figures ready before the reporting deadline, not assembled the night before.
Outside accountants preparing family reports
A structured starting point instead of a stack of unrelated statement PDFs to work through.
Edge cases worth knowing
An alternative investment statement that reports a valuation lagged by a full quarter — common for private equity and real assets — needs to be tagged as reflecting an earlier period than the rest of the consolidation, rather than treated as a current-quarter figure that happens to look stale.
A joint account held by more than one family member, or an account that changed custodian mid-period, needs its ownership and continuity tracked explicitly rather than assumed — both are flagged for confirmation rather than resolved with a default assumption that might not hold for that specific account.
Why a traceable figure beats a rounded one
A consolidated report that shows only final totals, without the statement each figure came from, is easy to trust until the principal or an advisor asks why a specific number moved. Reconstructing that answer later means going back to the original PDFs and starting over.
Keeping the source statement attached to every consolidated figure — custodian, statement date, page reference, confidence level — turns that reconstruction from a scramble into a detail already sitting in the data, ready the moment a question comes in.
What this doesn't do
Doesn't calculate net worth or performance for you
It lines up the balances and positions each statement reports — applying your valuation and performance methodology stays your step.
Doesn't replace a full wealth-reporting platform
It's the document-reading layer many family offices feed into a reporting platform, a master spreadsheet, or their own existing process.
Doesn't give investment or tax advice
Any question about allocation, performance or tax treatment belongs with your advisors, not this tool.
Doesn't decide which figure is 'correct' when custodians disagree
It flags the disagreement. Resolving it — a timing difference or a genuine discrepancy — stays a human judgment call.
What it does fits in one sentence: turn a stack of custodian statements in a dozen different formats into one consistent, traceable workbook, so the report doesn't have to wait on the slowest statement or trust a re-typed figure nobody double-checked.
Bringing an existing wealth report into this process
A family office switching from a purely manual consolidation doesn't need to rebuild anything before starting — the first period run through this process stands on its own, read directly from that period's custodian statements rather than depending on how prior periods were assembled. There's no migration step, no historical re-entry required to get useful output from the very first upload.
What's worth doing deliberately in that first period is a side-by-side comparison against the most recent manually built report — not because the automated reading is expected to disagree, but because confirming it matches a report the team already trusts is what builds the confidence to rely on it going forward, and any genuine gap surfaces immediately rather than several periods later.
Security and privacy
Uploads are encrypted with TLS from end to end.
Processing runs on infrastructure with SOC 2-aligned controls.
Original documents are deleted shortly after processing.
Nothing you upload is ever used to train AI models.
For statements that reveal the full shape of a family's wealth, that matters — details are on the security page.