The available cash amount displayed on the Fund Management tab of the Portal is calculated by subtracting outstanding liabilities and pending grants from available assets.
Sometimes an organization would like to show the available for cash amount instead of the spendable balance of the fund because the organization uses a cushion of investment assets to allow room for market fluctuations. Additionally, a fund may have assets in holding accounts, like a pending stock sale or pledges/accounts receivable, where it is a non-spendable asset.
Outstanding Liabilities - The current sum of liabilities in the fund.
Pending Grants - The total of any recommended or pending grants on the fund that are unposted and waiting approval.
Available Assets - Calculated by multiplying the balance in each asset account by the available for cash percentage defined in the asset account.
Example
Assume that a fund has the following assets:
- Checking Account: $1000 with 100% available cash
- Investment Pool: $1000 with 75% available cash
- Pledges Receivable: $2000 with 0% available cash
The fund has a total of $4000 in assets, so the available assets would be $1750.
Enable Show Available Cash
- Navigate to the Portal Options page and click Portal Settings in the left-side menu.
- Click the Fund Advisor tab.
- Locate the Fund Advisors section, and then click Edit Fund Advisor.
- Check the Show Available Cash box, and then click Update.
- Customized text can be seen by fund advisors if it is entered into the Available To Cash Wording field.
- When Show Available Cash is turned on and Subtract Min Fund Balance From Available Cash is checked, available cash will be reduced by the Minimum Fund Balance set on the fund.
- Navigate to the Accounts page.
- Click the ID of the relevant asset account.
- Locate the row of buttons at the top of the record, and then click Edit.
- Enter the percentage of cash that should be made available for grants in Available For Cash, and then click Save.
- All Receivable Accounts and all Fixed Assets should have 0 entered in the Available For Cash field. These accounts should be excluded from admin fees if they are illiquid. If this field is set to 0, you should consider the admin fee calculation bases.
- All Receivable Accounts and all Fixed Assets should have 0 entered in the Available For Cash field. These accounts should be excluded from admin fees if they are illiquid. If this field is set to 0, you should consider the admin fee calculation bases.
- Navigate to the Funds page.
- Enter the fund name in the Search Fund field and select the fund from the drop-down list.
- Alternatively, click List in the left-side menu to view a list of all funds. Click the ID of the fund.
- Alternatively, click List in the left-side menu to view a list of all funds. Click the ID of the fund.
- Locate the row of buttons at the top of the record, and then click Edit.
- Available Cash can only be shown if the Track Spendable box is not checked in the Restrictions section.
- Click Save.