Skip to content
Cash & receivables

Cash conversion cycle calculator — DIO + DSO − DPO

Work out your cash conversion cycle from day figures or raw balances. See CCC, working capital funded, and the cash a five-day move in each leg frees.

Free · no signup · runs in your browserUpdated
Short answer

The cash conversion cycle is DIO plus DSO minus DPO. It counts the days between paying for inventory and collecting from the customer. With DIO of 63.6 days, DSO of 30.7 days and DPO of 41.2 days, CCC is 53.1 days. A negative CCC means your suppliers fund working capital.

The cash conversion cycle is the number of days your own money is locked up between paying a supplier and being paid by a customer. It is the one working-capital figure that treats inventory, receivables and payables as a single system instead of three departmental scores.

This cash conversion cycle calculator works either way round. Enter DIO, DSO and DPO if you already track them, or drop in raw balances and let it derive all three legs. Either way you get CCC, the working capital the cycle funds, and the cash a few days off each leg would release.

Your numbers

Input basis
$

At cost. Opening plus closing divided by two, excluding in-transit and consignment.

$

Trade AR net of credit notes.

$

Trade AP only, without accruals or intercompany.

$

Drives both the DIO and DPO legs.

$

Invoiced on terms. Cash and card sales must be excluded from the DSO leg.

days

The same period length for all three legs.

days

The improvement you want to price in each leg.

Result

Cash conversion cycle
53.1 days

53.1 days of your own cash locked in the cycle

DIO — inventory63.6 days
DSO — receivables30.7 days
DPO — payables (funds you)41.2 days
Operating cycle (DIO + DSO)94.2 days
Financed by suppliers (DPO)41.2 days
Working capital funded by the cycle$4,450,000
A day of DIO or DPO$69,231
A day of DSO$94,505
Cash from 5 days off every leg$1,164,835
DIO = $4,400,000 ÷ $6,300,000 × 91 = 63.6 days
DSO = $2,900,000 ÷ $8,600,000 × 91 = 30.7 days
DPO = $2,850,000 ÷ $6,300,000 × 91 = 41.2 days
CCC = 63.6 + 30.7 − 41.2 = 53.1 days
DIO and DPO are priced at a day of COGS; DSO at a day of revenue.
ImprovementNew CCCCash released
DIO −5 days48.1 days$346,154
DSO −5 days48.1 days$472,527
DPO +5 days48.1 days$346,154
All three legs38.1 days$1,164,835
53.1 days is the normal band for distribution and make-to-stock manufacturing. Inventory is usually the biggest pool of recoverable days at this level, ahead of collections.

Everything is computed in your browser. Nothing you type is sent anywhere or stored.

The formula

CCC = DIO + DSO − DPO
DIO
Days inventory outstanding: average inventory ÷ COGS × days in period.
DSO
Days sales outstanding: accounts receivable ÷ credit sales × days in period.
DPO
Days payable outstanding: accounts payable ÷ COGS × days in period.

DPO carries a minus sign because supplier credit is the only leg that funds you rather than costing you. Note the mismatch built into the formula: DIO and DPO run on cost, DSO runs on revenue. It is still the standard definition, but it means CCC is a duration, not a dollar figure — convert each leg at its own daily rate before you talk about cash.

Worked example

Average inventory
$4,400,000
Accounts receivable
$2,900,000
Accounts payable
$2,850,000
COGS in period
$6,300,000
Credit sales in period
$8,600,000
Days in period
91
Result
CCC = 53.1 days · $4,450,000 funded

DIO is $4,400,000 ÷ $6,300,000 × 91 = 63.6 days. DSO is $2,900,000 ÷ $8,600,000 × 91 = 30.7 days. DPO is $2,850,000 ÷ $6,300,000 × 91 = 41.2 days. So CCC = 63.6 + 30.7 − 41.2 = 53.1 days. Converted at each leg's own daily rate that cycle funds $4,450,000, which is exactly inventory plus receivables minus payables.

Which leg to attack first

The three legs are not equally movable, and a day is not worth the same in each. A day of DIO or DPO is worth one day of COGS; a day of DSO is worth one day of revenue, which is larger by your gross margin. Rank by days available multiplied by dollars per day, not by which team you can lean on hardest.

LegA day is worthTypical days availableWho owns it
DIOOne day of COGSOften the largest pool, held in slow movers and stale buffersPlanning and purchasing
DSOOne day of revenueWhatever sits beyond agreed termsCredit control and billing
DPOOne day of COGSOnly up to agreed terms, unless you renegotiateProcurement and AP

