On the System Manager Reporting Page in OneUSG Connect, you can run the TL Reconciliation Report (180_TL_RECONCILIATION) to see hours in Time and Labor that have been 'Taken by Payroll.' This is a query that only shows the hours that are set to be paid for the payroll. The query will only show data after the first Payroll Load, typically on Monday afternoon.
Keep in mind that the hourly rate listed is the hourly rate on job data, and special Time and Labor Rules do not apply. For example, overtime hours will show the employee's base hourly rate, and not the time and a half rate.
For more information on this process, see the Manager Self Service for Supervisors and Time & Absence Approvers courses in the OneSource Training Library.
First, log into OneUSG Connect
From the Manager Self Service page, click the System Manager Reporting tile.
The System Manager Reporting page is displayed.
Under the Queries menu, click the Time and Labor menu item.
The available queries under Time and Labor are displayed.
Click the TL Reconciliation Report link.
The search criteria for the query 180_TL_RECONCILIATION is displayed
Click the Calendar icon next to the Period Begin DT field to select a date.
Note: You can search for a specific employee if you have the Employee ID available. You can also leave the % sign in the Employee ID and/or Dept ID fields to return all possible results.
Click the appropriate date for the Period Begin DT field .
Example shown here: March 24 link.
Click the Calendar icon next to the Period End DT field to select a date.
Click the appropriate date for the Period End DT field.
Example shown here: April 6 link.
Click the View Results button.
Click the Excel SpreadSheet link.
Click the Open button.
The Excel file opens in a protected view.
Click the Enable Editing button to work with the data.
Click any cell prior to inserting the Pivot chart in the document.
Click the Insert tab at the top of the screen.
Click the PivotChart button
The Create PivotChart dialog box is displayed with default settings. You can change the settings for the PivotChart according to your needs.
Example shown here: OK button.
The PivotChart is displayed. You can use the PivotChart Fields section to the right of the page to create the chart.
To include the Employee ID field in the PivotChart, you can drag the Employee ID field to the Axis (Categories) quadrant.
The Employee ID field is now shown under the Row Labels on the left side of the screen.
Next, you can drag the Last Name field to the Axis (Categories) quadrant.
Now you can see that the last names of the employees are displayed under their associated Employee ID in Column A.
In the PivotChart Fields area, scroll down to drag the Sum Quantity field to the Values quadrant.
The total reported hours for the pay period for all your employees are displayed
Click the Data tab at the top of the screen.
Click the Sum of Sum Quantity cell in B1.
Click the Sort Largest to Smallest icon button to sort the total reported hours in an increasing or decreasing order.
The reported hours are sorted to display hours reported from most to least.
Drag the Pay Group field to the Filters quadrant to filter the table by Pay Groups.
The Pay Group filter is displayed in the top row.
Click the Pay Group (All) drop-down menu to view reported hours for a particular pay group.
Click the Select Multiple Items option.
Deselect any pay group by clicking the checkbox next to the pay group.
Once you have deselected all the Pay Groups that you don't want to view, click the OK button.
Employees in the selected Pay Group(s) are displayed with their Last Names, Employee ID, and the total hours reported for the specific pay period.
Click the Sort Smallest to Largest icon button to sort the column from the least to the most number of hours reported.
The hours reported are displayed from lest to most.