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
Progress Invoicing (also called progress billing, percentage of completion billing, or partial billing) involves billing from an estimate (or Schedule of Values) over the course of time and could be considered a type of installment billing. Progress billing is commonly associated with the construction industry; however, it is common in other industries as well.
QuickBooks® Pro, Premier, and Enterprise editions all offer several options for invoicing and a Progress Invoicing function is also available.
Some projects or jobs will require only a single invoice, others will require two invoices, others may require three invoices (one at the start of the job, one when you are 50% done, and the other when you are finished), other projects might require that you submit monthly progress invoices over the course of months or even years.
Typically, if you take on a job that you will have finished at the end of 30 days, you might only want to create a single invoice, unless retention or retainage is held for some reason, in which case you will have to create two invoices.
When your scope of work on the project will span one or more months, then you will want to consider progress billing. When you generate progress billings, you will bill ONLY for the work that you have completed and the materials that you have used or installed – occasionally you will also be allowed to bill for materials that you have at the jobsite but have not yet used.
If you are a subcontractor, sometimes the General Contractor will have a form that they insist you use (instead of your own invoice form), other times they may insist that you submit your progress billing on an industry standard billing form – such as the AIA G-702 & G-703 forms developed by the American Institute of Architects – or similar plain paper forms containing the same information.
Make sure that you submit your billings on the forms that they want or they will probably reject your invoice; mail it back to you and tell you to resubmit your billing CORRECTLY. Usually having to resubmit a bill means that you have to wait until next month to submit the corrected bill.
Always try to get your invoice paperwork right the first time and include any proper releases that are required. Sometimes the General Contractor will hold up everyone’s invoices —-even if only one contractor has submitted their billing incorrectly.
