Technician Hourly Production Report GuideLast updated on 03/22/2022

Purpose of the Technician Hourly Production Report:

This report provides an overview of how well technicians are performing, based on business unit. Data in this report is based on invoices created within the report date range. This report includes all invoices regardless of status (pending, posted, and exported invoices).

Common uses for this report:

Use this report to view job number, invoice subtotals, split percentages, total hours, sold hours, efficiency, hourly sales, and gross costs.

How to find this report:

Click Reports > Search Technician Hourly Production> Click the report name. Then you will be able to set filters and run the report.

Report filters

Technician

Filter by technician. This report can be run by a single technician or all technicians.

Business Unit

Filter by business unit. This report can be run by a single business unit or all business units, based on technician.

Date Range

Filter by date range. Use the From and To fields to set a custom date range.

View or download the report

Click Run to view the report.

The report can be downloaded in three different formats:

Download PDF
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)

Explanation of report columns

The report includes the following columns:

Job	Job number on the invoice.
Date	Job arrival date on the invoice.
Total $	Total dollar amount on the invoice, including tax.
Split %	Percentage of technician splits on the job. The split determines how much credit each technician is getting for the job. By default 100% of the technician split will go to the first technician assigned to the job. If you assign additional technicians to a job, you’ll need to navigate to the invoice to adjust the splits. Note: The sum of split percentages for all technicians assigned to a job must be equal to 100%. How to Configure - Split %: To set split percentages, navigate to an invoice and select Adjust splits from the left menu.
Total Hrs	Total number of hours spent on a job for all technicians combined. This is the total number of hours, rounded to the nearest tenth. For example, it one technician works for 2.1 hours, and another technician works for 2.1 hours, this means that the total hours spent on the job is 4.2 hours. Technician splits are not included in the calculation. [2.1 hrs + 2.1 hrs] = 4.2 total hrs To change hours to minutes: If the technician was on the job site for 2.1 total hours, it means the technician worked for 126 minutes. To calculate the number of minutes, simply multiply total hours by 60 minutes. 2.1 total hrs x 60 mins = 126 mins on the job Multi-day jobs are calculated by taking the sum of hours worked for each day. For example, if the technician was on the job site for 2.1 hours one day and 3 hours the next day, it means the technician worked for a total of 5.1 hours (306 minutes). To view total hours, navigate to technician timesheets in Search > Job > Blue Job Action Button > Timesheets. On the timesheet, you will see an Arrived On time and a Done On time. Total hours is the difference between the Arrived On time and the Done On time. For example, the technician arrived on the job at 1:04pm and was done on the job at 2:42pm. The technician worked 1.6 total hours. Calculation - Total Hrs: [Time of job completion/cancellation] - [Time of job arrival]
Hours	Hours spent on a job for a single technician. This is the number of hours, rounded to the nearest tenth. For example, it a technician works for 2.1 hours, out of a 4.2 total hour job, this means that the technician worked 50% of the total hours. Technician splits are included in the calculation. [2.1 hrs / 4.2 total hrs] 100. = 50% Next to the number of hours, you will see the percentage of hours the technician worked, out of the total hours spent on a job. For example, if a technician works for 2.1 hours, out of a 2.1 total hour job, this means that the technician worked 100% of the total hours. Technician splits are included in the calculation. [2.1 hrs / 2.1 total hrs] 100. = 100% To view hours, navigate to technician timesheets in Search > Job > Blue Job Action Button > Timesheets. On the timesheet, you will see an Arrived On time and a Done On time. Total hours is the difference between the technician Arrived On time and the technician Done On time. For example, David arrived on the job at 1:04pm and was done on the job at 2:42pm. David worked 1.6 hours. Calculation - Hours: [Technician time of job completion/cancellation] - [Technician time of job arrival] *100.
Sold Hrs	Total hours billed for the technician. Sold hours is the amount of time the technician is paid for working. Technician splits are included in the calculation. Calculation - Hourly Split:[Hours rounded to the nearest tenth] / [Total hours rounded to the nearest tenth] Calculation - Sold Hours: [Hourly split] x [Sum of hours spent on the job for a single technician] How to Configure - Sold Hours:To set sold hours, navigate to Settings > Pricebook > Services > Commission tab > Hours.
Efficiency	Efficiency tells you how productive the technician is on a job, based on whether the actual hours on the job are above or below the sold hours in your Pricebook. If the billable efficiency percentage is above 100%, this means the technician completed work faster than expected. Calculation - Efficiency:([Total hours billed to the customer] x [Technician splits]) / [Hours the technician spent on a job] *100. Trigger: Job completed (invoice subtotal does not need to be over the sold threshold). How to Configure - Sold Hours:To set sold hours, navigate to Settings > Pricebook > Services > Commission tab > Hours.

(Report columns continued)

Tech $	Total dollar amount the technician is compensated for, based on the technician’s hourly pay rate. Calculation - Tech $: [Hours the technician spent on a job] x [Technician hourly pay rate] How to Configure - Tech $:To set a technician’s hourly pay rate, navigate to Settings > Technicians > Payroll tab > Hourly Rate.
Sales $	Total job revenue. This is the invoice subtotal. Calculation - Sale $:([Hours the technician spent on a job] / [Total hours spent on a job]) x [Invoice subtotal] x [Technician splits]
Hourly Sales	Total revenue generated per hour. Calculation - Hourly Sales: [Total job revenue] / [Hours the technician spent on a job]
Material	Total costs of materials and purchase orders on the invoice. This total includes charge and no charge purchase orders. Calculation - Material: : [Material costs] / [Total job revenue] How to Configure - Material:To set material costs, navigate to Settings > Pricebook > Materials tab > Details tab > Cost. How to Configure - Purchase Orders:To add a purchase order to an invoice, navigate to the invoice page, and click Add a purchase order from the left menu. Technicians may also add purchase orders when using ServiceTitan Mobile.
Labor	Total costs of labor and payroll adjustments, rounded to the nearest tenth. Calculation - Labor: [Labor costs] / [Total job revenue] How to Configure - Payroll Adjustments:: To add a payroll adjustment to an invoice, navigate to the invoice page, and click Add a payroll adjustment from the left menu.
Other	Additional costs. Other costs include flat bonuses, percent bonuses, and invoice items. Calculation - Other:[Other costs] / [Total job revenue] How to Configure - Payroll Adjustments:: To set flat bonuses, navigate to Settings > Pricebook > Services > Commission tab > $ Bonus. How to Configure - Payroll Adjustments::To set percent bonuses, navigate to Settings > Pricebook > Services > Commission tab > % Bonus.
GP	Gross Profit is the profit made after the cost of materials and labor, rounded to the nearest tenth. Next to the gross profit, you will see the gross profit percentage, out of the total revenue generated for the job. Example: Total revenue = $230 Costs (Material and Labor) = $24.00 Gross Profit = $206.00 Gross Profit Percentage = 89.6% ([$206.00 / $230.00] * 100%]) Calculation - GP: [Total job revenue] - [Material costs] - [Labor costs] - [Other costs] Calculation - Gross Profit Percentage: [Gross profit] / [Total revenue] *100%

Explanation of report totals

(Report totals)

Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.

Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.