Located under the Reports, Management Reports menu, the Assets Under Management report lists all accounts under management with market values of as of the report date. Note: Investments marked as unmanaged assets are excluded from the report.
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 Products
Security Category Asset Classes
Security Underlying Holding Asset Allocations
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.
Click here for a report sample.
The information below describes each column of the report.
Account Name - The names of all accounts that are under this advisor's management. When a client's accounts are split between advisors in the firm, the Display Split AUM Portion only report option determines what is included on the report.
Account Number - The associated account number for all accounts under the advisor's management.
Security Type - The market value of each security type as of the report date. Security types include Bond, Cash, Equity, Derivative, Managed Product, Others.
Total Account - The total market value of each account.