Job Costing Report

This pre-built SA report lists the labor and material costs of each Visit. Your job cost settings must be complete for the report to be accurate.

The Job Costing report is based on these main areas:

  • Labor cost
  • Time spent on job site
  • Time spent driving to the job site
  • Product cost (if applicable)

About this report

The Job Costing report is one of the most detailed pre-built reports in the Report Center. Therefore, if setup is not done completely, it can result in inaccurate data for one or more columns.

The Job Costing report includes only completed jobs. This report cannot be modified.

  1. Go to Reports > Report Center > SA Reports
  2. Select Job Costing Report.
  3. Set the Start Date and End Date.

    blobid0.png

  4. Click Refresh.

The Job Costing report looks like this.

blobid1.png

The columns in this report extend much further to the right than pictured in this screenshot. See below for explanations of some of these columns as well as calculation information, when applicable.

Note: For Pro and Pro Plus Members, the data listed below is also used in the Job Cost data set for a Custom Analysis.

  • Bgt Hrs – The budgeted hours entered for the Visit. The budgeted hours are the amount of time you expect the job to take regardless of the number of resources working the job.
  • Bgt Rate – The rate applied to the Visit.
  • Bgt/Man Hr – The budgeted dollars per man hour (Bgt rate divided by Bgt Hrs). 
  • Actual Start/Stop time – The start and stop times that were clocked on the Visit (via a mobile app or manually recorded on the Dispatch Board).
  • Actual Hrs – The total time spent on a Visit in decimal form. For multiple resources, the calculation is the total time worked multiplied by the number of Resources and then divided by 60.
  • Actual Time Variance – The difference between Bgt Hrs and Actual Hrs. A positive number indicates the job was finished under the budgeted hours. A negative number means the job took longer than the budgeted hours.
  • Actual Rev Rate – The rate invoiced for the s.ervice.
  • Actual Rev Product – The rate invoiced for the product that was added to the service.
  • Actual Rev Total – The combined invoiced rates of the Service and Products (Actual Rev Rate plus Actual Rev Product).
  • Direct Cost – The sum of expense line items associated with the Visit.
  • Actual Rev Costs – The total of all related costs for the Visit.
  • Actual Rev Gross Margin – This is the Actual Rev Total minus Actual Rev Costs.
  • Actual Rev/Man Hr – This is the Actual Rev Rate divided by Actual Hrs.
  • Target/Man Hr – This is the targeted dollars per man hour, which is the target hourly rate you want to earn to be profitable on a service. This number is pulled from the information entered on the service level (Settings > Services > [Service Name] > Job Costing/Analysis tab).
  • Target Over (Under) – This is the Target/Man Hr minus Actual Rev/Man Hr (either over or under).
  • Drive Effect Hrs – The total time spent driving between Visits (in decimals).
  • Drive Effect Cost – This is the labor cost accrued during Drive Effect Hrs. It's based on the information under Teams > Employees > [Employee Name] > Edit > Payroll/Job Costing tab.
  • Drive Effect % of Rev – This is how much of the total revenue this cost makes up (Drive Effect Cost divided by Actual Rev Rate).
  • Drive Effect Gross Margin – This is the Actual Rev/Man Hr minus Drive Effect Cost.
  • Drive Effect/Man Hr – This is the drive effect dollars per man hour (Drive Effect Cost divided by Drive Effect Hrs).
  • Target with Drive/Man Hr. – The target amount you want to earn on a service for it to be profitable when accounting for drive time and cost. This number is formulated based on the information under (Settings > Service > [Service Name] > Job Costing/Analysis tab).
  • Target with Drive Over (Under) – This is the difference between Actual Rev/Man Hr and Target/Man Hr with Drive Effect Cost
  • Labor Cost Avg Cost/Man – This is the Labor Cost divided by the number of resources who clocked time on the job.
  • Labor Cost – This is the average cost per resource multiplied by the number of resources on the job.
  • Labor Cost % of Rev – This is the percentage of the total revenue that the Labor Cost makes up (Labor Cost divided by Actual Rev Rate). 
  • Labor Cost Gross Margin – This is the Labor Cost minus the Actual Rev Rate
  • Products Bgt Cost – This is the total budgeted cost of the products associated with the service. This number is entered on the product level. 
  • Products Actual Cost – This is the actual cost of the products used in the service.
  • Products % of Rev – This is the percentage of total revenue the product's revenue accounts for.
  • Products Gross Margin – This is the Actual Rev Product minus the Products Actual Cost
Was this article helpful?
0 out of 0 found this helpful

Still looking for your answer? How Can We Help?