Reporting and Consolidation for Multifamily Offices

Multifamily offices manage many entities, accounts, custodians, properties, partnerships, and family decisions at the same time. Reporting and consolidation turn that information into a usable operating picture. The work includes collecting source data, checking it, assigning ownership, consolidating results, and presenting decisions in a format that family members and trustees can understand. This guide explains the process, the controls, and the questions to ask when comparing providers.

What reporting and consolidation mean

Reporting is the production of recurring information for a defined audience and purpose. A monthly investment report may show market value, time-weighted return, cash flows, fees, and exposure. A family balance sheet may show assets, liabilities, ownership, and liquidity. An operating report may track household expenses, staffing, property income, capital projects, insurance, and payments. Consolidation combines information from multiple accounts or legal entities into one view while preserving the underlying ownership and source records.

A multifamily office usually needs several views of the same data. The family may want a simple net worth summary. An investment committee may need performance by manager, strategy, currency, and risk bucket. A trustee may need a beneficiary and entity schedule. The chief financial officer may need an accounts payable aging report and a 13 week cash forecast. These reports should agree on the underlying facts, even when they use different layouts.

The goal is a controlled reporting process. A report should state its period, valuation date, currency, ownership basis, source systems, and material assumptions. It should distinguish market values from cost, realized results from unrealized results, and cash activity from accrual activity. Without those labels, a polished report can still mislead its reader.

Build a reporting data model first

Consolidation works when every record has a clear identity. Start with a master data model that assigns a unique identifier to each family member, trust, foundation, partnership, company, property, account, investment, and liability. Record legal name, common name, jurisdiction, ownership percentage, controlling person, reporting currency, tax status where relevant to the reporting purpose, custodian, and responsible internal owner.

Use an ownership tree for legal ownership and a separate economic exposure view when they differ. For example, a trust may own a limited partnership interest, while the family has an economic interest through several beneficiaries. Combining those concepts in one field creates errors. Keep legal ownership, beneficial interest, voting control, and reporting treatment as separate attributes.

Create a chart of accounts that works across entities. Map local account names into a common reporting taxonomy, but retain the original account and entity. The same expense can have different local labels. A common taxonomy supports group reporting, while the source label supports review and audit. Keep version history when an account mapping changes. A report for December should remain reproducible after a mapping update made in February.

Collect source data with a defined hierarchy

Source data should come from the system that owns the record. Custodian statements and approved feeds generally support securities positions and cash. General ledgers support booked income and expenses. Property systems support rent rolls, occupancy, maintenance, and capital projects. Payroll systems support compensation and employer costs. Loan statements support principal, interest, covenants, and maturity information. A family office should document which source controls each field.

Set a cut off calendar. Each source owner should know the reporting date, delivery deadline, file format, and review contact. Late data should be marked as pending instead of silently carried forward. When estimates are necessary, label them, record the method, and replace them when final information arrives.

Use secure transfer and access controls. Apply the requirements and policies that fit the office's activities, contracts, and jurisdictions, and obtain professional compliance advice where needed.

Reconcile before consolidating

Reconciliation compares an internal record with an independent source and explains differences. For investments, compare positions, quantities, prices, accrued income, cash, corporate actions, and transaction dates to the custodian statement. For operating entities, compare the reporting ledger to bank accounts, accounts payable, accounts receivable, debt statements, and intercompany balances.

Define tolerances by data type. A small price difference may be acceptable during a feed timing gap, while a missing security, duplicate transaction, or ownership change requires investigation. Each exception should have an owner, status, cause, correction, and review date. Keep a reconciliation sign off that identifies who performed the review and who approved the final result.

Reconciliation also catches stale data. A portfolio may show a position that was transferred months ago. A property may show a tenant as active after a lease ended. A trust may retain an old beneficiary percentage. These errors can flow into performance, liquidity, and planning reports unless the master data review is part of the close process.

Choose a consolidation basis

A report must state what it consolidates. Common bases include legal entity consolidation, family economic ownership, investment look through, and management reporting. Legal entity consolidation follows the applicable accounting framework and may eliminate intercompany activity. Economic ownership allocates assets and liabilities according to the family's beneficial interest. Investment look through breaks a pooled vehicle into underlying exposures when reliable holdings data are available. Management reporting may group assets by decision maker, strategy, or liquidity rather than legal ownership.

Do not combine bases without labeling them. A family net worth report can show total asset value, but it should also show the ownership percentage and whether debt is included. An investment exposure report can show a private fund's estimated exposure to real estate, but the estimate should be identified as look through data and dated. If an underlying manager reports with a lag, state the lag and the valuation convention.

Currency treatment deserves its own policy. Select a presentation currency, document exchange rate sources and dates, and separate changes caused by market performance from changes caused by foreign exchange where that distinction matters. The policy should apply consistently across periods.

