Show 

Release Notes February 2013

Morningstar Office Release February 2013

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.

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:

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:

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.