Viewing Foundation Account Budget Balance in the UGA Financial Management System

Summary

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

Body

   Overview   

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

1. Step 1

step image

First, log into the Financial Management System.

Click the Employee Self Service object.

2. Step 2

step image

Click the UGA Financials link.

3. Step 3

step image

Click the Query Viewer tile.

4. Step 4

step image

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

step image

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

step image

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

step image

Click the View Results button.

8. Step 8

step image

The requested result is displayed.

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

9. Step 9

step image

Click the Open button.

10. Step 10

step image

Click in the Enable Editing field.

11. Step 11

step image

The Excel file is displayed.

Click the Select All button to select the entire sheet.

12. Step 12

step image

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

13. Step 13

step image

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

step image

The selected cells are displayed.

15. Step 15

step image

The sum is displayed.

16. Step 16

step image

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

Click in the begins with field.

17. Step 17

step image

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

step image

Click the HTML link for the query UGA_KK_DEPT_EXP_REV_BALS.

19. Step 19

step image

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

step image

Click the View Results button.

21. Step 21

step image

The requested results are displayed.  

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

22. Step 22

step image

Click the Open button.

23. Step 23

step image

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.

 

Details

Details

Article ID: 149082
Created
Sat 9/24/22 11:03 PM
Modified
Fri 3/8/24 1:45 PM