Financial Services CloudAdvancedrollupsaumreporting
Design Financial Account roll-ups and performance reporting
Real World Scenario
Household AUM report disagrees with custodian statement by 3% due to roll-up configuration errors.
Expected Answer
• FSC roll-up definitions specifying which FA types included AUM
• Exclude closed accounts and internal house accounts per policy
• Multi-currency conversion dated rates corporate currency
• Held-away manual FA vs feed-updated managed FA consistency
• Reconciliation dashboard exceptions above tolerance
• CRM Analytics dataset certified AUM metric definition
• Document calculation methodology for advisor trust
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Direct answer: FSC roll-up definitions specifying which FA types included AUM Also consider: Exclude closed accounts and internal house accounts per policy In practice: Multi-currency conversion dated rates corporate currency Optimize for scale and operational observability.
Architect Perspective
AUM is regulated metric—one firm-wide definition in roll-up config not per office spreadsheet.