Available Budget Balances

View the beginning balance, current activity, and ending available budget balances in the system. You can filter on specific dates, accounts, and criteria to determine which data to display in the grid.

 

In this topic:

 

Set the Date Range

Document Date From, To: Set the date range for the documents you want to display balances for in the grid.


Apply Your Filters

Use filters to narrow down the range of accounts you want to display in the grid. You can double click or drag-and-drop individual segments to move them to the Selected Filters area.

Add All | Remove All: Select to quickly add or remove all of the Available Filters to the Selected Filters area.

 

Operators

When filtering data, select an operator and enter criteria to determine which data to display.

 

Criteria 1

Enter or select a value to compare with the item in the Selected Filter column. When using Like or Not Like, use "%" to represent any number of characters. For example, you want results showing the Accounts Receivable offset account assignments. Since you only want information on AR accounts and they all begin with "AR," you would complete the criteria as follows:

  • Selected Filter: Transaction Source
  • Operator: LIKE
  • Criteria 1: AR%

This filter limits the results to only transaction source codes that begin with AR, while the rest of the code could have any characters.

Please note the results if you choose the Like operator and the following criteria:

Criteria

Result

%AR%

Returns data with "AR" in any position

AR%

Returns data that begins with "AR"

%AR

Returns data that ends with "AR"

 

Criteria 2

Enter or select a value for the end of a range if the Compares To contains the Between or Not Between operators.


View & Export Your Results

The Transactions grid displays the results based on the filters you applied above. You can drill down into specific transactions and documents. You can Export your data in PDF or XLS format.

 

Level 1 - Original Document

The original document information.

{Segment Name}: The segment name being filtered on

Budget: The amount calculated by taking the net amount of budget decreases and increases for the Date From to the Date To

Actual: The amount calculated by taking the net amount of actual decreases and increases for the Date From to the Date To

Available Budget: The amount calculated by taking the Actual and Encumbrance less the Budget

 

Level 2 - Related Documents

All applicable documents associated with the original document.

Type: The entry type chosen during transaction entry

Transaction Type: The transaction type associated with the document, such as ARB, API, CL, or PRS

Document Number: The document number associated with the transaction code

Posted Amount: The amount applied to the account balance

ID: The ID associated with the document

Session ID: The session ID associated with the document

Document Date: The session date specific to this document

Document Description: The description entered on the transaction entry form

 

Level 3 - Transactions

All transaction lines for the original and related documents.

{Segment Name}: The system displays one column for each valid segment

Debit: The debit amount for the transaction line

Credit: The credit amount for the transaction line

Entry Type: The entry type chosen during transaction entry — Normal (N), End of Year Adjustment (A), Adjust Opening Balance (AO), Beginning Balance (UO), or System Opening Balance (SO)

Effective Date: The effective date entered during transaction entry

Transaction Description: The description entered for the transaction line item