Fund Balance Accounting Period Inquiry

The Fund Balance Accounting Period Inquiry (FBALAPD) page provides real-time information similar to the nominal account records of a trial balance report. The page uses data in the Accounting Journal and the Accounting Ledger – APD to calculate amounts for a summary section and a detail grid.

All amounts reflect the signs as stored in journals and ledgers. 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.

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 the calculation of the Ending Balance calculation for the first grid.

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 FBALADP that does not look correct. The Accounting Ledger Review will break down totals by APD, allowing a user to spot the one or more periods in unusual balances or activity. From that page, a user can open the Accounting Journal page to find individual transactions for review.

The fields in the filter section:

Field Name	Required?	Field Description
Fiscal Year	Required	Each search requires the specification of a single year.
Accounting Period	Required	Each search requires the specification of a single accounting period. The period entered is used both as an ‘up to and including this period’ as well as what is the ‘current’ period of the trial balance inquiry. Special accounting periods of 0 and 99 are not allowed.
Fund Dimension	Required	Choices include Fund and Sub Fund as delivered, where the latter should only be used if Sub Fund is retained in the Accounting Ledger – APD as setup on the Journal Ledger Control (JLCTRL) page. If JLCTRL setup is changed for the ledger to retain fund rollups, then those rollup choices will appear in this field.
Fund Dimension Value	Required	This COA field requires a single code to be entered without any wildcards as the page can only perform a single query. Multiple code inquiries are supported through reports or multiple FBALAPD queries where you download the results of each and then combine them. The code entered will be of the selection entered in the Fund Dimension except if Sub Fund is selected there. In that case the Fund Dimension Value will be the parent Fund code of the Sub Fund entered in the next field.
Sub Fund	Conditionally Required	If the Fund Dimension choice is Sub Fund then this COA field requires a single code to be entered without any wildcards.

The fields in the summary section:

Field Name	Required	Field Description
FY Beginning Balance	System Calculated	The FY Beginning Balance of the selected Fund (or Funds if using a Fund rollup) or the FY Beginning Balance of the selected Sub Fund from the respective reference page.
APD To Date Revenue	System Calculated	Total amount of all revenues selected up through and including those of the accounting period where the Posting Code had a Code Type of Revenue as defined on the Posting Code (PSCD) page.
APD To Date Spending	System Calculated	Total amount of all spending selected up through and including those of the accounting period where the Posting Code had a Code Type of Spending as defined on the Posting Code (PSCD) page.
APD to Date Ending Balance	System Calculated	The FY Beginning Balance after adding in APD To Date Revenue and subtracting APD To Date Spending, giving what would be an unadjusted fund balance if closed at the end of the APD.

The fields in the details section that are unique:

Field Name	Required?	Field Description
Prior Balance	System Calculated	Is a sum of selected spending and revenues from accounting period 1 up to but not including the accounting period searched.
APD Revenue	System Calculated	Total amount of all revenues selected in the searched accounting period where the Posting Code had a Code Type of Revenue as defined on the Posting Code (PSCD) page.
Total Credits	System Calculated	Total amount of all spending selected in the searched accounting period where the Posting Code had a Code Type of Spending as defined on the Posting Code (PSCD) page.
APD to Date Ending Balance	System Calculated	The FY Beginning Balance after adding in APD To Date Revenue and subtracting APD To Date Spending, giving what would be an unadjusted fund balance if closed at the end of the APD.