Days in Inventory Formula: How to Calculate It and Why It Matters

It’s 11:00 PM, and you’re staring at a warehouse full of boxes that aren't moving quite as fast as you hoped when you ordered them. You have payroll coming up next week, suppliers wanting their invoices paid, and a sinking feeling that your hard-earned cash is tied up in inventory gathering dust. You know you need to free up some breathing room in your bank account, but when you look at your balance sheet, everything just looks like a wall of intimidating accounting jargon.

You’ve probably heard people throw around terms like inventory turnover and the days in inventory formula like it's common knowledge. But if you’ve ever felt a little dizzy trying to remember what goes in the numerator and what goes in the denominator, you're in the right place.

Let’s demystify this metric together. No dry textbook lectures or confusing jargon—just a clear, practical way to figure out what your stock is doing, how long it actually takes to sell, and how to put that cash back into your pocket.

Why Your Warehouse is a Parking Lot for Cash

Think of every single item sitting on your shelves, in your back room, or in your storage unit as frozen money. When you buy inventory, you take hard-earned cash and transform it into physical goods. That’s great if those goods fly out the door the next day.

But what happens when they sit there for thirty days? Sixty days? Six months?

That cash is stuck. You can’t use it to pay yourself, hire a new team member, or take advantage of a sudden discount from a supplier. It’s trapped in the form of cardboard, plastic, or fabric.

The days in inventory formula—often called Days Sales of Inventory (DSI) or days inventory outstanding—is simply the tool that tells you the exact average number of days it takes for your business to turn its stock into actual sales. Once you know this number, the fog lifts. You stop guessing whether you ordered too much, and you start seeing the rhythm of your business in plain numbers.

Before we dive into the math, if you're running calculations for your business finances alongside your stock metrics, you can always map out your broader numbers using the Finlaa business finance tools to keep your cash flow steady.

Breaking Down the Days in Inventory Formula

Let’s look at the actual math. Don't worry, it only requires basic division and multiplication.

To find your days in inventory, you need two main pieces of information from your financial statements:

1. Average Inventory: The average value of the stock you held over a specific period (usually a year or a quarter).
2. Cost of Goods Sold (COGS): What it actually cost you to buy or produce the items you sold during that same period.

Here is the classic formula:

$$\text{Days in Inventory} = \left( \frac{\text{Average Inventory}}{\text{Cost of Goods Sold (COGS)}} \right) \times 365$$

(Note: If you are looking at a shorter timeframe, like a quarter, you would substitute 365 with 90 or 91 days. But sticking to 365 for an annual view is the standard starting point.)

Let's break down why these two inputs matter so much before we run through a full story of how it works in real life.

Finding Your Average Inventory

Why do we use the average inventory instead of just looking at what you have in stock right today?

Because inventory fluctuates wildly throughout the year. If you run a retail shop, your stock levels spike right before the holiday shopping season in November, and they plummet after the January clearance sales. If you only look at your inventory on December 31st, you get a skewed picture.

To keep it simple, businesses usually find the average by taking the inventory value at the start of the year and the inventory value at the end of the year, adding them together, and dividing by two:

$$\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}$$

The Magic of COGS

Cost of Goods Sold is often confused with your revenue or total sales, but it’s completely different. COGS is what you paid to acquire or manufacture the products you sold—not the price you charged your customers.

If you bought a batch of handmade mugs for $10 each and sold them for $25 each, your COGS for those mugs is $10, not $25. Using your retail price in this formula will completely throw off your results because it bakes your profit margin into the inventory calculation.

Walking Through a Real Example: Meet Maya's Boutique

Let’s see how this works in practice. Meet Maya, who runs a growing independent home-decor shop.

Maya is looking at her financial records for the past year. She feels like her capital is tied up, but she wants proof. Here is what her books show:

• Inventory on January 1st (Beginning Inventory): $40,000
• Inventory on December 31st (Ending Inventory): $60,000
• Cost of Goods Sold (COGS) for the year: $200,000

Step 1: Calculate Average Inventory

First, Maya figures out how much stock she held on average over the course of those twelve months:

$$\text{Average Inventory} = \frac{$40,000 + $60,000}{2} = $50,000$$

So, on any given day last year, Maya had roughly $50,000 worth of merchandise sitting in her shop and storage room.

Step 2: Divide Average Inventory by COGS

Next, she divides that average inventory by her annual Cost of Goods Sold:

$$\frac{$50,000}{$200,000} = 0.25$$

This fraction tells Maya that her average inventory represents one-quarter of her total annual cost of goods sold.

Step 3: Multiply by 365 Days

Finally, she multiplies that result by the number of days in the year:

$$0.25 \times 365 = 91.25 \text{ days}$$

There it is: 91 days.

On average, it takes Maya roughly three months to sell a piece of inventory from the moment she buys it from her supplier to the moment a customer buys it and takes it home.

When Maya sees that 91-day figure, she exhales. It's not a crisis—she isn't failing—but it explains why her bank account feels tight. Her money is locked up in a three-month cycle. If she can find a way to bring that number down to 60 days, she will free up thousands of dollars in trapped cash.

What's a "Good" Days in Inventory Number?

The immediate question Maya—and probably you—asks next is: Is 91 days good? Is my number too high?

