Estimating in QuickBooks

If you do job or project costing, then it’s important to use the Estimate feature in QuickBooks. But that feature is often underutilized for a few reasons.  Could be lack of understanding how to work with the estimate template in QuickBooks. Could be that a spreadsheet or other software is used to actually determine the estimate, so why bother entering it in QuickBooks?  Isn’t that an unnecessary step?  No.

If your estimating is fairly simple, then usually the regular estimate form in QuickBooks works. You can enter your anticipated costs for the various items, mark it up and arrive at a number you want to charge your customer.

I will admit that there are many times when the estimate form in QuickBooks can be inadequate so a spreadsheet or other estimating software often works better.  But that estimate does belong in QuickBooks.

If you just give your customer a fixed price, your costs still belong in an estimate in QuickBooks.

The estimate is the budget for the job and if entered in QuickBooks, it’s easy to review. More importantly, you can run estimated versus actual reports. Doing that elsewhere can be very time consuming and double work. The costs are already being entered into QuickBooks, so with an estimate in there, too, it’s real easy to click on a report and see your numbers. You can also drill down for more detail if you want. If all your costs show as “No Item” instead of different services and materials, then your costs are being entered incorrectly; check out this blog: http://bit.ly/items-tab

If your customer wants to make changes along the way, as so frequently happens, QuickBooks will let you do a change order and can keep track of the changes for you. And, you can easily invoice off the estimate, order materials or even enter orders for work you will sub out, so once the estimate is in, the other pieces can be simple clicks.

There are several ways to enter an estimate and some can be fairly quick.

  • Entering as you would an invoice
  • Use Item Groups for faster entry (see my blog on Item Groups http://bit.ly/item-groups)
  • If you use the same format and items, consider memorizing an estimate so next time you just pop in the numbers.  (see my blog on Memorizing in QuickBooks http://bit.ly/monetizations)
  • If this job is similar to another you’ve done, you can duplicate the estimate from that other job, change the customer name, and edit the numbers and items accordingly.
  • Depending on how the spreadsheet is setup, sometimes you can use an import utility to move the estimate into QuickBooks.
  • And, if this is a 3rd party estimating software, frequently there is a way to export that estimate and then import it into QuickBooks.

So let me know if you use the estimate feature in QuickBooks, what you like about it or what problems you are having.

If you’d like to learn more about estimating, then you might be interested in our job cost webinar:

http://bit.ly/muirjobcost

This entry was posted in Job Costing and tagged , , , , , . Bookmark the permalink.

2 Responses to Estimating in QuickBooks

  1. Amanda says:

    Hello there,

    Thank you for the information! Your site is very helpful… I am having a difficult time figuring out how to create a budget from an estimate so that I can run budget verses actual reports. Whenever I try to run these reports it says I must create a budget for the job. Since I already have the estimate laid out, after the customer decides to employ me, how do I turn the estimate into a budget in QB 2012? Any help would be so greatly appreciated.

    Thanks,
    Amanda

  2. Glad to hear you find the information helpful :-)

    Your estimate IS your budget – there’s no need to try to use the QB budget feature. The Estimated vs Actual report assumes your estimate is your budget.

Leave a Reply

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