Item Last Costs

Item Last Costs

Understanding Item Last Cost

The Item Last Cost refers to the cost of an item from its most recent purchase or receiving transaction (through an Item Receipt or Bill) and inventory adjustment. It reflects the last price paid for that specific item, generally excluding additional costs like taxes or freight.

You can find the Last Cost displayed on the Item Card's 'Cost and Quantity' tab.




Viewing the List of Item Last Costs

To view a comprehensive list of the last cost for all your items, open the Item Last Costs List. Navigate to Inventory > under the Tools section, choose Item Last Costs. This report lists all inventory items along with the most recent price you paid for them.

The Item Last Costs report displays the following columns: Date of the transaction, Item Code, Item Description, Cost, and Cost with Landed Cost.

Double-clicking on any line within the Item Last Costs report will take you directly to the Purchase Order, Item Receipt, or Item Adjustment where that last purchase or adjustment was recorded.


See How to Find Item Last Costs

This video shows how to open the Item Last Costs tool in CustomBooks, review the most recent purchase cost and purchase date for inventory items, search the list, and export the results.

Video Summary

To review Item Last Costs, go to Inventory and select Last Item Costs under the Tools menu. The list shows purchased inventory items with information such as purchase dates, item names, descriptions, and costs. You can use Find to filter the list by a value such as item description and use Export to save the results to a spreadsheet.

Key Takeaways

  • Open Item Last Costs from the Inventory menu under Tools.
  • Review the most recent purchase cost and purchase date for inventory items.
  • Use Find to filter the list by criteria such as an item description.
  • Use Export to save the Item Last Costs list to a spreadsheet.
＋ Read the Full Video Transcript

In this video, we’ll show you how to quickly find the last cost for your inventory items in CustomBooks. This feature allows you to see not only the last cost of each item but also the date it was last purchased, giving you a clear and organized view of your inventory data.

To get started, navigate to Inventory and select Last Item Costs under the Tools menu. Here, you’ll find a comprehensive list of your purchased inventory items, complete with purchase dates, item names, descriptions, and costs.

If you need to refine your search, the Find button makes it simple. For instance, if you’re searching for items with “Oil” in their description, select Description, type “Oil,” and choose Anywhere in the line. This will filter your list to show only the relevant results.

When you’re done, clicking Cancel Search will return you to the full list.

For record-keeping or sharing purposes, you can easily export the list. Simply click the Export button, and you’ll have a spreadsheet ready to save or share with your team.



From the Item Last Costs window, you can:
  1. Find or search for a specific item.
  2. Export the list to PDF, Excel, or Word format.
  3. Refresh the list.