In the As of Date box, type the date (mm/dd/yyyy) or use the calendar icon to select the date as of which you want to run the report.
In the Custodian field, from the drop-down menu choose Select Custodian or All. When Select Custodian is chosen, you are prompted to select one or more custodians to include in the report. Only assets associated with the selected custodians will appear on the report.
In the Report Type field, use the drop-down menu and select to generate the report in PDF or Excel Table format.
When using Excel Table format, select from the following options:
Display information by Percentage, Amount or Both
Report Asset class information by:
Investment Product
Security Category Asset Class
Security Underlying Holding Asset Class
Note: When you select Excel, these additional data points are included on the report: Current Custodian, Accounts Managed by, and Investment Strategy.
Filter the data according to options selected for each account under the Account Profile.
Select one or more of the checkboxes associated with Business Type.
Use the drop-down menu to limit the types of accounts, or select Both to include each type of account. These options are available for: Discretionary Accounts, Third Party Managed Accounts, and Related Person/Proprietary Accounts.
Select Yes or No to include additional types of accounts. They include: Quick Floating Accounts, Quick Fixed Accounts, and Shared Accounts.
For the Display Split AUM Portion only option, use the drop-down menu to select Yes or No. When a client's accounts are split between advisors in the firm, and this option is set to Yes, only the portion of the client's assets under management by the advisor running the report will be shown on the report. When this option is set to No, all of the client's assets will be shown on the report.
Click OK. The report is generated.