The frustrating, honest answer in finance is: It depends entirely on your industry.

• Grocery Stores & Supermarkets: These businesses deal in perishable items with razor-thin margins. Their days in inventory might be as low as 7 to 14 days. Milk and lettuce cannot afford to sit around.
• Clothing & Apparel Retailers: Fashion trends shift, so apparel stores typically aim for 60 to 90 days to avoid getting stuck with out-of-season styles.
• Heavy Machinery, Fine Jewelry, or Industrial Parts: If you sell specialized industrial equipment or luxury watches, a high price tag means lower turnover volume. Your days in inventory might easily stretch to 180 to 365 days (or even longer), and that's entirely normal for that business model.

The key isn't comparing yourself to a random benchmark across the internet. The key is comparing your numbers this year to your numbers last year, or comparing your specific product lines against each other. Is your inventory moving faster than it was six months ago? That’s the progress that matters.

Common Traps and Where People Trip Up

Even with a straightforward formula, it's remarkably easy to skew your numbers if you aren't careful. Here are the most common traps business owners fall into when calculating days in inventory, and how to dodge them.

1. Mixing Up Retail Price and Cost

This is the number one mistake. If you use your total retail sales revenue instead of your Cost of Goods Sold in the denominator, your math will look wildly optimistic.

Remember, your customers pay retail price, but your inventory is valued at cost. Always use COGS to keep apples matched with apples.

2. Using Year-End Snapshots Instead of Averages

If your business is seasonal, taking just your ending inventory from December can give you a completely false reading. If you grew rapidly over the year, your beginning inventory might be tiny and your ending inventory massive, making your "average" look artificially high or low.

If you have monthly inventory numbers available in your accounting software, calculate your average using all twelve months rather than just the start and end. It takes an extra two minutes and gives you crystal-clear accuracy.

3. Forgetting About Dead Stock

Let’s say you have an item that hasn't sold in three years sitting in the back corner of your warehouse. That dead stock drags up your average inventory value, making your overall days in inventory look much worse than your active products deserve.

If you have obsolete inventory that you know will never sell, write it off or clear it out at a steep discount. Leaving it in your average inventory calculation masks the true performance of the products that are actually making you money.

How to Lower Your Days in Inventory (and Free Up Cash)

Once you calculate your number, you might realize your stock is sitting far too long. Don't panic—this is where the formula transforms from a boring historical report into an actionable game plan.

Lowering your days in inventory means you are turning stock into cash faster. Here are the practical levers you can pull:

• Adopt Just-In-Time (JIT) Ordering: Instead of ordering a massive bulk supply to get a tiny discount from your vendor (only to have it sit for six months), order smaller batches more frequently. You’ll save on storage space and keep your cash liquid.
• Run Strategic Promotions on Slow Movers: Look at your inventory reports and identify the items that haven't moved in 90 days. Run a bundle deal, a flash sale, or feature them prominently. Even selling them at a slight discount frees up warehouse space and puts cash back in your hands to buy products that actually sell.
• Improve Your Demand Forecasting: Often, high days in inventory happen simply because of enthusiasm. We order what we hope will sell rather than what historical data says customers actually buy. Look at your seasonal trends from previous years before placing your next large purchase order.

When your business finances are humming along, managing these moving parts becomes second nature. To check how your broader financial health looks alongside your inventory adjustments, explore the tools available on the Finlaa homepage.

Putting It All Together

Financial metrics like the days in inventory formula can feel intimidating when they're trapped behind accounting lingo. But at its core, this formula is just a storyteller. It tells you the story of your cash: where it goes, how long it sleeps on a shelf, and when it finally comes back home to work for you.

You don't need an MBA or a complex spreadsheet to take control of it. Grab your last year's financial statement, pull your Cost of Goods Sold and your average inventory, and run the math. Whether your number is 30 days or 150 days, knowing the exact truth gives you the power to change it.

Take a deep breath. You now know exactly how to measure what's sitting in your warehouse, and more importantly, how to get your money moving again.

---

Disclaimer: This article is for informational purposes only and does not constitute financial or accounting advice. Every business is unique, and you should consult with a qualified accountant or financial advisor regarding your specific inventory and tax situation.

Frequently Asked Questions

What is the difference between inventory turnover and days in inventory?

They are two sides of the same coin! Inventory turnover tells you how many times your entire inventory is sold and replaced over a period (e.g., 4 times a year). Days in inventory takes that exact same data and translates it into how many days it takes to sell through that stock on average (e.g., about 91 days). Many business owners prefer days in inventory because a time-based metric is often easier to visualize than a frequency ratio.

Can I calculate days in inventory if I use FIFO or LIFO accounting?

Yes, but your choice of inventory valuation method (First-In, First-Out or Last-In, First-Out) will impact your Cost of Goods Sold and your ending inventory valuation. Whichever method you use for your general accounting and tax purposes, use those exact same figures for your inventory calculations so your financial reports remain consistent.

What is considered a "bad" days in inventory number?

There is no universal "bad" number, but a rapidly rising days in inventory number compared to previous years is a major warning sign. It usually indicates that you are over-purchasing, customer demand for your products is slowing down, or you are holding onto obsolete dead stock that needs to be cleared out.

---

To run calculations on the go, check out the free Finlaa app.