Inventory is the goods a webshop has bought in to sell on, and stock on hand is the number of units of each product currently in the warehouse. Stock on hand determines what customers can buy, and stock value determines how much money is tied up on the shelves. Both figures have to be correct if you want to order the right amounts and have accounts that add up.
Inventory, stock on hand and available stock
It is useful to distinguish between three figures for each product:
- Physical stock on hand is the number of units actually on the shelf.
- Available stock is the physical stock minus the units already sold in orders that have not been shipped yet. That is the figure customers should see in the webshop.
- Incoming goods are units ordered from the supplier but not yet received. They are not part of the inventory yet, but they have to be included when deciding whether to order more.
If you use physical stock as available stock, you can end up selling goods that are already promised to other customers.
How to calculate stock value
Stock value is the number of units multiplied by the cost price, added up for all products. The cost price is what the product cost to buy, possibly including freight and customs duty, but without VAT and without margin.
| Product | Stock on hand | Cost price | Stock value |
|---|---|---|---|
| Coffee pot | 140 | 180 DKK | 25,200 DKK |
| Travel mug | 50 | 95 DKK | 4,750 DKK |
| Coffee filter | 30 | 12 DKK | 360 DKK |
| Total | 30,310 DKK |
Stock value must be calculated at cost price and not at selling price. If you use the selling price, the stock looks more valuable than it is, and key figures such as inventory turnover become wrong.
FIFO and average cost
When the same product has been bought at different prices, you have to choose which cost price to value the stock at. The two most common methods are FIFO and average cost.
A webshop buys 100 units at 50 DKK and later 100 units at 60 DKK. It sells 120 units, so 80 units are left.
- With FIFO (first in, first out) you assume the oldest goods are sold first. The 80 units in stock are therefore from the latest purchase, and the stock value is
80 × 60 = 4,800 DKK. - With average cost the purchases are combined:
(100 × 50 + 100 × 60) / 200 = 55 DKKper unit. The stock value is80 × 55 = 4,400 DKK.
When prices are rising, FIFO gives a higher stock value than the average. Which method the business should use in its accounts is something to agree with your accountant, but the most important thing is to use the same method consistently.
Year-end stock count
A stock count is a count of the entire inventory on a specific date, typically at the end of the financial year. It is used to make sure the stock value in the accounts matches what is actually in the warehouse.
- Choose a date and stop or record all receipts and shipments while counting.
- Count each product and write down the counted quantity next to the system quantity.
- Investigate large differences before correcting them. A product counted in two places or a receipt that was not booked often explains the gap.
- Correct the stock on hand in the webshop and in the inventory system, so both show the counted quantity.
- Calculate the stock value at cost price and assess whether goods that cannot be sold at full price should be written down.
Many webshops also count parts of the stock on a rolling basis during the year, for example the products with the highest stock value every month. Errors are then found earlier, and the annual count goes faster.
Keeping the stock figure correct in the webshop
The stock figure in the webshop easily becomes wrong if not every movement is recorded. Typical sources of error are:
- receipts that are not booked, or that are booked with the ordered quantity instead of the received quantity,
- returned goods put back on the shelf without being added back in the system,
- defective or damaged goods that are still listed as saleable,
- sales in a physical shop or on a marketplace that do not draw from the same stock.
A wrong stock figure leads either to selling goods you do not have, or to products listed as sold out even though they are on the shelf. Both also distort the sales history that the forecast and purchasing are based on. Read more in the guide on stockout days.
Why stock value matters for cash flow
Every krone in the inventory has been paid to a supplier and only comes back when the product is sold. A webshop with a stock value of 900,000 DKK, corresponding to 90 days of cost of goods sold, will have roughly 900,000 × 75 / 90 = 750,000 DKK in stock at 75 days of cost of goods sold. That frees 150,000 DKK, which can be spent on other products or stay in the account. It is often overstock and products that do not sell that push the stock value up without producing sales.
lesslater fetches stock and sales from PrestaShop, WooCommerce or Shopify, and the analysis shows overstock, lost sales and ABC/XYZ classes, so you can see where the stock value sits. See more under analytics, and read about planning the payments in the guide on cash flow budget.