Family Office and Private Bank Consolidated Reporting: What to Look For

Short answer: consolidated reporting brings everything a family or private client owns, across banks, custodians, entities, trusts and currencies, into one book valued in a single base currency, with performance, exposure and liquidity calculated from the same transactions. Look for a tool that builds the book from transactions rather than uploaded statements, restates history when a late booking lands, puts a second approver on every change and issues statements the family can read in English or Arabic.

A family with wealth at five banks receives five statements, in five formats, on five dates. Each is correct on its own terms, and none answers the principal's questions: what do we own in total, how has it performed, and what can we spend? Private banks meet the same problem when one client holds accounts across several entities. For a wider view of what Gulf family offices run, see our family office technology guide.

Consolidation: Custodians, Entities, Trusts and Generations

A family book has two dimensions: where assets are held (banks, custodians, brokers, direct holdings) and who owns them (individuals, joint accounts, holding companies, trusts, foundations and, over time, the next generation). Good consolidation keeps both.

• Every position knows its owner and its custodian, and each owner can hold accounts at as many banks as needed.
• Reports cut by person, entity, branch of the family, custodian or the whole family.
• Ownership is dated, so a transfer into a trust changes reporting from that day without rewriting history.
• Access follows the role: a family member, adviser or trustee sees only what they are entitled to see.

Base Currency, Valuation and Exposure

• Every currency converts at a dated exchange rate, and a missing rate is shown as missing.
• Bonds and sukuk are valued at clean price plus accrued interest or profit; deposits at principal plus accrued interest.
• The valuation is frozen per day and restated when a back-dated transaction lands, with old and new figures kept.

The total is the first number the family reads; exposure is the second. The consolidated book should show asset class, currency, country, issuer and liquidity, so the committee sees concentration no single bank can show: the same issuer held through three custodians. Where the family invests through funds or holding companies, ask how far look-through goes and where its data comes from.

Performance: TWR, MWR and Benchmarks

• Time-weighted return (TWR) removes the effect of contributions and withdrawals, so it measures the manager or the strategy.
• Money-weighted return (MWR, or IRR) includes the timing of the family's own cash flows, so it measures the family's experience. Private investments with capital calls are usually judged on it.
• Both should be calculated from transactions, over standard periods, against a benchmark or target return.
• A value bridge (opening value, net flows, income, market movement, closing value) explains the change.

Liquidity and Cash

Reporting must answer "what can we spend, and when?" That needs settled cash per account and currency, a forward ladder of expected inflows and outflows (coupons, maturities, capital calls, distributions) and what the liquid holdings could raise within 7, 30 and 90 days.

Statements and Private Bank Client Reporting

Statements should be numbered, issued on a schedule, frozen exactly as sent and written in the language the client reads; in the Gulf that usually means English and Arabic. Private banks serve two more audiences: the relationship manager, who needs a dashboard of each client's portfolios, exposure, allocation, mandate and risk profile, and the client, who expects the same figures in a branded web and mobile app. All three should come from one set of numbers.

Data Aggregation, Reconciliation and Governance

Consolidated figures are only as good as the confirmations, bank statements, custodian files, price feeds and manual entries beneath them. The tool should:

• import trades, prices and history from files, checked row by row;
• load the opening position and reconcile it to the trial balance before go-live;
• reconcile corporate action results to what the custodian actually paid or delivered;
• keep double-entry accounting underneath, so the statement, the committee pack and the balance sheet agree.

A second person approves large trades, payments out, transfers, corporate actions and manual prices. Corrections are reversals, never deletions, and every figure traces to who entered it, who approved it and when.

Questions to Ask a Vendor

• Can one book hold every person, entity, trust and custody account, with reports for each and for the whole family?
• Is the valuation built from transactions, or from uploaded statements?
• What happens to past valuations, returns and statements when a back-dated trade is booked?
• Are both TWR and MWR available, and against which benchmark or target?
• Can statements be issued in Arabic and English, numbered and frozen as issued?
• Do relationship managers and clients see the same figures as the back office?
• How is our existing book loaded and reconciled before go-live?
• Does the tool also record trades, cash and accounting, or does that stay in spreadsheets?

How ZagTrader Handles It

ZagTrader Investment Office is its own product on the ZagTrader platform: the book of record for single- and multi-family offices, investment offices and holding companies, with its own ledger, reference data and screens, and one ZagTrader login.

• One family book: every beneficiary, portfolio and custody account at every custodian, with cash and holdings by custodian and a consolidated family view in one base currency. Each family can be its own organization, and operators see only the families they serve.
• Valuation: a daily valuation frozen per beneficiary, with bonds and sukuk at clean price plus accrued coupon or profit and every currency at its dated exchange rate. A back-dated booking restates every affected day, with the old and new NAV recorded.
• Performance and exposure: time- and money-weighted returns against your target, and a CIO Cockpit with value bridge, allocation against policy, concentrations, liquidity ladder and stress tests, printable as an investment committee pack. Shariah share, currency, issuer, country, unrated and liquidity limits are checked daily and before each trade.
• Liquidity: settled cash per custody account, a cash ladder per currency and what holdings could raise within 7, 30 and 90 days.
• Data and reconciliation: the opening position loaded from a template, reconciled to your trial balance and approved before it books; history and trade import from files; prices from the platform feed or approved manual sheets, with unusual moves held for review; custodian figures on rights issues reconciled before booking.
• Reports and governance: Asset Summary, Holdings, Allocation and Fixed Income Analysis with duration and DV01, scheduled report packs, and numbered statements in English or Arabic, frozen as issued and e-mailed as password-protected PDFs. Large trades, every payment out, transfer, corporate action, mandate limit and price sheet wait for a second manager, corrections are reversals, and the audit trail is complete.

For private banks and wealth managers running mandates across many client accounts, Portfolio Management & Wealth reports NAV, AUM, net flows, time- and money-weighted returns and realized P&L from Today to since inception, with benchmark comparison and attribution, and branded consolidated statements in several languages and currencies. Relationship managers get dashboards of each client's portfolios, exposure, allocations, mandates and risk profile, and clients see portfolios, performance and statements in a branded web and mobile app. ZagTrader for family offices also combines individual, joint, trust and corporate accounts, foundations and operating companies into consolidated family views, tracks private equity and real estate with capital calls and distributions, and provides tax-lot tracking and tax-ready reports for accountants and advisors.

ZagTrader is ISO 27001 certified, more than 100 institutions run on ZagTrader technology, and the platform has been in production since 2009.

Related: see Investment Office, ZagTrader for Family Offices, ZagTrader for Private Banks, and our guide to family office technology in the Middle East.