Skip to main content
W
windylou
June 9, 2020
Question

Price history on Inventory Items??

  • June 9, 2020
  • 2 replies
  • 0 views

Is there a way to see price or cost history of an item? I have one vendor that changes the pricing every single time I place a PO with them, so I'd like to be able to see a history of those changes.

    2 replies

    S
    ShiellaGraceA
    June 9, 2020

    Hi @windylou,

     

    QuickBooks Desktop gives you all the power your business could ever need to customize reports. You can use the audit trail report and filter it so you can see when you've made changes to the item's price.

     

    Here's how to pull up the report:

     

    1. Go to Reports.
    2. Choose Accountant and Taxes, then Audit Trail.
    3. Click the Customize Report button, then mark Item under Columns.
    4. Select the Filters tab, then search for Item.
    5. In the Item drop-down, look for the item that you've frequently change the price.
    6. Hit OK.

    With these steps, you'll be able to see your price history. You can learn more about customizing reports and understanding reports at these links here:

     

     

    We also have a guide on exporting reports that I' sure you'll find helpful. It contains step-by-step process and information for in-depth customization of your reports.

     

    That'll do it. Please know that we're here to lend a hand should you have other concerns. Thanks for reaching out today and have a wonderful day ahead.

    W
    windylouAuthor
    June 9, 2020

    That's not what I'm looking for. Doing the Audit trail, I will still have to go through each PO to look at the individual cost. What I'm looking for is something similar to the summary that was added to the employees section in the 2020 desktop version that shows when each person got a raise, etc.

    S
    ShiellaGraceA
    June 9, 2020

    Thanks for coming back @windylou,

     

    Currently, QuickBooks will only let you view the item's price history through the audit trail report. You'll want to check the available reports for items by going through these steps. 

     

    1. Go to Lists, then Item List.
    2. Scroll down towards the bottom, the choose Reports.
    3. You can choose Price List or Item Listing.

    I'm also attaching our page about reports and accounting. It has help related articles which you might find helpful.

     

    I'll be around if you need help with anything else. Thanks for reaching out and I wish you have a lovely day.

    G
    gigi73
    August 11, 2021

    It's easy.  Go to item list.  Do a quick report.

    Choose Customize:  In the display tab under columns choose "sales price."  In the filter tab choose "Transaction Type" in the first column, then choose "Bills" if that is appropriate for what you are doing in the middle column.  Hit ok to accept those customize changes. 

    Adjust your date range either in the customize section or at the top of the report.

     

    Terms & ConditionsAccessibility statement