by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Contractor Tip – Handling Negative Change Orders

Print Friendly, PDF & Email

Change Orders are a fact of life that a contractor must deal with on just about every construction project that they are involved with.

contractor change orderConstruction contracts start with an original bid amount for specific cost codes, phases of work, or line items.  However, most construction contracts change as work proceeds; resulting in both increases and decreases or positive and negative change orders – which affect the original bid amount.

There are many ways in which people will handle Change Orders when using QuickBooks, such as just going to the original Estimate and changing the dollar amounts of the affected items.  This is a “quick and easy fix”; however, it doesn’t leave a good documentation trail for what occurred on the project and can cause a lot of confusion.

Handling change orders that increase the value of the contract can be accomplished by:

  1. Editing the original Estimate and ADDING lines to the bottom indicating the cost codes and dollar amounts that are causing the increase.
  2. Creating a Sub-Job of the Job called Change Order 1 (2, 3, 4, ect.) and creating an estimate at the Sub-Job level to track just the cost codes involved in the change order.

Dealing with Negative Change Orders that reduce the original bid amount, is a bit more difficult – because QuickBooks will not allow you to create a Negative Invoice.

When you receive a negative change order that is LESS than the remaining balance on the contract, it’s a fairly easy process.

  1. Go to your QuickBooks Estimate, add a Change Order Item with no dollar amount – this provides a clear separation of the Original Contract amount.
  2. Below that add the Item that represents the reduction to the contract, enter the value as a negative amount, complete with the MINUS sign.
recording a negative change order

Right click on the image to enlarge it.

When you are ready to prepare your next progress invoice:

  1. Bill the negative amount at 100%.
  2. Reduce the corresponding line item in the original contract section.
  3. Bill for any other line items that you need to.
specify the negative amount

Right click on the image to enlarge it

Or simply generate a zero dollar invoice to record the reduction.

zero dollar invoice

Right click on the image to enlarge it.

This method allows for a good documentation trail that everyone involved can easily see.

4 Responses to QuickBooks Contractor Tip – Handling Negative Change Orders

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker