Know where every number came from
Connect holdings, transactions, cash flows, product status, market data and FX to their source. When a number changes, the team can identify the input and the processing step.
Turoid Insight · Reporting Operations
Why do the same family office assets show different numbers across reports?
Usually, the calculation is not the root problem. The underlying data source, portfolio scope, valuation time, display currency, product status or review process is different.
10 Aug 20266 min readEnglish adaptation
Short answer
Consistency starts before the report.
A reliable report needs a shared portfolio scope, traceable source data, one display-currency policy and a controlled review-and-release workflow. Without those controls, polished PDFs can still disagree.
Why numbers diverge
Each team may be working from a different version of the portfolio
An RM may use a client-facing workbook, operations may use the latest bank files, and management may receive a PDF prepared on another date. Manual consolidation hides these differences until someone asks why two totals do not match.
Six questions to settle
- Which custodians, administrators and files are authoritative?
- Which clients, entities and accounts are included?
- What valuation date and market-data cut-off apply?
- Which FX rates and display currency are used?
- How are structured products and alternatives classified?
- Who reviews exceptions before the report is released?
A practical operating model
Three capabilities that make reports consistent
Use one portfolio scope and display-currency policy
Retain original currencies while presenting one approved display currency. Apply the same client, entity and account scope across review screens, management views and published packs.
Review the portfolio before exporting
Check positions, allocation, trades, cash flows, structured-product status, performance and currency assumptions. Record exceptions and approvals before the PDF leaves the system.
Shared fact base
Reporting is a cross-team workflow
Relationship managers, operations, investment teams, management and compliance should not reconcile separate spreadsheets at the end of the month. They should review the same portfolio record throughout the process.
Recommended sequence
- Register and validate data sources
- Review portfolio and account scope
- Set display currency and reporting basis
- Define the report scope
- Resolve exceptions and approve
- Export and deliver the report
Continue reading
Build a more dependable reporting workflow
Start with one workflow
Identify the point where your reports begin to diverge
Turoid can help map one reporting workflow—from source files and portfolio review to controlled report delivery.