Skip to content
QQuentaTechnologies Inc.
Inventory

Slow-Moving Stock Is Sleeping Money: How to Find the Cash Asleep on Your Shelves

Your profit can look healthy while your cash quietly disappears into stock that is not moving. Here is how inventory turnover and days of inventory actually work, a worked example showing exactly how much cash a slow item is holding, and the one habit that keeps it from happening again.

By Sarah Songalia, CPA · Founder, Quenta

Business owners·7 min read·

There is a version of this conversation I have had many times, and it almost always starts the same way.

The owner is not in trouble. Sales are decent. The profit and loss statement shows a profit. And yet, when payday comes, or when a supplier calls, there is a familiar tightness in the chest. The money that the reports say exists does not seem to be anywhere in the bank.

So we look. And very often, we find it in the same place.

It is on the shelves.

Not the fast items. Those are doing their job. It is the other ones. The box that has been in the same corner since January. The variant you ordered because the supplier gave a better price for a larger quantity. The batch you bought when demand looked like it was about to take off, and then it did not.

That stock is not idle. It is working against you. It is your cash, converted into something you cannot spend, sitting quietly and waiting.

Key takeaways

  • Inventory is cash in a different shape. Until it sells, it cannot pay a supplier, a salary, or a loan.
  • Slow-moving stock does not appear as a loss on your profit and loss statement. It sits on your balance sheet, which is why profit can look healthy while cash feels tight.
  • Inventory turnover tells you how many times a year you sell through your stock. Days of inventory turns that into a number you can feel: how long an item sits before it moves.
  • Compute turnover per item, not just for the whole business. The total average almost always hides both your best performers and your worst.
  • The fix is rarely dramatic. It is a monthly look, an honest decision on the slow items, and a reorder point so it does not happen again.

Why Your Profit Can Look Fine While Your Cash Does Not

This is the part that surprises even experienced owners, and it is not because they missed something obvious. It is because of how accounting is designed to work.

When you buy stock, that purchase does not immediately become an expense. It becomes an asset. It sits on your balance sheet as inventory. It only becomes an expense, your cost of goods sold, at the moment it is actually sold.

Which means an item that never sells never hits your profit and loss statement at all. Your reported profit stays untouched. Your cash, however, left the moment you paid the supplier.

So the profit and loss statement tells you the truth, but it is not the whole truth. It is one of the clearest examples of why sales and profit are not the same thing as cash, and why a business can be profitable on paper and still struggle to pay for things this week.

Slow-moving stock is not a loss you can see. It is cash you have already spent, quietly waiting on a shelf for permission to come back.

Two Numbers That Make It Visible

You do not need an inventory system or a consultant to see this. You need two numbers, and both come from figures you already have.

1. Inventory turnover: how many times you sell through your stock

Inventory turnover = cost of goods sold for the year, divided by your average inventory for the year.

Average inventory is simply your beginning inventory plus your ending inventory, divided by two. Do not overthink it. An honest estimate is far more useful than a perfect number you never compute.

A turnover of 6 means you sold through your entire stock six times in a year. A turnover of 1 means it took the whole year to sell through it once.

2. Days of inventory: how long an item sits before it moves

Days of inventory = 365, divided by your inventory turnover.

This is the version that owners tend to feel, because it is expressed in something we all understand. A turnover of 6 becomes about 61 days. A turnover of 1 becomes 365 days, which is another way of saying that your money took a full year to come home.

Neither number has a universally correct value. A bakery should turn over stock in days. A furniture store may reasonably take months. What matters is not the benchmark. What matters is the comparison between your own items, and the direction the number is moving.

A Worked Example: Where the Cash Actually Went

Let us take a small retail business. For the year, its cost of goods sold was ₱2,400,000. Its inventory was ₱550,000 at the start of the year and ₱650,000 at the end.

  • Average inventory = (₱550,000 + ₱650,000) ÷ 2 = ₱600,000.
  • Inventory turnover = ₱2,400,000 ÷ ₱600,000 = 4 times a year.
  • Days of inventory = 365 ÷ 4 = about 91 days.

