Blog

16 OCT 2026

Stock that sits is cash that waits

Turnover says how many times a year your stock pays for itself; days on hand says how long each unit waits. Together they price the cash tied up on the shelf.

A shelf full of stock looks like an asset, and on the balance sheet it is one. In the bank account it is the opposite: money that went out and has not come back yet. Two figures say how long it is away.

Turnover

Inventory turnover is how many times in a period you sold through your average stock. Both numbers are at cost, because the stock is valued at what you paid for it, not at what you hope to sell it for.

average inventory = (opening stock + closing stock) / 2
turnover = cost of goods sold / average inventory
days on hand = days in the period / turnover

Say you sold 600,000 of goods at cost over the year. You started with 140,000 on the shelf and ended with 160,000, so you held 150,000 on average. That is four turns a year, and 365 divided by 4 says each unit waited about 91 days between arriving and leaving.

Days on hand is the one people feel

Four turns a year is abstract. Ninety-one days is not: it means the money you spent on a delivery in January comes back in April. Every supplier who gives you 30 days’ credit is financing a third of that wait; your own cash finances the rest.

What a lower target frees

Set a target number of days and the arithmetic tells you what stock level would deliver it, and therefore how much cash comes off the shelf.

target inventory = cost of goods sold x target days / days in period
cash freed = average inventory - target inventory

With the same 600,000 of annual cost, holding 60 days instead of 91 means an average inventory of about 98,600, which frees roughly 51,400. That money does not appear once; it stays out of the shelf for as long as you hold the new level.

Two cautions

  • An average of two points hides the shape. If you stock up before a season and sell down after it, opening and closing may both be low while the shelf was full in between. Use more points, or run the figure for the season on its own.
  • Faster is not always better. Days on hand can be driven down by running out, and a stock-out costs sales that never appear in any of these numbers. The target should come from how long your suppliers take to deliver and how much your demand swings, which is what a reorder point is for.

Run it by category

The whole-business figure is a start. The useful version is per product group: slow lines sit for a year while fast lines turn monthly, and the average tells you neither. The calculator takes the four inputs and a target, and gives turns, days on hand and the cash a lower target would free.

Try it on your own numbers

How fast your stock turns, how long it sits, and the cash a lower target would free.

Open the inventory turnover and days on hand

Written by the OrbisVendor team. If a number here looks wrong to you, tell us: we would rather correct it than defend it.