Service 05

Client Reporting

Reporting is the moment when every other discipline is tested. It is where data quality, risk analytics, and operational integrity either prove themselves — or expose the gaps that have been quietly accumulating underneath.

The question most family offices are asking

"Our principals receive a board pack every quarter. But if a trustee asks a question we haven't anticipated, we cannot always answer it from the numbers we've provided."

Reporting that cannot withstand an unexpected question has not been designed for governance — it has been designed for presentation. The difference matters, and it starts with how the reporting is built, not how it looks.

The challenge

Reporting produced is not the same as reporting designed

Most family offices produce reporting. The question is whether that reporting is doing the job it needs to do — enabling principals and trustees to govern with confidence, ask informed questions, and make decisions on the basis of information they understand and trust.

Reporting that is assembled manually from disparate systems, formatted to look complete, and distributed on a schedule is not a governance tool. It is an output. The distinction is whether the principal who receives it can trace any number back to its source — and whether a trustee who challenges a figure receives a clear, documented answer.

Designing reporting as a governance discipline — with accurate inputs, a consistent methodology, and output structured around decisions rather than data — is a different undertaking from producing a board pack. It is what Caelion brings from institutional delivery environments where the quality of reporting is scrutinised at every level.

Where reporting fails governance

—

Numbers that cannot be explained

Figures produced by a process that has never been fully documented. When a trustee asks how a performance number was derived, the honest answer is that it depends on who you ask.

—

Inconsistency across reporting periods

Methodology changes quietly between periods — different benchmarks, different valuation dates, different scope — making period-on-period comparison unreliable without knowing what changed.

—

Data assembled manually before every report

Reporting produced by extracting data from multiple systems, applying manual adjustments, and hoping nothing has changed since the last extraction. Error-prone, time-consuming, and not auditable.

—

Reporting structured around data, not decisions

A board pack that presents everything the family office tracks — rather than the specific information trustees need to govern, in the order they need to consider it.

—

No single version of the truth

The principal sees one set of numbers. The portfolio manager has a different view. The custodian statement reconciles to neither. When all three need to agree, no one is sure which is right.

What reporting needs to do

Reporting structured around governance, not presentation

Good client reporting serves a specific governance function for each audience it reaches. The Investment Committee needs a risk and performance view that connects to the Investment Policy Statement. The principal needs a portfolio summary they can act on without a briefing. The trustee needs assurance that what is reported is accurate, complete, and consistent with previous periods.

Designing reporting that does all of this — from a single governed source, on a repeatable methodology — requires the same discipline as any other front-office infrastructure project. It is not a design exercise. It is a data, systems, and governance exercise that happens to have a document at the end of it.

Performance

Absolute and relative returns across asset classes and time periods — benchmarked consistently, with attribution that connects performance to decisions rather than to market movements the portfolio could not control.

Risk

Consolidated risk exposure — duration, yield, spread, concentration, liquidity — structured for the Investment Committee meeting rather than extracted from the risk system and pasted into a slide.

Compliance

Mandate compliance status — what the IPS permits, what the portfolio holds, and whether any limits are approaching or have been breached. A governance record, not a retrospective check.

Portfolio summary

A consolidated view of the total portfolio — positions, valuations, cash flows, and asset allocation — reconciled to the custodian and traceable to source data. The document the principal can rely on.

ESG & impact

For families where sustainability or impact objectives form part of the mandate — reporting that tracks and evidences progress against those objectives alongside financial performance.

What Caelion delivers

Reporting that withstands scrutiny

Reporting framework design

Designing the end-to-end reporting framework — what is reported, to whom, on what frequency, from which data sources, with what methodology — before any report is produced. The framework that makes reporting consistent, auditable, and scalable as the family office grows.

Data pipeline and source governance

Establishing the governed data pipeline that feeds reporting — connecting portfolio systems, custodian data, pricing feeds, and risk analytics into a single, validated source. Reporting is only as reliable as the data that feeds it. Building the pipeline correctly is the prerequisite for reporting that can be trusted.

Performance measurement and attribution

Designing the performance methodology — benchmark selection, calculation basis, attribution framework — and implementing it consistently across reporting periods. Performance reporting that a trustee can interrogate and a portfolio manager can use to evaluate decisions. Drawing on direct FactSet Performance & Risk delivery experience at a Gulf sovereign wealth fund.

Board pack and IC meeting pack design

Structuring the board pack and Investment Committee meeting pack around the decisions that need to be made — not around the data that happens to be available. Each section with a clear purpose: what are trustees being asked to note, review, or approve? Reporting designed for a meeting, not a distribution list.

Custodian reconciliation and data validation

Implementing the reconciliation process that validates reported figures against custodian records before distribution — so that discrepancies are resolved before the trustee sees them, not after. The discipline that converts reporting from a process into a governance control.

Reporting automation and AI integration

Where appropriate, introducing automation to reduce the manual effort in report production — connecting governed data sources to report templates, with AI tools applied to data aggregation and narrative generation under a defined governance framework. Automation that increases reliability, not one that introduces new sources of error.

How Caelion approaches reporting

Six principles that separate governance reporting from production reporting

Accuracy before presentation

A report that looks authoritative but contains an error is worse than no report. Every number must be traceable to a governed source before formatting begins. Presentation is the last step, not the first.

Consistent methodology

Period-on-period comparisons are only meaningful if the methodology is consistent. Benchmark changes, scope changes, and valuation basis changes must be documented and disclosed — not quietly applied.

Structured for decisions

Every section of a board pack exists to support a specific decision or governance function. If it does not, it should not be there. Reporting designed around what trustees need to do — not what the family office wants to show.

Single source of truth

All reporting produced from the same governed data pipeline — so that the principal, the portfolio manager, and the trustee see consistent numbers, derived from the same source, at the same point in time.

Auditable and explainable

Every figure in every report must be explainable — from its source data, through every transformation, to the number on the page. If a trustee asks how a figure was derived, the answer is documented and verifiable, not dependent on the person who produced the report.

Scalable without proportional cost

Reporting built on governed data pipelines and automation scales as the family office grows — without requiring proportionally more manual effort. The reporting infrastructure that works for five beneficiaries should work for fifteen, without rebuilding from scratch.

Delivery experience

Built where reporting quality is non-negotiable

The reporting discipline behind Caelion was developed in institutional environments where the quality, accuracy, and consistency of reporting is subject to ongoing scrutiny — from regulators, boards, and sophisticated investors who know exactly what they are looking for.

Translating that institutional standard into a family office reporting framework — proportionate to the family office's scale, structured for its specific stakeholders — is the discipline Caelion brings to every reporting engagement.

Read the case study

a Gulf sovereign wealth fund

FactSet Performance & Risk implementation — shaped the data integration and validation framework directly with the Heads of Performance and Risk. Performance and risk attribution delivered to the investment committee from a single, governed source. The reporting infrastructure that made the five-year IT strategy visible to the board.

a Tier 1 UK fixed income manager

Fixed income risk analytics dissemination — designed and delivered the platform that gave portfolio managers, compliance, and trustees a single, accurate view of duration, yield, and spread. The reporting framework that connected risk analytics to governance — not as a data output, but as a decision-support tool.

one of the largest US investment houses

MiFID II trade and transaction reporting — end-to-end regulatory reporting delivery with direct accountability to compliance and front office leadership. Regulatory reporting requires the same discipline as governance reporting: accuracy, consistency, and an auditable process that survives scrutiny.

Engagement model

Every engagement is led by a senior practitioner with direct accountability to the client. Scoped against defined outcomes — agreed before work begins.