This guide explains Rackbeat's inventory valuation report and how to download the report in Excel format.

The report provides an overview of the inventory value - that is, the cost prices multiplied by the quantity of products in stock. 

Click "Search" and scroll down to find the total inventory value.

NOTE! If you want all products to be displayed in all locations, leave the product and location fields empty. Otherwise, you can select specific products or locations to be displayed in the report.

Click the "Download table" button in the upper right corner if you want to download the data into an Excel spreadsheet.

The purchase price is the actual purchase price field value of the product. If the valuation method is FIFO, this field shows the purchase price of the next item to leave the inventory.

The value field shows the total inventory value.




NOTE! If shelf locations are used and valuation is taken only at the warehouse (not at the shelf location), the report does not consider values at shelf locations. If you want to utilize warehouse restriction, the valuation report must be run per shelf location. So if you restrict the report by warehouse, the valuation report will show either the warehouse location value without shelf locations or only the value of a single shelf location. If you want to take the entire warehouse location value, the warehouse + each shelf location value must be taken separately. 


Keywords: Inventory valuation report, Purchase price, FIFO, Excel download


This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.