Days on hand
What is an inventory days on hand calculator?
An inventory days on hand (DOH) calculator shows how many days your current stock would last at your average rate of sales, measured at cost. Also called days inventory outstanding (DIO) or days of supply, it divides average inventory value by daily cost of goods sold. Ecommerce brands, retailers, wholesalers, and manufacturers use it to spot excess stock tying up cash, set reorder targets, and report working capital efficiency to lenders, investors, and finance teams.
Days on hand
Avg inventory ÷ daily COGS
Embed this free calculator on your website—copy the snippet after signup and keep the Built with Calclet link for attribution (or upgrade to remove branding).

Days on hand formula
Divide annual cost of goods sold by 365 to get daily COGS, then divide average inventory by that daily figure. Inventory turns is the inverse view: how many times the inventory is sold and replaced in a year.
Days on hand = Average inventory value / (Annual COGS / 365); Inventory turns = Annual COGS / Average inventory value- Days on hand and turns are linked: DOH = 365 / Inventory turns.
- Average inventory = (Beginning inventory + Ending inventory) / 2, or better, the average of monthly ending balances.
- Both inventory and COGS must be at cost, on the same accounting basis, and over the same period.
Inputs explained
Pull both inputs from the same accounting system and period so the ratio reflects real stock coverage rather than valuation or timing differences.
- Average inventory value ($)
- The average value of inventory on hand at cost over the period, from your balance sheet, ERP, or inventory system such as Shopify, NetSuite, QuickBooks, or Cin7. Averaging twelve monthly balances smooths out seasonal peaks and incoming shipments better than a simple beginning-plus-ending average. Never use retail selling price, which inflates days on hand.
- Annual COGS ($)
- Cost of goods sold for the trailing twelve months from your income statement, including landed costs such as inbound freight and duties if your accounting includes them. For a fast-growing or seasonal business, annualize the most recent quarter or use forecast COGS so days on hand reflects your current sales pace.
Example days on hand calculation
An ecommerce business with $118,000 in average inventory and $920,000 in annual COGS burns about $2,520.55 of inventory per day ($920,000 / 365). Dividing $118,000 by $2,520.55 gives about 46.82 days on hand, equal to roughly 7.80 inventory turns a year. Cutting days on hand by 10 days at that sales pace would free up about $25,200 in working capital.
Put this calculator on your site
We'll copy this tool into your Calclet account—tweak branding and fields, then paste the embed on WordPress, Webflow, Shopify, or any HTML page. Every embed can link back to Calclet for discovery.
How to use the days on hand
- Input average inventory value ($) using beginning-and-ending inventory averages or monthly average balances from your accounting system.
- Enter annual COGS ($) from the same reporting basis and timeframe so inventory and COGS are comparable on valuation method.
- Review days on hand as average inventory divided by daily COGS to estimate how many days current stock can support demand at current burn.
- Use the annual inventory turns output to compare category efficiency and set reorder or markdown strategies for slow-moving SKUs.
Common days on hand mistakes
- Valuing inventory at retail price while COGS is at cost, which can roughly double the result.
- Using one month-end inventory snapshot taken right after a large shipment or before a busy season.
- Using trailing annual COGS for a business growing quickly, which understates daily sales and overstates days on hand.
- Reporting one blended number that hides dead stock in some SKUs and stockouts in others.
- Including obsolete or unsellable inventory that should be written down or liquidated.
- Mixing COGS definitions between periods, such as adding landed freight costs in one year but not the last.
- Treating lower days on hand as always better without checking fill rate and stockouts on top sellers.
Inventory coverage benchmark context
- DOH variability by product category
- Fast-turn consumables usually target lower days on hand than seasonal or long-lead durable goods, so benchmarking should be done by category, not blended totals.
- Turns vs service-level tradeoff
- Higher turns improve cash efficiency but can increase stockout risk when supplier lead times or forecast error are volatile.
- Finance interpretation of DOH
- CFO teams pair DOH with gross-margin return on inventory and cash-conversion-cycle metrics to evaluate whether inventory supports profitable growth.
FAQs
My days on hand is 47 days, but I keep stocking out of best sellers—how is that possible?
A blended number averages fast and slow SKUs together. Slow movers sitting at 150 days of supply can mask best sellers at 5 days, so the total looks healthy while top products run out. Calculate days on hand by SKU or category, then shift purchasing budget from overstocked items to fast movers instead of buying more inventory overall.
How much cash would I free up by reducing days on hand?
Multiply the days you cut by daily COGS. At $920,000 in annual COGS, daily COGS is about $2,520, so reducing days on hand from 47 to 37 releases roughly $25,200 in working capital. The cash shows up gradually as you buy less than you sell, so plan purchase orders and markdowns over one or two replenishment cycles.
What days on hand should I target based on supplier lead time and safety stock?
A practical starting point is supplier lead time plus safety stock days plus half your order cycle. With a 21-day lead time, 10 days of safety stock, and orders placed every 30 days, the target is about 21 + 10 + 15 = 46 days. Longer lead times, overseas shipping, or volatile demand justify a higher target; local suppliers and steady demand support a lower one.
My business is seasonal—why does days on hand look terrible before the holidays?
Pre-season stock is built ahead of demand, while trailing annual COGS reflects average sales, so days on hand spikes before the peak and drops afterward. For planning, divide current inventory by forecast COGS for the next 30 to 90 days instead of trailing annual COGS. That forward-looking days of supply shows whether you can actually sell through before the season ends.
We are growing 50% year over year—is trailing twelve-month COGS giving me the wrong days on hand?
Usually yes. Trailing COGS lags your current sales pace, so daily COGS looks too low and days on hand looks too high. Annualize the latest quarter's COGS or use next quarter's forecast instead. If sales doubled steadily over the past year, trailing data can overstate days on hand by about a third.
How do I calculate days on hand for a single SKU using units instead of dollars?
Divide units on hand by average daily units sold. If you have 600 units and sell about 20 per day over the last 30 or 90 days, you have 30 days of supply. Unit-based days on hand is the better tool for reorder decisions, while the dollar version in this calculator is better for working capital and financial reporting.
My lender asked for DIO for the cash conversion cycle—is that the same as days on hand?
Yes. Days inventory outstanding uses the same formula: average inventory divided by daily COGS. The cash conversion cycle adds days sales outstanding (how long customers take to pay) and subtracts days payable outstanding (how long you take to pay suppliers). Lowering DIO, collecting faster, or negotiating longer supplier terms all shorten the cycle and reduce borrowing needs.
How do I find dead stock dragging up my days on hand, and what should I do with it?
Run an inventory aging report and flag SKUs with no sales in 90 to 180 days or more than a year of supply on hand. Calculate days on hand with and without those items to see how much they inflate the total. Options include bundling, markdowns, liquidation, returning to the supplier, or writing them down so financial statements reflect their real value.
Should I use inventory value at cost or retail price in this calculator?
Always use cost, because COGS is measured at cost. Entering retail value with a 50% gross margin roughly doubles days on hand, making stock look far slower than it is. If your system reports retail value, convert it using your cost-to-retail ratio or pull the inventory valuation report from accounting.
How much is excess inventory actually costing me each year?
Inventory carrying costs, including storage, insurance, shrinkage, obsolescence, and the cost of capital, are often estimated at roughly 20% to 30% of inventory value per year. At $118,000 in average inventory and a 25% carrying cost, that is about $29,500 annually. Each dollar of excess inventory you remove saves that carrying cost, as long as fill rates on best sellers hold up.
Related calculators
Related guides
Step-by-step articles on building, embedding, and ranking calculator pages like this one.
Category: Inventory management & supply chain financeTopics: Days inventory on hand, Inventory turns, Working capital efficiency
Last reviewed: 2026-05-07
Reviewed by: Souhayb Kama Ldine