Back	Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Performance Reports > Summary by Category Report

Summary by Category Report

Contents

Introduction

This report aggregates performance, holdings, and transactions data to provide details about how an account or group achieved the reported returns at the category level. This report shows a breakdown of returns for specific categories alongside transaction and holdings data like inflows and outflows, income and expenses, and realized and unrealized gains and losses.

The Summary by Category report gives a holistic overview of what category-level activity took place in an account or group during the date period. You can display a wide range of data points including value, flows, category benchmark, and returns for managed and unmanaged assets.

Top of Page

Why Use the Summary by Category Report?

In the Summary by Category report, versatile sorting and charting options let you answer high-level questions about accounts and groups, such as:

• What did this account's Categories look like During the period? The Summary by Category report allows you to show the changes in an account or group at the category level over the period, and what caused the changes.

• How do managed assets compare with unmanaged assets? Clearly break down managed and unmanaged performance and transactions into separate sections. If you want to compare them directly, you can add all the same data points for each.

• Can I show clients more Detail than the Summary Report? Provide more information about how specific categories impact returns and performance to clients interested in diving deeper into their financial details.

Top of Page

Features of the Summary by Category Report

The Summary by Category report helps you obtain meaningful insights when evaluating category performance, transactions, and holdings. Interactive reporting features include:

1. Category-level reporting. See performance, transaction, and holdings results at the category level, with optional column ordering.

   Note

   Uncategorized holdings are aggregated into the Unassigned column, which is included automatically. This column always appears on the right, after the individual category columns and before the Total column, regardless of Order by configuration.

   Note

   This report respects account-level category overrides. For more information about category overrides, see Maintaining Accounts: The Category Overrides Page.

2. One date period. Unlike the Summary report, the Summary by Category report only applies to one date period.

3. Customizable columns.In addition to category results, the report displays securities that aren't assigned to a category aggregated in the Unassigned column. You can also add a Total column or use Always include selected categories regardless of value to manually include columns for categories, even if a particular account doesn't hold that category.

4. Flexible data points. Select rows to display a side-by-side comparison for the date period. Available rows include flows, returns, start and end values, capital appreciation, income and expenses, gains and losses, category and account benchmark, and more.

   Tip

   Customize the name of the Start Value and End Value data points on the dynamic and PDF versions of the report using merge fields to insert {Date} or {Date Period Name}. For more information on how to customize data point names, see Customize the Name of Column Headings for Reports.

   

5. Customize the Look. Use sub-headings, dividers, and blank white rows to create separate sections and draw attention to the most important data points, such as net investment gain or return numbers.

   Note

   You can change the name of many rows. For more information, see Available/Selected Rows.

6. Show managed and unmanaged assets. Display managed, unmanaged, and total asset summary statistics side by side.

   Notes

   • You can customize the Managed/Unmanaged labels used for the headings and captions on your reports. These changes can be made on the System Settings page.

   • Use the Excluded Securities Panel to designate all or some securities as unmanaged assets at the account level.

   • You may notice that total flows don't always match the sum of managed and unmanaged flows in some reports. This occurs when, for performance purposes, there is a flow between managed and unmanaged. When viewing the total, this flow is not needed for performance purposes and so is excluded from these aggregated numbers.

     Because of this, the following flow columns may not sum to total:

     Capital Appreciation Cash Inflows Cash Outflows Change in Value of Securities Held Inflows

     Investment Gain Net Cash Flows Net Flows Net Receipts of Securities Outflows

Additional features include:

• Control data details. If appropriate, you can choose to annualize returns and include intra-group flows.

• See partial period returns. If you choose a category that only includes data for part of the date period, you can see additional details for those partial period returns.

Top of Page

Add Summary by Category to the Advisor Dashboard

There is no Summary by Category dashboard widget available for the reporting dashboard.

Top of Page

Summary by Category Report Settings

The following settings are available for the Summary by Category report. Click the setting name for more details.

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

• Learn More About Global Report Setup Options

• Learn More About Dynamic Reports

Top of Page

Report Actions

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

Top of Page