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
2. Then, run the Jobs by Time Summary Report
3. Customize the report to include Estimate hours

estimated vs actual 2

estimated vs actual 3

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.
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.

6 Responses to Estimated vs. Actual Hours

  1. sue napier says:

    Just starting Job Costing, a big job on the horizon and want to make sure I track costs. I have started to enter the workers hours in the employee section, but when I look for them in the P/L by job I cannot see them? I am entering these hours after I have manually entered my payroll, and there is a pop-up that says “adding these hours will not affect the persons paycheck”

  2. Judy McKinney says:

    Hello, I am in a new job and am new to QB Premier 2016. As a small arch/interiors firm, the number of hours to do the task is not something we want to share with the client and have it invoiced as a % of completion as it causes confusion. We would rather invoice a lump sum as % of completion, BUT we also want to analyze the time it takes us to do the task so it seems we MUST enter the hours in the estimate. 1. Am I correct in my premise? 2. Is there another way invoice LS % complete without showing the numbers, but still getting the costs? 3. Would the Job Costing add-in help with this? 4. Is there another resource besides exporting to Excel and creating a macro workbook to figure it all out?
    thanks in advance-Judy

  3. Rhonda Ponder says:

    How do you run the report for just hours entered.
    example. i have 24 hours for painting but then i also have material. i have to put in a quantity of 1 for the material line. then the hours (qty) carry over to the report and i don’t want that.

    thank you for the help

  4. In the Jobs, Time & Mileage reports, you’ll find you can run just hours. You need the jobs & hours entered in the timesheets to show in the reports

  5. You get to choose which columns you see on the screen and which show to your customer. This lets you have detail for job costing without showing every detail to the customer. There is no job costing add-in, it’s simply a part of QB.

  6. The P & L pulls from your chart of accounts so there will be some detail you won’t see
    And labor is not costed until you have a bill or check against those hours. So running payroll and then putting in hours will never pull costs into your reports. When you create paychecks AFTER you enter the hours, then you get job costing.

Leave a Reply

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