Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs 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.
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:
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.
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.
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.
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.
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.
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.
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
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:
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!
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....
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.