The Investment Report can be used to report on investment activity by investment account and level. Industry standard definitions for investment levels are listed below. In order to determine the proper coding, consult with your auditor for more details.
- Level 1 - Liquid assets, easily valued based on publicly quoted market prices.
- Level 2 - Harder to value; can be extrapolated based on market prices.
- Level 3 - Difficult to value.
- Mixed - More than one of the above levels in an investment.
- NAV - Net Asset Value.
Set the investment level for each investment account prior to running the report. This will create a more informational report.
Run an Investment Report
- Navigate to the Financials page and click Investment in the left-side menu.
- Click a date.
- Alternatively, select a Static Start and End Date, and then click Show Date.
- Alternatively, select a Static Start and End Date, and then click Show Date.
The Investment Report is displayed. To further refine the information in the report, use the options listed below.
- If a bank or investment account does not have a level defined, it will not show on the report.
Additional Information
- Click Edit Date in the left-side menu to change the date. Click Save to save changes.
- Click Edit Options in the left-side menu to make selections. Click Save to save changes.
- When Default is selected for Round, no rounding occurs.
- Rounding follows the standard rounding rule of rounding up if five or more, and rounding down if less than five.
- When using rounding, totals in reports may become imbalanced due to rounding differences across individual items.
- When Default is selected for Round, no rounding occurs.
- Click Load Saved in the left-side menu to use a saved filter.
- Click [delete] to remove saved filters.
- Click [delete] to remove saved filters.
- Click Save Report in the left-side menu to name a report. Click Save to save changes.
- Click Print in the left-side menu to customize report columns and titles. Click Print again to display the report.
- Click the Show checkbox to show columns or uncheck the box to hide columns.
- The printed report will have a white background, contain text from Financials Content, and display without lines.
- Click Add Filter in the left-side menu to Add Financial Filter.
- Click Export in the left-side menu to download an Excel spreadsheet containing currently displayed information.
- Click Raw Export in the left-side menu to download an Excel spreadsheet containing currently displayed information that has each cell of each line of the spreadsheet filled.
- This can be useful when using Excel functions.
- Fund attributes are included in the spreadsheet.
- Click Show Fund in the left-side menu to view each fund and its balance.
- Show/Ex Sub Fund becomes available when using Show Fund functionality.
- This option shows subfunds.
- Show/Ex Sub Fund becomes available when using Show Fund functionality.
- Click Show SubAcct in the left-side menu to view subaccounts.
- This will display the individual account balances, and the subaccounts will be indented.
If several investment pools with sub accounts are used, the most accurate view of the report will be at the foundation level. If no investment accounts with sub accounts are used, then filter down to a specific fund for accurate reporting.
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.