Skip to main content
September 3, 2019
Question

Negative invoice

  • September 3, 2019
  • 2 replies
  • 0 views

We have a customer that we gave a quote to and they've had several change orders to the original scope of work.  There are several items that won't land up being sold to them and other items that will be sold to them as a result of the change in work -- the net difference of the items that we won't land up selling to them versus what we will be selling to them is negative.  They would like something showing all of the items together.

 

For example, this is what the changes in materials sold may look like:

Quoted materials not used:

-80   Widget A           -$80.00

-1      Widget B           -$50.00

 

Addititional materials not included in original quote:

50     Widget C            $20.00

1        Widget D             $5.00

 

Net difference  -$105.00

 

I've tried doing a credit note listing everything but it won't let me put positive amounts on it; I've tried doing an invoice but it won't let me put negative amounts on it.  My absolute last resort is to do a credit note and an invoice and then give a statement with the net difference but the customer wants everything listed all on one invoice / credit.

2 replies

September 3, 2019

Hi cls23,

 

It's great to have you join us in the QuickBooks community! I'll help you sort this out.

 

Jobs change between estimates and invoices all the time. The great thing about estimates in QuickBooks is you can use them to create invoices through progress invoicing if things stay the same or simply create an invoice without the estimate listing the material actually used for the job.

 

It sounds like you haven't actually received a payment for the job from this customer yet. Because of that, you wouldn't create a credit memo on their account. Estimates are non-posting transactions (meaning they don't affect your books), so creating a credit would offset their balance and give them a credit they don't need.

 

I hear what you're saying about your customer wanting a transaction that shows them both what the estimate had and then what is actually being invoiced for the job. There isn't a way to enter all of those items on a single transaction. A workaround that you can consider is using the Customer message section of the invoice to outline what was originally entered on the estimate and what the difference is.

 

I hope that helps. Have a good evening.

Rustler
September 4, 2019

@cls23 

 

Well I disagree with @LauraAB , you can show changes in QBO.

A quote (estimate in QBO) is non posting so you can show anything you want. ie

 

Job, blah blah, $3,333 will show at the bottom as a total of the blah blah items

 

then add the change items
widget A, qty -80, $1, total -$80
widget B, qty -1, $1, total -$1
widget C, qty 50, $0.40, total $20
widget D, qty 1, $5, total $5.00
sub total, -$105

and the bottom number to the total estimate will reduce by 105 and show a total of $3,228

cls23Author
September 4, 2019

QB Desktop doesn't let you create negative Estimates; we originally tried to do this with an Estimate before trying the Invoice / Credit idea.

 

 

Rustler
September 4, 2019

did you look at my response, it is the full estimate for the job, the changes are reflected as negative and positive, and the resulting change in the total job cost is updated