Back

Account Performance Report

Contents

Introduction

Why Use the Account Performance Report?

Features of the Account Performance Report

Add Account Performance to the Advisor Dashboard

Account Performance Report Settings

Report Actions

 

Introduction

Applies to:
✔ Dynamic ✔ PDF ✔ Mobile

✔ Client Portal

 

The Account Performance report shows account values and performance data to tell the story of how an account or group has performed over a designated date range. It helps you understand and troubleshoot TWR for an account or group.

The report can include:

You can add benchmarks in both the table and chart views for easy comparison. The report helps you drill down on the performance for each account or group to view underlying holdings, categories, or accounts.

Tip

On the Account Performance PDF report, adding benchmarks is a two-step process. To add benchmarks:

  1. Select Include Benchmarks.

  2. In Selected Benchmarks, select the benchmark you want to add and click Add Benchmark.

Top of Page

Why Use the Account Performance Report?

The Account Performance report provides versatile charting options that make it an effective report to lead your reporting package, addressing your clients' likely primary concern: performance. The Account Performance report answers such questions as:

Example 1

Cherry Street Financial knows that the first thing clients look for in PDF reports is how their accounts are performing under Cherry Street's management. That's why Cherry Street includes an Account Performance section near the beginning of many of their PDF report templates. The section is configured to display performance for all accounts within the client's group as a broad overview of performance.

The remainder of the PDF template then follows up with detailed account performance for each account.

Example 2

An advisor has a group that includes managed and unmanaged accounts. When the client calls and asks about overall performance, the advisor uses an Account Performance report that splits out managed and unmanaged assets so he can address only the performance of accounts under his control.

The report clearly shows that performance of the unmanaged account lags noticeably compared to managed accounts, and the advisor uses this opportunity to suggest moving those assets under his management as well.

Example 3

An advisor is interested in showing clients how their accounts did within their group and then showing how each category in the accounts performed. The advisor creates two Account Performance PDF report sections.

One section shows a line chart of the group performance compared with all the direct member accounts and groups in the group, with account benchmarks displayed when available.

The other section shows a bar chart of all the categories held in the group for the one date period of interest, with category benchmarks for reference.

With these two charts, the advisor quickly and clearly tells the story of how the client's accounts and underlying asset classes performed over the period.

Top of Page

Features of the Account Performance Report

The dynamic report helps you easily filter and sort data to drill down to meaningful results. Interactive reporting features include:

Note

On dynamic reports, when hover text displays for partial period returns, it will show both start and end dates. If you're using the enhanced performance calculations and there was more than one open period during the selected date range, you will see the start date of the first holding period and the end date of the final holding period.

Top of Page

Add Account Performance to the Advisor Dashboard

You can use dashboard views to see an at-a-glance summary of the dynamic Account Performance report on your Reporting dashboard.

To learn more about creating and managing dashboard views, see Create and Share Dashboard Views.

For more information on customizing your dashboard, visit Add/Edit/Delete Dashboard Modules.

Top of Page

Account Performance Report Settings

The following settings are available for the Account Performance report. Click the setting name for more details.

Setting Details Available In...  
Dynamic Report PDF Report Advisor Dashboard PDF
Dashboard
Account Grouping Control grouping of accounts and groups.   X    
Annualize Returns Report the returns as annualized returns. X X X X
Available/Selected Columns Choose which columns are included and in what order.   X   X
Axis Scale Customize the scale of the y axis.   X    
Category Filter Choose to include or exclude specific categories from the report. X X X X
Combine Group Positions

Combine any common positions held within a selected group.

  X    

Date Period

Select the date period for the report.

Includes related setting:

  • Trade date or entry date

   X   X
Dashboard Benchmark Show an account benchmark on the Advisor dashboard and to set which benchmark the report displays. X   X  
Display Changes to Benchmark Assignments Mark on the line chart when benchmarks applied to an account were changed. X X X  
Gradient Chart Show PDF chart with a gradient.   X    
Group By Choose to see account or category data on the report. X X X X
Group By/Then By

Organize a report by various categories.

Includes related setting:

  • Show subtotals

   X    
Header and Footer Choose a unique header and footer for the section or use defaults.   X    
Hide Closed Accounts Show or hide closed accounts. X X X  
Include ___ Categories/Accounts Set how many accounts or categories to display on the chart. X X    
Include Total Return Show or hide account or group data, including benchmarks and indexes, on charts.   X    
Include Actual Return Start Date in Footnote Add actual return dates in the footnote.   X    
Include Additional Indexes Add the performance of any of the firm's available indexes, custom indexes, or blended indexes as a data point. X   X  
Include Allocation Weighted Benchmark Add the allocation weighted benchmark as a data point for comparison. X   X  

