by Sunburst Software Solutions, Inc.
Archives by Month

Create a QuickBooks Job Cost Report With Hours & Payroll Costs 

A QuickBooks tip for creating a job cost report that displays hours worked and payroll/labor burden costs.

solutionsCreating a job cost report displaying the hours worked by employee, on a specific job or on all jobs,  for a specific week or at the end of a job which includes payroll/labor burden costs can provide a contractor with vital job costing information so you can see if you correctly bid the number of man hours and payroll costs required on a job.

NOTE:  It is highly recommended that you start with a single pay period AND a single paycheck to ensure that your report is correct.  Once the report is correct, memorize it and you can then either finish your payroll or change the dates to better suite your needs.

  1. From the Reports menu -> choose Custom Transaction Detail Report (the Modify Report:Custom Transaction Detail Report window may or may not automatically appear; if it does not, click the Modify Report button)
  2. On the Display tab, navigate to the Columns section and using the scroll bar on the right of the window select (click) only the following options – Date, Num, Name, Source Name, Item, Payroll Item, Qty, Sales Price, Amount and Balance. All other items in this list that were preselected should be unchecked.
  3. Click on the Filters tab
    • in the Choose Filter block, click on Transaction Type -> from the Transaction Type drop down menu select Paychecks
    • still in the Choose Filter block, click on Account -> from the Account drop down menu -> select Multiple Accounts -> and click on each of your Payroll Expense or Payroll Cost of Goods Sold Payroll Costs accounts.
  4. Click the OK button.

Print your Report – but do not close it yet:

 

job cost report with hours and payroll costs

Right click on the image to enlarge it

Compare the report to the employees paycheck – making sure that ALL of the amounts from the Company Summary section of the Paycheck Detail are included in your report.

compare job cost report to paycheck detail

Right click on the image to enlarge it.

If all of your costs are included, return to the report, click the Modify Report button -> click on the Header/Footer tab -> change the Report Title to Job Cost Report with Hours & Payroll/Labor Burden Costs -> click OK.  Next click the Memorize button and save it.

You can now pull up the memorized report at any time and make further modifications for a specific date range or even a specific job.

To run the memorized report for a specific job:

  1. From the Reports menu -> choose Memorized Reports -> select your report
  2. Click the Modify Report button -> click the Filters tab -> from the Filters box -> click on Name -> from the Name dropdown menu select just the specific job
  3. From the Dates drop down menu -> select All
  4. Click the Refresh button

This will produce a report just for this specific job and include all payroll/labor burden costs to date.  This is a valuable report to run at the end of a job.

We hope you found this QuickBooks tip for creating a job cost report which included hours and payroll/labor burden costs helpful.  If so, please take a moment of your time to leave a comment.

Author’s Note:  The idea for this post originally came from Ruth Perryman – however, it has been modified to include additional instructions and details.

11 Responses to Create a QuickBooks Job Cost Report With Hours & Payroll Costs 

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert


I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.


QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:


Enter your email address:

Delivered by FeedBurner


We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!


QuickBooks Time Tracker