Inventory management: how do you turn shelf stock back into cash?
By: Ciro · · 8 min read
Every item on the shelf is money that is not in the till. Measuring stock turnover, catching dead stock early and focusing on the right products with ABC analysis.
The shelves of a neighbourhood shop, the store room of a car parts dealer, the pantry of a café: each is one of the largest cash items in the business. Too little stock and you lose sales; too much and the money sits on the shelf, spoils or goes out of fashion. Good inventory management means finding the balance between the two.
Stock turnover: how many times a year does your stock sell?
The most useful measure is stock turnover. Based on the definition in Iowa State University’s guide to financial ratios:1
Stock turnover = Annual sales ÷ Average stock
The number shows how many times a year your stock is sold and replaced. Example: your annual sales are 1,800,000 and you hold an average of 150,000 worth of goods on the shelves. Your turnover is 12: your stock turns over once a month. If you divide 365 by this number, you find that goods wait on the shelf for an average of 30 days.
The right number depends on the business. A peer-reviewed study of 311 U.S. retailers showed that most of the differences in stock turnover are explained by gross margin, capital intensity and unexpected changes in sales.2 So comparing a greengrocer with a jeweller makes no sense; you need to track your own number month by month and watch its direction.
The hidden cost of goods waiting on the shelf
Stock does not wait “for free.” This burden is called the carrying cost, and it includes:4
- The return you give up on the money tied up in goods (you could have used it to pay off debt or buy at a discount)
- Storage and shelf space
- Insurance
- Spoilage, breakage, loss and theft
According to a Penn State University supply chain course, the annual carrying cost of stock is around 7% of stock value in well-managed companies, and 2–3 times that in poorly managed ones. Companies have to write off 3–5% of their stock every year as excess or outdated goods.3 When inflation is high, the cost of tying up money rises even further.
Catch dead stock early
Dead stock is goods that have not sold for a long time. The signs are familiar: dusty boxes, products close to their expiry date, parts brought in because only one customer asked for them.
- Set a threshold: For example, every item that has not sold for 90 days goes on a list.
- Turn it into cash first: A discount, a bundle offer or a return to the supplier. Goods sold even at a loss are better than goods spoiling on the shelf; that money goes into new products that sell.
- Do not reorder: Before ordering an item on the list again, check whether there is real demand for it.
- Count your stock: The difference between the quantity in your records and the quantity on the shelf shows waste and loss. Without regular counts, dead stock keeps “existing” on paper.
ABC analysis: not every product deserves the same attention
ABC analysis, described in the University of Kentucky’s inventory management notes, divides products into three groups by annual money value (units sold × cost):4
| Group | Share of money value | What to do |
|---|---|---|
| A | First 80% | Never run out; order often, count often |
| B | Next 15% | Track regularly |
| C | Last 5% | Keep little stock; order on request if needed |
In most shops the number of A products is small, but most of the money is there. Give your attention to that group first. Keeping too many varieties in group C is the habit that ties up the most shelf space and money.
Ordering habits
- Buy less, more often: For fast-moving products, smaller and more frequent purchases instead of large batches reduce the money waiting on the shelf. If a bulk discount looks attractive, check whether it is worth the time the goods will wait on the shelf.
- Plan for seasons in advance: Think about purchases for holidays, the start of the school year or the summer season together with your cash flow forecast.
- Use supplier payment terms: A due date that lets you pay after you have sold the goods and collected the money means your stock is financed by the supplier’s terms, not by your own cash.
Stock tracking with Ciro
Stock tracking is available in Ciro without Premium:
- Stock items: You add a product with its name, starting quantity and an optional unit purchase price. The quantity goes up as you buy and down as you sell.
- Deducted from stock on sale: When you record a sale, you choose which item and how much; the quantity on the shelf updates automatically.
- Count and waste: During a count you enter the quantity you counted, and Ciro shows the difference from your records. A count entry does not affect cash; it only corrects the quantity.
- Movement history: You see when each item was bought, sold and counted. An item with no movement for a long time is a candidate for dead stock.
- Stock purchases in Cash flow (in Ciro Premium): For businesses that work with stock, the Cash flow screen also forecasts stock purchases in the coming weeks, so you see in advance which week a large purchase will put pressure on your cash.
You can download Ciro from the App Store or Google Play.
Summary
- Stock turnover = annual sales ÷ average stock; track your own number month by month.
- Goods waiting in stock have a yearly carrying cost.
- Turn goods that have not sold for a set period into cash early.
- Use ABC analysis to focus first on the products that tie up most of your money.
Sources
- Financial Ratios (C5-97) — Iowa State University Extension, December 2023
- An Econometric Analysis of Inventory Turnover Performance in Retail Services (Gaur, Fisher, Raman), Management Science 51(2) — INFORMS / RePEc, 2005
- Inventory Cost Fundamentals (SCM 800) — Penn State University, Smeal College of Business
- Inventory Management — University of Kentucky
This article is general information, not investment, legal or tax advice. Talk to your accountant or bank before making decisions. Rates and rules change; check the source for the current version.