Income Report & Expense Report

The Income & Expense Report allows Advisors to review the sources of income and expenses in their clients' portfolio in order to communicate how their investment strategy generates income for their clients and what expenses have been taken out of their accounts.

The report can be generated as a stand-alone report in the Report tab or it can be included in any PDF report when generated from a Household, Account, or Group dashboard.  The report contains two main sections: 

• A summary section that provides sub-totals by Activity Type and a Net Amount
• A transaction details section that provides details on the transactions that make-up the totals represented in the summary section. The following data points are displayed for each transaction:
  • Date of Transaction
  • Asset Name
  • Type of Transaction
  • Description of Transaction
  • Value of the Transaction

The summary section appears every time the report is run. Transaction details will only be included in the report (after the summary section) if this option is selected at the time the report is run.

Activity Types

There are three main Activity Types that can be included in this report:

• Income: This section displays Dividend and/or Interest transactions if selected

• Expense: This section displays Advisory Fee and/or Fee transactions if selected

• Options Trading: This section displays the amount generated from the buys and sells of Options

Advisors can select which transaction types (Dividends, Interests, Advisor Fee, Fees, and/or Options Trading) to include in the report at the time the report is run. If the transaction types for a section are not selected, that section will not appear. For example, if Options Trading is not selected, the Options Trading section will not appear in the report.

Please note that the Options Trading option requires an entitlement. If you do not see this option, please reach out to to the CircleBlack Customer Success team.

How To Run the Income & Expense Report

There are two main flows for running the Income Report.

1. Report tab on the Advisor Dashboard
   1. From the main Advisor Dashboard, click on the Report tab. In the Generate section, click the “Select A Report…” dropdown and choose the Income Report option.

   2. Depending on whether you are a Firm or Advisor-level user, you’ll select the Initial Context and then select whether you want to generate the report for a Household, Account, or Group.

   3. Then you’ll select the report’s Parameters, which is where you’ll see the Income Report option and each transaction Activity option pre-selected.

   4. Confirm the report parameters, including the desired time period, and then press the Generate button.

2. Any Household, Account, or Group Dashboard

   1. From any Household, Account, or Group Dashboard, click the Generate Report button the Household/Account/Group Info tile.

   2. From the ‘Select A Report…” dropdown, you’ll see a list of our standard reports; pick any one of those.

   3. In the Select Parameters section, choose the required time period and select the Income checkbox and the desired activity inclusions. Then, generate the report.