I would like to find or create a report that will help me manage old inventory such as items we have in the warehouse that haven't sold within the last 90 days (or any specified time period). I can run a report to show items on the floor and when they were purchased last, but I can't figure out how to filter it to show how long it's been there. I have some extreme cases of product we bought in 2013 that is still sitting in the warehouse. I haven't yet found a way to have quickbooks tell me we bought something 5 years ago and haven't sold it since.
Any suggestions or solutions would be appreciated.
I'm here to help share some information about the inventory item report you need in QuickBooks Desktop.
Currently, QuickBooks doesn't have a specific report that will show how long the list transaction of the item. However, you can export the Item List report through excel and pull up the Summary report and customize it by Item to show those items that have been used for 90 days.
This way, you can compare both reports to determine what are those items that haven't been sold.
Here's how to export the Item List report through excel:
To pull up the Summary report, here's how:
You may also check this article on how to customize reports in QuickBooks Desktop.
Feel free to leave a comment below if you have additional questions about the reports. I'd be happy to answer them for you.