Skip to main content
April 24, 2025
Question

I have items with 0 quantity but show a value in the asset value. How do i fix this so that the asset value is 0?

  • April 24, 2025
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

April 24, 2025

Thank you for reaching out to the QuickBooks Community, Max. I'd be happy to share details on how inventory items work in QuickBooks and guide you through the steps to correct the asset value to $0.00.

 

An incorrect Starting value or an inventory quantity adjustment can cause a zero-quantity item to show a value on your inventory valuation reports. With this, I recommend reviewing and updating your Products & services to fix this issue. Let me show you how.

 

  1. Navigate to the Sales menu on the left panel to choose Products & services.
  2. Select the item and hit the Edit button under the Action column. 
  3. Go to the Quantity on hand section and hit the Starting value link for more information.  
  4. Choose Got it to confirm the action.
  5. On the Inventory Starting Value no.START page, check the item details, and update the information if needed. 
  6. Click Save and close.

 

Moreover, if you need to delete any adjustments, you can reference this article for the complete process: Adjust inventory quantity on hand in QBO.

 

Please note that editing inventory adjustment entries can impact your accounting records. We recommend working with your accountant to ensure everything is accurate. If you don’t already have an accountant, you can easily find one in your area through the QuickBooks ProAdvisor website.

 

Accurate inventory and asset values provide essential insights for your business decisions. Please notify us in the comments below if you have further questions about adjusting inventory quantity in QBO. We're always here to help you!

April 25, 2025

Hi,

 

The starting value was correctly entered at $0. The item concerned is a Miscellaneous Item that has had multiple costs attributed to it. The first few postings the item went into negative stock and somehow had a number of different costs associated with it. There are no incorrect adjustments to the item. In fact I tried deleting the adjustments that had been made to see if that would fix the problem.

 

It defies all logic that Quickbooks allows an items to have 0 stock but have a value attributed to it. How can this be possible and how can you provide no solution to this to be able to adjust the value of such an item to $0?

 

Thanks.

April 25, 2025

Thank you for your prompt response, Max. I will explain how Asset Value works in QuickBooks.

 

QuickBooks calculates the Asset Value of an item based on its Inventory Cost and the Quantity on Hand. If you set the Quantity on Hand to zero, both the Inventory Starting Value and the Asset Value will also show as zero. However, the Asset Value is updated each time you record a transaction.

 

If you haven't made any transactions, you can click on the Asset Value amount in the Inventory Starting Value to adjust the transactions, just like my colleague mentioned above.

 

However, if you have already recorded transactions, that could explain the difference in the Asset Value. You can view the Inventory Valuation Detail report to see more information. If you need to make adjustments, you can do so by clicking on the amount listed under the Asset Value.

 

Additionally, please refer to this article for comprehensive guidance if you want to edit or create management reports in QuickBooks: View and edit management reports in QuickBooks Online.

 

You are welcome to reach out if you have inquiries or questions about how Asset Values are calculated in QuickBooks. Simply click the Reply button below, and I will assist you promptly. you for your prompt response, Max. I will explain how Asset Value works in QuickBooks.

April 25, 2025

Thanks for your response, but how does it help me fix this problem? I have a quantity of 0 and an asset value of $1,401.53. See attached Inventory Valuation Detail. Strangely, in the detail report it says there are 12 on hand but in the Inventory Valuation Summary it says there are 0.