cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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?

 

Solved
Best answer April 04, 2019

Best Answers
Alessandra_B
QuickBooks Team

Inventory / Item

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

11 Comments 11
Alessandra_B
QuickBooks Team

Inventory / Item

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. 

Operations_Monkey
Level 3

Inventory / Item

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!

 

Thanks!

SarahannC
Moderator

Inventory / Item

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.

Operations_Monkey
Level 3

Inventory / Item

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.

anonymous person
Level 1

Inventory / Item

Has a report been created yet that allows us to sort out unused items that we haven't used in years?  I know that there wasn't anything in 2019 or 2020, as I read through the comments from the first post.  I am checking to see if anything has changed since 2020. 

Boomer907
Level 1

Inventory / Item

Checking in to see if anyone has a solution to this as we have the same problem.  

Kelly_W
Level 1

Inventory / Item

We use QuickBooks Enterprise. It would be so helpful if QuickBooks provided a simple report that can be run to compare the Item Lists to Invoices  / Sales of items to be able to easily determine when the last time an item was sold.  Even if on the item list there is a column for last date item sold.  

 

I've been performing vlookups to invoices to compare to our items listing.  I am unable to obtain reliable info.  QuickBooks could make this so simple.  I do not understand why this report is not available.  

 

QuickBooks:  Any status if this helpful feature will ever be offered?

 

FateCandylaneT
QuickBooks Team

Inventory / Item

We're glad to see you chiming in on this thread, Kelly_W. I'm here to share insights and updates about inventory item reports in QuickBooks Desktop.

 

 We appreciate the time and effort you've taken to run an item detail report to show recently sold inventory items. Currently, this option or report customization is unavailable. In the meantime, we can export the Inventory Valuation report to enable these data to be sorted out. To do this:

 

  1. Go to Reports and click Reports Center.
  2. From the search bar, enter the Inventory Valuation Detail report.
  3. Modify and add specific information to ensure accurate data are showing.
  4. Click on the Excel dropdown and select Create New Worksheet.
  5. Select In new workbook. Then, click Export.

 

Additionally, we're unable to provide a specific timeframe as to when this feature will be available in the program. To help us improve our products and achieve customer's needs, you can submit this suggestion to our product developers. They'll consider this idea and include it in future product enhancements.

 

Here's how to submit feedback in QuickBooks Desktop (QBDT):

 

  1. Go to the Help menu at the top and select Send Feedback Online.
  2. Click on Product Suggestion and enter your feedback or suggestions.
  3. Once done, click Send feedback.

 

To be updated with our latest news and updates, including product improvements, I'd suggest visiting the What's New section on your QBDT account or opening this link to view our product update blogs.

 

Moreover, you can add specific customizations to your reports to ensure accurate information is displayed.

 

Keep us posted if you need additional assistance handling your inventory items and reports. We'll keep this thread open and get back to help you further. Have a good one!

Operations_Monkey
Level 3

Inventory / Item

The closest I've gotten is the Sales by Item report and adding in the column "Entered/Last Modified." If you change the dates to say, everything prior to 3 years ago, it doesn't help at all because it just hides recent transactions.

 

I'm currently exporting an 826 page excel report with plans to use conditional formatting to try to find recent dates and weed out those items. I'm worried it's going to take forever, but I don't have a better plan yet. I'm hoping I can just find some really useful formulas in excel to make it all happen. I'll come back and update here if I found any useful strategies for this.

crash0607
Level 1

Inventory / Item

Try this and let me know if you found it helpful:

Item estimates vs actuals (dates: all)

Double click total (est cost column) to get the item estimated cost detail

export to excel

data sort newest to oldest, then data sort item a to z

Remove duplicates function 

 

 

This should give you the most recent time every item was used in an estimate.

Operations_Monkey
Level 3

Inventory / Item

This is helpful information, I would love to compare this against sales to see what we've quoted vs sold, but not quite what I need. I certainly didn't think to look under "jobs, time, & mileage" reports for sales history, but this makes sense.

I think my best option is to actually compare a purchase report with a sales report, but in the very early days of the company, some items were just inventory adjusted in instead of received properly, so just those items would be an issue.

 

We're in the process of exiting Quickbooks, but my full sales history won't be moving over. I'm running a series of reports to help as we move, and we're keeping a single seat in quickbooks indefinitely for now so I'll have access to this information, but I do appreciate your suggestion!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us