What a negative cash conversion cycle means

A negative CCC means you collect from customers before you pay suppliers, so the business grows on other people's cash. Retail and subscription models reach it routinely: fast stock turns, card settlement in days, and 45- to 60-day supplier terms. Distributors and make-to-stock manufacturers almost never do, because inventory alone is 60 days or more.

Common errors that make CCC uncomparable

  • Mixing period lengths. All three legs must use the same days-in-period, or the arithmetic is meaningless.
  • Revenue in the DIO or DPO denominator. Both are cost-based. Using revenue understates them by your gross margin.
  • Cash sales left in the DSO denominator. This flatters DSO and therefore CCC. Fix it with the DSO calculator.
  • Closing balances on a seasonal business. A December balance sheet on a Q4-heavy business produces a CCC nobody experiences. Use a monthly average.
  • Consolidating subsidiaries with different terms, which averages one healthy entity and one struggling entity into a number that describes neither.

Where the inputs come from

Six figures, three definitions, and every one of them needs a filter: trade AR net of credit notes, trade AP without accruals, inventory at cost excluding in-transit, credit sales without cash sales. That is normally an afternoon of saved searches and a pivot table, repeated every month.

With you ask for "cash conversion cycle by subsidiary for the last six months" and get it computed live from your own account, with the query shown underneath so you can check each definition instead of trusting the label on a dashboard tile.

Frequently asked questions

How do you calculate the cash conversion cycle?

Add days inventory outstanding to days sales outstanding, then subtract days payable outstanding. With DIO of 63.6 days, DSO of 30.7 days and DPO of 41.2 days, CCC is 53.1 days. All three legs must be calculated over the same period length, and inventory and payables must use a cost-based denominator.

What is a good cash conversion cycle?

Shorter than last quarter, without fill rate or supplier terms getting worse. Absolute levels are industry-bound: grocery and retail often run negative, industrial distributors commonly sit between 50 and 100 days, and capital equipment makers can exceed 150. Compare against your own trend and your direct competitors only.

Can the cash conversion cycle be negative?

Yes. A negative CCC means customers pay you before your suppliers need paying, so growth is funded by trade credit rather than by cash. It requires fast inventory turns and long supplier terms together. It is normal in retail and subscription businesses, and rare in distribution or make-to-stock manufacturing.

What is the difference between the cash conversion cycle and the operating cycle?

The operating cycle is DIO plus DSO, which is how long stock takes to become cash. The cash conversion cycle subtracts DPO from that, because supplier credit covers part of the wait. The difference between the two figures is exactly the amount of financing your suppliers are providing.

How much cash does one day of the cash conversion cycle represent?

It depends on the leg. A day of DIO or DPO is one day of COGS; a day of DSO is one day of revenue. On $25,269,231 of annualised COGS and $34,494,505 of annualised revenue, that is $69,231 and $94,505 respectively — so a 5-day move in each leg together releases about $1,164,835.

Related calculators

Cash & receivables
DSO calculator

Calculate days sales outstanding from your AR and credit sales. See days beyond terms, cash tied up in receivables, and what each day of improvement is worth.

Cash & receivables
DPO calculator

Calculate days payable outstanding from your AP and COGS. See how far you sit from supplier terms and what five more days of DPO is worth in cash.

Inventory & supply chain
DIO calculator

Calculate days inventory outstanding and inventory turns from average stock and COGS. See the cash tied up in inventory and the cost of holding it.

Cash & receivables
Working capital calculator

Calculate working capital from your current assets and liabilities. Get current ratio, quick ratio, working capital as a % of revenue and days of coverage.

Read the background

Finance metrics
Cash conversion cycle explained, with a worked example

The cash conversion cycle explained: CCC = DIO + DSO − DPO, a full worked example at 65 days, and how to cut each leg without breaking the other two.

Finance metrics
What is DSO — and how do you actually bring it down?

DSO explained plainly: the formula, the three variants people confuse, realistic benchmarks by industry, and the seven levers that actually move it.

Finance metrics
DPO explained: days payable outstanding, and when to stretch it

DPO explained: the days payable outstanding formula, a worked example at 36.5 days, and where stretching supplier terms starts to cost you money.

All 50 ERP & finance tools

Stop calculating it by hand. Just ask your ERP.

This calculator needs you to find the inputs first. ERPray pulls them from your own ERP account and computes the answer live — with the exact query shown so you can check it.

Get early access — freeBrowse all 50 tools