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.
For a step-by-step walkthrough on how to find an Item Last Cost, check out the video below.
From the Item Last Costs window, you can:
- Find or search for a specific item.
- Export the list to PDF, Excel, or Word format.
- Refresh the list.
Need help applying this to your business?
See how CustomBooks™ can support your accounting and inventory workflow
If you are evaluating CustomBooks™ or want help setting up workflows for your business, explore the product or schedule a conversation with our team.
Already using CustomBooks™? Explore the Knowledge Base or contact support for product help.
Related Articles
Item Last Costs
Item Last Cost The Last Cost is the most recent purchase price of an item. It is derived from the cost on the Bill received for a Purchase Order. Inventory adjustments, item receipts, and assembly builds also update an item's Last Cost. The Item Last ...Inventory Details: Item Costs, Item Quantities and Location Information
Inventory Details Overview Understanding inventory details, such as item costs, quantities, and location information, is essential for effective inventory management. Accurate insights into these details ensure proper stock control, cost tracking, ...Choose Item Purchase Cost (extension)
Introduction This extension allows users to choose between item expected cost (from the Item Detail Card) and item last cost 9cost the last time the item was purchased) when creating purchase orders. The Purchase Order draft is automatically updated ...Item Last Cost
CustomBooks™ uses the Item Last Cost on Purchase Orders when adding an item. The Item Last Cost is the amount that you last paid for this item on a Bill / Bill Payment recorded in CustomBooks™. For more about last costs, see this article.About Costs
Costs AccountingSuite uses the following terms when reporting costs for an item: Standard (or expected) cost - this is in the expected cost field on the item card. It is entered manually and is stored as entered. This number is not used in any ...