Include Allocation Weighted Benchmark By

Designate which category of allocation weighted benchmark is used in the return calculations.

Note

This feature is the same as Group Allocation Weighted Benchmark By

   X   X
Include Benchmarks

Add one or more of the account or category benchmarks as a data point for comparison.

When you want to include benchmarks, you select benchmarks from the list and add them to the report. The report displays these for accounts and groups, including SMAs.

Note

When reporting on SMA accounts in a group context, the Account Performance report shows all of the selected benchmarks, including accurately reflecting any changes in benchmark history for each benchmark displayed on the report.

 X X X X
Include Page Break After This Section

Control where page breaks occur in PDF reports.

   X    
Include Reports for Closed Accounts Show sections for accounts that were closed before the report as-of date.   X    
Mark as Publicly Accessible Share the report view. X      
Only Show Returns for Assets Held at the End of the Period

Choose whether assets that were held during a selected period are shown when you expand a group.

 X X    
Partial Returns Choose how to mark data points that have partial returns.   X    
Preview See a sample of the PDF report with the selected settings.   X    
Report Name Designate a unique name for the view of the report view. X   X  
Section Alignment

Align the PDF Dashboard report to the top, middle, or bottom of the vertical space.

       X (table only)
Section Title Designate what the section will be called in the PDF report.   X   X
Show Actual Return Dates Show the actual start date for partial period returns.   X    
Show Bar Chart Show or hide the performance bar chart. X X    
Show Category/Account Returns Choose what data to show on the line or bar chart. X      
Show Data As Set what type of data the PDF Dashboard section displays.       X
Show Detailed Performance

Show or hide the performance table on the PDF report, and customize what the table displays.

Includes related settings:

  • Group By/Then By

  • Include Benchmark

  • Date Period

  • Use Inception Date

  • Show Return As

  • Within Each Group, Show

  • Available/Selected Columns

  • Preview

  • Include allocation weighted benchmark by

  • Partial Returns

Note

In the PDF report detailed performance table, columns available are weight, description, and value.

   X    
Show Line Chart

Add the line chart to the report.

 X X    
Show Performance For Show an account or group's performance, or just the performance for an index or indexes. X X X X
Show Return or Net Investment Gain Report performance as percent return or as net investment gain. X X X X
Show Returns As Net or Gross

Determine how returns should appear on the report.

 X X X X
Show Returns As Percentage or Dollar Show returns as a percentage or a dollar amount on the line chart. X X X X
Show Table With Chart Values Show or hide a summary table.   X    
Show Values On/Show Returns or Investment Gain For

Configure which dates or date periods appear as columns on the report.

Note

Categories are displayed only if they have value at time during any of the date periods added to the report.

 X X X  
Show Subtotals Add subtotals to each grouping level.   X    
Theme Designate what theme the section will use.   X    
Unmanaged Asset Treatment

Choose how you want to treat unmanaged assets on the report.

Note

For more information about marking securities as unmanaged and how reports display unmanaged assets, see How Reports Handle Unmanaged Assets.

 X X X X
Use Date or Date Period as Title Use the date (in MM/DD/YYYY format) as the title of the column heading, rather than the name of the date period. X   X  
Use Inception Date Report partial periods in PDF reports for instances where the account or group was opened after the beginning of the date period selected.   X   X
When Expanding a Group, Show

Report on securities or accounts within the group, or to not expand groups. 

Includes related setting:

  • Within each group, show

 X X    
Y-Axis Label Set what you want to call the y axis.   X    

 

Notes

For more general dynamic reports settings, including how to customize columns, add footers, and more, see:

Top of Page

Report Actions

You can do any of the following actions with the report.

Action   Available in Dynamic Report Available in PDF Report
Run Report Run dynamic report or PDF template. X X
Edit Report Edit report view or template. X X
Copy Report Copy report view or template. X X
Delete Report Delete report view or template. X X
Share Report Share report view with other firm users. X X
Export to Excel Export report data to a CSV file. X X
Print Report Print a dynamic report. X X
Site Themes Edit how the dynamic report looks. X  
Learn More About Customizing How PDF Templates Look Edit how the PDF report looks.   X

 

Top of Page