The cash conversion cycle for inventory sellers, computed on real store numbers
The cash conversion cycle explained with a real store's numbers — DIO, DSO, DPO, the three levers that shorten it, and what payment terms actually buy.
InventoryX is in development and not available today. ClearStock is the live Shopify app.
Your cash conversion cycle (CCC) is the number of days between paying a supplier and getting paid by a customer — and for most inventory sellers it's the single number that decides whether growth feels exciting or suffocating. A store can be profitable on paper and still be broke every March because the cycle is 70 days long. This article computes one real store's cycle from its own numbers, follows the owner through the year she shortened it, and shows what each of the three levers is actually worth.
The formula, in plain terms
CCC = DIO + DSO − DPO
- DIO (days inventory outstanding): how long stock sits before selling. Inventory on hand ÷ COGS × 365.
- DSO (days sales outstanding): how long customers take to pay you. Receivables ÷ revenue × 365. Near zero for pure DTC card sales; real for wholesale.
- DPO (days payable outstanding): how long you take to pay suppliers. Payables ÷ COGS × 365.
Every day of DIO and DSO is a day your cash is out; every day of DPO is a day your supplier's cash is covering you. The gap between them is what you finance out of pocket.
One store's cycle, computed
Saffron & Ember is a spice-blend shop: 240 SKUs, about $1.1M revenue, $840K COGS, mostly DTC with a growing wholesale channel. In January, the owner's books showed inventory on hand of $180,000, receivables of $28,000, and payables of $55,000. (All figures illustrative, but the arithmetic is the point.)
- DIO = 180,000 ÷ 840,000 × 365 ≈ 78 days
- DSO = 28,000 ÷ 1,100,000 × 365 ≈ 9 days
- DPO = 55,000 ÷ 840,000 × 365 ≈ 24 days
- CCC = 78 + 9 − 24 = 63 days
Read that operationally: every dollar she spends on stock is out of her pocket for about nine weeks before customers hand it back. At $840K of annual COGS, that's roughly $840,000 ÷ 365 × 63 ≈ $145,000 of cash permanently tied up just running the cycle. That number — not profit — is why she couldn't afford the spring restock.
The year, as a timeline
January — the squeeze. Sales grew 30% last year, but the bank balance didn't. The January order to her main blender went on a credit card at a painful rate she declined to name. Diagnosis day: she computes the CCC above and puts the three numbers on a whiteboard.
February–April — attacking DIO first. DIO is usually the fattest lever, and hers was bloated by two things: 12 blends that hadn't sold in 90+ days (about $31,000 of the $180K) and over-ordering on bestsellers "while the discount was there." She clears the dead weight at a discount she'd rather not discuss, and rebuilds reordering around days of cover instead of gut — each SKU gets ordered when cover drops below lead time plus buffer (the method is the same one behind a days of cover calculation). Nothing clever: just ordering to demand instead of to discounts. By April, inventory is $142,000 → DIO ≈ 62 days.
May–July — attacking DPO. Her two biggest suppliers had her on 30/70 deposits: cash out before anything ships. She asks her best supplier — three years of clean orders, predictable volumes — for net 30 on replenishment orders. They counter with net 30 on orders above a minimum, which she meets anyway. Payables rise to $92,000 → DPO ≈ 40 days. The mechanics of what she asked for and how are the standard terms playbook (what net terms do to your math) — the point here is the DPO arithmetic: each day of terms on $840K of COGS is roughly $2,300 of permanent float. Moving from 24 to 40 days is ~$37,000 of cash she didn't have to find.
August–October — leaving DSO mostly alone. Wholesale receivables run 30–45 days, and she decides not to fight it — the channel is profitable and the buyers pay reliably. She tightens invoicing instead of terms: invoices go out same-day with the POD attached. DSO drifts from 9 to 8. Small lever, deliberately ignored.
October — the recomputed cycle. Inventory $138,000 (DIO ≈ 60), receivables $25,000 (DSO ≈ 8), payables $92,000 (DPO ≈ 40).
CCC = 60 + 8 − 40 = 28 days, down from 63. Cash permanently tied up: $840,000 ÷ 365 × 28 ≈ $64,000. Roughly $80,000 freed up without raising prices, dropping a supplier, or borrowing. That freed cash funded the Q4 spice-gift-set buy she'd have financed on a card the year before.
What each lever is worth — and what it costs
| Lever | Moves | Typical way to move it | The catch |
|---|---|---|---|
| DIO | Down = good | Order to cover, prune dead SKUs, smaller more frequent buys | Smaller buys can mean higher freight per unit and missed case-pack pricing — run the tradeoff, don't assume |
| DPO | Up = good | Negotiate net terms with your best suppliers | Suppliers price terms sometimes; and terms tempt over-ordering — the order size should come from demand math, not from the invoice due date |
| DSO | Down = good | Invoice same-day; require deposits from slow wholesale accounts | Chasing DSO to zero can cost you wholesale relationships; it's often the lever to leave alone |
Order matters more than most guides admit. DIO is the lever you control unilaterally — start there. DPO requires a supplier who trusts you, which you earn with clean order history. And financing (a facility, an advance, or a structured inventory funding option) doesn't shorten the cycle — it funds it. That's sometimes the right call for a confirmed big order, but it's a cost layered on top, not a fix. The cheapest financing remains the float your supplier gives you.
Two failure modes to watch
The growth trap. CCC stretches as you scale: more SKUs, deeper stock, new wholesale terms. A store whose cycle goes from 45 to 75 days while revenue doubles needs roughly proportionally more working capital — growth consumes cash before it produces it. Recompute the cycle quarterly; a rising CCC with flat sales is an early warning, not a rounding error.
The double-count trap. DIO uses COGS, not revenue. Using retail value inflates DIO and makes the cycle look worse than it is — and if your cost data is sloppy (half your variants missing a cost price), the whole calculation is fiction. The cost-per-item field in Shopify is the input that makes this computable (Shopify Help Center, cost-per-item documentation, accessed October 2026), and it feeds your carrying cost math the same way. Keep it current.
Common questions
What is a good cash conversion cycle for an ecommerce store? There's no universal benchmark worth citing — it varies enormously by category, supplier terms, and channel mix. The useful comparison is your own: compute it quarterly, and treat a rising trend as the signal. A store that shortens its own cycle by 20 days has freed real cash regardless of what any industry table says.
How do I calculate DIO from my Shopify data? Divide current inventory value (at cost) by annual COGS, multiply by 365. Shopify's inventory reports give the value and profit reports give COGS (Shopify Help Center, inventory and profit reports documentation, accessed October 2026) — but only if cost per item is filled in for every variant. Gaps in cost data show up directly as errors in your cycle.
Does net 30 from a supplier improve my cash conversion cycle? Yes — net terms raise DPO, and every day of DPO offsets a day of DIO and DSO. A store paying suppliers on delivery with a 60-day cycle and a store on net 60 with the same stock have very different cash needs; the second one's supplier is financing the entire inventory period.
Can financing fix a long cash conversion cycle? Financing doesn't shorten the cycle — it pays for it, at a cost that varies by provider and structure. It makes sense for confirmed demand (a big order in hand), less so for chronic cycle length. If your cycle is long because stock sits too long, fixing DIO is usually cheaper than funding it.
What's the fastest way to shorten the cycle? Usually pruning inventory that doesn't sell and reordering to actual demand rather than to discounts and gut feel. It requires no negotiation and no borrowing, and it attacks the component (DIO) that's typically the largest for a DTC store.
Where to go next
Compute your own three numbers this week: inventory value at cost, receivables, and payables — five minutes from your books. Then run DIO against your days of cover per SKU to find which stock is stretching the cycle. The 63-to-28 arc above took one store about nine months, and the first move — pruning and cover-based reordering — did most of the work by April.