The cash conversion cycle for inventory: how many days your cash is gone, worked line by line
The cash conversion cycle estimates how long operating cash is tied up between paying suppliers and collecting from sales. For an ecommerce brand that pays deposits up front and waits on payouts, it can be longer than the textbook version suggests. This post works it for an invented brand from an invented P&L and balance sheet, then prices each lever in days and dollars. Every number in the example is invented so the arithmetic can be checked.
- CCC = DIO + DSO − DPO. Days stock sits, plus days you wait to be paid, minus the days your supplier waits for you.
- Supplier prepayments extend the cycle before the stock arrives. Textbook DPO does not capture them. If you pay before the stock reaches you, the supplier is not financing you; you are financing them, and those days add to the cycle.
- In the worked example the textbook formula gives 79.8 days. Counting the 30% deposit and the stock paid for while at sea gives an adjusted cycle of 128.3 days, with $333,123 of working capital tied up across prepayments, inventory and receivables.
- Price each lever in days, then dollars: a day of DIO, DPO or pre-receipt time is worth a day of COGS, a day of DSO is worth a day of revenue.
- The average hides SKUs. One slow SKU here is 6.7% of COGS and 21.9% of the inventory cash.
Profit says whether a sale made money. The cash conversion cycle says how long the money was away while it did. A profitable brand can still run short of cash when each dollar of stock leaves weeks before the stock arrives and comes back in payout batches after it sells.
Step 1 — The formula and the inputs
CCC = DIO + DSO − DPO
In words: the cash conversion cycle is days inventory outstanding (how long stock sits before it sells), plus days sales outstanding (how long after a sale the cash lands), minus days payables outstanding (how long after receiving stock you pay for it). Each term turns a balance into days:
- DIO = average inventory ÷ COGS × days in period
- DSO = average receivables ÷ revenue × days in period
- DPO = average payables ÷ COGS × days in period
Two things about the inputs. The balances are period averages and the flows (COGS, revenue) are period totals, so the result belongs to the period you chose. A year, a quarter and a peak month give different answers for the same business; Step 5 shows how different. And an average of two points (opening and closing balance) can miss a build-up in the middle; the average of 13 month-end balances (the opening balance plus the 12 month-ends) follows the year more closely.
Worked example (invented brand, invented figures)
An invented brand sells kitchen products through its own store and one marketplace. Over a 365-day year:
| Input | Figure | Per day (÷ 365) |
|---|---|---|
| Revenue | $1,800,000 | $4,931.51 |
| COGS (product cost of units sold) | $900,000 | $2,465.75 |
| Average inventory on hand, at cost | $180,000 | |
| Average receivables (sold, not yet paid out) | $33,534 | |
| Supplier terms | 30% deposit with the PO, 70% on shipment | |
| Production time, then transit time | 45 days, then 35 days |
The example assumes the brand buys at a steady pace, so purchases over the year equal COGS. A growing or seasonal brand buys ahead of COGS; Step 5 covers what that changes.
Step 2 — Each term, for an ecommerce operator
DIO: how long stock sits in your warehouse or 3PL
DIO = $180,000 ÷ $900,000 × 365 = 73.0 days
Use inventory at cost, to match COGS. Here DIO counts stock from the day it is received until it sells; stock still at sea is handled in the pre-receipt adjustment below, so it is not counted twice. The details of the days-on-hand calculation, including which inventory value to use, are in the days of inventory on hand formula. If you think in inventory turnover instead, DIO is 365 divided by turns: 73.0 days is 5.0 turns.
Where the 73 days come from, in this example: the brand orders every 90 days and holds 28 days of safety stock. One simple estimate of average on-hand stock is safety stock plus half an order cycle, 28 + 90 ÷ 2 = 73 days. It assumes even sales and each order landing as the last one runs down to the safety level.
DSO: the marketplace payout schedule and the processor delay
A shopper pays at checkout, but the money is not the brand’s to spend until it lands in the bank. For an ecommerce brand that delay is set by payout schedules, not invoice terms. In the example, 60% of revenue goes through a marketplace that pays out every 14 days and holds each payout 3 more days; 40% goes through the brand’s own store, whose payment processor deposits 2 days after the sale.
With sales spread evenly, a marketplace sale waits on average half the 14-day cycle, 7 days, plus the 3-day hold: 10 days. An own-store sale waits 2.
DSO = 0.6 × 10 + 0.4 × 2 = 6.0 + 0.8 = 6.8 days
Check against the balance sheet: average receivables of $33,534 ÷ $1,800,000 × 365 = 6.8 days. If your payout schedule says one thing and your balance sheet another, look for reserves or holdbacks the marketplace keeps against returns; those sit in receivables and lengthen DSO.
Supplier prepayments: the days before receipt that DPO misses
The textbook DPO divides payables by COGS. This brand owes its supplier nothing after the stock arrives, because the full price is paid before it does. Its supplier payables are $0, so the textbook DPO is 0 and the textbook cycle is:
textbook CCC = 73.0 + 6.8 − 0 = 79.8 days
That leaves out the cash already paid for stock the brand does not have yet. Measure each payment against the day the stock is received (day 80, after 45 days of production and 35 of transit):
- The 30% deposit leaves on day 0, which is 80 days before receipt: 0.3 × −80 = −24.0
- The 70% balance leaves on shipment, day 45, which is 35 days before receipt: 0.7 × −35 = −24.5
weighted payment timing = −24.0 + −24.5 = −48.5 days, so prepayments add 48.5 days before receipt
Textbook DPO stays at 0. The 48.5 days are a separate adjustment that extends the cycle back to the day cash first leaves for stock the brand does not have yet. The same figure comes out of the balance sheet. At a steady purchase pace of $2,465.75 a day, the deposits waiting on production average 0.3 × 45 days × $2,465.75 = $33,288, and stock paid for and at sea averages 1.0 × 35 days × $2,465.75 = $86,301. Together that is $119,589, which is 48.5 days of COGS. If your books carry deposits as a prepayment and in-transit stock as inventory, those are the balances to look for.
The full cycle
adjusted cycle = DIO + DSO − DPO + pre-receipt days = 73.0 + 6.8 − 0 + 48.5 = 128.3 days
| Where the cash is | Days | Average balance |
|---|---|---|
| Paid to the supplier, stock not yet received (deposits + at sea) | 48.5 | $119,589 |
| On the shelf, at cost | 73.0 | $180,000 |
| Sold, waiting on payouts (at sales value) | 6.8 | $33,534 |
| Total | 128.3 | $333,123 |
For this brand the textbook number understates the cycle by 48.5 days. Balances are rounded to the dollar and days to one decimal; the total is the sum of the unrounded balances. The receivables row is at sales value and the other two are at cost, so read the $333,123 as working capital tied up across prepayments, inventory and receivables (how much is out of the bank), not as one kind of balance or as 128.3 days of a single daily figure.
If you pay before the stock reaches you, your supplier is not financing your inventory. You are financing theirs.
Step 3 — The levers, priced in days and dollars
To turn days into dollars, use the flow the term is measured against. A day of DIO, DPO or pre-receipt time is a day of COGS, $2,465.75 here. A day of DSO is a day of revenue, $4,931.51. Each lever below is changed on its own, with everything else held at the Step 2 figures.
Lever 1: smaller, more frequent purchase orders
Ordering every 45 days instead of 90 halves the order, from $221,918 to $110,959 at cost. Using the same safety-plus-half-cycle estimate, average on-hand stock falls from 73 days to 28 + 45 ÷ 2 = 50.5 days.
22.5 days × $2,465.75 = $55,479 freed
The deposit and in-transit days do not change: they depend on production and transit time, not order size. What can change is the price. A smaller order may fall under the supplier’s minimum, carry a higher unit price, or round up to full cartons (see case-pack rounding). The $55,479 is a one-time release of working capital; what it is worth each year depends on your cost of cash. Put a value on the freed cash with your own cost of cash. At an invented 12% a year:
$55,479 × 12% = $6,658 a year
If the smaller order raises the unit price by 2% (invented), that costs 2% × $900,000 = $18,000 a year, more than the cash is worth. The break-even is $6,658 ÷ $900,000 = 0.74% of COGS, before any extra per-order freight or receiving cost. A decision rule: take the smaller order if the freed cash times your cost of cash beats the added annual cost. The same trade-off, with ordering cost in place of price, is the idea behind economic order quantity.
Lever 2: supplier terms
Two invented negotiations, each priced against the 48.5 pre-receipt days (weighted timing −48.5):
- Balance due 30 days after shipment instead of on shipment. The 70% now leaves 5 days before receipt: 0.3 × −80 + 0.7 × −5 = −24.0 − 3.5 = −27.5 days. That is 21.0 days shorter: 21.0 × $2,465.75 = $51,781 freed.
- Deposit cut from 30% to 20%, balance still on shipment: 0.2 × −80 + 0.8 × −35 = −16.0 − 28.0 = −44.0 days. That is 4.5 days shorter: $11,096 freed.
Here, moving the large payment is worth more than shrinking the small one. Your terms may rank the other way.
Lever 3: lead time and the cash at sea
Because the 70% is paid at shipment, every day at sea is a day of COGS paid for and not yet sellable. Cut transit from 35 to 25 days and the weighted payment timing moves from −48.5 to 0.3 × −70 + 0.7 × −25 = −38.5 days:
10 days × $2,465.75 = $24,658 freed
It works in reverse: a lane that adds 10 days ties up another $24,658. A shorter, steadier lead time can also let you hold less safety stock, which would shorten DIO as well; recalculate that with your own lead time and reorder point rather than assuming it. If your terms were payment on arrival, transit days would sit in the supplier’s cash, not yours.
Clearing slow stock is the fourth lever, priced SKU by SKU in Step 4. DSO is set by the channel more than by you; if a channel offers a faster payout for a fee, price the fee against $4,931.51 a day.
| Lever (one at a time) | Days off the cycle | Cash freed |
|---|---|---|
| Order every 45 days instead of 90 | 22.5 | $55,479 |
| 70% due 30 days after shipment | 21.0 | $51,781 |
| Deposit 20% instead of 30% | 4.5 | $11,096 |
| Transit 25 days instead of 35 | 10.0 | $24,658 |
| Clear the slow SKU to 90 days (Step 4) | 10.0 | $19,764 cash ($24,705 of stock at cost, sold at 80%) |
Do not add the rows: a shorter transit and a later balance payment both move the 70%, so together they are worth less than the sum.
Step 4 — The SKU-level view the average hides
Worked example (four invented SKUs)
The brand’s 73.0 days of DIO is an average over four SKUs:
| SKU | COGS a year | Avg inventory | DIO | Share of COGS | Share of inventory |
|---|---|---|---|---|---|
| A | $420,000 | $57,500 | 50.0 | 46.7% | 31.9% |
| B | $300,000 | $49,000 | 59.6 | 33.3% | 27.2% |
| C | $120,000 | $34,000 | 103.4 | 13.3% | 18.9% |
| D | $60,000 | $39,500 | 240.3 | 6.7% | 21.9% |
| Brand | $900,000 | $180,000 | 73.0 | 100% | 100% |
(Each DIO is avg inventory ÷ COGS × 365, rounded to one decimal. SKU D: $39,500 ÷ $60,000 × 365 = 240.3.)
Without SKU D, the other three average $140,500 ÷ $840,000 × 365 = 61.1 days. One SKU adds about 12 days to the brand’s figure. Run the same terms per SKU and D’s own cycle is 240.3 + 6.8 + 48.5 = 295.6 days, against 50.0 + 6.8 + 48.5 = 105.3 for SKU A. (That applies the brand’s payout and supplier days to every SKU, which is an assumption; if D comes from a different supplier, use its terms.)
Pricing the clearance
Bring SKU D down to 90 days of its own COGS: 90 ÷ 365 × $60,000 = $14,795. That removes $39,500 − $14,795 = $24,705 of stock at cost. Suppose a markdown sells it for cash equal to 80% of cost (invented):
- Cash recovered: 0.8 × $24,705 = $19,764
- Loss against cost: $24,705 − $19,764 = $4,941
- Brand DIO afterwards: ($180,000 − $24,705) ÷ $900,000 × 365 = 63.0 days, 10.0 days shorter
The 90-day target is an invented choice for the example, not a rule. The days only stay off if reorders stop rebuilding the excess. Whether to keep buying D at all is a separate question, covered in when to stop reordering a SKU. The point here: a brand-level CCC can look acceptable while one SKU holds a fifth of the inventory cash.
Step 5 — Where this breaks
- The period changes the answer. Take an invented third quarter (92 days) in which the brand builds stock for the holidays: COGS $198,000, average on-hand inventory $255,000. DIO is $255,000 ÷ $198,000 × 92 = 118.5 days, against 73.0 for the full year. Compare like periods with like.
- Steady purchasing is an assumption. The 48.5 days of paid-for stock assume purchases equal COGS. A growing brand, or one building for a peak, buys ahead of sales, so its deposits and stock at sea can be larger than 48.5 days of COGS. Use the actual balances when you have them.
- The safety-plus-half-cycle estimate is a heuristic. It assumes even sales and orders that arrive on time. Late orders, uneven demand or orders placed early all move the real average away from it; measure the average from month-end balances before relying on the lever arithmetic.
- Inventory and COGS must be valued the same way. Freight and duty in one but not the other skews DIO; landed cost per unit covers what goes in.
- No single “good” CCC. A brand with a long sea lead time and deposit terms carries a longer cycle than one buying from a domestic supplier on 30-day terms, for reasons that have nothing to do with how well either runs. Track your own number over time, by SKU. The same argument for turnover is in what is a good inventory turnover ratio.
What to do this week
- Pull a year of revenue and COGS, and 13 month-end balances (opening plus 12 month-ends) of on-hand inventory at cost and of receivables.
- Write down your supplier terms as percentages and days before or after receipt, and compute the pre-receipt days the way Step 2 does. Check it against your deposit and in-transit balances.
- Compute the adjusted cycle and the working capital it ties up, split into “paid, not received”, “on the shelf” and “sold, not paid out”.
- Compute DIO per SKU. List any SKU whose share of inventory is well above its share of COGS.
- Price one lever in days and dollars, and compare the freed cash times your cost of cash with what the lever costs.
Questions people ask
What is the cash conversion cycle formula for an ecommerce brand?
CCC = DIO + DSO − DPO: days inventory sits, plus days until sales are paid out to you, minus days your supplier waits for payment. If you pay suppliers before stock arrives, textbook DPO is 0 and misses those days; add them to the cycle as a separate pre-receipt adjustment.
How does inventory tie up cash?
If you pay deposits or pay on shipment, each unit is paid for before it is received. It then sits on the shelf until it sells, and the money reaches you some days after the sale. The cash conversion cycle adds those days. In the invented example they total 128.3 days, and $333,123 out of the bank (receivables counted at sales value).
How do supplier deposits affect the cash conversion cycle?
They add days before the stock is received, which textbook DPO does not count. Weight each payment by its share and by how many days before receipt it leaves: a 30% deposit 80 days before receipt and 70% at shipment 35 days before receipt gives −24.0 − 24.5 = −48.5 days, which lengthens the cycle by 48.5 days.
Do marketplace payouts count in DSO?
Yes. The days between a sale and the payout reaching your bank are receivables, along with any reserve held against returns. On a 14-day payout cycle with a 3-day hold and even sales, the average wait is 7 + 3 = 10 days.
Does the cash conversion cycle change with the period I choose?
Yes. It uses period averages and period totals. In the invented example, DIO is 73.0 days for the full year and 118.5 days for a third quarter spent building stock. Compare periods of the same length and season.
What is a good cash conversion cycle for inventory?
There is no single figure. Lead time, supplier terms and payout schedules differ by catalog, so the same cycle can be fine for one brand and a problem for another. Track your own cycle over time and by SKU.
