cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor *

Negative Inventory on an item with $0.00 Average Cost - Implications

Scenario #1 - I am aware of the problems of showing Negative Inventory in quickbooks.  However, does it still create problems if that Negative inventory is on items with a $0.00 average cost?  Example: employee cleaning out 40 year old facility and finds aproximately100 widgets.  Inventory item is created with $0.00 average cost.  ($0 Average cost because there is no expense or records to be found.)  Inventory is sold, and at the end of the year we show sales of 150 widgets sold.  (Negative inventory of 50 showing.)

 

  At the end of year inventory, is there any problem making an inventory adjustment to quantity on hand and zeroing out that negative inventory.

 

I realize all 150 units sold are showing as 100% profit, as they should, as there was no cost.  My question is: am I creating problems or issues within quickbooks by doing this?

 

 

Solved
Best answer 04-22-2019

Accepted Solutions
Established Community Backer ***

Re: Negative Inventory on an item with $0.00 Average Cost - Implications

Do an inventory adjust, set the adjusting account to COGS or better a sub account of COGS called shrinkage, and increase the qty so that there is zero on hand

 

BEFORE you save, look at the bottom right, if the value is zero save it, if not back out of the adjustment and let me know what the value was.

3 Comments
Established Community Backer ***

Re: Negative Inventory on an item with $0.00 Average Cost - Implications

Do an inventory adjust, set the adjusting account to COGS or better a sub account of COGS called shrinkage, and increase the qty so that there is zero on hand

 

BEFORE you save, look at the bottom right, if the value is zero save it, if not back out of the adjustment and let me know what the value was.

Community Contributor *

Re: Negative Inventory on an item with $0.00 Average Cost - Implications

Correct, I have the Adjustment account set to a COGS account.  Adjusting value at bottom of screen is $0.00, so I believe this should work....  Thank you for the support.

Established Community Backer ***

Re: Negative Inventory on an item with $0.00 Average Cost - Implications

Curious though, did you ask how you sold 50 of something you did not have and still got paid?

 

That is one hell of a business plan or salesman

:-)