Contents

Introduction Why Use the Summary Report? Features of the Summary Report Add Summary to the Advisor Dashboard Summary Report Settings Report Actions Report Calculations

 

Introduction

Applies to:
✔ Dynamic	✔ PDF	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.

Top of Page

Why Use the Summary Report?

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.

Top of Page

Features of the Summary Report

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.

  

  Note

  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

  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

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

  

Top of Page

Add Summary to the Advisor Dashboard

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.

Top of Page

Summary Report Settings

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
Date Period	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:

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

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

Report Calculations

Entry	Transaction Activity	Other Considerations
Start Value	N/A (market value at start of period)
Inflows	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
Outflows	Withdrawals and transfer of securities	Assets changed from managed to unmanaged Formula: Cash withdrawals + Market value of securities transferred out during that period + Capital outflows from excluded assets + Fees unchecked to reduce both gross and net returns
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.

 

Top of Page