Morningstar Office Release February 2014

Portfolio Reporting

New Time Weighted Return Calculation Diagnostic Report Now Available.

Client Management > Client > Reports > Data Diagnosis Report > Time Weighted Return Calculation

Client Management > Client >Account> Reports > Data Diagnosis Report > Time Weighted Return Calculation

This new excel report provides users who run reports using the Time Weighted Return methodology with the raw data used to calculate returns to diagnose reporting and billing errors.

Information used in this report includes the following:

Beginning Market Value
Ending Market Value
Cash Flows
Daily Return Percentages
Period rate of TWR return
Annualized rate of TWR return

This report can be run for Clients, Groups or Individual Accounts. When run for Clients and Groups, you can choose to aggregate or segregate accounts. You also have the option to select Net of Fees or Gross of Fees.

Global Cash Flow Report has been Enhanced

Top Tool Bar > Reports > Management Reports > Global Cash Flows

This report has been enhanced to provide more detailed information when tracking cash flow management. New report options include the following:

Report Type (excel or csv)
Custodian
Exclude Management Fees
Include Cash and cash Equivalents only
Filter accounts from the following flags:
Business Type
Third Party Management Accounts
Related Person/Proprietary Accounts

After you click OK, the report will be run on a server and will be available within the Reports page under the Reports tab. (See New Workflow for Management Report Generation.)

New Workflow for Management Report Generation

The Global Cash Flows report will now be run on Morningstar servers, rather than generated on the fly. When you run the report, you will receive a message alerting you that the reports are being generated. Once complete, you will be able to view the report from the Reports page under the Reports tab.

Imported Return Data now used in select Standard Reports and Report Studio components.

Client Management > Client > Reports > Client Return Summary

Client Management > Client > Account > Reports > Performance Summary/Performance History by Account

Report Studio > New Template/Saved Template

Imported portfolio valuation data will now be considered when calculating portfolio or aggregation data for a select group of Standard Reports and Report Studio components. Prior to this, imported data was only calculated for performance data.

Morningstar Office will now use the following imported data points in calculations:

Beginning Market Value
Ending Market Value
Net Cash flow
Management Fee

The table below details the reports, components and data points affect by this change:

Standard Reports	Affected Data Points
Client Return Summary	Aggregated Account data (Page 1) Beginning Market Value Ending Market Value Net Investment Asset Allocation (Page 1) Ending Market Value Percent Asset % Account Value Change (Page 2) Beginning Market Value Net Investment Management Fees Period Investment Gain/Loss Ending Market Value
Performance Summary	Beginning Market Value Management Fees Period Investment Gain/Loss Ending Market Value
Performance History by Account	Final Market Value Total Investment

Report Studio Component	Affected Data Points
Portfolio Evaluation	Ending Market Value Percent Asset
Portfolio Period Performance	Beginning Market Value Net Investment Management fee Period Investment Gain/Loss Ending Market Value
Performance Summary Portfolio Performance by Account Comparative Performance	Beginning Market Value Management Fee Total Gain after Management Fees Total Gain before Management Fees Ending Market Value

Website Now included on Cover page for PMS Reports

File> Update Profile

You can now include your Web sites on the cover page for all PMS reports. To include a Web site, update the information from the User profile located under the File menu on the Top Tool bar.

Report Studio Landing Screen Re-designed

Report Studio

The Report Studio Landing screen has been redesigned. The following changes have been made:

The middle section has been removed
The Global formatting options have been moved to the left side of screen. An Icon appears on the screen, rather than a button.
The New Report Template button has been moved to the right side of the screen.

Client Information Management

New Feedback System Launched

Top Tool Bar > Send us Feedback Link

Morningstar Office has enhanced the Send us Feedback tool. This improvement will allow us to collect more detailed information about client questions, which will improve the response time and quality of responses. Please note: for privacy concerns, reports will not be accepted as an attachment.

Investment Planning

Changes to the Income section in Investment Planning

When using the Investment Planning tool, the income section has been changed to be more precise in its calculations. The Employment Income field is now broken into to fields:

Pre-retirement income, which looks at any income sources (such as primary employment) that takes out pre-retirement taxes
Secondary income, which considers other income sources, such as part time work or rental property income.

We’ve also added a cash flows field, which will strictly measure cash flowing in and out of the accounts.