Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Performance Reports > Comparative Review Report
|
Comparative Review Report
Why Use the Comparative Review Report? Features of the Comparative Review Report Add Comparative Review to the Advisor Dashboard |
Applies to: | |||
---|---|---|---|
✔ Dynamic | Mobile |
✔ Client Portal |
The Comparative Review report presents account-level data including category values and weights, contributions, and rates of return (both TWR and IRR) for one specific date period. This report tells a comparative story of how one account did, with the entire group or account set for context. This report can also show you how the value of your accounts is distributed among your asset classes.
On the Comparative Review report you'll see a table listing each account and its statistics for the selected date period only. Grouping and sorting options allow you to configure the table for easy interpretation.
You can use the Comparative Review PDF report to create a tax planning report. For more information, see Tax Planning Report.
In the Comparative Review report, you will find versatile sorting and grouping options and detailed columns that let you answer many questions about accounts and groups, such as:
How Did One Account's Performance Compare with Others In the Group? See the value, flows, weights, returns, and more for a single date period for all the accounts in a group or account set.
What is the overall story of this account or group, compared to the group or set? Use the Comparative Review report to tell the story, in broad strokes, of what activities—transactions, flows, returns, and more—occurred in the account or group over one date period, in comparison with the other accounts in the group or account set.
What did this account look like at the beginning of and end of the period, compared to the group or set? When looking at just one date period, the Comparative Review report allows you to show broadly the changes in an account over that period, and what caused the changes, in comparison with a larger group or account set.
What Taxable Interest, Dividends, and Gains Did This Account Accumulate Over the Period? Create a tax planning version of the Comparative Review PDF report to see and share tax planning data points for various income and expense sources, realized gains and losses, and more, with clients and their tax preparers. Group accounts by tax status to separate taxable and non-taxable.
An advisor wants to evaluate the performance of diversified accounts in a group. Some of the accounts hold substantial US equities, while others are more heavily weighted toward fixed income.
Using a Comparative Review report, the advisor adds a column showing weights of the major categories held within the group: US Equities, International Equities, Cash and Equivalents, and Fixed Income. The report automatically aggregates all the other categories into the Other column. The advisor also includes annualized gross TWR and annualized gross IRR columns to review the overall account's returns in comparison with the other accounts in the group.
The Comparative Review report helps you easily filter and sort data to drill down to meaningful results. Interactive reporting features include:
Highly customizable columns. Customize the data displayed to show only relevant data. You control what data the report displays and which columns the report includes, in what order, so you can create the exact report you need.
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 two versions of the PDF Report: Performance or Tax Planning. In the Comparative Review report PDF template, create either a performance-focused report that includes details of flows and returns, or a tax planning report that includes details of interest, dividends, and gains and losses. Available columns and settings depend on the type of report you choose.
For more information, see Tax Planning Report.
Household-Based Grouping Options. The Comparative Review report offers two unique group by options: Primary Household and Primary Household Primary Advisor. These unique Group by options originate from the following sources:
The new Group by options originate from the following sources:
Option | Data Source |
---|---|
Primary Household |
The primary Household selected for the account or group.
For more information on the primary household setting, see Maintaining Accounts: The Household and Group Membership Panel. |
Primary Household Primary Advisor |
The Primary Advisor assigned to the Service Team for that account's Household.
This value matches the Primary Household Primary Advisor column available on any bulk report that includes the Account - General Reporting section.
If the account has multiple primary advisors, Tamarac displays the first primary advisor listed as the Primary Household Primary Advisor in bulk reports. For more information on service teams, see Service Teams. NoteFirms can customize the Primary Advisor service role name, so it may not be called Primary Advisor in your firm. |
Show Managed and Unmanaged Assets. Display managed, unmanaged, and total asset statistics side by side.
For more information about marking securities as unmanaged and how reports display unmanaged assets, see How Reports Handle Unmanaged Assets.
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:
|
|
Expand/Collapse. Expand (>) or collapse (˅) table rows to further control the level of detail.
On-the-Fly Column Sorting. Sort columns by clicking column headers. The caret direction indicates sorting order, either ascending or descending.
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.
You can easily identify linked partial period TWR and other partial period returns on your dynamic and PDF reports. A dagger symbol (†) indicates a linked partial period TWR and an asterisk (*) indicates all other partial period returns (TWR and IRR).
You can use dashboard views to see a pared-down, at-a-glance summary of the main dynamic report on your dashboard.
Columns available on the dashboard version of the dynamic report are based on the columns added to the dynamic report.
To see or add a column to the Dashboard report, add the desired column to the dynamic report. This makes it available in the Available/Selected column list for the dashboard report.
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.
The following settings are available for the Comparative Review report. Click the setting name for more details.
Setting | Details | Available In... | |||
---|---|---|---|---|---|
Dynamic Report | PDF Report | Advisor Dashboard | PDF Dashboard | ||
Report Name | Designate a unique name for the report view. | X | X | ||
Section Title | Designate what the section will be called in the PDF report. | X | X | ||
Section Alignment |
Align the PDF Dashboard report to the top, middle, or bottom of the vertical space. |
X | |||
Theme | Designate what theme the section will use. | X | |||
Header and Footer | Choose a unique header and footer for the section or use defaults. | X | |||
Include Page Break After This Section |
Control where page breaks occur in PDF reports. |
X | |||
Account Grouping | Control grouping of accounts and groups. | X | |||
Mark as Publicly Accessible | Share the report view. | X | |||
Select the date period you want to use for the report. | X | X | X | ||
Group By/Then By |
Organize a report by various categories. Includes related settings:
|
X | X | ||
Sort First By/Then By |
Determine the default order in which the data is displayed. NoteIn the PDF Dashboard, the sort options are slightly different. |
X | X | X | X |
Unmanaged Asset Treatment |
Choose how you want to treat unmanaged assets on the report. NoteFor more information about marking securities as unmanaged and how reports display unmanaged assets, see How Reports Handle Unmanaged Assets. |
X | X | X | |
Dollar Amount Precision | Choose how many decimal places you want displayed for dollar values. | X | X | ||
Percentage Amount Precision | Choose how many decimal places you want displayed for dollar values. | X | X | ||
Use SMA Categories | Choose how to use the SMA categories assigned to that account. | X | X | X | |
Use Security Group Categories | View security categories at the group level. | X | X | X | |
Include Capital Gains Distributions in Realized Gain/Loss Columns | Include or exclude capital gains distributions | X | X | X | |
Only Show Returns for Managed Assets | Include or exclude unmanaged asset returns. | X | X | X | |
Categories by Value |
Designate which categories you want to display the value for. Includes related settings:
|
X | X | X | X |
Categories by Value/Weight |
Designate which categories you want to display value and weight together for. Includes related settings:
|
X | X | X | X |
Categories by Weight |
Designate which categories you want to display the weight for. Includes related settings:
|
X | X | X | X |
Available/Selected Columns | Choose which columns are included, in what order. | X | X | 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 | ||
Report Direct Members as a Single Line Item | Show or hide all the direct members of a group within a group. | X | |||
Include Tax Planning Data for Non-Taxable Accounts | Control whether the report displays tax-related data for non-taxable accounts. | X | |||
Reporting Data Type | Create a performance report or a tax planning report. | X |
To learn more about general dynamic reports settings, including how to customize columns, add footers, and more, see:
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 |
Entry | Transaction Activity | Other Considerations |
---|---|---|
Start Value | N/A (market value at start of period) | |
Deposits and receipt of securities |
Assets changed from unmanaged to managed Examples: buying managed security using unmanaged cash, selling unmanaged security to managed cash, dividend income from unmanaged security going to managed cash, etc. Child accounts which have a non-zero value at inception during the period being requested |
|
Withdrawals and transfer of securities |
Assets changed from managed to unmanaged Formula: Cash withdrawals |
|
Management Fees | Expense transactions marked as management fee | |
Ending Value | N/A (market value at start of period) | |
Net Investment Gain |
Formula: End Value – Start Value – Inflows – Outflows |