Cash Conversion Cycle Calculator
Convert average receivables, inventory, and payables into operating days. See how customer collection and inventory holding time combine, then subtract supplier financing to estimate the net cash-cycle interval.
Set the three clocks
Use trade receivables and trade payables that correspond to the entered sales and COGS. If detailed monthly averages are available, use them instead of simple opening-closing averages by entering the equivalent average in both fields.
The three-clock formulas
DSO = average trade receivables divided by (net sales / period days)
DIO = average inventory divided by (COGS / period days)
DPO = average trade payables divided by (COGS / period days)
Cash conversion cycle = DSO + DIO − DPO
Net operating working capital = average receivables + average inventory − average trade payables
The calculator uses simple opening and ending averages. A business with material seasonality, acquisitions, rapid growth, or month-end window dressing should use weekly or monthly balance averages and a matching trailing flow period.
Worked U.S. distributor example
The default annual period has $7,300,000 net sales, or $20,000 per day, and $4,380,000 COGS, or $12,000 per day. Average trade receivables are $1,100,000, producing 55.00 DSO. Average inventory is $875,000, producing 72.92 DIO. Average trade payables are $715,000, producing 59.58 DPO.
Adding customer collection and inventory time, then subtracting supplier financing, gives 68.33 cash-cycle days. Average receivables plus inventory minus payables equals $1,260,000 net operating working capital. That dollar result reconciles the three components, but it is not the same as multiplying the 68.33-day cycle by one daily amount because DSO uses daily sales while DIO and DPO use daily COGS.
The prior entered components produce a 60.00-day cycle, so the current cycle is 8.33 days longer. Five fewer DSO days correspond to $100,000 receivables at current sales. Five fewer DIO days correspond to $60,000 inventory at current COGS. Five more DPO days shift $60,000 supplier payment timing, subject to contract and relationship constraints.
Match account scope to the flow denominator
Receivables
Use trade customer balances associated with the sales denominator. Exclude tax receivables, employee advances, notes, and unrelated amounts unless the policy says otherwise.
Inventory
Include raw material, work in process, finished goods, and reserves consistently with the COGS measure. Consignment and vendor-owned inventory need careful treatment.
Payables
Use supplier obligations supporting COGS. Payroll, income tax, interest, capital expenditure, and accrued bonuses may not belong in the operating DPO numerator.
Average balances matter more as volatility grows
A year-end receivable balance divided by full-year sales can misrepresent the typical cycle when December sales are unusual. The same problem arises after a large inventory purchase, supplier payment run, acquisition, divestiture, or rapid growth. Simple beginning-ending averages reduce but do not eliminate endpoint bias.
Use daily or monthly averages from the subledgers when the decision is important. Keep the numerator and denominator on the same consolidated group, currency basis, and period. If a company reports a rolling three-month metric, compare it with another rolling three-month metric, not an annual calculation.
DSO is a collection signal, not an aging report
Higher DSO can reflect slower collections, more generous terms, disputed invoices, a customer mix shift, revenue timing, or growth late in the period. Lower DSO can reflect deposits, card payments, factoring, improved billing, or a temporary collection push. DSO alone does not show which invoices are overdue.
Pair it with accounts-receivable aging, on-time payment rate, dispute reasons, credit limits, bad-debt provision, and customer concentration. Improve invoicing accuracy and dispute resolution before pressuring customers whose invoices are not yet due.
DIO balances service with cash and risk
Inventory days can rise because of demand weakness, safety-stock policy, new product launches, supply disruption, minimum order quantities, seasonal builds, inflation, or obsolete stock. Cutting inventory without considering lead time, variability, quality, and service level can cause stockouts and lost margin.
Segment by SKU velocity, margin, lead time, shelf life, and criticality. Use demand forecasts, reorder points, cycle counts, supplier reliability, and disposition plans. Inventory write-down policy can change the balance and ratio without physically moving goods.
DPO is financing supplied by real partners
Longer DPO can preserve cash, but late or unilateral payment can lose early-pay discounts, damage supplier trust, interrupt supply, breach a contract, or disadvantage small vendors. A higher number is not automatically operational excellence.
Negotiate terms transparently, pay on the agreed date, resolve invoice errors quickly, and compare the implied return from discounts with the cost of cash. Supplier-finance programs require accounting, disclosure, and counterparty review.
A negative cycle can be healthy or fragile
A retailer or subscription business may collect from customers before paying suppliers, producing negative CCC. That can create powerful working-capital economics. It can also reverse quickly if customer demand falls, refund obligations rise, processors hold reserves, or suppliers shorten terms.
Do not treat customer advances or deferred revenue as free equity. Forecast refunds, service obligations, purchase commitments, and renewal seasonality. Maintain liquidity for the obligations behind the favorable timing.
Growth can consume cash even when margins are positive
When sales expand, receivables and inventory may grow before supplier financing and customer collections catch up. Model working capital by month alongside revenue and gross margin. A profitable growth plan may need a revolver or additional equity if the cash-cycle investment arrives first.
Use scenario ranges for growth, gross margin, terms, inventory lead time, bad debt, and supplier capacity. Compare the borrowing base and covenant definitions in actual loan documents; this calculator does not determine eligible collateral.
Turn each day into an accountable operating action
For receivables, measure the time from completed delivery to accurate invoice, from invoice to dispute, and from resolution to cash. Assign owners to missing purchase orders, billing errors, unapplied cash, and promised payment dates. A broad request to “collect faster” is weaker than removing a documented delay in the order-to-cash process.
For inventory, separate supplier lead time, production time, quality hold, storage, and time waiting for a customer order. Examine forecast bias and order quantity at the SKU-location level. For payables, measure invoice receipt, approval, scheduled due date, and actual payment rather than rewarding indiscriminate delay.
Recalculate the cycle after a process change, but also verify customer service, fill rate, gross margin, supplier reliability, early-payment discounts, and bad debt. A cash release that creates lost sales or fragile supply may not improve enterprise value. Record the baseline, intervention date, responsible owner, expected dollar effect, and guardrail metric before claiming an improvement.
Tax timing is outside the three clocks
Sales tax, payroll tax, estimated income tax, customs duties, capitalization, inventory accounting, bad-debt deductions, and method changes affect cash and taxable income under separate rules. They are not automatically included in trade receivables, inventory, trade payables, sales, or COGS.
Close-process checklist
- Lock the reporting period and day count.
- Reconcile net sales and COGS.
- Map trade receivable accounts.
- Map inventory and reserves.
- Map supplier trade payables.
- Use representative average balances.
- Explain acquisitions and currency effects.
- Review receivable aging.
- Review slow and obsolete inventory.
- Review supplier terms and discounts.
- Bridge current to prior CCC.
- Update the monthly cash forecast.
Frequently asked questions
Is a lower cash conversion cycle always better?
No. Improvement achieved through accurate billing or lower obsolete stock may be healthy; starving service or paying suppliers late can destroy value.
Why does DSO use sales while DIO and DPO use COGS?
Receivables arise from customer selling prices, while inventory and supplier payables generally relate to the cost base.
Should I use 365 or 360 days?
Use the actual days in the matching period or a consistently disclosed convention. Comparability matters more than switching opportunistically.
Can a service company use CCC?
DSO can be useful, but inventory and trade-payable components may be small or defined differently. Do not force manufacturing accounts into a service model.
Does the result equal cash needed?
No. It describes average operating working-capital timing. Cash needs also reflect margin, growth, taxes, payroll, debt, capital spending, and minimum liquidity.