Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
F
ForelParts
April 26, 2019
Question

Creating a Last Sold report for inventory items

  • April 26, 2019
  • 31 replies
  • 114 views

My goal is to create a report that will show me the items that have been sitting on my shelf for the last to years with no movement.  

 

The report can be as simple as the date each item was last sold.  

 

If anybody has any ideas or currently works with a report that shows this information, please let me know what you do. 

 

Thanks a bunch! 

Dani 

    31 replies

    PreciousB
    PreciousB
    Level 6
    April 26, 2019

    Hello Dani,

     

    I can share some details on running an inventory report.

     

    We are unable to run a report for the date an item was last sold. However, I have a workaround to share. Run the QuickReport for each item to see the last transaction's date.

     

    Here's how:

    1. Go to Lists at the top menu bar.
    2. Choose Item List.
    3. Right-click the Item.
    4. Choose QuickReport.

     

    Check out this article for more details about customizing a report: Customize reports in QuickBooks Desktop.

     

    That should get you on the right track. Let me know how that works for you. I'm always here to help if you have other concerns. Have a good day!

    L
    Locklearm
    October 25, 2022

    Sorry Admin Moderator - but for larger companies with hundreds of items, your method is not efficient 

      Rustler
      Rustler
      Level 15
      April 27, 2019

      this third party utility might help, it is not specifically a last sold report, but there is a free trial

      http://www.q2q.us/itooverview.htm

      I am not affiliated

       

      As stated this, (last used/sold) is one of several standard inventory reports missing in QB

        F
        FYW39
        December 14, 2020

        Do you know if QB has created a last sold report yet?  Can I run a last sold report in the POS program?

        Z
        ZackE_Moderator
        Moderator
        December 14, 2020

        Thanks for becoming part of the Community, FYW39.
         

        Currently, there isn't a last sold report available in QuickBooks Desktop (QBDT) or Point of Sale (POS). As a workaround, you can use PreciousB's process to run a QuickReport for each item. There's also the third party utility Rustler mentioned, which might come in handy.
         

        I can certainly understand how this type of report could be useful to yourself/others and have submitted a suggestion about it as of today. You can also submit your own feature requests while signed in.
         

        Here's how:

        1. In your top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
        2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus.
        3. Enter any suggestions/feedback in your Here is my suggestion: field.
        4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
        5. Select Send Feedback.


        Your feedback's definitely valuable. It goes to our Product Development Team and will be considered in future updates. You can stay up-to-date with Intuit's latest news by checking out the QuickBooks Blog.
         

        I've included a few helpful resources about working with reports in QBDT and POS that may come in handy moving forward:

         

        Please feel more than welcome to post a reply if there's any other questions I can help with. Have a fantastic day!

        Charity_SplashSales
        Charity_SplashSales
        December 28, 2021

        Here is the best I've found so far because clicking on each item and pulling a quick report is ANNOYING... Go to Reports>Sales by Item Detail>Customize Report. I sorted by date and removed all of the junk I didn't want to see, make sure in dates you click ALL - if you are wanting the entire history for the item. It still creates a fairly long and annoying list but the last date you sold the item should be right under the item name.

        Jen_D
        Jen_D
        Level 8
        November 1, 2022

        Thanks for reaching out to us again about this reporting concern, @Too Much Trouble.

         

        We recognize the need for some additional reporting options in the software. While the option to get the report for unsold items is not available, I'd recommend that you share this as a feature request or suggestion so our developers can review them.

         

        To add your product suggestions for our developers, go to the Help menu and select Send Feedback Online.

         

        Please note that the product updates are handled by our developers internally. For now, we can't provide the turnaround time if they will release additional preferences and enhancements. 

         

        For now, you can check the item list and the remaining quantity there are the items that weren't sold yet.

         

        Reach out to back to me if you need further assistance while working with QuickBooks reports. I'm always here to help. Have a great rest of the day.

        Need QuickBooks guidance?
        Log in to access expert advice and community support instantly.
        Terms & ConditionsAccessibility statement