This guide explains Rackbeat's stock valuation report and how to download the report in Excel format.
The report provides an overview of the stock value - that is, the cost prices multiplied by the quantity of products in stock.
Click "Search" and scroll down to find the total stock 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 stock.
The value field shows the total stock value.
NOTE! If shelf locations are used and valuation is taken only at the stock (not at the shelf location), the report does not consider values at shelf locations. If you want to utilize stock restriction, the valuation report must be run per shelf location. So if you restrict the report by stock, the valuation report will show either the stock location value without shelf locations or only the value of a single shelf location. If you want to take the entire stock location value, the stock + each shelf location value must be taken separately.
Keywords: Stock valuation report, Purchase price, FIFO, Excel download
Did you find it helpful? Yes No
Send feedback