Estimating in QuickBooks

Are your estimates in QuickBooks? If you do job or project costing, then I believe some form of your estimate belongs in QuickBooks. Even if you just give your customer a fixed price. All your other numbers are there – invoicing, job costs, payroll….

The estimate is your budget for the job. Once entered in QuickBooks, you can easily run the following reports:

1

­­

Screen Shot 2016-03-07 at 12.25.27 PM
Screen Shot 2016-03-07 at 12.25.34 PM

 

You’re creating some form of those reports already, but many of you are pulling some numbers from QuickBooks, some from a stack of receipts for the project and then entering them either in a spreadsheet, on the back of a project folder and using a calculator. Doing that elsewhere can be very time consuming and double work. If it’s in QuickBooks, with just a click or two, you have your Estimated vs Actual and you can drill down for more detail if you want.

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, often other tasks can be done with just a couple clicks.

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 some form of the estimate still belongs in QuickBooks making it easier to review the job. How much detail to have in QuickBooks depends on what you want to see in your reporting when you’re reviewing your job reports.

There are several ways to enter an estimate, including Memorized Estimates or importing using 3rd party software.

Let us know if you’d like help with getting your estimates in QuickBooks!

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

One Response to Estimating in QuickBooks

  1. Anna Meyer says:

    We were discussing how to keep track of our subcontractors. In American Contractors we would put in the amount of their contracts and if we tried to go over it would alert us. We also could run a report that would show how much we have paid to date to each subcontractor on each job. I haven’t been able to find a program in QB that does this. Is there a program, and if so, where can I find it.

    Thank you, Anna

Leave a Reply

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