CRM FEATURES
New Feature – Smart Search
Client Management > Smart Search
Portfolio Management > Smart Search
You can now conduct client and account searches using multiple data points. Smart search allows you to mix and match account and client management data into one search. An example of a Smart Search could include creating a search to filter clients over 50 who own 401(k) accounts. This search would include two data points: account category and age.
Once created and saved, you can run searches from the “view” window on the grid-view tool bar within the following pages.
Clients/Prospects, which run searches at the household level
Contacts (new page under the Client Management tab), which runs searches at the individual member level
Accounts, which run searches at the individual account level
In addition, you can use a saved smart search when creating and adding members to a group.
IMPORT
Ability to Import Cost Basis Files from Pershing InfoDirect and Fidelity Wealth Central
Subscribers who use Pershing InfoDirect or Fidelity Wealth Central have the ability import open tax lot files in order to track and report cost basis data for their clients. These users also have the ability to reconcile and edit tax lot data, to ensure data between Office and your custodian matches.
For more information on importing and reconciling cost basis data, see the online Help content.
Performance enhancement decreases time for posting data
Import > Reconcile and Post Account Data
An enhancement increases posting performance and decreases the amount of time it takes data to post. Previously, posting large amounts of client and account data could take several minutes
Social Security Number field expanded to hold fifteen characters
Users can now import Social Security numbers with up to 15 characters. This alleviates issues that can arise when a custodian provides a Social Security number longer than nine characters. Morningstar Office will extract the true Social Security number from the extraneous characters sent with this field.
Morningstar Workstation added as an Import Interface
Import > Action > Edit Import Interfaces > Morningstar Principia/Morningstar Advisor Workstation (XML)
Subscribers can now import data from Morningstar Advisor Workstation. In this process, data is exported from Advisor Workstation, saved to your hard drive, and then imported into Morningstar Office. See the online Help for information on this procedure.
Client Name Column added in Tax Lot Blotters
Import > Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, or Excluded Lots
A new Client Name column has been added to all tax lot blotters (Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, and Excluded Lots), to identify the client account owner.
Client Name Column added in Tax Lot Blotters
Import > Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, or Excluded Lots
A new Client Name column has been added to all tax lot blotters (Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, and Excluded Lots), to identify the client account owner.
Reconcile button added to all Lots Blotters
Import > Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, or Excluded Lots
A Reconcile button has been added to all tax lots blotters (Imported Open Lots, Matched Lots, Mismatched Lots, Mismatched Cost Basis, and Excluded Lots). Subscribers can reconcile each blotter by clicking the Reconcile button without leaving the blotter.
Mapped Account Name column added to Transactions Blotter
Import > Transactions blotter
A Mapped Account Name column has been added to the Transactions blotter. This column identifies the account name in Morningstar Office a transaction is mapped to.
Edit multiple rows simultaneously for the Morningstar Mapped Security Type data point in Transactions Blotter
Import > New User-Defined Securities Blotter
The Morningstar Mapped Security Type data point in the Transactions blotter can be edited for multiple rows simultaneously instead of one at a time. This update speeds the process of identifying security types if the security type is incorrect or missing for multiple securities of the same type.
Investment Planning
Create Multiple Scenarios for a Plan
Investment Planning > Plans > Forecast page
You can create up to seven scenarios (or versions) of an Investment Plan. This will help you provide alternatives or comparisons to the primary scenario and alleviates the need to recreate a Plan from scratch if you need to adjust just one or two variables. With this feature, a new scenario is created on the Forecast page of the primary plan and a Scenario Name drop-down field has been added to the toolbar, allowing users to change the scenario being displayed.
Two new report sections are available as well on the Reports page of the Investment Plan window:
• Detailed Comparison Scenarios, and
• Scenario Comparison Summary.
Portfolio Accounting
Exporting Client and Account Data Limits Expanded
Client Management / Portfolio Management >Clients>Tools>Export>Account Positions
The export limit for client records has increased from 500 rows to 2,000. The limit for accounts has increased from 5,000 rows to 20,000.
New iRebal Export File Formats for Account Data Export
Client Management>Clients>Tools>Export>Account Positions > Group Account ID for Clients
Data can be exported in a new file format acceptable for iRebal in order for portfolio rebalancing to take place at the client (household) level. The new option titled Group Account ID for Clients in the Export Account Position by Lot screen creates the new file format. A new column in the Recent Exports section titled Accounts Grouped by indicates the grouping option selected during export. Please contact iRebal to verify this file format is acceptable before using the new file format selection.
Portfolio Reporting
New Data Set for Asset Allocation Pie Chart and Portfolio Asset Allocation Components
Report Studio > Pie Chart Component > Chart Settings > Data Sets
Report Studio > Portfolio Asset Allocation Component > Chart Settings > Data Sets
You can now select “Super Asset Class” as a data set for the Asset Allocation Pie Chart and Portfolio Asset Allocation components.
New Data Points for the Performance by Account Component
Report Studio > Performance by Account Component
The following two data points have been added to the Performance by Account component:
• Net Investment
• New Investment Gain/Loss
New Setting Option for Portfolio Evaluation Component
Report Studio > Portfolio Evaluation Component > Chart Settings
You can now choose to aggregate duplicate securities within the Portfolio Evaluation Component.
Two New Data Point Options for Portfolio Evaluation Component
Report Studio > Portfolio Evaluation Component
You can now choose to add the Account Name and Account Number to your data table when using the Holding Position view. Once selected, you can group your data by account, when creating a template for a household.
Enhancements to the Investment Growth Chart
Report Studio > Investment Growth Chart
The following features have been added to the Investment Growth Chart, Chart Settings:
A new option (Portfolio Market Value) is now available within the Data Point drop-down field
A Cumulative Contributions line is now available. The Cumulative Contributions option is available only when you select Portfolio Market Value from the Data Point drop-down field.
The Start Date and End Date can now be changed for the Investment Growth Chart within the Chart Menu on the tool bar.
New Template Setting
Report Studio > Home > Template
You can now choose to mask account numbers in Report Studio using the Template option under the Home tab. Account numbers will be masked throughout the template, including the header, footers, and all components.
Custom Header and Footers now available
In addition to standard headers and footers, you can now create custom headers and footers. Custom headers and footers act similar to a component, and allow you add banners and other images, as well as client and account notes. When using a custom header or footer, choose insert a copy rather than adding new pages. This will allow you to copy your custom header and footer throughout your template.
New Morningstar Templates added to Report Studio
Report Studio > Morningstar Template
Two new templates have been added to Morningstar Templates in Report Studio: Fixed Income Report and Household Performance Report.
New Calculation Data Points Added to X/Y chart, Security Performance table and Rolling Windows charts
Report Studio > X/Y Chart > Chart Settings
Report Studio > Security Performance
Report Studio > Rolling Windows Chart > Chart Settings
The following calculation data points have been added to the X/Y chart, Security Performance table and Rolling Windows chart:
Alpha
Alpha (non-excessive return)
Alpha T-Stat
Alpha T-Stat (non-excessive return)
Beta
Beta (non-excessive return)
Beta T-Stat
Beta T-Stat (non-excessive return)
Two New Management Reports Available (Excel)
Reports > Management Reports
Two new management reports have been added: Global Account Performance Review and Global Unrealized Gain/Loss. These reports allow you view data at the Practice level. Reports are located under the Management Reports sub-menu under the Reports option on the menubar at the top of the screen.
The Global Account Performance Review report shows the change in each account’s value at the practice or group level. If you are a firm administrator, you can break down this report by advisor.
The Global Unrealized Gain/Loss report shows how the value of holdings within an account have changed. This report is also available at the practice or group level, with firm administrators able to break down this report by advisor. Please note: This report is currently in Beta and available only upon request. Please contact your CSC to request access to either report.