Inventory days on hand: Formula + reseller examples (2026)

Inventory days on hand (DOH), also called days inventory outstanding (DIO) or days sales of inventory (DSI), is the average number of days you hold inventory before it sells. It estimates how long your stock lasts at your recent sales pace.

We’ll work through both formulas, a reseller example, and ways to choose a useful target, then cover how to move slow inventory at a price that still leaves you a profit.

TL;DR

• Inventory days on hand = (average inventory cost ÷ COGS) × days in the period.
• You get the same result by dividing the days in the period by inventory turnover for that period.
• Use inventory costs instead of listing prices, and include stock you own for resale even if you haven’t listed it yet.
• Set your target from your own category, margins, seasonality, and replenishment needs, and treat large-company figures as a starting check.
• Repricing, bundling, relisting, and crosslisting help stock sell, and DOH drops once those sales come through.

What is inventory days on hand?

DOH compares the cost of the stock you held with the cost of the goods you sold, then converts that comparison into days. A result of 150 means your average inventory equaled 150 days of COGS at that period’s selling pace.

A higher DOH means you carried more inventory relative to sales. The figure is an average across all your stock, so some items will be far older or newer than the result.

Compare your DOH with businesses that buy and sell the way you do. A grocer restocks perishables within days, and a vintage dealer can hold a one-off jacket for months, so their ratios differ even when both businesses run well.

Use DOH alongside sell-through rate, which counts units. DOH uses inventory costs, so a $40 coat adds more to your inventory balance than five $4 tees, even though the tees take up more lines on your stock list.

How to calculate inventory days on hand

The two formulas below give the same answer when you use the same inventory costs, COGS, and time period. Rice University’s free OpenStax accounting textbook sets out how inventory turnover and inventory days connect.

Average inventory method

Add your beginning and ending inventory costs and halve the total to get your average inventory cost. Then divide by COGS and multiply by the days in the period:

Inventory days on hand = [(Beginning inventory cost + Ending inventory cost) ÷ 2] ÷ COGS × Days in the period

In plain terms, you’re dividing your average inventory cost by the cost of the goods you sell per day (COGS ÷ days). If you sell $20 of inventory cost a day and hold $3,000 of stock on average, you’re carrying 150 days of inventory.

Here’s what each variable means.

• Beginning inventory cost: The recorded cost of resale stock you own at the start of the period. Include unlisted goods and stock stored elsewhere, and count an item listed on several marketplaces once.
• Ending inventory cost: The recorded cost of resale stock you still own at the end of the period. Leave out sold goods and personal belongings that aren’t part of the business.
• Cost of goods sold (COGS): The inventory cost assigned to items sold during the period. If a blazer cost $6 and sells for $48, it adds $6 to COGS, and the $48 counts as sales revenue.
• Days in the period: The number of days your inventory balances and COGS cover. The section on time periods below explains which count to use.

Acquisition costs belong in these figures too. The IRS lists freight-in among the inputs to COGS in Publication 334.

Use the same costing method for your inventory balances and COGS. If you use purchase prices in one figure and a broader cost basis that includes freight in another, your DOH will be off.

Our reseller bookkeeping guide covers keeping a consistent cost log. Record inventory costs separately from selling expenses such as fees and shipping labels, so you can calculate DOH and profit without mixing the two.

Inventory turnover method

Inventory turnover is the number of times you sell the cost value of your average inventory during a period. Annual turnover of 4 means your COGS for the year was four times your average inventory cost, so you sold through your average stock about once a quarter.

This method calculates turnover first, then divides the days in the period by that turnover:

Inventory turnover = COGS ÷ Average inventory cost

Inventory days on hand = Days in the period ÷ Inventory turnover

With annual turnover of 4, DOH is 365 ÷ 4 = 91.25 days. If you calculated turnover for a quarter, divide that quarter’s day count, such as 90, by the turnover figure instead of 365.

Which time period should you use?

Both formulas need a day count. Use 365 for a standard year and 90 for a standardized quarter. For a calendar period, use its actual day count: January to March has 90 days (91 in a leap year), and July to September has 92.

