History of Items Purchased Report in QuickBooks
Many businesses that carry inventory need to run a purchase history of those items now and then for planning purposes.
If you are one of those businesses, QuickBooks delivers with the Purchases by Item Summary report.
Located by clicking Reports > Purchases > Purchases by Item Summary (there is a detail version too!), you’ll unlock a report that looks like this sample (click the image for a larger view):
Here you can easily pick the range of desired dates, and QuickBooks will then populate the report with the quantity of the item purchased and the total dollars spent on that item as well.
NOTE: This report works just as well for non-inventory parts too!
GETTING A MORE GRANULAR VIEW OF THE PURCHASE HISTORY
Here’s a tip if you want to do a more detailed analysis of the purchase history of your items:
On the report above, look for the option at the top of the report that says “Show Columns” and change it to month. Here is how it would look once you do that:
In this view, you can see on a monthly basis exactly what is happening with the purchase history of each of your items!
Pair this with the ability to export this report to Excel, you have unlocked a simple yet powerful way to track the purchase history of your inventory and non-inventory items in QuickBooks!