Working in the Financial Statistics Workcenter

Summary

In this article, you will learn the steps to use the Financial Statistics Workcenter in the UGA Financial Management System to run a query and view/export related data.

Body

   Overview   

 

In the UGA Financial Management System, you have access to a list of queries that can be used to track useful statistics relating to financial transactions. The queries are organized by system module. Results can be exported as an Excel file for reporting purposes.

In this article, you will learn the steps to use the Financial Statistics Workcenter in the UGA Financial Management System to run a query and view/export related data.

1. Step 1

step image

From the Employee Self Service homepage, click the Classic Home tile.

2. Step 2

step image

To navigate to the UGA Financial Stats Workcenter, select:

Main Menu > UGA > UGA Financial Stats Workcenter

Click the UGA Financials Stats Workcenter link.

3. Step 3

step image

The UGA Financial Stats Workcenter is displayed with a list of available queries on the left side of the screen. The queries are organized by system module.

To collapse any of the modules, click the arrow to the left of the module name.

Example shown here: Budget Journals arrow.

4. Step 4

step image

The section is collapsed. Use the arrow to the left of any module to collapse each section as needed.

5. Step 5

step image

To re-expand, click the arrows again as needed to display the list of queries.

Example shown here: arrow to the left of Budget Journals .

6. Step 6

step image

To view a query, click the appropriate link.

Example shown here: Payment Request Details by Employee  link in the Payment Requests section.

7. Step 7

step image

The Payment Request Details by Employee query search screen is displayed. You must enter both a FROM and TO date. Dates can be entered manually in the MM/DD/YYYY format or by using the calendar.

Note: Leaving the Employee  field blank will return all employees that initiated a payment request for the dates selected.

Click the calendar icon to the right of the Enter Dt - FROM field.

8. Step 8

step image

The Calendar pop-up window is displayed. Select the appropriate month and year from the corresponding drop-down lists. Click to select the appropriate date.

Example shown here: November 1, 2019  link.

9. Step 9

step image

The selected date is displayed in the FROM field.

Select or enter the appropriate information in the Enter Dt - TO field.  

Example shown here: 11/19/2019.

10. Step 10

step image

Click the View Results button.

11. Step 11

step image

The query results are displayed. Results can be exported into an Excel Spreadsheet, CSV (Comma Separated Value) Text File, or XML File (which can be embedded).

12. Step 12

step image

In the left navigation menu, click the Expense Report Counts link.

13. Step 13

step image

The Expense Report Counts query search page is displayed.

Note: The % in the Dept field is a wild card and will return all results. Data followed by % will return partial matches. The field cannot be left blank.

Click the Calendar Created-FROM  icon.

14. Step 14

step image

Click the November 1, 2019 link.

15. Step 15

step image

Click the Calendar Created-TO icon.

16. Step 16

step image

Click the November 19, 2019 link.

17. Step 17

step image

Enter the required query search parameters.

Click the View Results button.

18. Step 18

step image

The results of the query are displayed.

To export the results, click the Excel Spreadsheet link.

19. Step 19

step image

The system prompts for opening the file are displayed. Select the appropriate option(s) to open the file.

Example shown here: OK button.

20. Step 20

step image

The data is displayed in Excel.

 

Additional information:

Available queries include:

  • Budget Journal Approval Counts
  • Budget Journals Returned
  • Expense Report Counts
  • Expense Report Approval Counts
  • Expense Report Denials
  • GL Journal Counts
  • GL Journals Returned
  • Payment Request Counts
  • Payment Request Details by Department
  • Payment Request Details by Employee
  • Payment Requests Returned
 

Details

Details

Article ID: 148970
Created
Sat 9/24/22 10:59 PM
Modified
Fri 3/8/24 2:31 PM