Showing results for 
Search instead for 
Did you mean: 
Active Member

"Aging" Inventory

My boss wants to start advertisting our stock that has been sitting for a long time. I can go through each stock item and figure it out manually, but that is extremely time consuming. Is there a way with Quickbooks that can show me unused inventory for a period of time?
QuickBooks Team

Re: "Aging" Inventory

Good day, @LOSTinQUBKS.


I can help you utilize the reporting feature in QuickBooks Desktop. 


We can run and customize the Purchase by Item Detail report. It classifies the items by type and sorts them by date. That should help you figure out the Inventory items unused for a period of time.

  1. On the top menu, click the Reports tab.
  2. Choose Purchases.
  3. Select Purchases by Item Detail.
  4. Set the dates to All.
  5. Click Refresh.

Scan through the list to get the last purchase date of the items. If you wish to get the quantity on hand of the items, you can also run the that report. I'll show you how:

  1. On the top menu, click Inventory.
  2. Choose Physical Inventory Worksheet.

That should help you get the inventory data you need, @LOSTinQUBKS. For additional reference, you can check the links below:

Keep me posted on how these steps work out for you. I'm still here to help you more with reports. Have a wonderful day ahead!

Established Community Backer ***

Re: "Aging" Inventory

check this utility, it is not a true inventory aging report but much closer than desktop will provide

I am not affiliated

Established Community Backer ***

Re: "Aging" Inventory

You can't really do that in QB, but you can get close with our BRC List Reporter 

You can use it to create an item list in Excel that includes the last sale date.  So, you can see items that have had no activity recently.  CaptureItemsWithDates.JPG

Experienced Member

Re: "Aging" Inventory

Help me get my dada assets passed threw our name  .Andres Gutierrez jr. I'm Andres Gutierrez iii thank u


QuickBooks Team

Re: "Aging" Inventory

Hello there, Andres Gutierrez. 


If you are referring to QuickBooks as your acquired asset, you can transfer or change the owner. Log in to CAMPS using your Intuit login credentials. At the upper-right corner, click the drop-down arrow so you can see the Transfer Ownership option. Then, follow the onscreen instructions.


If you need more help, you can get in touch with our Customer Support Team. They can walk you through the secure process so you'll be able to transfer the license to your name.

In QuickBooks, click the Help menu and then select QuickBooks Desktop Help. Select Contact us. After, enter a brief description of your concern about transferring account owner. Then, click Let's talk. You can either Talk to a Specialist or Message an Agent.


Alternatively, you can reach out to us through this link. Then, follow these steps:

  1. Select Continue as a guest and choose your QuickBooks Desktop version.
  2. Under the What can we help you with? section, click for Search for something else.
  3. After, enter your question about changing the account owner.
  4. Click Search.
  5. Scroll down to the page until you'll see ways on how you can contact us.


If you want to create an asset account under your name, you can get ideas from these threads. Our Established Community Backer (AllStar) provided steps and insights on how to handle asset accounts. I also recommend reaching out to your accountant so they can identify how to set it up, according to your business preference. 


Drop a reply if you have further questions.