Fund Balance Inquiries

Each level of Fund balance control has a corresponding inquiry table where amounts are tracked and may be used for editing if maintenance records are established for that feature.

  1. Fund - 'Summary’ on Fund Balance Summary (FBALSQ)

The Fund Balance Summary page displays current balances for fund balance tracking amounts for a Fund. Settings for control level and for what amounts to use in calculating Adjusted Fund Balance come from the Fund Balance Summary Maintenance (FBALS) page.

  1. Fund and Sub Fund - 'Detail’ on Fund Balance Detail (FBALDQ)

The Fund Balance Detail page displays current balances for fund balance tracking amounts for a Fund and Sub Fund combination. Settings for control level and for what amounts to use in calculating Adjusted Fund Balance come from the Fund Balance Detail Maintenance (FBALD) page.

The layout and fields for each page are very much the same. COA fields change, as do the Related Pages. Only one set of field definitions is given. COA fields are not defined unless they have a special property.

Field Name

Field Description

Sub Fund

A special value exists for this field when Sub Fund is not being used to define a set of fund balance rules or track amounts – BLNK.

Fund Balance

The total balance of all equity defined for the Fund and Sub Fund combination on the BSA tab of the Edit Fund Balance Detail Maintenance page.

Adjusted Fund Balance

A calculated amount using the ‘include amount’ indications set on the applicable Detail or Summary Detail Maintenance page and the Fund Balance. This amount gives a total before applying any Fund Balance Minimum.

Fund Balance Minimum

An optional minimum amount that should be kept in reserve.

Available Fund Balance

The calculated net result after applying any Fund Balance Minimum to the Adjusted Fund Balance. It is this amount when calculated during transaction processing that is evaluated and an error of the defined severity is issued.

Pending Revenue Increases

Pending Revenue Decreases

This pair of amounts on the inquiry pages and ‘include amount’ indications of the maintenance pages track and optionally include in the fund balance availability editing revenue amounts that are currently in workflow. Posting Code settings determine what Posting Codes are these amounts but Billed Earned Revenue (R002) and Collected Earned Revenues (R003) are examples. Posting codes are not defined as an increase or decrease, but the type of update to the account determines the Pending Revenue amount.

Pending Spending Increase

Pending Spending Decrease

This pair of amounts on the inquiry pages and ‘include amount’ indications of the maintenance pages track and optionally include in the fund balance availability editing spending amounts that are currently in workflow. Posting Code settings determine what Posting Codes are these amounts but Accrued Expenditures (D011) and Cash Expenditures (D014) are examples. Posting codes are not defined as an increase or decrease, but the type of update to the account determines the Pending Spending amount.

Accepted Revenues

This amount tracks revenue amounts from transactions that have reached the Final Transaction Phase. Posting Code settings determine what Posting Codes update this amount. Billed Earned Revenue (R002) and Collected Earned Revenues (R003) are examples.

Accepted Spending

This amount tracks spending amounts from transactions that have reached the Final Transaction Phase. Posting Code settings determine what Posting Codes update this amount. Accrued Expenditures (D011) and Cash Expenditures (D014) are examples.

Fund Balance Error Severity

The level of error severity to be generated if a posting line should result in the fund balance amount to drop below the minimum fund balance. Valid values are Warning, Overrideable Error, Error, or No Error.

Balance Control

The indication of where the edits should be performed. Valid options are: Summary and Detail.

Current Balance

This amount is shown only on the BSA tab of the Edit Fund Balance Detail Maintenance page where it is the current balance for the account as seen on the ITD Balance Sheet Detail page. These amounts are summarized up to the Fund Balance amount seen on the two fund balance inquiry pages.

More Info