> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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:

1. Cost price
2. Average cost
3. 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.

| The stock value is a **total**: there is no column with the value per item in your overview. If you want the detail per item, use the Excel export from that card.

## Negative stock

If an item has a **negative stock** in Robaws, Robaws counts the value of that item as **0**. A negative stock therefore does not lower your stock value and does not pull the total down. With the FIFO strategy, a negative stock does not create any FIFO layers for the same reason.

This only applies to the **value**. The **quantity** does remain negative, both in your overview and in the export. If you see a negative quantity, this is usually a sign that an incoming stock change still has to be booked.

| The Excel export also counts negative values as 0. The total on your card and the sum of your Excel column therefore always match.

## 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:

1. If the stock change comes from a supply order: the price of the supply order is taken over one to one
2. If it is a separate stock change: if an average cost is known, this average cost is taken
3. 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.**

||| When you set this strategy, you are asked once whether you want to create your initial FIFO valuation. If you choose "Yes", we create underlying archived stock changes for all items so that the FIFO valuation can be determined.

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:

1. If the stock change comes from a supply order: the price of the supply order is taken over one to one
2. 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-(10*500+1*300)) |