Run the Job Costing toolLast updated on 03/02/2023
The Job Costing tool breaks down costs on jobs and projects so you can gain insights on payroll costs, equipment and material costs, and opportunities to increase gross margins.
Things to know
Accountants and administrators can use the Job Costing tool by default. Other office employees must have the View Job Costing permission enabled. Contact your account administrator to enable this permission.
Including labor and performance pay in job costing requires account configuration. Please contact your success or implementation manager for details.
Labor burden rate is typically the payroll costs and overhead costs for a technician. If you include labor rates and performance pay in your job costing, subtract payroll costs from your technicians’ burden rates. You can edit a technician’s burden rate in their profile.
If you include labor rates in your job costing, you can view labor hour totals, which can help you with project scope and planning.
Run the Job Costing tool
You can run the Job Costing tool for an invoice or project.
Run the Job Costing tool for an invoice
To access the Job Costing tool for an invoice:
Search for the invoice you want to run job costing on and open it.
Under the invoice menu, click Job Costing.
The Job Costing tool opens.
Run the Job Costing tool for a project
To access the Job Costing tool for a project:
Search for the project you want to run job costing on and open it.
Under the Financials section, click View Project Costing.
The Job Costing tool opens.
Understand job costing details
When you open the Job Costing tool, it automatically calculates costs for the invoice or project you opened it from. The tool breaks down costs into several sections.
Note: If a section is a cost, the cost as a percentage of the total revenue displays next to the header.
Invoices
The Invoices section shows the pre-tax invoice subtotal or project invoices subtotals. The Invoice Total shows the sum of all invoice subtotals. Any sales tax charged is listed separately.
Payments
The Payments section shows payments received, their status, and the invoices they were paid on. Total paid shows the total amount paid on the invoice or project invoices. Balance shows the total outstanding balance.
Performance Pay
The Performance Pay section shows a list of technicians who received bonus pay or commission paid on the invoice or project invoices and the amount awarded. Performance pay requires account configuration. Please contact your success or implementation manager for details.
Note: Performance pay is only available in job costing after invoices are posted.
Labor Pay
The Labor Pay section shows the hourly labor pay including any overtime pay for all technicians on the invoice or project invoices. The total labor hours and labor pay appear at the bottom of the section.
Payroll Adjustments
The Payroll Adjustments section shows any payroll adjustments made on the invoice or project along with the technician who received the adjustment.
Labor Burden
The Labor Burden section lists the payroll and overhead costs for technicians on the invoice or project invoices.
Note: If you include labor rates and performance pay in your job costing, subtract payroll costs from your technicians’ burden rates. You can edit a technician’s burden rate in their profile.
Materials
The Materials section lists all material items on the invoice or project invoices, their cost, and the total material costs.
Purchase Orders
The Purchase Orders section lists all purchase orders (POs) on the invoice or project invoices, their cost, and the total PO costs.
Equipment
The Equipment section lists all equipment items on the invoice or project invoices, their cost, and the total equipment costs.
Profit
The Profit section shows cost and profit details for the invoice or project invoices:
Total Revenue—Subtotal of invoice or project invoices
Total Cost—Sum of all cost sections in the job costing
Gross Margin—Calculated as (total revenue) - (total cost)
% Gross Margin—Calculated as (gross margin) / (total revenue) * 100
Print, export, and email job costing details
The top of the Job Costing tool includes additional tools:
Click the Printer icon to print a copy of the job costing details.
Click the Mail icon to email a copy of the job costing details.
Click the Export as dropdown and select Export as .xls file to download an XLSX version of your job costing details. Each section is a separate tab in the spreadsheet.
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.