The Fund Balance Accounting Period Inquiry (FBALAPD) page provides an online inquiry, which is a subset of the Trial Balance Inquiry (TBAL) page. FBALAPD shows only nominal account activity and that is summarized information at a level higher than individual department, object, and revenue source codes. Whereas existing Fund Balance Detail (FBALDQ) and Fund Balance Summary (FBALSQ) information contains similar amounts, those two pages present totals that are ‘as of now’. The FBALAPD page allows for the display of information up to and including a specified accounting period (APD).
Browsing requires a user to enter a Fiscal Year (FY) and Accounting Period (APD). A browse cannot use the special APD values for 0 and 99 used by Annual Close. There are other required fields: Fund Dimension, Fund Dimension Value, and selection of either the Real Accounts or the Nominal Accounts flag (or both selected). Sub Fund is required if the Fund Dimension selected is Sub Fund. Browse fields do not allow wildcards or multiple values. When a user wants to see multiple sub funds, then a search with just a fund code will provide that detail. Please note sub fund use is not required to get totals in the second grid.
All amounts reflect the signs as stored in journals and leaders. This means that credit balances are negative and debit balances are positive. For this reason, revenues will appear negative, but are actually accrual and collection increases.
First Grid - When searching on a sub fund, the FY Beginning Balance value comes from SFUND. When searching on a fund, the FY Beginning Balance value comes from FUND. When searching on a fund rollup, FY Beginning Balance is an aggregate of all funds defined to the rollup. APD to Date Revenue is records up to and including the browsing APD with a revenue posting code. APD to Date Spending is records up to and including the browsing APD with a spending posting code. The APD to Date Ending Balance is a calculation of FY Beginning Balances minus APD to Date Spending plus APD to Date Revenue.
Second Grid - Prior Balance is a sum of revenue and spending records where the APD is one less than the browse APD. APD Revenue is records in the browse APD with a revenue posting code. APD Spending is records in the browse APD with a spending posting code. The APD to Date Ending Balance is a calculation of Prior Balance plus APD Revenue plus APD Spending.
Please note that until the prior FY is closed, the page will not have any FY Beginning Balances on FUND and SFUND to pull into FY Opening Balance.
There is a download feature available for the page that takes all data from the second grid (not just what is visible online) and downloads it to Excel, using the defined system download line limitation. A link also exists to transition a user directly to the second page (Accounting Ledger Review) of the Accounting Journal Ledger Query (JLACTGQY) with data from the row selected in the second grid. This feature is useful when researching an amount on the TBAL that does not look correct. The Accounting Ledger Review will break down totals by APD and COA such as department, unit, object, and revenue source. This allows a user to spot the one or more periods in unusual balances or activity. From that page, a user can open Accounting Journal page to find individual documents for review.
As the FBALAPD is a subset of the TBAL page, a transition exists to carry a user to the TBAL page. There the user can obtain details such as department, object, revenue source, and optionally closing classification to break down a single FBALAPD amount into smaller units for researching.