Data requirements for Model Reporting
These are the fields that should be reviewed by the team to make sure the dissemination of information meets all parties approval.
Reports should be grouped by manager (each manager have one report with multiple strategies/IDs)
Date of sleeve inception
Inception Value
Current Month-end Value
Account identifier (number)
Manager Name
Manager Strategy
Manager ID
Client Firm Name
Advisor Name
Advisor Phone
Advisor City, State
Things to consider, how often should the report be made available (this may vary by sponsor and manager needs).
How and when are contributions and distributions reported and tracked. Also new sleeves, while original inception of a sleeve is easily defined when a new sleeve is opened inter quarter how should that be billed and reported?
Here are the fields that we are currently providing to our Manager Model Providers. It looks very similar to the list that James provided.
Period
Account number, Internal
Account number, Custodian
Manager Name
Investment Style
Internal manager code
Value of Sleeve at quarter or month-end
Manager Rate
Days
Manager Fee
Firm Name
Rep Name
Rep City
Rep State
