You can review the budget status of all chartstrings in your unit by running the UGA_KK_DEPT_EXP_REV_BALS query from the Query Viewer in the UGA Financial Management System.
Query results can be downloaded to Excel where the data can be filtered or used in a pivot table.
In this article you will learn how to review the chartstring budgets for your unit using the UGA_KK_DEPT_EXP_REV_BALS query.
First, log into the Financial Management System
Click the Query Viewer tile.
UGA queries use a specific naming convention. All queries begin with UGA_XX (where xx = the module to which the query pertains. Commitment Control uses KK as the module abbreviation.
Enter " UGA_KK_DEPT " in the search field to search for the report.
Click the Search button.
The queries that match the criteria are listed.
You can click the HTML option to view the results on your screen and print from the web browser. Alternatively, you can click on Excel to save the information and analyze using pivot tables and other Excel features.
Click the HTML link for the UGA_KK_DEPT_EXP_REV_BALS query.
A new page opens with the parameters you can use to find your budget information.
The report defaults to the current fiscal year.
The report defaults to the final period of the fiscal year to include all transactions entered. You can type or use the search features to select a different period .
Note : July is Period 1 in the fiscal year moving successively to June which is Month 12.
The Budget Reference ChartField defaults to the current budget year. You can type in a different year, if needed.
The "%" wildcard allows users to run the query with or without ChartField filters.
To view an entire division, enter the first two digits of the department number followed by "%".
To view a specific department, enter the full eight digit department number in the prompt field without the wildcard.
Enter appropriate information into the Dept field.
Example shown here: " 17% " in the Dept. field.
Click the View Results button.
The query reflects budgeted expenditures, encumbrances, actual expenditures and budgeted balances for each defined chartstring.
The farthest right columns also show the budgeted revenues, recognized (actual) revenue, and the estimated budget balance (budgeted revenue - recognized revenue) by chartstring.
From this page you can download the results to Excel. This will open an Excel file and load the data shown on the screen. You can then use Excel features such as filters and pivot tables to analyze the data.
When you have completed the review, close the Query page.