Viewing Foundation Account Budget Balance in the UGA Financial Management System

   Overview   

This article will walk you through two queries to view foundation account budget balances and expenditures.

1. Step 1

Oneusg connect Employee Self Service home page displayed with the dropdown arrow highlighted

First, log into the Financial Management System.

Click the Employee Self Service object.

2. Step 2

Oneusg connect Employee Self Service home page displayed with the UGA Financials link highlighted

Click the UGA Financials link.

3. Step 3

UGA Financials home page displayed with the Query viewer tile highlighted

Click the Query Viewer tile.

4. Step 4

Query Viewer page displayed with the begins with field highlighted

The Query Viewer page is displayed. Enter appropriate information into the begins with field.

Note: You can enter the entire query name or can do a partial search.

Example shown here: " UGA_KK " in the begins with field.

5. Step 5

Query searched results displayed with the selected HTML link highlighted

The search result is displayed. Click the appropriate query link.

Example shown here: HTML link for the Query UGA__KK_DEPT_BUDGET_BALANCE.

6. Step 6

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the Class field highlighted

The search parameters for the query are displayed. The Fiscal Year, Thru Period, and the Bud Ref fields auto populate. You can change the search criteria for any field.

Enter appropriate information into the  Class  field.

Example shown here: " 67072 " in the Class field.

7. Step 7

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the View Results button highlighted

Click the View Results button.

8. Step 8

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the Excel Spreadsheet linkhighlighted

The requested result is displayed.

Click the Excel SpreadSheet link to open the data into an Excel file.

9. Step 9

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the Open button highlighted

Click the Open button.

10. Step 10

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the Enable Editing button highlighted

Click in the Enable Editing field.

11. Step 11

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the Select All button highlighted

The Excel file is displayed.

Click the Select All button to select the entire sheet.

12. Step 12

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the selected columns highlighted

Select and shrink the columns to view all the fields to the right.

13. Step 13

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with column 17 highlighted

You can filter through and analyze the data in any way you want.

Example shown here: " =sum( " in the field under the column 17

14. Step 14

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the selected cells highlighted

The selected cells are displayed.

15. Step 15

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the column 17 sum highlighted

The sum is displayed.

16. Step 16

Query Viewer page displayed with the Begins With search field highlighted

Close the Excel tab to switch back to the Query Viewer page.

Click in the begins with field.

17. Step 17

Query Viewer page displayed with the Begins With search field highlighted

Enter appropriate information into the begins with field.

Note: You can enter the entire query name or can do a partial search.

Example shown here: "UGA_KK" in the begins with field.

18. Step 18

Query searched results displayed with the selected HTML link highlighted

Click the HTML link for the query UGA_KK_DEPT_EXP_REV_BALS.

19. Step 19

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page displayed with the Class field highlighted

The parameters for the specific query are displayed. You can edit/enter information into any of these search fields.

Example shown here: " 67072 " in the Class field.

20. Step 20

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the View Results button highlighted

Click the View Results button.

21. Step 21

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page  displayed with the Excel spreadsheet link highlighted

The requested results are displayed.  

Click the Excel SpreadSheet link to open the data in an Excel spreadsheet.

22. Step 22

UGA_KK_DEPT_BUDGET_BALANCE - Departmental Budget Balances page displayed with the Open button highlighted

Click the Open button.

23. Step 23

UGA_KK_DEPT_BUDGET_BALANCE spreadsheet displayed with the expenditure and revenue balances highlighted

The expenditure and revenue balances are displayed for the specific department.

You can filter through the data to view and analyze the information you need.