Fund Balance Report is a financial report that shows the total, the principal, and the spendable balance for specified funds. The balances are initially set up during your implementation.
Traditionally, the balances are calculated as noted below:
- Fund Balance: Assets minus Liabilities.
- The fund balance is the total balance for the fund.
- Principal Balance: The historical gift balance.
- Any incoming donations will increase the principal balance of a fund.
- Spendable Balance: The spendable amount within the fund.
- This is determined by the Distribution Type set on the fund.
- Available Cash: The amount of cash available to spend.
- This is a separate balance from Spendable Balance which is calculated by the percentage of available cash on the investment account associated with the fund.
This data will show you the Fund and Fund Group (eg. Fiscal sponsorship, Unrestricted, Agency, etc). The columns include Permanently Restricted (PR), Temporarily Restricted (TR), Unrestricted (U), plus the total for the Fund, as well as the asset amount in the Principal balance and the Spendable.
Restrictions are exclusively for reporting purposes.
You may apply different filters to narrow the results.
Run a Fund Balance
- Navigate to the Financials page and click Fund Balance in the left-side menu.
- Click one of the date options, or select a Date from the calendar and click Show Date.
- The Fund Balance now shows. To further refine the information in the report, use the options listed below.
- A basic report will show you the Fund Group, the individual Funds, the Total amount in the Fund, and it will break out the amounts into the various restrictions you set up for each Fund as well as the Principle and Spendable amounts. If no restrictions are set up for a Fund, you will see a column labeled ZZ.
- 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 select Group Funds By. Click Save to save changes.
- 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 Add Filter in the left-side menu to use 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.
- Click Show/Ex SubFund in the left-side menu to view subfunds.
- A basic report will show you the Fund Group, the individual Funds, the Total amount in the Fund, and it will break out the amounts into the various restrictions you set up for each Fund as well as the Principle and Spendable amounts. If no restrictions are set up for a Fund, you will see a column labeled ZZ.