Your beginning inventory cost, ending inventory cost, and COGS must all cover the period you’ve chosen.

We’d start most resellers on a quarterly review. Compare seasonal categories with the same quarter last year as well as the previous quarter, because a winter coat business and a year-round basics shop sell on different calendars.

Beginning and ending balances give a simple average. If you buy in large batches or your stock levels swing during the period, average your monthly or weekly balances instead. With only two snapshots, you can miss a large haul that arrived and sold between them.

If COGS is zero, you can’t divide by it. Record N/A, then check whether you had no sales or are missing cost records.

If you use ending inventory instead of average inventory, label that version clearly and keep it out of comparisons with average-based results.

Inventory days on hand example for a reseller

Suppose you resell secondhand clothing and home goods. For one 90-day quarter, your records show these illustrative figures:

• Beginning inventory cost: $3,200
• Ending inventory cost: $2,800
• COGS for the quarter: $1,800
• Days in the quarter: 90

Using the average inventory method

Work out your average inventory cost, then put it into the DOH formula:

Average inventory cost = ($3,200 + $2,800) ÷ 2 = $3,000

Inventory days on hand = ($3,000 ÷ $1,800) × 90 = 150 days

Your average inventory equaled 150 days of COGS at this quarter’s selling pace. In daily terms, you sold $20 of inventory cost per day ($1,800 ÷ 90) and held $3,000 of stock on average.

Using the turnover method

Divide COGS by average inventory cost to get turnover, then divide the 90 days by it:

Inventory turnover = $1,800 ÷ $3,000 = 0.6 turns

Inventory days on hand = 90 ÷ 0.6 = 150 days

Both methods give 150 days because they use the same costs and period. Use the first when you have inventory balances and COGS, and the second when you already track turnover.

Break your DOH down by category

If you split the same quarter’s figures by category, you’ll see where your inventory costs are concentrated. Each row uses the same 90 days:

Home goods round from 187.5 to 188 days. Calculate total DOH from total average inventory cost and total COGS, as in the bottom row. A simple average of the four category results comes to about 203 days and overstates your actual 150.

Outerwear holds 40% of average inventory cost but accounts for about 13% of COGS. Use its 450-day result as your cue to review outerwear pricing, demand, and future buying.

The 450 days is a category average, so some coats may have sold within weeks while others have been in storage for over a year.

We’d check category results like these before running a shop-wide sale. Marking down women’s tops at 75 days cuts margin on stock that already sells.

Nifty’s inventory labels let you group listings by category or source. Nifty doesn’t calculate COGS, so you pair those groups with your own cost records to work out each category’s DOH.

Inventory days on hand vs average days to sell

Average days to sell is the mean time between listing an item and selling it. If three items sell after 10, 20, and 30 days, their average is 20 days.

That average covers sold items only. Stock that hasn’t sold, and the weeks an item spent unlisted before you photographed it, never enter the calculation.

DOH divides the cost of everything you held by the cost of what you sold. A rack of unsold coats raises your DOH, even though none of those coats appear in your days-to-sell average.

Use days to sell for decisions about individual listings. Use DOH to judge whether you’ve put more cash into a category than its sales justify.

What is a good inventory days on hand?

There’s no universal good DOH, but public filings give apparel sellers a reference point. In their FY2024 10-K filings, eight US-listed apparel companies carried between 72 and 179 days of inventory, with a median of about 110 days.

American Eagle Outfitters had the lowest figure, and Coach owner Tapestry had the highest. Each figure is annual COGS divided by average inventory, converted to days.

Those companies import on long lead times and restock by the container. A reseller buying one-off pieces can’t reorder a sold item, so use that range as a starting check for your own number.

Your target depends on your margin, storage costs, and how easily you can replace sold stock. Use these factors to set a target for each type of inventory:

Choose a category your own sales history supports, then test whether it keeps enough stock available without locking up more cash than you can afford. A collector’s shop and a replenishable basics business need very different targets.

How to judge your inventory days on hand

