The Job Labor Report consolidates and summarizes metrics related to job labor within a given date range (based on the visits' scheduled date).
Specifically, this report compares and contrasts estimated labor for a particular job and the actual labor performed. The difference between estimated and actual is reflected in the Remaining column.
From there, Job Labor efficiency is calculated by [ Actual / Estimated = Efficiency ]
Filters on the report allow users to select the desired job labor data; these include Date Range, Operations, Sales Reps, and Assignees. The search bar in the upper right corner of the table will allow you to search by Job Reference Number, Job Name, and Customer.
In this article:
Access by navigating to:
Reports > Labor > Job Labor Report
Job Labor Report Features
Filters
To use the report, first select a Date Range. By default, this report shows the totals of Labor Line Items based on the visit's scheduled date.
Once you have a date range selected, you have the option to filter based on: Operation, Sales Rep, or Assignees.
⚠️ When you filter by Assignee, the results may show partial information if all visits on a job are not assigned to the same assignee.
If a job is missing: Report inclusion is based on the visit's scheduled date and Labor type estimated hours, not on whether the job is Completed or Approved. Check that:
At least one visit on the job is scheduled within the selected date range.
The job has at least one Labor type line item with estimated labor hours.
The Operation, Sales Rep, or Assignee filters aren't excluding the job.
Columns
The data included in the Job Labor Report can be controlled by selecting which columns to display. To access this:
Click the Columns button on the far left.
Select the desired columns to include or remove by clicking the name of the data field, and your selections will update on the report table.
Column order can be adjusted by dragging and dropping column headers. Data can be sorted by clicking on column headers. Click once to sort from Low-to-High, and again to sort from High-to-Low.
Values
Estimated | The summation of Labor Items on a job. *Note: If a job does not include any Items of type 'labor', the job will not be included in the report since it will not have an estimated quantity. |
Actual | The summation of Labor Lines reported on Job completion. |
Remaining | The difference between the Estimated and Actual Labor for the Job. If Estimated Labor is less than Actual Labor, this number will be positive and show how many hours one could stay on the Job and remain profitable. If the Estimated Labor is greater than the Actual Labor, the number will be negative and show the number of hours labor has exceeded the estimate. |
Efficiency | A ratio calculated as estimated labor-to-actual labor. If the ratio is greater than or equal to 100%, the Job is deemed to have been accurately estimated and efficiently handled. |
Rows
To expand the row: Click the "+" to the left of the table. Upon expanding the job, you will be shown additional information about the Items and Labor as it relates to the job.
To minimize the row: Click the "-" and the row will collapse.
Additional Features
Search Bar: The search bar in the top right of the table will allow you to search by the following: Reference Number, Job Name, Customer
⚠️ You cannot search by estimated, actual, remaining, or efficiency metrics.
Export CSV: You also have the option to export the data table to CSV to further manipulate the information. Once you select the Export CSV button in the top right, only the data depicted on screen will be exported.
Save Report: You have the ability to save the Job Labor Report and the filters that you have activated by selecting the Save Report button in the top right of the screen. You will be given the option to create a name for your report; afterwards, the report will be stored in the Saved Reports section of your Reports Catalog.
Update or Remove a Report
Navigate to
Reports > Saved Reports
To remove the report select Remove Saved Report
To update a saved the report, make your changes and select Update Report
🎥 Labor Reports Video