Back	Home > Tamarac Reporting > Available Reports > Performance > 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.

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

The Summary by Category PDF Template

The PDF template version of this report displays six total columns, including any columns you add, such as Total, Unassigned, and Always include columns. The following table clarifies what this means in practice.

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:

• How did an Account's Holdings Change during this Period?Show the changes in an account or group at the category level over the period, and what transactions 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 Shows? Provide more information about how specific categories impact returns and performance to clients interested in diving deeper into their financial details.

See the Summary by Category Report in Action

An advisor uses a Summary report to obtain a high-level overview of account activity and performance. But he'd really like to drill down into more detail on how specific asset classes performed, while also keeping an eye on the flows for that time period.

The Summary by Category report allows the advisor to see all the Summary report data points, including returns, transactions, and flows, broken down by the asset classes for the specific account he's interested in. He adds the Total column to provide an account-level view of those data points for the same date period, adding further context to category-level data.

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 the following.

This report displays managed, unmanaged, and total account value, flows, returns and more data points from the Summary report. For details and considerations about these data points, see Summary Report Data Point Calculations.

Report at the Category Level

See performance, transaction, and holdings results at the category level, with available column ordering. 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.

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

Customize Columns Included

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.

Choose Data Points and Control Data Details

Manage data included, data source, annualization, and more:

• 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.
• Decide whether to show annualized returns when it's appropriate.
• Use custodian data for realized gains and losses in this report with Use the Account Custodian As the Source of Record for Realized Gains Losses.

• 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.

  

Create the Look You Want

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.

Customize Naming

You can customize the name of most selected rows and the Managed/Unmanaged labels used for the headings and captions. 

Show Managed and Unmanaged Assets

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

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:

For more information about marking securities as unmanaged and how reports display unmanaged assets, see:

• How Reports Handle Unmanaged Assets
• Exclude Cash or Other Securities from Performance
• Exclude From Performance/Exclude ALL Securities From Performance

Identify Partial Period Returns

Identify Partial Period Returns

The following symbols mark partial period returns:

• Dagger symbol (†): linked partial period TWR only
• Asterisk (*): all other partial period returns (TWR and IRR)

See Date Ranges for Partial Period Returns

On dynamic reports, hover text displays both start and end dates for partial period returns. 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.

See Date Ranges for Partial Period Returns

Add Summary by Category to the Reporting Dashboard

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

Summary by Category Report Settings

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

Report Actions

To learn more about reports in Tamarac, see Introduction to Reports.

To learn more about how to generate a report, change the data displayed, print or export the report data, and more, see Basics of Working With Reports.

To learn more about creating and using PDF reports, see Understanding PDF Reports and Workflow: Generate a PDF Report.