Consulting your stock value in Robaws
The stock value of a warehouse is the total value of the goods that are present in the warehouse at a given moment.
This value is determined on the basis of a particular stock valuation method.
In Robaws you set the stock valuation method via settings > items > stock valuation strategy.
In Robaws there are 3 possible strategies:
- Cost price
- Average cost
- FIFO = First In / First Out
The 'items' overview has an 'analysis' tab. There you can consult the stock value. You can consult this value for a specific date. In addition, you can use the filters here to consult the value of a specific selection of items.
The value shown there is calculated on the basis of the strategy you have chosen in the settings.
Cost price
This is the method that is set by default.
The calculation of this method is as follows: total stock * cost price of the item. The cost price of the item is the cost price from the item file in the library in Robaws.
Example:
Date | Item | Cost price from the item file | Quantity in stock | Stock value |
|---|---|---|---|---|
1 March 2025 | Solar panel inverter | € 550.00 | 5 | € 2,750.00 |
1 April 2025 | Solar panel inverter | € 600.00 | 6 | € 3,600.00 |
1 April 2025 | Solar panel inverter | € 620.00 | 8 | € 4,960.00 |
Average cost
If you want to use this method, you set it via settings > items > stock valuation strategy.
For this strategy we keep an average price per item. This average price is used for outgoing stock changes.
Every time an incoming stock change is booked, the average cost is adjusted in line with the price and quantity of the stock change.
The price logic that determines which price is used for a stock change:
- If the stock change comes from a supply order: the price of the supply order is taken over one to one
- If it is a separate stock change: if an average cost is known, this average cost is taken
- If it is a separate stock change: if no average cost is known (e.g. for a new item), the cost price from the item file is taken
Example:
Stock change | Item | IN/OUT | Quantity | Cost price | Average cost | Stock value |
|---|---|---|---|---|---|---|
SW0001 | Inverter | IN | 5 | € 550.00 | € 550.00 | € 2,750.00 |
SW0002 | Inverter | IN | 4 | € 600.00 | € 572.22 | € 5,150.00 |
SW0003 | Inverter | OUT | 2 | € 4,005.56 (5,150.00-2*572.22) |
FIFO (First In - First Out)
If you want to use this method, you set it via settings > items > stock valuation strategy.
For this strategy we adjust the stock value by taking the oldest incoming stock as the first outgoing stock.
When you select this strategy, an extra column 'Fifo out' is added to the stock change. When an incoming stock change is booked, this field is set equal to the quantity of the stock change and it is adjusted as outgoing stock changes take place.
The price logic that determines which price is used for a stock change:
- If the stock change comes from a supply order: the price of the supply order is taken over one to one
- If it is a separate stock change: the cost price of the item
Example:
Stock change | Item | IN/OUT | Quantity | Cost price | Stock value |
|---|---|---|---|---|---|
SW001 | Inverter | IN | 10 | € 500.00 | € 5,000.00 |
SW002 | Inverter | IN | 5 | € 300.00 | € 6,500.00 |
SW003 | Inverter | OUT | 11 | € 1,200.00 (6500-(10500+1300)) |
Updated on: 04/09/2026
Thank you!