Performance and fee reporting

Performance reports need a stated return method and time period. Time-weighted return is commonly used to evaluate an investment manager because it reduces the effect of external cash flows. Money-weighted return reflects the timing and size of those cash flows and can be more useful for evaluating the investor's experience. The report should identify which method it uses, whether returns are gross or net of fees, and how valuations and cash flows are treated.

Show fees in a way that supports decisions. Separate management fees, incentive or performance fees, fund expenses, custody charges, advisory fees, and one time costs when the data allow. Reconcile billed fees to contracts, fee schedules, and account statements. A performance result without its fee basis is incomplete.

For private investments, include valuation date, valuation source, estimated versus final status, unfunded commitment, distributions, and cash flow history. A private asset that has not been revalued for several months should not appear equivalent to a daily priced security. The report can still include it, but the timing and uncertainty need to be visible.

Reporting for family decisions

A useful monthly package begins with a one page summary. Include total net worth or portfolio value, change from the prior period, liquid cash, near term obligations, major inflows and outflows, and unresolved exceptions. Follow with supporting schedules that readers can trace back to source records.

A quarterly package can add asset allocation, manager performance, concentration, liquidity by time horizon, private investment commitments, debt maturities, property operating results, and philanthropic activity. An annual package can include a full entity roll up, realized gains, tax information delivered by custodians or accountants, insurance schedules, estate planning document status, and a record of major approvals.

Use role based detail. Family members may need a clear summary and a few decision pages. An investment committee may need manager level attribution and exposure analysis. An operations team may need invoice status and cash forecasts. A trustee may need beneficiary, distribution, and fiduciary records. One report rarely serves every audience well.

Controls, security, and continuity

Reporting systems hold sensitive financial and family information. Apply least privilege access, multi factor authentication, encryption in transit and at rest, activity logging, vendor due diligence, and a documented process for removing access when roles change. Keep a retention schedule that matches legal, regulatory, contractual, and operational requirements.

Maintain a written close checklist and a change log. A change log should show changes to ownership, accounts, mappings, valuation policies, report formulas, and user permissions. Back up source files and completed reports in a way that permits recovery after a system failure. Test restoration periodically and record the result.

Business continuity should cover people as well as systems. At least one trained backup should know the close calendar, key contacts, data locations, and escalation path. A reporting process that depends on one person creates operational risk even when the software is reliable.

How to evaluate a reporting provider

Ask the provider to show a sample close calendar, reconciliation workflow, exception log, ownership model, and final report package. Confirm which data sources are supported, how private assets are handled, how historical corrections are recorded, and how reports can be reproduced for a prior period.

Ask who performs data review, who approves the final package, and where work papers are stored. Request service levels for data delivery, issue response, and report release. Review the contract for confidentiality, security responsibilities, subcontractors, termination assistance, data export, and ownership of work product.

Ask for references with similar complexity. A firm serving a family with public securities only may have a different process from one handling operating companies, trusts, property partnerships, and private funds. The match should be based on reporting requirements and control depth.

Finally, compare total cost. Include implementation, data cleanup, recurring reporting, special projects, integrations, user access, and historical restatements. A lower recurring fee can be offset by manual work, limited controls, or extra charges for the reports the family actually needs.

A practical implementation sequence

Start with a reporting inventory. List every recurring report, audience, decision supported, period, source, owner, and deadline. Remove reports that no one uses, then define the minimum package that must be accurate every month.

Next, clean the master data and ownership tree. Confirm entities, accounts, currencies, custodians, managers, and reporting treatments. Build the chart of accounts and mapping table. Run one historical period through the model and investigate every material difference.

Then document the close. Set cut off dates, source responsibilities, reconciliation steps, exception thresholds, approval points, and release rules. Produce a parallel report for at least one cycle so users can compare the new output with the existing process.

After launch, review the process quarterly. Track late sources, recurring exceptions, manual adjustments, restatements, report usage, and time spent. Improve the data model when a new entity, custodian, investment type, or jurisdiction appears. The reporting system should change through controlled updates rather than informal workarounds. Keep the prior report, source files, and adjustment record together when a period is restated.

Key takeaways

• Define ownership, reporting basis, valuation date, currency, and source systems before building consolidated reports.
• Use the system that owns each record, then reconcile positions, cash, transactions, liabilities, and operating data before release.
• Keep legal ownership, economic exposure, and investment look through views separate and clearly labeled.
• Report performance with a stated return method and show fees, valuation dates, commitments, and data lags.
• Evaluate providers on controls, data quality, security, continuity, implementation work, and total cost.

FAQs

Sources

1. FASB, Accounting Standards Codification
2. NIST, Cybersecurity Framework 2.0
3. NIST, Digital Identity Guidelines
4. U.S. Securities and Exchange Commission, Investment Adviser Public Disclosure