User Personas: Admin | Project Manager
Labor reports tell you whether the job is being built at the rate you bid it. They compare budgeted hours and units against what the field actually reported, so you can see a productivity problem while there is still time to do something about it.
There are three of them, and they answer different questions. All three read from the same source data:
- Your project budget
- Crew Timecards from Daily Reports
To perform the actions described in this article, you must have the Analytics - Labor Reports - View permission. See the Permissions table at the end of this article.
Use the links below to jump to a topic:
- Which Report Answers Which Question
- Where the Numbers Come From
- View Project Labor Reports
- Labor Productivity
- Labor Unit Productivity
- Lost Hours Report
- Permissions
- FAQ
Which Report Answers Which Question
Report |
The question it answers | Requires |
Labor Productivity |
Are we burning hours faster than we budgeted them? | Budgeted hours on the project. |
Labor Unit Productivity |
Are we installing at the production rate we bid? | Budgeted hours AND budgeted units, plus units reported in the field. |
Lost Hours |
How much time did we lose, and to what? | Lost hours recorded on Daily Reports. |
Labor Productivity is the one to start with, because it needs the least setup. Labor Unit Productivity is the more powerful of the two, but only if your crews are reporting installed quantities as well as hours.
Where the Numbers Come From
No figure in these reports is typed in directly. Each column is fed by something upstream, which is why a blank column is nearly always a setup or data-entry gap rather than a reporting fault.
Column family |
Source |
Original budgeted hours and units |
The Budgets page under Settings on the project. |
COR and approved change order hours |
Change Order Requests in Approved status. Change orders in any other status are excluded. |
Actual hours and completed units |
Crew member timecards, entered through Daily Reports. |
Lost hours |
Lost hours recorded on Daily Reports, separately from hours worked. |
Cost code names |
The project cost code list. |
View Project Labor Reports
- Select a project from the project list, then select Labor Productivity, Labor Unit Productivity or Lost Hours under Reporting in the slide-out menu
- Select a custom date range if you want to narrow the period shown
If you would like to export the report for further analysis:
- Select the Actions button, then select the export option
- Choose either Excel (.xlsx) or .csv format, then save the file on your computer
The export reflects what the report is currently showing, so set your date range before exporting.
Labor Productivity
The Labor Productivity report is labor focused. It compares your total budgeted hours for each cost code against the hours actually reported in the field.
|
Run Labor Productivity weekly rather than at closeout. A cost code drifting over budget is a conversation with a foreman while the work is still in front of you. The same number at the end of the job is just a loss you have already taken. |
Labor Productivity Columns
Column |
What it shows |
Project Cost Code and Name |
The cost code number and name as it appears on the project cost code list. |
Original Budgeted Hours |
The original hour estimates associated with each cost code, pulled from the Budgets page under Settings. |
COR Hours |
Hours from change orders in Approved status associated with each cost code. |
Total Budgeted Hours |
The sum of original hour estimates and approved change order hours. |
Actual Hours |
All reported hours for the cost code from crew member timecards, derived from Daily Reports. |
Remaining Hours |
Total Budgeted Hours minus Actual Hours. |
Lost Hours |
Reported lost hours for the cost code, derived from Daily Reports. |
Labor Unit Productivity
The Labor Unit Productivity report combines labor and production unit data for each cost code. It shows percentage complete per cost code and compares budgeted against actual production rates, which is the closest thing to a direct read on whether the crew is hitting the rate you bid.
| Export the Labor Unit Productivity Report to to Excel (.xlsx or .csv) to adjust columns, freeze panes, and customize the view to analyze all of your data. |
Its columns fall into three groups:
Budgeted Values
Column |
What it shows |
Project Cost Code and Name |
The cost code number and name as it appears on the project cost code list. |
Original Budgeted Hours |
The original hour estimates for each cost code, pulled from the Budgets page under Settings. |
Approved CO Hours |
Hours from change orders in Approved status for each cost code. |
Total Hours |
The sum of original hour estimates and approved change order hours. |
Original Budgeted Units |
The original unit estimates for each cost code, pulled from the Budgets page under Settings. |
Actual Values
Column |
What it shows |
Actual Hours |
All reported hours for the cost code from crew member timecards, derived from Daily Reports. |
% Complete Hours |
Actual Hours divided by Total Hours for each cost code. |
Completed Units |
All reported units for the cost code from crew member timecards, derived from Daily Reports. |
% Complete Units |
Actual Units divided by Original Budgeted Units for each cost code. |
Remaining Units |
Total Budgeted Units minus Actual Units. |
Production Rates
Column |
What it shows |
Budgeted Rate |
Total Budgeted Units divided by Total Hours for each cost code. |
Actual Production Rate |
Actual Units divided by Total Hours for each cost code. |
Production Rate Difference |
Actual Production Rate minus Budgeted Rate for each cost code. |
Lost Hours Report
The Lost Hours report tracks and documents hours lost on the job to issues outside the planned work, such as trade stacking, material delays, site access problems or appointments. Beyond productivity analysis, it is the documentation you need when the lost time was somebody else's fault.
This report is an easy way to quickly view and summarize all Lost Hours entered on a Daily Report for analysis and documentation needed for any delay claims, change conditions notices and subsequently reimbursement per change order.
Lost Hours Columns
Column |
What it shows |
Date |
The specific date the lost hours occurred, which gives you a timeline for analysis. |
Cost Code |
The code associated with the work being performed, for example 100 Labor. Categorises which types of work are being impacted. |
Labor Class |
The role of the affected crew member, e.g. Foreman, Journeyman or Laborer. |
Crew Member |
The specific crew member affected by the delay. |
Lost Hours |
The number of hours that crew member lost to the delay. |
Comments |
The reason for the delay, for example "Team had to stay 2 extra hours because of the late material delivery". This is what turns the report into usable documentation. The comments are derived from crew member specific comments on the Crew Tab of the Daily Report, not from the General Info's Comment fields. Anytime Lost Hours are entered on a Daily Reports, Comments are required. |
DR Number |
Links the lost hours back to a specific Daily Report for cross-reference. |
|
Lost hours are not included in timecards and are for reporting purposes only. The full number of hours the employee worked that day should still be entered in the Hours Worked fields on the Daily Report. Recording lost hours does not reduce anyone's pay. |
How to Use the Lost Hours Report
Use |
How |
Tracking project delays |
Review the comments and total hours lost to find root causes. Recurring issues such as material delays or trade stacking become visible once they are written down in one place. |
Cost management |
Lost hours are additional project cost, so the report feeds the analysis needed for potential cost forecasting and budget adjustments. |
Performance monitoring |
Assess productivity levels and identify workflow changes that would reduce delays. |
Reimbursement |
Where lost hours are outside your control, such as weather, late deliveries or incomplete work by another subcontractor, the report documents why you should be reimbursed for the additional time on site. |
Permissions
| Permission | What it allows |
| Analytics - Labor Reports - View | View the Labor Productivity, Labor Unit Productivity and Lost Hours reports on a project. This permission also governs the project progress bar and the Project Summary widgets, so removing it hides those as well. |
If a user cannot see a report described in this article, review their Analytics permissions. Admins manage these from User Permissions.
FAQ
A cost code shows budgeted hours but no actual hours.
No time has been recorded against that cost code in a Daily Report, or the hours were recorded against a different code. Actual hours come only from crew timecards, so if the work happened but was logged elsewhere, this is where it shows.
Unit columns are empty.
Either no budgeted units were entered on the Budgets page, or the field is not reporting installed quantities on Daily Reports. Labor Unit Productivity needs both sides to produce a rate. See Where the Numbers Come From.
Do lost hours reduce the hours on a timecard?
No. Lost hours are recorded separately and are for reporting only. The full hours worked should still be entered in the Hours Worked fields on the Daily Report.
Are change order hours included?
Only from change orders in Approved status. Hours on a change order that is still pending, priced or returned are excluded until it is approved, which is worth remembering when a total looks lower than you expected.
A user lost the project progress bar and summary widgets.
The Labor Reports permission controls those as well as the reports themselves. If it was removed to hide labor reporting, the progress bar and Project Summary widgets go with it. That is intended behavior, since those widgets surface the same labor data in condensed form.
A cost code is over 100 percent complete.
The crew reported more hours or units than were budgeted for that code. That is either a genuine overrun, work booked to the wrong cost code, or a budget that was set too low. The Comments on any related Daily Reports usually tell you which.
See also: Set Up Your Project for Job Cost Reporting · Labor Rates Setup · Project Budget Setup