On its own, that reads like a reasonably healthy business. Stock turns four times a year, and money comes back roughly every three months.

But a business does not sell an average. It sells items. So we broke the same ₱600,000 into just two groups.

  • Group A, the fast movers: ₱250,000 of the stock, generating ₱2,250,000 of the cost of goods sold. Turnover = 9 times a year. Days of inventory = about 41 days.
  • Group B, the slow movers: ₱350,000 of the stock, generating ₱150,000 of the cost of goods sold. Turnover = 0.43 times a year. Days of inventory = about 852 days.

Read those two lines again, because the story completely changes.

The healthy 91-day average was an illusion created by mixing the two. In reality, the business has an excellent core that recovers its money in about six weeks, and it has ₱350,000 of cash lying down on the shelves with an expected wake-up time of more than two years.

₱350,000. That is more than half of everything the business has in stock, and it is producing almost nothing. It is not stolen. It is not lost. It is simply asleep.

And here is the part that stings: the owner has almost certainly been paying rent to store it, insurance to protect it, and interest on a loan taken out because cash felt tight. Slow stock does not sit for free. It charges you rent.

What to Do With What You Find

Once the slow items have names, the decision gets much less emotional. It usually comes down to one of four honest choices.

  • Sell it, even at a discount. This is the hardest one, because discounting feels like admitting the purchase was a mistake. It is not. The money is already spent. The only question left is how much of it you can get back, and how soon. ₱350,000 that becomes ₱250,000 in cash this month is worth more than ₱350,000 that becomes ₱350,000 in two years, or nothing at all.
  • Bundle it with something that moves. Pair the slow item with a fast one. It moves quietly, and it protects the price of the item you sell on its own merits.
  • Return or exchange it, if your supplier relationship allows it. Ask. Many owners never do, and the answer is more often yes than they expect.
  • Stop reordering it. This sounds obvious, and yet slow items are frequently reordered out of pure habit, because the reorder list was written when the item was still selling.

And when you price whatever you decide to move, price it deliberately. A discount that looks generous on a markup basis can quietly erase your entire margin, which is the trap I wrote about in markup is not margin.

The Habit That Stops It From Happening Again

Dead stock is almost never the result of one bad decision. It is the result of no decision, made repeatedly, for months.

So build the decision into your month. Once a month, open your stock list and sort it by how long each item has been sitting. Look only at the bottom of that list, the slowest ten items. Ask one question of each: is this still earning its place, or is it just familiar?

Then set a reorder point for the items that do earn their place: the level at which you buy again, based on how fast the item actually sells and how long your supplier takes to deliver. A reorder point protects you from the two most expensive versions of the same mistake, which are running out of the things people want and drowning in the things they do not.

This pairs naturally with the weekly numbers check. The weekly check keeps you close to cash. The monthly stock review keeps your cash from wandering onto a shelf and falling asleep.

Seeing It Sooner

Almost every owner I have worked with eventually finds their sleeping money. The difference between a difficult year and an ordinary one is usually just how long it took them to look.

Waiting until year-end to discover that half your stock has not moved is not a lack of discipline. It is a lack of visibility. If the only time your numbers become clear is after the month has already closed, then every decision you make is a decision about a business that no longer exists.

This is precisely what Quenta was built to shorten. When your sales, your purchases, and your stock levels sit in one place and stay current, an item that has stopped moving does not need to be discovered. It is simply visible, while there is still time to do something about it.

But you do not need software to start. You need your cost of goods sold, your stock list, and one honest hour this month. Compute your turnover. Split it between what is moving and what is not. Then go and look at the slowest ten items on your shelf, and give each one a name and a decision.

Some of that stock will earn its place. Some of it is money you have been waiting for without realizing you were the one holding it.

slow moving inventoryinventory turnover ratiodays of inventorydead stock small businessinventory management Philippineshow to compute inventory turnovercash tied up in inventoryreorder point small businessstock not selling what to doMSME inventory Philippines

Do this automatically in Quenta.

Everything in this guide - captured, reviewed, and reported from the transactions you've already entered. Start free.

Start free

Discuss in the community →