Skip to content
lesslater

Guides Inventory

Stock on hand and inventory: stock value and stock count

What inventory and stock on hand are, how to calculate stock value at cost price, carry out a year-end stock count and keep the stock figure correct in the webshop.

Updated 18 November 2026 · 5 min read

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 DKK per unit. The stock value is 80 × 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.

  1. Choose a date and stop or record all receipts and shipments while counting.
  2. Count each product and write down the counted quantity next to the system quantity.
  3. Investigate large differences before correcting them. A product counted in two places or a receipt that was not booked often explains the gap.
  4. Correct the stock on hand in the webshop and in the inventory system, so both show the counted quantity.
  5. 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.

See your own products in lesslater

Create an account and connect your webshop. The first 14 days are free, and no credit card is needed. If you would rather go through it on your own data with us, book a demo.

No credit card · No commitment · Data in the EU