• Compare like periods: If DOH rises, check whether average inventory increased, COGS fell, or both. From the ratio alone, you can’t tell whether the cause was weak demand, a planned stock build, or a change in the items you sell.
• Weigh profit as well as speed: Discounting helps inventory sell, but it leaves less money after fees and shipping. Before chasing a lower DOH, use our profit margin guide to check what you’ll keep.
• Plan for seasonal stock: A higher figure before your main selling season can be intentional. Review it against your buying plan and the same season in earlier years before you treat it as a problem.
• Track item age separately: A 60-day listing review suits many categories, but item age and DOH measure different things. Some items deserve more time, and others need action sooner because of expiry, fashion changes, or storage costs.

Inventory days on hand vs inventory turnover vs DSI

Inventory turnover counts how many times average inventory sells through in a period, and DOH converts the same relationship into days. DSI and DIO are other names for the days measure, though some sources use ending inventory in place of average inventory.

For the same period and inventory basis, higher turnover means lower DOH. Annual turnover of 6 gives 365 ÷ 6, or about 61 days. Compare it only with other annual figures, because quarterly turnover of 6 works out to 15 days.

Check the inputs before comparing published ratios. A result based on ending inventory can differ sharply from one based on average inventory if stock levels changed during the period.

Historical DOH vs forward inventory cover

Historical DOH measures a period that has ended, using the inventory you held and the goods you sold. Forward inventory cover estimates how long the stock you hold today will last at your expected selling pace.

To see how long today’s stock would last in the reseller example, divide ending stock of $2,800 by daily COGS of $20. That gives 140 days of cost-based cover, assuming your sales mix and pace stay the same.

The 140 days differs from the 150-day DOH because it uses ending stock instead of the quarter’s average inventory.

For a repeatable product, operations teams usually calculate cover in units:

Forward cover (days) = Current units on hand ÷ Expected units sold per day

If you hold 100 plain white tees and expect to sell five a day, you have 20 days of cover. Place your next order before that, leaving time for your supplier’s delivery.

Use cost-based cover for a mixed inventory and unit-based cover for a repeatable SKU. Neither accounts for a change in demand unless you build it into your forecast.

6 ways to lower your inventory days on hand as a reseller

Start with slow stock you can act on, then adjust future buying. Review DOH alongside sales and margin, because the ratio only improves once sales, stock levels, or COGS change.

Use each category review to guide sourcing. If one category keeps a high DOH through comparable seasons and earns little margin, cut its buying budget and move that money into categories your own sales records support.

1. Find your stale listings first

Review your oldest unsold items, including goods you haven’t listed. Check acquisition dates where you have them, because a relisted item gets a fresh listing date even when the same physical stock has been in storage for months.

Our reseller inventory guide covers stock records and storage routines. If eBay is your main marketplace, our guide to eBay inventory management covers tools and workflows for that setup.

2. Reprice your oldest stock

Compare slow items with recent sold comps before changing the price. Buyers also skip listings with poor photos or missing measurements, so fix those first. Our reseller pricing guide helps you weigh the full cost of a discount.

Set a minimum acceptable return for each item before using automatic reductions. If you sell an item at a loss to free up shelf space, record it as a clearance decision, since the lower inventory balance adds nothing to your profit.

3. Send offers to likers and watchers

A like or watch shows interest, which makes it a good moment to test an offer. Plenty of likers still won’t buy. With Nifty’s automatic offers, you choose the discount rules, and follow-up waterfall offers are available on Poshmark, Mercari, and Depop.

Follow-up waterfall discounts apply to the previous offer price. A 10% initial discount on $100 gives $90, and another 10% gives $81, compared with $80 for a flat 20% discount. Check the whole sequence against your costs using our Poshmark offer guide.

4. Bundle slow items with fast ones

Offer a useful combination, such as jeans with a belt, instead of adding an unwanted item just to clear it. Check the combined parcel weight and your margin before discounting, since Poshmark’s flat-rate label covers bundles up to 5 lb.

Our Poshmark bundling guide explains the marketplace’s bundle and offer process.

5. Relist what’s gone quiet

