The Labor Hour and Rate Analysis provides the user with hourly information about employees in a chosen period of time. This report shows total amounts paid to employees, including overtime hours and rate.
Article Topics
Navigation
- In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears. - At the top of the My Reports screen, select Labor.
The screen generates a list of reports in alphabetical order. - Locate the Labor Hour and Rate Analysis.
- Select Customize to adjust the report parameters and run the report.
Report Parameters
| Field | Description | |
| 1 | Filter By | Location reporting category by which to filter the report. Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 2 | Filter | Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report. For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category. Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 3 | Start | First date to include in the report. The Start and Ends dates create a date range for which data is displayed in the generated report. |
| 4 | End | Last date to include in the report. The Start and Ends dates create a date range for which data is displayed in the generated report. |
| 5 | Group By | Determines whether data is grouped by Location or by Employee. |
| 6 | Job | Determines which jobs are included in the report. |
| 7 | Employee | Determines which employees are included in the report. |
| 8 | Include Employees | If set to Yes, employee names appear below their job titles. If set to No, only the job title is shown. |
| 9 | Break Page Per Location | If set to Yes, the report includes a page break after each location, allowing users to more easily separate data when printed or downloaded. |
| 10 | Identify Minors | If set to Yes, the word 'Minor' appears next to all employees who are under a certain age. |
| 11 | Primary Location | If set to Yes, employees are sorted by primary location. If the employee worked at more than one location, all rows for the employee appear listed below their primary location, and the Location column specifies the actual physical location where the employee worked the shift. If set to No, each row for the employee appears under the actual physical location where the employee worked the shift. |
| 12 | View options | Provides the user with options to select, save, edit, or delete a report view. For more information about these controls, see My Reports: Using My Reports. |
| 13 | Run | Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.  |
Report Columns
| Column | Description |
| Employee | If Group By Location was selected prior to running the report, displays labor data for employees grouped by the location where the labor data was recorded. If Group By Employee was selected prior to running the report, this column groups labor data by employee, regardless of the location where the labor data was recorded. For example, if an employee worked at Location 1 and at Location 2, all rows containing data for that employee are grouped, one below the other. |
| Employee Payroll ID | Number used to identify the employee in the payroll system. |
| Worked Location | Location where the employee worked the shift. This column appears only if the Primary Location parameter is set to Yes. |
| Location | Employee's primary location. |
| Job | Job that was worked. |
| Reg Hours | Number of hours worked at a regular rate. |
| Reg Rate | Regular rate of pay. |
| Reg $ | Amount owed to the employee for hours worked at the regular rate. |
| OT Hrs | Number of hours worked at an overtime rate. |
| OT Rate | Overtime rate of pay. |
| OT $ | Amount owed to the employee for hours worked at the overtime rate. |
| Total Hrs | Total number of hours worked. |
| Total $ | Total amount owed to the employee. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.