This query ( UGA_KK_DEPT_EXP_REV_BALS) shows departmental revenue and expenditures budgets, actuals, and balances by all chartfields. The user can select the fiscal year and can filter by several chartfield selections.
In this article, you will learn the steps to view budget balances and adjust to include revenues by running a query.
First, log into the Financial Management System.
Click the drop-down link next to the Employee Self Service menu.
Click the UGA Financials link.
Click the Query Viewer tile.
The Query Viewer page is displayed.
Enter appropriate information into the begins with field.
Example shown here: " UGA_KK_DEPT_EXP_REV_BALS ".
Click the Search button.
Click the HTML link.
You can search for specific information using different search criteria.
Example shown here: View Results button.
The Search Results page is dis played.
To view results in an Excel SpreadSheet, click the Excel SpreadSheet link.
Click the Open button to review the information in Excel.
The Excel spreadsheet opens in a new window.
You can filter through different columns to view the information you need.
If necessary, scroll to the right to view additional columns.
The Budget Balance and Revenue Budget information is displayed.