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
Did you find it helpful? Yes No
Send feedback