Investment Report

Written by Nick Miles

Last published at: January 21st, 2021

Overview

The Investment Report can be used to report on investment activity by investment account and level.


Components

  • Investment Accounts


Setup

First, you'll need to define the investment level for each investment account that you want to report on.

  1. Select Accounts from the Home page.
     
  2. Select an investment account.
  3. Click Edit.
  4. Select an Investment Level and then click Save.

Repeat these steps for each investment account that you want to include in your investment reports.

Note: if an investment account does not have a level defined, information from that account will display within the N/A column in the investment report.


Run an Investment Report

Now that you've set an investment level for each of your investment accounts, you can run the investment report.

  1. Select Financials from the Home page.
  2. Click Investment.
  3. Select a Start Date and End Date for the report to run then click Show Date; or click one of the pre-defined date ranges.
  4. The investment report will display the results by investment level.

Please Note:  

  • If your foundation has several investment pools with sub accounts the most accurate view of the report will be at a foundation level.  If your foundation does not have investment accounts with sub accounts then you will have accurate reporting if you filter down to a specific fund.
  • This report will show CommunitySuite activity only. If you converted during the fiscal year then this report will not have the investment activity in the correct categories due to the conversion.


Investment Report Fields

Beginning Balance - the balance in the investment account as of the beginning of the date range selected.

In - a total of any increases that are not from a statement voucher.

Interest - from statement voucher.

Dividends - from statement voucher.

Realized Gains - from statement voucher.

Unrealized Gains - from statement voucher.

Fees - from statement voucher.

Out - a total of any decreases that are not from a statement voucher.

Note: if an investment account does not have a level defined, information from that account will display within the N/A column.