Working in the Financial Statistics Workcenter

   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

Employee Self Service hompage displayed with the Classic Home tile highlighted

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

2. Step 2

Classic Homepage displayed with the UGA Financials Stats Workcenter link highlighted

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

UGA Financial Stats Workcenter displayed with the Budget Journals arrow highlighted

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

UGA Financial Stats Workcenter displayed with the expand arrows highlighted

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

5. Step 5

UGA Financial Stats Workcenter displayed with the Budget Journals arrow highlighted

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

UGA Financial Stats Workcenter displayed with the Payment Request Details by Employee link highlighted

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

UGA Financial Stats Workcenter displayed with the Calendar icon highlighted

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

UGA Financial Stats Workcenter displayed with the Calendar date highlighted

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

UGA Financial Stats Workcenter displayed with the Enter Dt - TO field highlighted

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

UGA Financial Stats Workcenter displayed with the View Results button highlighted

Click the View Results button.

11. Step 11

Query results displayed with the Download result in field highlighted

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

Query results displayed with the Expense Report Counts field highlighted

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

13. Step 13

UGA Financial Stats Workcenter displayed with the Calendar icon highlighted

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

UGA Financial Stats Workcenter displayed with the Calendar date highlighted

Click the November 1, 2019 link.

15. Step 15

UGA Financial Stats Workcenter displayed with the Calendar icon highlighted

Click the Calendar Created-TO icon.

16. Step 16

UGA Financial Stats Workcenter displayed with the Calendar date highlighted

Click the November 19, 2019 link.

17. Step 17

UGA Financial Stats Workcenter displayed with the View Results button highlighted

Enter the required query search parameters.

Click the View Results button.

18. Step 18

Query results displayed with the Excel Spreadsheet link highlighted

The results of the query are displayed.

To export the results, click the Excel Spreadsheet link.

19. Step 19

System prompts for opening the file displayed with the OK button highlighted

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

Excel Spreadsheet displayed with the data highlighted

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