A Super Easy Way to Track Mileage (and a special bonus for you!)
TSheets Adds Employee Scheduling Features

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):

Purchase by Item Summary Report

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:

Purchases by Item Summary by Month

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!

RELATED TOPICS:

_________________________________________________________________________________________________________

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

The comments to this entry are closed.