Two businesses can post identical revenue and identical profit margins and still be in completely different financial health — because one of them has $80,000 sitting on a shelf collecting dust while the other turned that same $80,000 into cash three separate times last quarter. The difference doesn't show up on the income statement. It shows up in a single, under-used number: Days Inventory Outstanding.
If you've never calculated it, you're not alone — most small business owners track revenue, margin, and maybe a bank balance, and stop there. But if your business buys or makes physical things and sells them later, DIO is one of the most useful health checks you can run, because it answers a question your profit-and-loss statement can't: how long is my cash actually stuck before it comes back to me?
What Days Inventory Outstanding Actually Measures
Days Inventory Outstanding (DIO), sometimes called "days in inventory" or "days sales of inventory," tells you the average number of days it takes to sell through your inventory. A lower number means you're converting stock into sales quickly. A higher number means cash is parked on shelves, in a warehouse, or in a stockroom instead of in your bank account.
It's a liquidity metric, not a profitability metric. A product line can be wildly profitable per unit and still be a cash-flow problem if it takes five months to sell.
The Formula
The standard calculation is:
DIO = (Average Inventory / Cost of Goods Sold) × Number of Days in PeriodMost businesses calculate this annually (using 365 days) or quarterly (using 90-91 days). Average inventory is simply your beginning inventory value plus your ending inventory value, divided by two — this smooths out seasonal spikes that would distort a single point-in-time snapshot.
Worked example: Say a boutique retailer starts the year with $40,000 in inventory and ends with $50,000, for an average inventory of $45,000. Their cost of goods sold (COGS) for the year was $270,000.
DIO = ($45,000 / $270,000) × 365 = 60.8 daysThat retailer takes roughly 61 days, on average, to turn a dollar of inventory into a dollar of sales.
The Shortcut: Inventory Turnover
You'll often see DIO discussed alongside inventory turnover — they're two views of the same underlying data.
Inventory Turnover = COGS / Average Inventory
DIO = 365 / Inventory TurnoverIn the example above, turnover is $270,000 / $45,000 = 6 times per year. Divide 365 by 6 and you land back at roughly 61 days. If a supplier, lender, or advisor quotes you a turnover ratio instead of a days figure, this conversion lets you compare it directly against your own DIO.
What Counts as "Good"
There's no universal good number — DIO is only meaningful next to your own history and your own industry, because holding periods are structurally different across business types. A few reference points:
- Grocery and perishables: roughly 10–25 days — shelf life forces fast turnover
- Fast-moving consumer goods: roughly 20–40 days
- Electronics retail: roughly 30–45 days
- Apparel: roughly 50–70 days, reflecting seasonal buying cycles
- Auto parts distribution: roughly 75–90 days
- Industrial distribution and mechanical equipment: 60–120+ days, since specialized parts sell less predictably
- Pharmaceutical manufacturing: 120–180 days, driven by regulatory and production lead times
If you're a boutique apparel shop running a 65-day DIO, you're roughly in line with the category. If you're an electronics reseller at 65 days, you're carrying stock nearly 50% longer than peers — and that gap is worth investigating. The comparison that matters most, though, is DIO against itself over time. A steady climb from 45 to 55 to 68 days over three quarters is an early warning sign long before it shows up as a cash crunch.
Why This Number Deserves Your Attention
It's a Direct Line to Your Cash Position
Every day inventory sits unsold is a day that cash isn't available for payroll, rent, a marketing push, or an unexpected expense. Inventory carrying costs — the combination of storage, insurance, capital cost, and shrinkage risk — commonly run 20% to 30% of inventory value per year across the industry, and small businesses often sit at the higher end of that range (25%–30%) because they lack the purchasing power and warehouse efficiency that larger companies use to bring costs down. On $50,000 of average inventory, that's $10,000–$15,000 a year quietly evaporating in carrying costs alone, independent of whether the goods ever sell.
It Feeds Directly Into Your Cash Conversion Cycle
DIO is one-third of the cash conversion cycle (CCC), the full loop from spending cash on inventory to collecting cash from the customer:
Cash Conversion Cycle = DIO + Days Sales Outstanding (DSO) − Days Payable Outstanding (DPO)A shorter DIO shortens the whole cycle — meaning less time your business needs outside financing (a credit line, a loan, or your own savings) to bridge the gap between paying suppliers and getting paid by customers. For most businesses, a cash conversion cycle in the 30–45 day range is considered healthy, though — like DIO alone — this varies significantly by industry.
It Surfaces Problems Before They're Obvious
A rising DIO is often the earliest signal of a few different problems, well before they show up anywhere else:
- Overbuying relative to actual demand — you're purchasing based on last year's sales pace, not this year's
- Slow-moving or dead SKUs — a handful of products are dragging the average up while the rest of your catalog turns fine
- Demand softening — a signal worth catching months before it appears as a revenue decline
- Pricing or assortment mismatch — the product mix doesn't match what customers currently want
Because DIO moves before revenue does, checking it quarterly (or monthly, if inventory is a big share of your assets) can give you a head start that a quarterly income statement won't.
How to Bring Your DIO Down
Forecast demand from actual sales data, not gut feel. Reorder based on recent velocity per SKU rather than round-number purchase habits. Even a simple spreadsheet tracking units sold per month per product beats intuition.
Identify and clear slow-moving stock deliberately. Run a report ranking inventory by days-on-hand and target the bottom 10–20% with bundling, discounting, or liquidation before it becomes a total write-off. It's better to recover 60 cents on the dollar now than 10 cents in a year.
Negotiate smaller, more frequent orders with suppliers. If a vendor offers a discount for buying in bulk, run the math on whether the carrying cost of the extra inventory actually beats the discount — often it doesn't, once storage and capital costs are included.
Segment your inventory by turnover speed. Not every SKU needs the same replenishment strategy. Fast movers can run closer to just-in-time; slow movers need tighter caps on how much you ever hold at once.
Review your DIO on a schedule, not just when cash feels tight. By the time cash flow feels like a problem, the inventory buildup usually started months earlier.
Common Mistakes When Calculating DIO
Using ending inventory instead of average inventory. A single snapshot — especially one taken right after a big restock or right before a seasonal sell-off — can swing your DIO by weeks in either direction. Averaging beginning and ending balances smooths that out. For businesses with sharp seasonal swings, an average of monthly (rather than annual) inventory balances gives an even more accurate read.
Using revenue instead of COGS in the denominator. Revenue includes markup; COGS doesn't. Dividing average inventory (which is carried at cost) by revenue instead of COGS understates DIO and makes your turnover look better than it actually is. This is the single most common error in DIY calculations.
Comparing DIO across dissimilar business models without adjusting. A company that manufactures its own products will naturally carry more inventory (raw materials, work-in-progress, and finished goods) than a retailer that only holds finished goods. If you're benchmarking against a competitor or an industry average, make sure you're comparing similar supply chain structures, not just similar industries.
Ignoring seasonality when trend-watching. A toy retailer's DIO in September looks nothing like its DIO in December, and that's by design — not a warning sign. Compare the same period year-over-year (this September vs. last September) rather than sequential months when your business has a seasonal pattern.
A Quick Comparison
Two hypothetical hardware stores illustrate why this metric matters more than it might seem at first glance. Store A carries $60,000 in average inventory against $360,000 in annual COGS — a DIO of about 61 days. Store B carries the same $60,000 in average inventory but only does $240,000 in annual COGS, giving it a DIO of about 91 days.
Both stores have identical inventory investment. But Store B has 30 extra days, on average, where that $60,000 is unavailable for anything else — an extra month of carrying costs, an extra month of exposure to the products going out of style or becoming obsolete, and an extra month before that cash can fund payroll, a new location, or simply sit as a buffer. Same balance sheet line item, meaningfully different risk.
Where This Connects to Your Books
Calculating DIO accurately depends on having clean, current numbers for both inventory value and cost of goods sold — which means your chart of accounts needs to track inventory as a real asset, not just an expense when purchased, and COGS needs to reflect what was actually sold in the period, not what was bought. Businesses that record inventory purchases straight to an expense account (skipping the asset step entirely) can't calculate DIO at all, because there's no inventory balance to average.
This is one of the areas where plain-text, version-controlled bookkeeping pays off: your inventory asset account and COGS account are both queryable data, not numbers buried in a proprietary dashboard. Beancount.io gives you plain-text accounting that's transparent and auditable, so pulling the two figures you need for a DIO calculation — or any custom metric — is a matter of querying your ledger, not exporting a report and hoping the categories line up. Get started for free and see your inventory and cash position with the same clarity you'd expect from a well-organized codebase.