If you use QuickBooks for your accounting and you create your Estimates in Excel instead of within QuickBooks you loose out on job costing capabilities and so much more!
I often see and hear comments such as this as I browse the web or talk with potential customers for our software:
Right now we are using QuickBooks Contractor. It is ok for our accounting software but we are looking for something that works as an overall system for our office – CRM, estimating, job costing, proposals, work tickets and most importantly easy for my guys to use. Right now we are using Excel for Estimates and invoices.
When I see and hear comments like this I get so confused – because QuickBooks does allow you to create Estimates, Proposals, and do Job Costing - so I thought I’d attempt to write a short article to address this.
Creating Estimates in Excel vs. QuickBooks – Pros and Cons:
Excel is REALLY easy to use – anyone can quickly whip up an Estimate, Proposal or a Work Order., you can create some great looking documents that you are proud to hand to your prospective customer. But that is about as far as you can go.
QuickBooks, on the other hand, if set up properly will allow you to create an Estimate, Proposal, Work Order, or an Invoice and perform job costing just by entering vendor bills, writing checks, entering credit card charges, and employee payroll. You then can access all kinds of Job Costing reports and an Actual vs. Estimate Report – which allows you to see the difference between what you thought you’d make on the job vs. what you actually made.
But….QuickBooks requires more work on the front end and then proper training for your employees.
I think I just heard everyone groan! There is no way that I can write a “short” article on the benefits of using QuickBooks to prepare these documents for your business, but I can provide you with some suggestions to get started.
- Is the QuickBooks Estimate function turned on? If not go to the Edit menu -> Preferences -> Jobs & Estimates -> Company Preferences tab -> set “Do You Create Estimates” AND “Do You Do Progress Invoicing” to Yes
- Modify/Customize the built in forms to meet the needs of your company using the Layout Designer, by downloading a pre-built template or by using the Create Form Design option. All of these options are available from the Lists menu -> Templates -> and then clicking the Template button at the bottom of the window.
- Create a FULL list of the services, cost codes and/or products your company uses for billing
- Have a meeting – get EVERYONE involved – take that master list of products and/or services/cost codes and come up with descriptions that EVERYONE can agree on {letting them know that they can “tweak” it more to their liking later}
- Go to the Items List and set up items that correspond to that master list of of the things your company does, creating Group Items or Inventory Assemblies if appropriate
- Create an Estimate, a Proposal, or a Work Order using the entries in your Item List – print it out and see what everyone things of it. If they are happy teach your Estimators how to use the Estimating function
- When entering Vendor bills, writing checks, or entering Credit Card Charges use the Items tab and assign the cost to the job
- Turn on time tracking, enter employee hours by Job, Service Item, and Payroll Item
- Create a Progress Invoice from an Estimate for the current amount that you are billing the customer
- Look at the Estimate vs Actual Report for a specific job and look at the report results
These suggestions are just the tip of the iceburg for taking QuickBooks from plain-Jane accounting to job-costing accounting. Use the search box on our site and enter specific keywords for additional tips.
If you can’t get your Estimators to leave Excel, there is a 3rd party application Transaction Pro Importer – that will import your Excel based Estimate into QuickBooks for you and you can implement some of the other suggestions in this article.
I hope you’ve found this article to be helpful, if so please take a moment to leave a comment or ask a question – or share it on your favorite social networking site if you think others would find it to be useful.
Dealing with special customer invoicing requirements can be a royal pain! Sometimes it feel like each customer you deal with says “if you don’t invoice me like THIS you aren’t going to get paid”. While QuickBooks is a very flexible software program, sometimes it’s very difficult to meet the requirements of specific customers or clients. Below is a perfect example, submitted by a reader of just how difficult billing requirements can be.
I use QuickBooks Contractor version as a self-employed contractor with a hospital. The problem is I get the job on a P.O. from the hospital, say it’s for $80,000. As I do different stages of the job I bill the hospital for that stage and they send me a check. When I do the next stage the hospital wants the invoice to reflect the original P.O. and the money they have already paid. How do I do that on this software? Jean
____________________________________________________
Jean, I’m pretty certain that you can meet these requirements – it will cause some extra work on your part each time you are ready to bill the hospital for the next stage; but I don’t think it will be a lot of work.
Go ahead and create your invoice as usual – I’m making a BIG assumption here that you take the PO from the hospital and set that up as a QuickBooks Estimate and generate Progress Invoices from your Estimate {but even if you don’t that’s ok}.
Once you are viewing that Invoice in QuickBooks, click the Letters icon at the top and choose Prepare an Invoice Letter
Right click on the image to enlarge it
When the Choose a Letter Template window appears, select Invoice Letter with Details and then click the Next button
Right click on the image to enlarge it
This now sends your Invoice into Microsoft Word and by default provides information about the invoice that you can then modify to meet the invoicing requirements of the hospital.
Right click on the image to enlarge it
For example, I would change the heading called Invoice Amount $720.00 to read Original PO Amount $80,000.00, Invoice Balance $720.00 to read Previous Payments Received $XXX.XX, and add a line that reads Current Payment Due $720.00.
Right click on the image to enlarge it
NOTE: You can edit this letter template and include the changes to the wording – that way all you have to do is enter the amounts for Original PO and Previous Payments. To Edit a letter template go to the Company menu -> choose Prepare Letters with Envelopes -> Customize Letter Templates -> View or Edit Existing Letter Templates -> choose Invoice Templates -> Invoice Letter with Detail.
QuickBooks has a lot of built-in functionality – the problem is finding it! We hope you found this QuickBooks tip for dealing with special invoicing requirements to be helpful. If so please take a moment to leave a comment or share it on your favorite social network.
Progress Invoicing is a standard feature of QuickBooks® Pro, Premier, and Enterprise editions; each of these versions also offer several options for invoicing as well. In order to implement the Progress Invoicing function you must also utilize the QuickBooks Estimate function – this will eliminate repetitive data entry and help you achieve good job costing reports, such as Estimate vs. Actual reports.
To activate Progress billing you MUST first log into QuickBooks as the QuickBooks Administrator and be in single-user mode. From the Edit menu -> choose Preferences -> scroll down to Jobs & Estimate -> and click on the Company Preferences tab. Once you are in the Company Preferences tab, review and set the options as follows:
- Do You Create Estimates – should be set to Yes
- Do You Do Progress Invoicing – should be set to Yes
- Warn about duplicate estimate numbers – should be checked (this will prevent you from creating two or more estimates for different jobs with the same estimate number)
- Don’t print items that have zero amount – this option SHOULD NOT be checked (this allows you to display line items on a progress invoice even if you are not billing for them on the current invoice)
- Click Ok to save the changes that you have made.
Right click to enlarge image
At this point, you can switch to multi-user mode so you and others can continue working.
Next, you’ll want to build your Estimate or Schedule of Values using the Job Cost Codes found in your QuickBooks item list. You will want to make sure that you QuickBooks Items or Job Cost Codes are set up as double-sided items in order to capture both expenses and income.
Your Estimate can be as simple or as detailed as you like – bearing in mind that an Estimate with multiple lines will provide better job costing information than a single line Estimate with the full dollar amount.
Right click to enlarge image
Once you have your Estimate in place and you are ready to create your first progressing billing or draw, you will go back to the Estimate you created and look for an option that says “Create Invoice” – click on that button/option.
This opens a Create Progress Invoice Based on Estimate window, which provides you with 3 different options for creating your progress invoice:
- Create an invoice for the entire estimate (100%)
- Create an invoice for a percentage of the entire estimate (you then get to choose a percentage – 33%, 30%, etc.)
- Create invoice for selected items or for different percentages of each item.
Most construction contractors will choose the third option, to Create invoice for selected items or for different percentages of each item. After making your selection on how you want to create the progress invoice; click OK.
Right click to enlarge image
This now opens a new window, Specify Invoice Amounts for Items on Estimate; where you will be able to see the various line items that are on your Estimate. You can specify the quantity, rate, amount or percentage for each item that you wish to bill for in the current period. As you enter amounts or percentages you will be able to see a running total for the current billing. When you are satisfied, click the OK button to have the information automatically populate the Progress Invoice form.
Right click to enlarge image
If you didn’t enter an amount or a percentage for each line item on your Estimate, QuickBooks will display a message indicating that there are items with zero amounts.
Right click to enlarge image
Most people will find this Zero Amount Items message to be very annoying; it can be turned off by checking the Do not display this message in the future and clicking Ok.
Following this procedure you have created your first basic progress invoice. When you Save it, you have automatically updated your Accounts Receivable, and can send it to your customer or General Contractor or you can use the information it contains to complete an special invoice format that is required.
Right click to enlarge image
It’s the start of construction season, is your job costing system in place?
While the start of a busy construction season may not be the time to do a full-scale revamp of your current job costing system, it is certainly time to give it a thorough review for the upcoming season and perhaps make some modifications to your existing system within QuickBooks. As you read through this article, take some notes and see what you can change now and what should wait until you are in “off season” before implementing.
- QuickBooks is a very flexible and versatile program. The Customer Center List provides you with the ability to track your Customers (project owners, awarding authorities, or general contractors) that you perform work for. For each Customer you can then track the various Jobs (projects) that you are working on for that specific customer. For each Job that you are working on you can also track Sub-Jobs (your Change Orders or Extra Work orders) that are specific to the original job.
Each Job and Sub-Job should have its own Estimate; the Estimate that you create at the Job level should be for the Original Contract, whereas, the Estimate that you create at the Sub-Job level should only be for the items that are specific to the change order/extra work order.
ALL costs that are entered into QuickBooks should be posted or job costed to either the Job or to the Change Order/Extra Work order.
Variations:
Sometimes the contract owner wants the Change Order/Extra Work Order to be added or included with the original contract for billing purposes, in this case it is recommended that you still set up both the Job and Sub-Job records in QuickBooks for job-costing purposes and also add the Change Order/Extra Work Order (in whatever sort of detail required) to the BOTTOM of the Original Estimate for billing purposes.
NEVER, I repeat – NEVER simply open the original QuickBooks Estimate and simply change the dollar amounts of any line item to reflect the new amount after a change – this will NOT provide you with a good documentation system.
2. Review your QuickBooks Chart of Accounts and make sure that you have suitable accounts listed there for Direct and Indirect Job Costs
3. Review your QuickBooks Item List – it should be set up to match your industries cost code lists with all items being “Double-Sided” (having both a Purchase and a Sales price) and using “Group Items” as appropriate.
4. Review your QuickBooks Payroll Item List – does it have different payroll wage items that reflect the type of work (work classification) that the employee performs work under on the jobsite?
5. While we are on the subject of Payroll, you should be doing your payroll in-house or through the use of QuickBooks Assisted Payroll and entering employee hours using the weekly timesheet – mirroring the information that is sent from the field.
6. Make sure that you are accounting for your Equipment Costs on the job site and in your job costing reports.
7. Track committed costs, material purchases, and subcontracts using customized QuickBooks Purchase Orders and the Cost Codes you create in your Items List.
8. Create Estimates that reflect the Schedule of Values using the Cost Codes you create in your Items List and then use the Progress Invoicing feature to generate the base billing.
9. Use our free Project Info Worksheet as a means of providing essential contract information to the appropriate people.
10. Document procedures.
11. Get your employees involved; make sure that everyone is trained properly.
12. Monitor the work flow carefully and make adjustments as necessary.
