Skip to main content

How to Generate a Performance Report for an Account or Household

S
Written by Sarah Miller

The Performance Report is a customizable PDF that provides a comprehensive overview of a client’s portfolio. It can be generated at either the Account or Household level, depending on your needs. The report includes multiple sub-reports that can be selected based on the specific data you want to share with your client.

Steps to Generate a Performance Report

  1. Go to the Clients menu on the left-hand side of the dashboard.

  2. Locate the specific Account or an Account within the Household for which you want to generate the report.

  3. On the right side of the account record row, click the three dots (⋮) to open the action menu. Select “Generate Performance Report”.

  4. The system will default to the Household of the selected account. Use the Account/Household dropdown to change this if needed.

  5. Choose a predefined period or select Custom to set specific start and end dates.

  6. There are 13 sub-reports pre-selected by default. You can select or deselect any sub-reports as needed.

  7. Choose the preferred calculation methodology (e.g., Time-Weighted Return, IRR, etc.).

  8. Pick the Performance Chart Range to define the date range for the visual performance chart included in the PDF.

  9. Click “Generate Report” to begin the process.

Note: Generating the report can take between 2–10 minutes, depending on:

  • The amount of data

  • Selected time period

  • Number of sub-reports included

Where to Find the Report

  • The report will be available to download on the notification (Toast) that appears after the Requested PDF report.

  • The PDF report will be stored under the Account Documents section.

  • If generated at the Household level, the report will also appear under each Account Document within that household.

Available Sub-Reports

Here’s a list of the sub-reports that can be included in the performance PDF. Each one offers a different view into the client's portfolio:

Report Name

Description

Portfolio Snapshot

A four-quadrant view with asset allocation, summary, net contributions chart, and performance chart.

Account Summary

Performance metrics over fixed intervals (e.g., ITD, PTD), including contributions and returns.

Performance Summary

Monthly performance table across standard time intervals (YTD, 3Y, etc.).

Net Investments

A line chart showing cumulative contributions vs portfolio value.

Cumulative Performance

A performance chart comparing the account to benchmarks.

Account Appraisals

Current holdings with valuation, cost basis, and unrealized gains/losses.

Account Holdings

List of currently held securities and their market values.

Top Ten Holdings

A breakdown of the top ten positions by asset class.

Buys and Sells

All trade activity (buy/sell) in the selected period.

Deposits and Withdrawals

Cash and security transfers in/out of the account.

Income

Dividend, interest income, and expense details.

Excluded Assets Summary

Assets excluded from performance reporting.

Risk Return

Return, volatility, and Sharpe ratio compared to benchmarks.

Management Fees

Summary of advisory/management fees charged.

Realized Gains & Losses

Details of sold securities and capital gains/losses.

Allocation & Performance Summary

Combines account summary with asset allocation details.

Performance Calculation Methodology

We use the Time-Weighted Return (TWR) methodology to calculate investment performance.

This industry-standard method:

  • Removes the impact of cash flows, so performance reflects the market behaviour—not deposits or withdrawals.

  • Enables accurate comparisons against benchmarks and across accounts of different sizes.

  • Aligns with GIPS standards recommended by the CFA Institute.

The generalized formula looks like this:

Where:

  • r1 = return for the first sub period

  • r2 = return for the second sub period

  • rn = return for the final sub period

The return itself is calculated using the following formula:

Where:

  • EMV = ending market value

  • BMV = beginning market value

  • CF = cash flow

Why TWR?

  • More accurate than Simple Return or IRR when cash flows are present.

  • Divides performance into sub-periods between cash flows, calculates each return, and links them geometrically.

  • Uses daily transaction and pricing data for high precision.

Example: If a deposit is made mid-month, TWR calculates separate returns before and after, then combines them into a total return.

This approach ensures fair, transparent, and comparable performance reporting for both you and your clients.

Did this answer your question?