Stock Levels: Which Report to Use, How to Calculate Days of Stock and Avoid Tying Up Cash
Management4 min read
How to control stock levels: a stock report, days of stock, cash tied up in goods, items below minimum and slow-moving stock. A worked example and a checklist.

Stock levels need to be controlled from two sides: so that fast-moving goods don't run out and so that cash isn't sitting in slow-moving goods. A stock report with minimums, days of stock and value at cost is all you need.
Below: which columns the report needs, how to calculate days of stock and what to do with each group of goods.
One-minute calculation
- Export stock levels for each warehouse.
- Add average daily sales over the last 4–8 weeks.
- Calculate days of stock: stock ÷ sales per day.
- Multiply stock by cost price — that's the cash in goods.
- Flag items below minimum and items with more than 90 days of stock.
Which columns a stock report needs
| Column | What it shows |
|---|---|
| Warehouse | Where the goods are |
| Stock | How many units there are now |
| Minimum | When it's time to reorder |
| Sales per day | Rate of consumption |
| Days of stock | How long it will last |
| Stock value at cost | How much cash is in the goods |
Example: four items
| Item | Stock | Sales per day | Days of stock | Unit cost, ₽ | Cash in goods, ₽ |
|---|---|---|---|---|---|
| Oil filter | 24 | 8 | 3 | 450 | 10,800 |
| Oil, 5 L | 90 | 6 | 15 | 2,100 | 189,000 |
| Wiper blades | 60 | 0.5 | 120 | 700 | 42,000 |
| Antifreeze, 5 L | 200 | 1 | 200 | 1,300 | 260,000 |
Filters will last 3 days — order today. Oil will last 15 days, which is normal. Wiper blades and antifreeze have 120 and 200 days of stock: 302,000 ₽ is tied up in them. Antifreeze is seasonal and can't be sold at full price before winter — better to free up some of the cash by arranging a return or a promotion.
Three groups of goods and what to do with them
- Below minimum. Order from the supplier today, or sales will stop.
- Within range. Do nothing, but review the minimum once a month.
- Excess. Stop purchasing, run a promotion, move stock to a warehouse where it sells faster.
Why report figures don't match the shelf
- Sales aren't written off from the warehouse automatically.
- Transfers between warehouses aren't recorded.
- Returns are accepted without paperwork.
- Write-offs of defective goods are put off "until later".
Each of these causes is fixed by tracking where stock changes along with the sale and every movement is logged.
Related reading: warehouse inventory tracking, supplier orders, cash gap.
How it works in Mestra

Company warehouses and items below minimum
Mestra is a CRM system: clients, messengers and marketplaces, tasks, finance, analytics and an AI operator in one window.
- Warehouse list with alerts. Each warehouse shows the number of items and how many are below minimum.
- Warehouse card. A "Below minimum" block with the current quantity and minimum for each item.
- Warehouse products. A list with quantities, minimums and search by name or SKU.
- Movement log. Transfers and stock changes with date, author and comment.
- Reorder task. When the minimum is reached, an "Order from supplier" task appears.
- Cost price. Set in the product card and used in invoices, so the profit on every sale is visible.
FAQ
What stock level is considered normal?
Usually the delivery lead time plus a few days of buffer. For goods delivered within 3 days, more than 30–45 days of stock is a reason to check your purchasing.
How often should you review the stock report?
Items below minimum — daily; excess and slow-moving stock — once a month.
What should you do with goods that don't sell?
Stop purchasing, offer a discount or a bundle, return them to the supplier if the contract allows.
Should stock be tracked for each warehouse?
Yes, if you have more than one. Total stock hides shortages at a specific location.
Bottom line
Stock control comes down to two questions: will goods last until the next delivery, and how much cash is sitting idle. Calculate days of stock, review items below minimum daily and excess stock monthly. In Mestra, stock, minimums and the movement log are visible in every warehouse card — try it free for 15 days.


