Set Filters to define report contents
Restricted Beyond Purpose Filters
Chart: Cash Flow by Fiscal Year
Chart: Funds by Purpose and Percent of Balance in Funds Accumulated 2+ Years
Chart: Fund Accumulation and Balance
Overview
The Fund Accumulation and Purpose report has three charts that show:
-
Cash flow by fiscal year
-
Funds by purpose and percent of balance accumulated in the last two years
-
Fund accumulation and balance
The report presents key metrics at the top and filters on the left. When you change a filter, the key metrics and all of the charts update to reflect your selection.
Set Filters to define report contents
Use the check boxes to specify the data to be included. Each time you change a filter, the three charts update to reflect your selection. Note that it is not possible to make multiple selections before the data refreshes. See the Optional Filters tab of the Wiki documentation for descriptions of the filters.
Restricted Beyond Purpose Filters
No Restriction beyond purpose
For spending guidance, funds in this category are only limited by the purpose and sub-purpose to which the are assigned.
Preference(s)
For spending guidance, funds in this category are only limited by a donor preference, in addition to the purpose and sub-purpose they're assigned to. Note that a preference should be honored if possible, but the preference can be ignored if impossible or impractical.
Restriction(s)
For spending guidance, funds in this category are only limited by a donor restriction, in addition to the purpose and sub-purpose they're assigned to. Note that a restriction must be honored. Fund Stewardship and Compliance should be alerted to funds with impossible or impractical restrictions.
Restriction(s) & Preference(s)
For spending guidance, funds in this category are only limited by a donor restriction and preference, in addition to the purpose and sub-purpose they're assigned to. Note that a restriction must be honored, but the preference can be ignored if impossible or impractical. Fund Stewardship and Compliance should be alerted to funds with impossible or impractical restrictions.
Not Classified
Some older current use funds do not have coding. If any of these funds move into an accumulated value beyond 0-2 years, then the fund will be reviewed and a value added in the near future.
Chart: Cash Flow by Fiscal Year
The Cash Flow by Fiscal Year chart shows the ending fund balance in a trend line and the income and expenses in blue and gold bars. When you select a data point in either of the other two charts, this chart updates to reflect the selection. This chart is not interactive; selecting a data point in this chart does not cause changes in the other charts.
Funds that have accumulated funds can still have spending activity. Accumulation does not mean funds have been sitting unspent for 2+ years. It means the balance of the fund is 2+ years of the typical annual payout, even though the balance is being spent.
Chart: Funds by Purpose and Percent of Balance in Funds Accumulated 2+ Years
Each square shows a purpose, the total dollars accumulated, and the percentage that has been available for more than two years. The color of the square indicates the percent accumulated, with higher percentages having darker colors.
Move your mouse (hover) over a purpose to see more information
When you hover over a purpose block in the chart, a window opens and displays the organization, fund primary purpose, available balance, number of funds, maximum fund balance, balance in funds with 2-5 years accumulation, balance in funds with 5+ years accumulation, and the percentages in endowment vs available for current use.
Filter the data
To filter by purpose, select the desired purpose by clicking on it. The Cash Flow by Fiscal Year and the Fund Accumulation and Balance charts update to reflect your selection. (Note: double-clicking takes you to the Fund Detail report with the purpose selected.)
You can tell that you have filtered the data by looking at the purpose in the title of the Fund Accumulation and Balance chart.
To remove the filter, click on the selected purpose.
See details
To see details, you can double-click on a purpose. Alternatively, you can select a purpose and then click the Gift Fund Detail tab in the upper left corner of the dashboard.
Chart: Fund Accumulation and Balance
This chart shows the units that are one level below the selected organization. For each unit, the bar chart displays the distribution of funds by age and balance. Each org shows the fund balances by fund age with >5 years in the darkest color and <2 years in the lightest color.
See more information
As with the Funds by Purpose and Percent of Balance in Funds Accumulated 2+ Years chart, you can hover over a segment of the chart to see more details.
Filter the data
There are three ways to filter the data to more details:
-
Select years the fund has accumulated from the color legend in the title bar at the top
-
Select an Org from the left
-
Select an intersection of years accumulated and org from the chart
Fund Accumulation and Balance with Org selected
Fund Accumulation and Balance with intersection of Org and Accumulation Period selected
