Not applicable

Inventory / Item

I would like to run a report to see items that I haven't sold in ten years, so I can remove them or make them inactive. Can I do that in QB Desktop?


QuickBooks Team

Reports and accounting

Hey there, @Anonymous.


Currently, there is no available report which shows your unused items. I have another report you can pull up.


You can pull up the Transaction Valuation report. This report shows the latest transaction that uses the product. 


To pull up the account, you can search for it in the Reports Center


Also, you can save the report by clicking on Memorize on the top part of the report. 


Please leave a comment below if you have any other questions. 

View solution in original post

Level 2

Reports and accounting

I'm also looking to do this. Has there been any update in capabilities in the last 2 versions? I'm currently running 2020 and haven't found a way to do this, but thought I'd ask to see if anything has changed since this post was made in April 2019. We have thousands of items, and a valuation report for even the last 2 years would be a nightmare to sort through and compare to our item list. There's gotta be a better way!




Reports and accounting

Hello there, Operations_Monkey.


I can see how important and relevant for you to run a report that shows the unused items in the previous years. Still, you can run the report suggested by my colleague above and compare the lists of items.


I got your point on how important to get this thing done easily. I'll take note of this, and you may want to visit our blog website, where you can check the latest features and product enhancement. 


Let me know if you have other questions. Take care always and be safe.

Level 2

Reports and accounting

We have 21k items, I don't think I'll be running that report. It would be more efficient for me to manually sort through the items and choose the ones I don't remember ever selling than it would be for me to run that report and attempt to compare items. If there was a way to run a report that just listed the items sold without all of the transaction information (or just showed 1 transaction per item instead of every transaction from the past 2 years), that would be helpful. But I have items that I sell thousands of in a year as well, so that report is just not a good option for us. Running the suggested report for just this month to date is 27 pages, and this is by far the slowest year we've had in sales since 2012. If you have any tips on how to make that report work for our volume in sales, I would be open to it, but I just don't see that as a functional option. The extra items will just continue to bloat our item list as they always have until an update that solves this issue.


I read the very difficult to navigate blog website about updates, and despite clicking through several options that I thought might apply, I was unable to find the feature. I figured it's possible I missed something in that maze of options, so I figured I'd ask.


Thanks for your help.