Back Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Performance Reports > Summary Report
|
Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Performance Reports > Summary Report
|
Summary Report
|
|
| Applies to: | |||
|---|---|---|---|
| ✔ Dynamic | Mobile |
✔ Client Portal |
|
The Summary report gives a broad, holistic overview of what took place in an account or group over one or more date periods. You can display a wide range of data points, including value, flows, benchmarks, and returns for managed and unmanaged assets in the Summary report.
The report displays a table of the data you select. Benchmarks can be added to the table for easy comparison against the account. It can also include a bar chart that always displays net contributions, capital appreciation, income, management fees, and other expenses for the first date period in the table.
In the Summary report, you will find versatile sorting and charting options that let you answer broad, high-level questions about accounts and groups, such as:
What is the overall story of this account or group? Use the Summary report to tell the story, in broad strokes, of what activities—transactions, flows, returns, and more—occurred in the account or group over one or more date periods.
What did this account look like at the beginning and end of a period? When looking at just one date period, the Summary report allows you to show broadly the changes in an account or group over that period, and what caused the changes.
Are there any Activity trends in this account or group? By setting the report to display up to five date periods, you can use the Summary report to spot trends in activity. For example, if a client takes withdrawals at the beginning of every quarter, a Summary report can reveal that and help you proactively anticipate the need for cash the following quarter.
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. But you can also report on different data points for managed and unmanaged—for example, show only transactions and values for unmanaged assets, but including returns for managed assets.
A firm includes the Summary report at the beginning of their year-end reporting package to provide an overview of what happened in the client's account over the year. They have set up the Summary report to show the four quarters of the year, adding rows that display start value, various possible transactions and flows that could impact the account value, the ending value, and some summary statistics.
An advisor uses the Summary report for reviewing the returns in an account in comparison with the benchmark and allocated weighted benchmark. The Summary report provides context for those returns, showing what activities occurred in the account over the selected date period.
The Summary report helps you easily filter and sort data to drill down to meaningful results. Interactive reporting features include:
Customize the Look. Use custom-named sub-headings 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.
You can change the name of many columns. For more information, see Available/Selected Columns.
Customize Data. Select specific rows to display and compare up to five date periods side by side.
Show Managed and Unmanaged Assets. Display managed, unmanaged, and total asset summary statistics side by side
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:
|
|
Tooltips. See data details by hovering over a category on the bar chart.
Customize zoom. Zoom in by clicking and dragging to select an area. You can then scroll through the zoomed area by holding down the Shift key and dragging to the left or right. Reset your zoomed chart quickly by clicking the 
button.
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.
To learn more about creating and managing dashboard views in general, 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 Summary 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 | |||
| Include Reports for Closed Accounts | Choose to show sections for accounts that were closed before the report as-of date. | X | |||
| Mark as Publicly Accessible | Share the report view. | X | |||
| Select the date periods you want to use for the report. | X | X | X | X | |
| Use Date or Date Period as Title | Use the date (MM/DD/YYYY) as the title of the column heading, rather than the name of the date period. | 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 | ||
| Group Allocation Weighted Benchmark By | Designate which category of allocation weighted benchmark is used in the return calculations. | X | X | X | X |
| Annualize Returns | Report the returns as annualized returns. | X | X | X | X |
| Include Intra-Group Flows | Include or exclude intra-group flows, or display intra-group flows in the Intra-Group Flows In and Intra-Group Flows Out rows. | X | X | X | X |
| Partial Returns | Choose how to mark data points that have partial returns. | X | |||
| Show Chart | Show or hide a chart summarizing flows. | X | X | X | |
| Available/Selected Columns | Choose which columns are included, in what order. | X | X | X | X |
| Include Additional Indexes | Add the performance any of the firm's available indexes, custom indexes, or blended indexes as a data point. | X | X | X | 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 |
|
| Change in Value of Securities Held | N/A (change in market value during period of positions currently held) |
Calculated as plug figure to reconcile beginning to ending value Formula: Current Value – Start Value – Cash Inflows – Cash Outflows – Receipts of Securities – Transfers of securities – Transfers – Realized gains – Dividend Income – Interest Income – Management Fees – Other Expenses – Change in accrued |
| Change in Value of Securities Sold |
N/A (change in market value during period of positions sold) Sells, covers, transfers of securities, income reported as gain, and debit security |
Formula: Value Closed – Market Value at the Beginning of the Date Period |
| Dividend Income | Income transactions marked as: dividend, non-qualified dividend, qualified dividend, payment in lieu of dividend | Income must come from managed security |
| Interest Income | Income transactions marked as interest, sell transactions with an accrued interest component | Income must come from managed security |
| Management Fees | Expense transactions marked as management fee | |
| Other Expenses | Expense transactions not marked as management fee | If the expense type does not reduce net performance, then it is considered a cash outflow instead of an expense. |
| Change in Accrued |
Difference in accrued income at the start and end date Formula: Ending Accrued – Beginning Accrued – Accrued Income Paid |
|
| Ending Value | N/A (market value at end of period) | |
| Investment Gain |
Formula: End Value - Start Value - Net Flows = Capital Appreciation + Income + Other Expenses + Management Fees + Change in Accrued |
|
| Transfers | Journals, credit security, debit security, buys/sells/shorts/covers where the Money security is set to NONE. | |
| External Fee Payment | When a management fee and a deposit are the same amount on a given date, it is considered an external fee payment. | The deposit amount is not included in the Contributions row, even if the External Fee Payment row is omitted from the report. |
