cancel
Showing results for 
Search instead for 
Did you mean: 
windylou
Level 4

Price history on Inventory Items??

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.

9 Comments 9
ShiellaGraceA
QuickBooks Team

Price history on Inventory Items??

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.

windylou
Level 4

Price history on Inventory Items??

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.

ShiellaGraceA
QuickBooks Team

Price history on Inventory Items??

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.

gigi73
Level 1

Price history on Inventory Items??

It's easy. Go to your item list.  Choose the item and do a quick report. 

Customize the report:  In the display tab under columns find sales price and select that.  Go to the filter tab.  In filters choose transaction type and then choose "bill" if that is the appropriate type for what you want to accomplish.  Click ok. 

Then set your date range either in the display tab of customize or at the top of your report.

You can save the report so that you don't have to do this much work the next time.

gigi73
Level 1

Price history on Inventory Items??

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.

 

namesraj
Level 1

Price history on Inventory Items??

This way is not faster honestly, in my previous company I used SAGE where when you make invoice for a customer under the price column there is a dropdown where you can what price you gave in the past that way we can maintain price for each customer and it is faster please bring that option in quickbooks it is a must have feature thank you and atm Im just exporting some of my customer report to an excel file and cross checking along side while i make invoice bit frustrating though hope you guys bring an update thanks

Rubielyn_J
QuickBooks Team

Price history on Inventory Items??

Thanks for joining this thread, @namesraj.

 

I recognize how relevant adding an option to select a price you gave in the past for each customer is to you and your business. Currently, this option is unavailable in QuickBooks Online.

 

Rest assured our product engineers are working to roll out enhancements based on our customer's requests. That being said, I suggest sending a recommendation to our product developers. They'll review this idea and might consider updating it in the future.

 

Here's how:

 

  1. Select the Help menu and click Send Feedback Online.
  2. Choose Product Suggestion.
  3. Select a feedback type and product area on the QuickBooks Feedback window. 
  4. Enter your suggestion or feedback, name, and email address (optional).
  5. Click the Send Feedback button.

 

I also encourage you to visit these resources that provide some insights about inventory assemblies: 

 

 

As always, add a comment below if you have any other questions about managing your inventory items in QuickBooks. I'm here to help always. Take care!

laddnichols
Level 2

Price history on Inventory Items??

So the person was asking COST and price changes. Here we are in an inflationary period and as I have scoured QB, I find NO WHERE to understand cost increases for products we purchase over a period of time. This is a big deal to many businesses today as we are looking at costs increase on products almost daily. Answers were terrible, as usual from QB people. And the most appalling is the usual...put it in for requested update for future enhancements...as if there are EVER valuable enhancements to QB. You can sure raise prices, but improve the product....this is a basic need. Simply ridiculous....

ahensley
Level 1

Price history on Inventory Items??

I was just looking for this same info and found this helpful:

Lists, Item List

Reports (bottom of page)

Reports on all items

Purchases, Purchases by item detail

Change the date range to what is needed. This showed me all of our past purchase costs of each inventory item.

Hope this helps!

 

 

Need to get in touch?

Contact us