Days Inventory Outstanding Explained
How long does a typical item sit on your shelves before it sells? Days inventory outstanding, or DIO, answers that question in a single number. It tells you how many days of cash are tied up in stock, and once you know it, you can spot slow sellers, plan purchases better and free up money for the rest of your business.
Key takeaways
- Days inventory outstanding = average inventory divided by cost of goods sold, times 365 (or the days in the period).
- It shows the average number of days stock sits before it is sold. Lower usually means cash moves faster.
- DIO is the flip side of inventory turnover, so you can convert one into the other.
- Compare DIO with your own history and by product group, not with a single "ideal" number.
Mid-January is a good moment to meet this metric. Your year-end stock figures are fresh, your cost of goods sold for last year is nearly final, and you are about to place orders for spring. Calculating DIO now gives you a baseline for the whole year and an early warning if you are about to over-order.
You do not need to be an accountant to use it. If you can find two numbers in your accounts and do a little division, you can calculate DIO in a few minutes. The harder, more valuable part is understanding what the number tells you and deciding what to change.
A quick note: this article is general information about financial metrics, not accounting or investment advice. For decisions about borrowing, tax or your statutory accounts, speak with a qualified accountant.
What days inventory outstanding means
Days inventory outstanding measures the average number of days your business holds inventory before selling it. You will sometimes see it called days in inventory, days sales of inventory or inventory days. They all describe the same idea.
Think of it this way. Every item you buy is cash that has left your bank account and turned into stock. It only turns back into cash when you sell it, and later still when the customer pays. DIO measures the first part of that journey: how long your money waits on the shelf.
The parts of the formula
- Average inventory: usually opening inventory plus closing inventory for the period, divided by two. If your stock levels swing a lot, averaging monthly balances gives a fairer picture.
- Cost of goods sold (COGS): what the stock you sold cost you, not what you sold it for. Use the figure from your profit and loss report.
- Days in the period: 365 for a year, about 90 for a quarter, or the actual number of days for a month.
Common mistake
Using sales revenue instead of cost of goods sold. Inventory is valued at cost, so comparing it with sales at retail prices mixes two different measures and makes your DIO look better than it is. Always use COGS.
How to calculate DIO, step by step
- Pick your period. A full year is a good starting point. Quarters are useful once you want to track change.
- Find opening and closing inventory. Take them from your balance sheet or inventory valuation report.
- Calculate average inventory. Add the two and divide by two, or average your monthly balances.
- Find COGS for the same period. Take it from your profit and loss report.
- Divide and multiply. Average inventory divided by COGS, then multiply by the days in the period.
- Write it down. Record the result with the date and the figures you used, so you can compare next time.
Example
Imagine Aisha, who runs a small craft supplies shop. Her inventory was $22,000 at the start of the year and $18,000 at the end, so her average inventory is $20,000. Her cost of goods sold for the year was $80,000. Her DIO is $20,000 divided by $80,000, which is 0.25, times 365, which is about 91 days. On average, an item sits in her shop for about three months before it sells. (All figures are made up for illustration.)
DIO and inventory turnover
Inventory turnover is cost of goods sold divided by average inventory. It tells you how many times you sell through your average stock in a period. DIO is the same relationship turned into days. In Aisha's example, turnover is $80,000 divided by $20,000, or 4 times a year, and 365 divided by 4 is about 91 days. If you already track turnover, you can convert it to DIO with one division.
What a high or low DIO tells you
There is no single "good" DIO. A florist and a hardware store will have very different numbers, and both can be healthy. What matters is what the number means for your cash and your customers.
A high DIO
Stock is sitting for a long time. That can mean:
- Cash is tied up that could pay bills, fund marketing or reduce borrowing.
- Some products are slow sellers, out of season or no longer wanted.
- You are buying in larger quantities than you need, perhaps for a discount.
- Storage, insurance and handling costs are higher than necessary.
- There is a greater risk of damage, spoilage or items going out of date.
A high DIO is not always bad. You might be building stock on purpose before a busy season, or holding spare parts that customers need urgently. The key is knowing why.
A low DIO
Stock moves quickly. That usually means cash comes back faster, but if DIO gets too low you may run out of popular items, lose sales and frustrate customers. Frequent small orders can also raise shipping and admin costs.
Pro tip
Calculate DIO by product group, not just for the whole business. A healthy overall number can hide a fast-moving bestseller and a category of slow stock that has not moved in months. The breakdown tells you where to act.
A DIO tracker template by product group
Copy this layout into a spreadsheet and fill in one row per category. The figures are made up for illustration.
| Product group | Average inventory (example) | COGS for the year (example) | Turnover | DIO (days) | Action |
|---|---|---|---|---|---|
| Yarn and wool | $6,000 | $36,000 | 6.0 | About 61 | Keep reorder levels; watch winter peak |
| Paints and brushes | $5,000 | $30,000 | 6.0 | About 61 | No change |
| Craft kits | $9,000 | $14,000 | 1.6 | About 235 | Bundle, discount slow lines, order smaller batches |
In this made-up example, craft kits hold almost half the stock but sell slowly. That is where cash is stuck, and where a change in buying or pricing would help most.
Ways to bring DIO down without running out
If your DIO is higher than you want, small changes add up. Try these one at a time and measure the effect.
- Order smaller, more often: especially for items with steady demand and reliable suppliers.
- Set reorder points: base them on how fast each item sells and how long suppliers take to deliver.
- Clear slow stock: bundles, gentle discounts, wholesale sales or returning items to suppliers where your agreement allows it.
- Trim the range: drop variations that rarely sell and focus on what customers actually buy.
- Negotiate with suppliers: shorter lead times or smaller minimum order quantities can be worth more than a bulk discount.
- Forecast with your own history: look at last year's sales by month to plan seasonal buying.
Common mistake
Chasing a lower DIO at all costs. Cutting stock too far leads to empty shelves, lost sales and unhappy customers. Aim for a DIO that keeps your bestsellers in stock while freeing cash from slow lines.
DIO in the bigger cash picture
DIO is one piece of a larger cash puzzle. Many businesses look at it alongside how long customers take to pay them and how long they take to pay suppliers. Together, those three numbers describe how long cash is tied up in day-to-day operations, often called the cash conversion cycle.
For example, if your stock sits for 60 days and customers pay on the spot, but you pay suppliers in 30 days, you have to fund roughly a month of stock from your own cash. Reducing DIO shortens that gap, which can mean less need for overdrafts or credit lines.
Seasonal businesses
If your stock builds up before a peak season, a single annual DIO can hide big swings. Calculate it quarterly or monthly, and compare each period with the same period last year rather than with the month before. A high DIO in the run-up to your busy season can be perfectly sensible.
Watch for distortions
- Year-end write-offs or count adjustments can change average inventory.
- A change in your costing method can move COGS without any real change in sales.
- Large one-off purchases near a period end can inflate closing stock.
Make a short note next to each DIO figure that explains anything unusual, so you do not draw the wrong conclusion later.
Your DIO action checklist
- Find opening inventory, closing inventory and COGS for last year
- Calculate average inventory and your overall DIO
- Repeat the calculation for each main product group
- Identify the two or three groups with the highest DIO
- Choose one action for each slow group, such as smaller orders or bundling
- Set reorder points for your bestsellers
- Recalculate DIO every quarter and note anything unusual
Frequently asked questions
What is a good days inventory outstanding?
It depends on your industry, products and season. Perishable goods need a low DIO, while some specialist parts can reasonably sit for longer. The most useful comparison is with your own past results and between your product groups.
Is DIO the same as inventory turnover?
They measure the same relationship in different ways. Turnover tells you how many times you sell through average stock in a period; DIO turns that into the number of days stock sits. Divide 365 by annual turnover to get DIO.
How often should I calculate DIO?
Once a year gives you a baseline. Quarterly or monthly calculations are more useful if your business is seasonal or you are actively trying to reduce stock levels.
Does DIO apply to service businesses?
Only if you hold stock, such as parts or materials for jobs. If you carry little or no inventory, other cash metrics will be more useful to you.
The bottom line
Days inventory outstanding tells you how long your money sits on the shelf. Calculate it with average inventory, cost of goods sold and the days in the period, break it down by product group and compare it with your own history. Then act on the slowest groups while protecting your bestsellers.
Grab last year's figures today and work out your first DIO. One number, calculated regularly, can free up more cash than you might expect.
