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 ;-)   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 hoursAnd 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.

This entry was posted in Business Finance, Job Costing, QuickBooks, Reports and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *