Current vs Model Portfolio Report

The purpose of the Current vs. Model Portfolio report is to compare the breakdown of the account's asset allocation with a model portfolio that has been created under the Workspace tab. Click here for more information on working with asset allocation sets.

To access the report, open either a transactional or quick account and then from the top menu, click on Reports, Portfolio, Current vs. Model Portfolio.

Note: This report can also be generated from the client level as an aggregated or segregated report for all accounts within the client. Additional options are available when generated from the client level.

Report Options

1. Click the drop-down menu and select Yes or No to include a Cover Page.

2. Set the As of Date for the report. The date can be typed into the field or use the drop-down calendar to select a date.

3. Specify the Asset Allocation to be used. This will be the allocation that the report will be based on when displaying asset classes. Options include Morningstar Security Category, Morningstar Consolidated, Morningstar Basic, and Morningstar Expanded, as well as any manually created asset allocations. Click here for instructions on creating a custom asset allocation reporting set.

4. Use the drop-down menu to select the Model Portfolio that will be used to compare with your current accounts.

5. Use the drop-down menu to select the Report By option. This determines how the asset allocations will be displayed, either by Asset Class Only or by Asset Class with Security.

6. From the drop-down menu, select how the Report Type will be displayed. Options include PDF or Excel format.

7. When checked, the Hide 'Symbol' Column option, removes the Symbol column from the report.

8. The Add 'Recommended Portfolio Asset Allocation' Column option can only be selected if the Hide Symbol Column option is checked. When selected, this option displays the dollar value of what the model portfolio suggests should be held for each asset class and security.

9. Select Mask Account Number to limit the amount of an account number that is displayed on the report. This inserts a level of security when reports are e-mailed to clients or uploaded to the Web via the Client Web Portal. Click here to see how the masked account number will be represented (based on the number of characters in the account number).

   Number of Characters in Account Number	Masking Formula
   6 or less characters	All characters are presented as an asterisk (*)
   7 characters	Only character 3 is an asterisk (12*4567)
   8 characters or more	The account number shows the first two numbers and the last four numbers. All numbers in between are represented by an asterisk. Examples: 8 characters = 12**5678 15 characters = 12*********2345

    

10. If you choose to include a Cover cuPage, you can also use the option to Add disclosure to cover page. Click here for more information.

    Prior to selecting this option, the cover page disclosure must be set up under the Home tab, Settings page. Under the Portfolio Account System Settings, select Reports, Tax Lot Methods, Transactions, Management Fees settings. From the toolbar above the grid, select New Disclosure, and then New Cover Page Disclosure. Once the new disclosure is saved, you are returned to the Settings grid where you should now be able to see your disclosure listed.

    Once the disclosure has been created, you will need to associate the disclosure with a Report Setting from the Settings grid. Make sure this is the Report Setting that is then attached to the account (Profile/Settings, Account Settings, Reports). If your Account Settings reflect Use Client Default Setting, make sure the correct Report Setting is selected at the Client level.

11. When selected along with using a cover page, the Add blank 2nd page option inserts a blank page between the cover page and first page of the report.

Additional Client Level Report Options

When the Report Accounts Aggregated option is selected, the program combines all the client's accounts and treats them as one account. If the Report Accounts Segregated option is selected, all of the client's accounts are displayed individually within one PDF. The options can both be selected and will generate two separate reports.

Report Contents

Click here for a report sample.

The information below describes each column of the report.

Account Name - This heading changes based on the selected account type. It will be the account name if the report is for a single account, "account aggregates for 'client name'" if the report is for account aggregates, or "client aggregates for 'client name'" if the report is for client aggregates.

Asset Allocation Graphs - Portfolio Asset Allocation and Model Portfolio Asset Allocation graphs appear on the top portion of the report. These appear as pie charts unless a negative allocation is held. That would require a bar graph to be displayed in order to show the negative value. The graphs appear side-by-side for ease of comparison from the portfolio to the model portfolio. The assets listed are determined by the Asset Allocation specified on the Report Options screen.

Description - This changes based on the Report By option selected. The Asset Class Only option shows only the class name, while the Asset Class with Security option displays the class name and any securities that are included in the class.

Symbol - The security identifier for each security detailed under each asset class. This column appears blank if the option was not selected to show securities.

Current Market Value - The market value as of the report date for the asset class. If securities are shown as part of the class, their individual market values are also displayed.

Current Portfolio Asset Allocation (%) - The percentage of the portfolio held in each asset class. If securities are shown as part of the class, their percentage of the total portfolio is also displayed.

Recommended Portfolio Asset Allocation (%) - The percentage of the class and/or security that the model portfolio suggests should be allocated for each.

Difference - The percentage that needs to be reallocated within the class to reach the recommended allocation percentage.

Approximate Transaction Value - The approximate reallocation value needed within the class to reach the desired allocation percentage.