Estimated vs. Actual Hours

How did the actual time on the job compare to what you estimated?  That’s one of the big things you want do know, right? If job costs run over, it’s usually in the area of labor, not materials.  It’s been a report I’ve wanted to see for a long time. And wouldn’t you know, I found it, accidentally, so I have no idea how long it’s been there! So even us “pros” still learn ;-)

This is for those who use a desktop version of QuickBooks (Pro/Premier/Enterprise) AND enter the time spent on jobs in QuickBooks (you either use Enhanced Payroll or Assisted Payroll or if you outsource payroll, you have the manual payroll turned on) Anyhow, here’s how you create it.

  1. First, the estimated number of hours needs to be on your estimate in QuickBooks.
    estimated vs actual hours
  2. Then, run the Jobs by Time Summary Report or the Time by Item Report
  3. Customize the report to include Estimate hours

estimated vs actual hours


estimated vs actual hours

estimated vs actual hours

And there you have it!

If this is a report you will run often, memorize it, maybe even put it on your QuickBooks toolbar. Then next time it’s easy to change the customer:job or date range if need be.

If you want to see this in video form, here’s your link.

Let us know if you have questions or want some help with this.

Leave a Reply