QuickBooks™ Group Items – Create Lump Sum Draws

Progress Billing Solution for Sub-Contractors and Lump Sum Draws.

QuickBooks™ Premier Contractor Edition offers many options for invoicing and includes a pretty flexible Progress Invoicing feature. However, the Progress invoicing feature is definitely geared more toward line-item billing for General Contractors.

Specialty and many General Contractors run up against a customer billing issue when attempting to properly utilize detailed job-costing with QuickBooks™ Progress invoicing.  To get good Estimate vs. Actual Job costing, the Estimate will need to be entered in detailed format with estimated labor, material, subcontractor and other costs. The issue arises when the Contractor is billing the Customer in a Lump Sum Draw schedule rather than by line item. Most often a Contractor in this situation would prefer to display on the invoice the Progress detail provided by QuickBooks™ progress invoicing such as the original contract amount as one lump sum, the current amount billing, and the previous amounts or percentage billed. However, they do not want to show several line item amounts like Labor, materials, etc. as detailed on the Estimate.

Because the Progress invoice pulls it’s data directly from the Estimate, there is a conflict. One solution is to create a custom Progress Invoice template that eliminates all columns except for the Description and manually typing in the detail, such as 20% Draw, etc. The disadvantage is of course is that you have eliminated one of the best features of Progress Billing, created manual entry, and the invoice just doesn’t look as professional.

Another solution, more preferable in my opinion, is to create Group Items that include your detailed job-costing items yet allow you to create a separate description. When you use this item on your Customer’s Estimate, you will retain the Item’s Job-costing and Revenue reporting, yet the Invoice created from the Estimate will Group the items together on one line with one amount. The main issue with this scenario is that it seems like you will need to set up a new group item for every group of items you use.

For instance if you always use the same combination of items, like Labor, Materials, Subcontractor, you will set up a group item that consists of these items.  For more complicated re-models that include many different items for every job, how does this work?  One of the best things about using Group items is the ability to add and subtract items in the group “on the fly”.  Meaning,  while you are creating the estimate, you can insert and delete the items in the group.

Click here to view the Free Lesson
This is an amazing feature and quite transformative for those who do lump sum billing and job costing

Looking for more video tutorials?  I created this one a long time ago and I’ve learned a lot since then.  Check out an example of what the videos look like from my QuickBooks for Contractors Job Costing Intensive Program:

Learn more at: www.jobcosting.com/quickbooks-training