Update stale photos, item details, and pricing before relisting. Nifty’s automatic relists recreate eligible listings and apply the price adjustment you choose. Relisting alone doesn’t remove stock from your inventory or lower its recorded cost.

Match the relisting schedule to the marketplace. Nifty’s Poshmark relisting docs set a 30-day minimum cycle and recommend 60 days, because Poshmark only moves a relisted item into Just In once the original is at least 60 days old.

6. List on more marketplaces

When you crosslist, buyers on other marketplaces see the same stock. Use photos and descriptions that fit each platform’s requirements, and choose marketplaces where that type of item is eligible to sell.

You can bulk crosslist selected items to cut repeat listing work. Count each physical item once in your inventory costs, however many listings it has, and keep its availability accurate when it sells.

We’d crosslist your highest-DOH category first, because that’s where most of your cash is tied up.

Sell more with Nifty

A lower inventory days on hand starts with getting your oldest stock in front of more buyers at the right price. Nifty, a crosslisting and automation tool, lets you manage and crosslist inventory across multiple marketplaces from one interface.

Here’s why sellers and resellers trust Nifty:

• Customized AI listings: Upload photos and let Nifty generate search-optimized titles, descriptions, and item details. Review the draft, then use custom instructions to shape its writing style.
• Crosslist now: List eligible items across eBay, Etsy, Poshmark, Whatnot, Mercari, and Depop from one interface instead of re-entering the details on each marketplace. Marketplace access and features depend on your connected accounts and plan.
• Bulk crosslisting: Select multiple existing listings in Nifty, choose your target marketplaces, pricing, and shipping, then save the AI-generated results as drafts or publish them.
• Marketplace-specific Pricing Rules: Set a primary marketplace and rules for how prices should change on other marketplaces, so you don’t have to calculate every crosslisted price from scratch.
• Built-in auto-delisting: Enable auto-delisting and Nifty can remove an eligible sold item from your other connected marketplaces, so you don’t risk selling the same item twice.
• Bulk tools = less busywork: Relist selected items in batches, schedule ready-to-publish drafts, and use supported automations to handle recurring selling tasks.
• Analytics and profits, made clearer: Track sales, fees, profit, and your top-selling brands and categories. You can also set seller goals and check your progress from Nifty’s home screen.

Start with a 7-day free trial and track how your DOH changes once your slow stock is listed everywhere. Sell a few slow pieces you’d otherwise have marked down, and Nifty pays for itself.

If you’re in Australia or the UK and selling on eBay, Etsy, Whatnot, and/or Depop, Nifty’s now available.

FAQs

1. What are ideal inventory days?

Ideal inventory days depend on your category, margins, seasonality, and replenishment needs. Large US apparel companies carried a median of about 110 days in FY2024, and a reseller’s target should come from comparable periods in their own records.

Aim for enough stock to meet demand without tying up more cash or storage than you can afford.

2. What’s the difference between inventory turnover and days on hand?

The difference between inventory turnover and days on hand is the unit. Turnover counts how many times average inventory sells through in a period, and days on hand converts that relationship into days.

Divide the days in the period by turnover to switch between them, using the same inventory and COGS basis for both. Annual turnover of 4 equals 91.25 days on hand.

3. Is a lower inventory days on hand always better?

A lower inventory days on hand isn’t always better, because a low result can come from running short of stock or from discounts that cut your profit.

Check availability, margin, and seasonal needs alongside DOH, and aim for a level your business can sustain through a full year.

4. How do I calculate inventory days on hand in a spreadsheet?

To calculate inventory days on hand in a spreadsheet, put beginning inventory cost in B2, ending inventory cost in C2, COGS in D2, and period days in E2. Then use this formula:

=IF(D2=0,"N/A",AVERAGE(B2:C2)/D2*E2)

Enter 365 for a standard year or 90 for a 90-day quarter. Keep inventory values and COGS on the same cost basis.

5. Should I count items I haven’t listed yet?

Yes, you should count items you haven’t listed yet if you own them and intend to sell them. Include their recorded cost in beginning or ending inventory, even if they’re unphotographed or in storage.

Leave out personal belongings and consigned goods that belong to someone else.