The List of Accounts report, located under the Reports, Management Reports menu, generates a list of all active client accounts as of the selected report date. This list includes Quick accounts and transactional accounts, and can be generated in PDF or Excel format. Accounts are excluded from this report if:
An account is marked as Exclude from Client Aggregate (grayed out).
An account close date is entered in the account profile using a Close Date that is before the As of date used to generate the report.
A transactional account does not have any transactions, or a quick account does not have value.
In the As of Date box, type the date (mm/dd/yyyy) or use the calendar icon to select the date for when you want to run the report.
Use the drop-down menu in the Report Type option to select to generate the report in PDF or Excel Table format.
Click OK. The report is generated.
Click here for a report sample.
The information below describes each column of the report.
Client/Account Name - The name of the client and account.
Account Number - The account number associated with the account.
Account Owner - The name of the member of the client who owns the account.
Investment Strategy - The investment strategy associated with the account. This is established under the account's Profile/Settings area, on the Account Profile page.
Account Type - The type of account as established under the Account Profile page.
Account Start Date - This refers to the earliest Trade Date in the system for transactional accounts or the Created On date for quick accounts.
Market Value - The current market value of the account. The figure takes into account all options selected by the user, including sales charges, reinvestment of dividends and capital gains, sell shares to pay taxes, and whether or not the holding has been liquidated. When calculating the market value for a holding, the calculation varies based on the type of investment. Click here for calculations.