Most of what a brand keeps in a warehouse doesn't have a clock on it.
A t-shirt doesn't go bad. A phone case doesn't degrade sitting in a box.
Leave either one on a shelf for a year and the only thing you've lost is a season of relevance.
A bottle of supplements has a date printed on it that it dies on.
And the contract manufacturers who make it usually won't produce a small batch, so you're often holding a lot more of that clock-carrying product than you'd choose to if you could order freely.
No other category stacks those two pressures on the same shelf.
Which is why one specific number is worth checking twice here, when almost nobody checks it anywhere else.
A supplement brand we worked with was placing inventory orders every couple of months, because they never had much sitting in the warehouse.
Their lead time ran 80 to 90 days, tight enough that a late order was a real risk.
That's what the founders told us. Then we ran their days inventory on hand, and it came back at 240.
Nine months of stock, on paper, in a warehouse the founders had just described as close to empty.
We told them the number. They told us it couldn't be right.
They weren't wrong to be suspicious. They were just looking for the wrong kind of mistake.
Most founders treat days inventory on hand as a stocking dial. Too much sitting around, or too little to cover demand.
So their first instinct was to argue about the warehouse.
But the warehouse was telling the truth.
The number was broken because of what their books said each sale had cost them, and nobody had noticed that the same broken number was setting every other target in the business.
That's what this post is actually about.
The two things a days-inventory-on-hand number can be lying to you about instead, and how to tell which one is happening to you.
How to calculate days inventory on hand (and what it means)
Days inventory on hand answers one question: at your current sales pace, how many days would your inventory last if you stopped restocking today.
Take your average inventory value and divide it by your cost of goods sold per day. That's it.
Most founders learn one way to read the result.
⬆️A high number means too much cash tied up in stock, sitting there instead of working for you.
⬇️A low number means you're close to running out, and a stockout is coming if nothing changes.
Both readings are correct, as far as they go.
If your number looks off and your first move is to ask whether you're overstocked or understocked, you're not wrong to ask it.
It's the same instinct behind most standard supplement inventory management advice: watch your inventory turnover ratio, set a sensible reorder point, keep enough safety stock to survive a late shipment without a stockout.
All of that is real and worth doing.
None of it explains a number like 240 sitting next to an empty warehouse.
But, it can answer two more, and for a brand selling anything with an expiry date, those two matter just as much.
Check it against what's physically true
The stocking-dial read only works if you take the number at face value.
The move that catches everything else is cheap and takes five minutes: line it up against reality.
Three numbers should roughly agree with each other, and almost nobody puts them side by side.
- What days inventory on hand says you're holding
- What your lead time requires you to keep as a buffer
- What's actually sitting on the shelf
For the brand we worked with, the first number said 240 days.
The founders had just told us their warehouse was close to empty, and that their lead time was 80 to 90 days.
Two of those three numbers agreed with each other.
A near-empty warehouse and a short lead time tell the same story: this is a brand that runs lean and reorders constantly.
The third number, the 240, didn't belong in that story at all.
If your lead time is under 90 days and you're constantly placing new orders because stock keeps running low, and your days inventory on hand says you're sitting on the better part of a year of product, you have the exact same mismatch.
One of your three numbers is lying, and it isn't the one you can walk over and count.
Fork A: your product cost is understated
Here's the mechanism, and it's simple enough to check on your own books this afternoon.
Days inventory on hand climbs artificially high when too little cost gets deducted per unit sold.
Every sale should reduce your inventory value by what that unit actually cost you.
If the number your accounting deducts is too small, the books think you're still holding stock you've already shipped out the door.
The inventory value on paper barely moves. Sales keep happening.
The gap between "what the books say we have" and "what's actually on the shelf" gets wider every month, and days inventory on hand is exactly where that gap shows up.
Which means your unit cost is wrong. Not by a rounding error, by enough to matter.
And your unit cost isn't a number that stays contained to an accounting tab.
It's the number every CAC target, every pricing decision, every LTV model in your business gets built on top of.
If it's too low, everything built on it is too optimistic, including the number you think you can afford to pay to acquire a customer.
That's the exact mechanism behind the CAC ceiling we walk through in What's a Good CAC for Supplement Companies.
This is the part of the story that happens before that math ever gets run: the ceiling was never going to be right, because the cost feeding it wasn't right first.
Fork B: you're closer to a write-off than you think
Say the cost accounting checks out clean.
The number every sale deducts genuinely matches what each unit cost you.
Then 240 days isn't a bookkeeping error. It's real, and it's a different kind of problem.
Run the math a supplement operator actually needs.
On its own, 240 days against an 18-month shelf life isn't automatically a crisis.
Stack it against an 80 to 90 day lead time and a contract manufacturer's minimum order quantity, and the room to fix it shrinks fast.
You can't just stop ordering.
The MOQ won't let you order small enough to work the number down quickly.
Every day that passes is a day closer to the date printed on product still sitting in the warehouse.
This is also where lot tracking earns its keep.
If you're recording batch or lot numbers at receiving and rotating stock first-expired-first-out rather than first-in-first-out, you can see exactly which units are closest to their date instead of guessing from an average.
A lot of supplement brands run FIFO out of habit, inherited from categories where shelf life isn't a factor, and it's the wrong default here.
A quarterly cycle count against your lot data will tell you faster than any dashboard whether this fork is actually the one you're in.
Same symptom as Fork A. Completely different business to be in.
Why blended channel accounting makes both forks invisible
For the brand in this story, one decision made things worse: their Amazon and Shopify cost-of-goods lines were blended into a single number.
That erases per-channel profitability entirely.
You can't tell if the understated cost problem is worse on one channel than the other.
You can't isolate which channel's inventory is actually closest to expiry.
The two channels run on different fee structures and different fulfillment timelines, but the accounting can't see them as two different businesses, because they were never recorded as two different businesses.
This is usually where a founder starts shopping for inventory management software, hoping a system will fix what's actually a setup problem.
A tool can absolutely help once your COGS is split correctly by channel and your SKUs are tracked at the lot level.
It won't fix a blended cost line on its own, and buying one before that split exists just gives the same bad number a nicer dashboard to sit on.
There's a fast check for whether your own accounting has this problem, and it doesn't require touching inventory at all.
Your product cost ratio is COGS as a percentage of revenue. Discounts and promos shouldn't move it.
Neither should a slow month or a fast one. It should only shift when pricing or supplier cost actually changes.
If it's jumping around month to month, or if you can't even calculate it separately for each channel you sell on, that's the fastest tell that the accounting underneath your days-inventory-on-hand number can't be trusted either.
The checks to run this week
- Pull your days inventory on hand and your average lead time side by side. If DIO is running several multiples of lead time, and you're still reordering constantly, that's the mismatch worth chasing.
- Check whether your COGS is broken out per channel. If Amazon and Shopify are blended, fix that before trusting anything else in this list.
- Check your product cost ratio over the last six months. Stable and correctly priced, keep going. Jumping around, your unit cost is probably feeding a bad number into everything downstream.
- If the cost checks out clean, run the expiry math directly. Current stock, shelf life remaining, lead time, and MOQ, together, not one at a time. That combination is the real risk. Any single number in isolation understates it.
- Act on whichever fork you're in. An understated cost means revisiting your CAC ceiling before you spend another dollar against it. A real expiry exposure means a conversation with your contract manufacturer about order sizing, before your next MOQ commitment locks you in again.
- Only then, look at demand forecasting. Once the cost and expiry pictures are both clean, a real forecast, built off your actual reorder points and sales velocity per SKU, is what keeps this from recurring. Skipping straight to a forecasting tool before fixing the accounting underneath it just automates the same mistake.
Putting it together
A days-inventory-on-hand number that doesn't match the warehouse floor is never neutral in this category.
It's either your cost accounting setting every other number in the business too high without anyone noticing, or a shelf-life clock that's closer to a write-off than the raw number lets on.
Either way, the fix starts with the same three-way check: what the formula says, what the lead time requires, and what's actually on the shelf.
If you'd rather see this on your own numbers
The three-way check above takes an afternoon and access to your own inventory and order data.
If you run it and everything lines up, that's a real answer, and a good one.
If you'd rather have someone run the full picture, including the per-channel cost split, the product cost ratio, and the expiry-versus-MOQ exposure once a fork is confirmed, that's what the Growth Cash Dash does.
We take your historical numbers, run them through 30+ ecommerce finance KPIs, and come back with the ones that are telling a story your dashboard isn't.
Sometimes it confirms your inventory accounting is clean.
Sometimes it finds a cost number that's been setting every target in the business too high, or a write-off with a date already on the calendar.
Either way, you'll know which one you're looking at.
.jpg)
