Established 1994

Financial Planning Guide

Consolidated Reporting for Family Wealth: Aggregating Assets Across Custodians and Jurisdictions

Updated 6 min readBy Global Investments Editorial

A consistent feature of accumulated wealth is fragmentation. Assets are held with multiple banks, fund managers, pension providers, and property vehicles across different countries. Some are in individual names, others in trusts or company structures, and others in offshore portfolios established over many years by different advisers. The result is that most wealthy families do not have a reliable real-time view of their total financial position — and the decisions they make about individual components are rarely optimised for the whole.

Consolidated reporting is the discipline of aggregating all of these disparate holdings into a single, coherent picture. Done well, it provides the foundation for effective financial decision-making, accurate tax reporting, and genuine oversight of risk.

The aggregation challenge

The technical challenge of consolidated reporting is real. Different custodians and platforms provide data in different formats, on different timescales, and with different levels of detail. Multi-currency portfolios require a consistent approach to currency translation. Trust and company structures need to be represented in a way that reflects both their legal ownership and the economic interests of underlying beneficiaries. Illiquid assets — direct property, private equity stakes, artwork, and structured products — may not have market prices and require regular revaluation.

For a family with holdings across, say, a UK SIPP, an offshore portfolio bond in Dublin, a discretionary investment account in Geneva, a buy-to-let property in the UK, a GIA with a London private bank, and a US brokerage account, simply compiling a quarterly net worth statement requires pulling data from six different sources, reconciling four different currencies, applying consistent valuation methodologies, and applying the appropriate tax considerations to each.

Technology platforms for wealth consolidation

Several technology platforms have been developed specifically for this aggregation challenge, operating at different tiers of the market:

Landytech: a UK-based consolidated reporting platform widely used by family offices and multi-family offices. Connects to custodians via API and manual feed ingestion, providing multi-currency performance reporting, risk attribution, and regulatory reporting output. Strong on alternative assets and private equity.

SEI Archway: one of the more established family office technology platforms, particularly strong in the US market. Provides general ledger accounting, portfolio management, and consolidated reporting across complex multi-entity structures.

Objectway: a European wealth management technology provider used by private banks and wealth managers. Provides portfolio management, order management, and client reporting with multi-custodian aggregation.

Wealth Dynamix: a CRM and client lifecycle management platform used by private banks, with data aggregation features for consolidated client views.

Masttro: a Swiss-based platform positioned at the UHNW market, offering secure document storage, portfolio aggregation, and family governance tools with a strong emphasis on privacy and security.

For families not yet at the scale or complexity that justifies a dedicated platform, a well-maintained spreadsheet model or a service provided by a family office or multi-family office acting as the consolidation agent can serve the purpose effectively.

Performance attribution across asset classes

A consolidated report is most valuable when it moves beyond a static balance sheet to provide performance attribution — showing not just what you own but how each element has performed, against what benchmark, and why.

Performance attribution across a diversified family wealth base typically analyses:

  • Asset class attribution: the contribution of equities, bonds, property, alternatives, and cash to total portfolio return
  • Geographic attribution: return contribution from different regional allocations (UK, US, Europe, Asia, emerging markets)
  • Currency impact: for multi-currency portfolios, the total return needs to be separated into the base currency return on the underlying asset and the currency movement component
  • Manager attribution: where assets are managed by external fund managers, comparing manager performance against the relevant benchmark

For the wealthiest clients, more sophisticated attribution analysis — factor exposure (value, growth, quality, momentum), sector concentration, duration risk in fixed income — is increasingly standard. The value of attribution analysis is that it allows the client and their advisers to make evidence-based decisions about allocation changes, rather than responding to recent performance alone.

Currency impact reporting

For internationally mobile families or those with assets denominated in multiple currencies, currency impact reporting is essential. A portfolio that has returned 12% in US dollar terms may have returned only 6% in sterling terms if the dollar weakened against sterling over the period — or may have returned 18% if the dollar strengthened.

Currency reporting should:

  • Identify the base currency of the consolidated report (typically sterling or the family's primary consumption currency)
  • Translate all positions to the base currency at current and historical rates
  • Quantify the proportion of portfolio volatility attributable to currency movements
  • Identify currency concentrations that create unhedged risk

Where a family has significant spending commitments in one currency but investment assets predominantly in another, this mismatch is a material risk that needs to be managed explicitly.

Risk exposure aggregation

A consolidated view enables risk analysis that is impossible at the individual custodian level. Key risk metrics include:

Concentration risk: what percentage of the total wealth is held in a single security, sector, or geography? A family with a large holding in a former employer's shares, a significant commercial property in one city, and an offshore bond invested in a US equity index fund may have a far more concentrated US equity exposure than any individual account statement reveals.

Geography and currency concentration: particularly relevant for wealthy families with connections to multiple countries.

Sector concentration: for portfolios with direct equity holdings, sector-level aggregation is important — a portfolio spread across six different fund managers may still be heavily overweight technology if each manager independently holds the same positions.

Leverage and counterparty risk: where assets are held with margin lending or have embedded derivatives, the consolidated view should capture these exposures.

Tax reporting output

For UK-based individuals, consolidated reporting should produce outputs aligned with HMRC reporting requirements:

CGT summary: a consolidated annual record of all disposals, gains, and losses, including the application of available annual exemptions and loss relief. This is particularly important for clients with multiple investment accounts who may be unwittingly exceeding the annual CGT threshold through disposals spread across custodians.

Income summary: aggregation of dividends, interest, and rental income by tax year, by jurisdiction, and by wrapper type (ISA income is exempt; pension income is taxable on withdrawal).

Withholding tax recovery: for clients receiving dividends from overseas companies, withholding tax may be deducted at source. A consolidated view identifies the WHT credits available and supports reclaim applications where applicable under double tax treaties.

Trust and company consolidated with personal holdings: for clients with assets in trusts or holding companies, the consolidated report should include these structures, clearly identifying the legal owner and the economic interest of the beneficial owner.

Build, buy, or outsource?

For families considering how to implement consolidated reporting, the options are:

  • Buy a platform: appropriate for family offices with sufficient scale and in-house resource to manage the platform and data feeds
  • Outsource to a multi-family office or consolidated reporting service: the most common approach for families below the scale of a dedicated SFO. The service provider maintains the platform, manages data quality, and produces the reports
  • Commission bespoke development: in rare cases, proprietary consolidated reporting systems are built, typically where the family's asset mix is highly idiosyncratic (e.g., dominated by complex illiquid assets that off-the-shelf platforms cannot handle)

Compliance note

Consolidated reporting is a financial management and planning tool, not a substitute for formal accounting, tax returns, or audited financial statements. Tax reporting outputs from a consolidated platform should be reviewed by a qualified accountant before submission to HMRC. Valuation methodologies for illiquid assets are inherently judgmental and should be applied consistently and reviewed by a specialist where material.

How Global Investments Can Help

Global Investments provides consolidated reporting services for clients with complex, multi-custodian, multi-currency wealth bases. Our family office and private client teams work with dedicated technology platforms to aggregate your holdings, identify risk concentrations, and produce clear, actionable performance reports — alongside the tax reporting outputs your accountants need. Contact us to discuss how consolidated reporting can give you a clearer picture of your financial position.

This guide is for general information only and does not constitute financial advice or a personal recommendation. The value of investments can fall as well as rise and you may get back less than you invest. Tax rules, pension legislation, and investment regulations change — always verify current rules and seek advice from a qualified independent financial adviser before making any financial decisions.

Get a free financial planning review

Our independent advisers specialise in expat and internationally mobile clients — covering tax, investments, estate planning, and offshore structures.