Calculating Inventory Days: How to Figure Out How Long Your Stock Is Sitting
30 July 2026
Calculating Inventory Days: How to Figure Out How Long Your Stock Is Sitting
It’s past midnight, the warehouse lights are humming, and you’re staring at a spreadsheet that’s giving you that familiar, heavy feeling in the chest.
Your bank balance is tighter than it should be, yet your shelves are packed. Boxes of last season's best-sellers are gathering dust in the back corner, and your suppliers are expecting payment for a fresh batch of stock you aren't even sure will sell. You know the cash is trapped in those boxes somewhere, but looking at a total inventory value of £80,000 doesn’t actually tell you what you need to know.
What you actually need to answer is a much more human question: How long is my money sitting around gathering dust before it turns back into cash?
If you’ve been googling how to figure that out, you’ve likely bumped into the term "Days Sales of Inventory" or simply calculating inventory days. It sounds like corporate jargon meant for people in gray suits managing multinational supply chains, but it is actually one of the most comforting, grounding numbers a small business owner can find. Once you calculate it, the mystery disappears, and you can finally see the levers you have to pull.
Let’s break it down together, step by step, using real math that actually makes sense.
Why Inventory Days Actually Matters (More Than Profit)
Here is the dirty little secret of running a business with physical products: you can look profitable on paper and still go bankrupt.
Profit is an opinion; cash is a fact. You can sell £10,000 worth of merchandise on credit or watch it sit in a warehouse, but if that value is locked up in physical goods, you can’t use it to pay rent, buy groceries, or cover payroll.
When people talk about calculating inventory days, they are measuring your Days Sales of Inventory (DSI). This metric tells you the average number of days it takes for your business to turn its inventory into sales.
- If your inventory days is 15, you’re running a fast-moving machine. You buy stock, and two weeks later, it’s out the door and money is back in your account.
- If your inventory days is 180, your stock is taking half a year to move. That means your cash is trapped, sleeping on a shelf, unable to do any work for you.
Knowing this number stops the guesswork. Instead of wondering why the bank account feels so light despite a busy month, you can look at your DSI and say, "Ah. My stock is sitting for 90 days instead of 45. That’s where the money went."
The Formula: Two Steps to Clarity
To get to your inventory days, you only need two pieces of financial data from your profit and loss statement and balance sheet: Average Inventory and Cost of Goods Sold (COGS).
Don’t let the accounting acronyms scare you. Let’s look at how they fit together.
Step 1: Find Your Average Inventory
Why average? Because inventory fluctuates. You might stock up heavily before the winter holidays and run lean in the summer. If you just look at today's inventory value, it might be misleading.
To keep it simple, take your inventory value at the start of the year (or quarter) and add it to your inventory value at the end of the year (or quarter), then divide by two.
$$\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}$$
Step 2: Find Your Cost of Goods Sold (COGS)
This is what it actually cost you to buy or produce the items you sold over that same period. Note: not what you sold them for (revenue), but what you paid for them.
Step 3: Put Them Together
Now, divide your Average Inventory by your COGS, and multiply the result by the number of days in the period (usually 365 for a full year, or 90 for a quarter).
$$\text{Inventory Days} = \left( \frac{\text{Average Inventory}}{\text{COGS}} \right) \times 365$$
Let’s watch how this works in the real world so the math stops feeling abstract.
Meet Maya: A Worked Example
Meet Maya. She runs an independent homeware shop, importing artisan ceramics and textiles. Lately, she’s been feeling the squeeze. She feels like she’s constantly reordering, yet her business checking account never seems to grow.
Let’s look at Maya’s books for the past 12 months to see what’s really happening.
- Beginning Inventory (January 1): £30,000
- Ending Inventory (December 31): £50,000
- Cost of Goods Sold (COGS) for the year: £120,000
Maya’s business has grown over the year, which is why her ending inventory is higher than her beginning inventory. Let’s run the numbers step-by-step.
1. Calculate Average Inventory
First, Maya finds the midpoint between her start-of-year and end-of-year stock value:
$$\frac{£30,000 + £50,000}{2} = £40,000$$
On average, Maya kept £40,000 worth of ceramics and blankets sitting in her storage unit and shop over the course of the year.
2. Divide by Cost of Goods Sold
Next, she divides that average inventory by what it cost her to buy all the goods she successfully sold (£120,000):
$$\frac{£40,000}{£120,000} = 0.3333$$
This fraction tells Maya that her average inventory represents about one-third of her annual cost of goods sold.
3. Multiply by 365 Days
Finally, she multiplies that decimal by the number of days in a year to translate it into a timeline:
$$0.3333 \times 365 = 121.6 \text{ days}$$
Maya’s inventory days is roughly 122 days.
Take a breath with Maya for a second. That means from the moment she wires money to her overseas supplier to the moment a customer buys that ceramic vase and the cash hits her account, four months have passed.
For four months, her hard-earned money has been turned into clay sitting on a shelf. Suddenly, she understands why cash flow is so tight: she is financing a third of a year’s worth of stock at all times.
(If you are running numbers for your own business right now and want to check how other parts of your financial setup interact—like working capital loans or business equipment financing—you can always hop over to look at our guides in the Loans category to see how borrowing costs fit into your cash flow timeline.)
The Hidden Traps: What Trips People Up
When business owners start calculating inventory days, they often make a few common mistakes that skew the results and lead to unnecessary panic (or false confidence). Here is what to watch out for.
1. Using Retail Price Instead of Cost
This is the number one trap. If Maya looks at her inventory and counts it based on the price tags she’s going to sell it for (say, £80,000 instead of her actual cost of £50,000), her inventory days will look artificially inflated.
Always use your cost price—what you paid for the goods—not your retail revenue price. COGS is built on cost, so your inventory valuation must match it.
2. Mixing Up Timeframes
If you use a 90-day Cost of Goods Sold figure for a single quarter, you must multiply by 90 days at the end of the formula, not 365.
- Quarterly calculation: Multiply by 90.
- Annual calculation: Multiply by 365. Mixing these up will give you results that make zero sense, like claiming your inventory sits for 1,400 days.
3. Ignoring Seasonality
If you run an outdoor garden center or a holiday gift shop, an annual average can lie to you. Your inventory days in June might be 30, but in December, they might spike to 150.
If your business is highly seasonal, calculate your inventory days on a monthly or quarterly rolling basis. That way, you see the crunch points before they drain your bank account.
What Is a "Good" Number? (Spoiler: It Depends)
The moment you get your final number, the immediate next question is: Is 122 days bad? Should I panic?
The honest answer is: It depends entirely on what you sell.
- Perishable goods or fast-moving consumer goods (groceries, fresh food, trendy fast fashion): You want inventory days to be very low. Think 15 to 45 days. If lettuce or milk sits for 120 days, you’re throwing it in the bin.
- High-end luxury goods, fine wine, specialized machinery, or custom furniture: These are supposed to take time. Customers expect to wait, and the items hold their value. An inventory day count of 180 or even 240 days might be completely normal and healthy for this business model.
Instead of comparing your business to a random benchmark on the internet, compare your number to last year's number.
Are your inventory days creeping up from 90 to 120 over the last two years? That is your early warning system. It means stock is slowing down, dead inventory is accumulating, or your purchasing habits have outpaced your actual customer demand.
The Relief: What You Can Actually Do With This Number
Here is where the knot in your stomach starts to untie. Once you know your inventory days, you are no longer reacting to a vague sense of financial dread—you have actual levers you can pull.
You don’t have to fix everything overnight. You just have to pull one of these three levers.
[ Your Inventory Days Too High? ]
│
├──► 1. Slow Down Ordering (Buy less, buy more often)
├──► 2. Run Targeted Promotions (Turn dead stock into liquid cash)
└──► 3. Negotiate Payment Terms (Ask suppliers for net-60 instead of net-30)
1. Stop Buying on Autopilot
Many businesses reorder stock out of habit because "we always order 500 units in October." If your inventory days are climbing, your first move is simple: order less next time. Let your existing stock draw down. You’ll free up cash immediately without spending a single penny on marketing.
2. Turn Dead Stock Into Oxygen
That stuff sitting in the back corner of the warehouse for nine months isn't an asset anymore; it’s a liability holding you hostage. Run a clearance sale, bundle it with fast-selling items, or sell it to liquidation buyers at cost.
- Yes, you take a hit on margin.
- No, you don't make a profit on those specific items.
- However, you turn dead weight into cash sitting in your bank account today, which you can use to buy things that actually sell in two weeks. Cash is oxygen; dead stock is an anchor.
3. Talk to Your Suppliers
If your inventory takes 120 days to sell, but your suppliers demand payment within 30 days, you are financing your business out of your own pocket for a 90-day gap. Can you negotiate longer payment terms (moving from Net-30 to Net-60)? Can you order smaller batches more frequently (Just-In-Time delivery) so you don't tie up capital all at once? Most suppliers prefer a loyal customer who pays reliably over one who goes bankrupt because they over-ordered.
Taking a Deep Breath
Financial metrics like inventory days often feel like school exams—tests designed to prove whether you’re succeeding or failing.
They aren't. They’re just instruments on a dashboard. Just like the fuel gauge in a car, an inventory days calculation doesn't judge you for running low; it just tells you how many miles you have left before you need to pull over at a petrol station.
If your number is higher than you’d like, take comfort in the fact that you now know where your money is hiding. It isn't lost to a mysterious black hole—it’s sitting on your shelves, waiting to be unlocked.
Take 20 minutes with your last year’s P&L and balance sheet, run the equation for your own business, and see where you stand. Once you have that number, the fog clears, and you can make a plan that lets you sleep easy tonight.
Frequently Asked Questions
Can inventory days be negative?
No. Mathematically, because average inventory and COGS are both positive numbers, your inventory days will always be a positive figure. If you get a negative number, check your inputs—you likely entered a negative inventory adjustment or reversed your beginning and ending figures.
How often should I calculate inventory days?
If your business is stable, calculating it once a year during annual accounts is fine. But if you have seasonal rushes, volatile supply chains, or tight cash flow, calculating it quarterly (every three months) gives you the timely insights you need to adjust your purchasing before cash gets tight.
Is inventory days the same as inventory turnover?
They are two sides of the same coin. Inventory turnover tells you how many times your inventory is sold and replaced over a period (e.g., 4 times a year). Inventory days (DSI) simply converts that turnover into how many days each cycle takes (365 divided by your turnover ratio). Use whichever one feels more intuitive to your brain.
Disclaimer: This article is for informational purposes and provides general guidance on financial calculations. It does not constitute formal financial, accounting, or tax advice tailored to your specific business.
For calculations on the go, check out the free Finlaa app to run your numbers anytime.
