Skip to main content
December 15, 2023
Question

Negative Inventory on Balance Sheet - QuickBooks Desktop

  • December 15, 2023
  • 1 reply
  • 0 views

Hello QB Community,

 

My question is on Inventory for Quickbooks Desktop. My clients inventory has a negative value on the Balance Sheet. I have researched and found how to adjust the quantities on hand  but what would my Journal Entry be to correct the amount on the Balance Sheet?

 

Thank you in advance,

 

1 reply

December 15, 2023

How to Find if your data file has Negative Inventory?
Run the Inventory Valuation Detail (IVD) report in QB:

In QB, select Reports>Inventory>Inventory Valuation Detail.
Click the Dates drop-down and select All.
Find all occurrences of negative amounts in the On Hand column.


How to Fix Negative Inventory?
Adjust the transaction dates such that bills are dated before invoices:

From the QB menu, select Reports and then Inventory and then Inventory Valuation Detail.
Click the Dates drop-down arrow and select All.
Scroll through the report to an item that is showing a negative amount in the On Hand column.
If you can do so legitimately, adjust the dates of the bills and/or invoices so that the bill dates are before the invoice dates.
Repeat the steps for each item with a negative quantity in the On Hand column.
Caution: It is not sufficient to adjust the current QOH to a positive value. You must eliminate each occurrence of negative QOH.

 

Another option, consider buying a 3rd party file repair service. They will analyze your file to identify the items and dates the quantity on hand (QOH) went negative and then fix all occurrences of negative inventory. The repaired file will not have negative inventory and will verify correctly in QB. There may be a change to the COGS and Inventory Asset account balances after the repair. There will also be a change to the Opening Balance Equity account that will be used to add the inventory adjustments. You will need to add adjusting journal entries after the repair.

SueD1Author
December 15, 2023

Looking back over the past YEAR! this new client didn't use purchase orders or invoices only recorded the payments as the invoices came in. Any suggestions on how to fix this?

December 15, 2023

How do they have inventory?

Run the Verify/Rebuild Data utility. Did you encounter any error message?