Cash Conversion Cycle Formula: DSO, DIO and DPO Explained

The cash conversion cycle formula is DSO + DIO − DPO: days sales outstanding plus days inventory outstanding, minus days payables outstanding. The result shows how many days cash stays locked up between paying a supplier and collecting from a customer.

For a controller this is a financing question rather than an academic ratio. Every day in the cycle is a day of revenue the company funds itself: at annual revenue of € 12 million, one day costs roughly € 33,000 in liquidity. That is the difference with working capital, which expresses the same position in euros. Days are the better unit for comparison, because they adjust for growth by themselves.

What the cash conversion cycle formula measures

The cash conversion cycle, also called the cash-to-cash cycle or the cash conversion period, measures the throughput time of working capital in days. It has three components:

• DSO (days sales outstanding): the average number of days between invoicing and payment. The calculation, the countback method and sector norms are covered in DSO calculation.
• DIO (days inventory outstanding): the average number of days inventory sits on the balance sheet before it is sold. For project-based companies, work in progress belongs here as well.
• DPO (days payables outstanding): the average number of days taken before a supplier gets paid. This is the only component that shortens the cycle instead of extending it.

DSO and DIO together form the operating cycle: the time a euro needs to travel through inventory and receivables and turn back into cash. Subtracting supplier credit leaves exactly the part the company finances on its own.

The cash conversion cycle formula step by step

Cash conversion cycle = DSO + DIO − DPO

Each component follows the same pattern: a balance sheet position divided by a flow, multiplied by the number of days in the period.

1. DSO = (accounts receivable ÷ revenue) × days. Strip VAT out of the receivables balance, since the revenue below it is recorded net of VAT.
2. DIO = (inventory ÷ cost of goods sold) × days. Never against revenue: inventory is carried at cost, so the denominator has to be at cost as well. Otherwise the gross margin ends up inside the ratio.
3. DPO = (accounts payable ÷ cost of goods sold) × days. Strip VAT here too, and include only purchasing that actually runs through accounts payable.
4. Add DSO and DIO, then subtract DPO. Use the same period and the same basis for all three, or the formula compares apples with pears inside itself.

With growth or seasonality, use the average of opening and closing balances instead of the closing balance alone. Measuring on closing balances during fast growth mostly measures the growth.

Worked example

A wholesaler with annual revenue of € 12,000,000 and cost of goods sold of € 8,400,000 applies the cash conversion cycle formula over a full year of 365 days. All balance sheet positions are net of VAT.

Position	Amount	Result
Accounts receivable	€ 1,480,000	DSO 45.0 days
Inventory	€ 1,380,000	DIO 60.0 days
Accounts payable	€ 690,000	DPO 30.0 days
Cash conversion cycle	—	75.0 days

45.0 + 60.0 − 30.0 = 75 days, roughly two and a half months of revenue financed internally. At € 33,000 per day, about € 2.5 million sits locked in working capital.

Suppose procurement moves supplier terms from 30 to 45 days and inventory comes down by eight days: 45.0 + 52.0 − 45.0 = 52 days. Twenty-three days shorter, releasing more than € 750,000 in cash without adding a single euro of margin.

What counts as a good outcome?

There is no absolute benchmark; the result follows the business model. The only meaningful comparison is against your own history and against companies running a comparable model.

• Retail and hospitality: often negative. Inventory turns within days, customers pay immediately and suppliers are paid after thirty or forty days. The customer funds the operation.
• Professional services: almost no inventory, so the cycle is effectively DSO minus DPO. Thirty to fifty days is common.
• Wholesale and manufacturing: sixty to a hundred days is normal, with the largest share sitting in DIO.
• Construction and project work: work in progress makes the cycle long and volatile. Milestone billing and down payments are the only real levers.

A negative outcome is therefore no arithmetic error at all, but a feature of the model. Judge the twelve-month trend alongside the quick ratio, which shows whether short-term coverage holds up.

Which of the three levers moves fastest?

In theory DPO is the cheapest lever, since paying later costs nothing. In practice it is the hardest. Dutch B2B contracts may stipulate sixty days at most, and since 1 July 2022 large companies may no longer agree terms beyond thirty days with SME suppliers. Stretching terms unilaterally also forfeits early payment discounts and supplier goodwill.

DSO delivers real results fastest, because part of the delay sits in your own process: the days between delivery and the invoice going out count in full. An aging analysis shows immediately whether the increase comes from a handful of large customers or from the whole portfolio.

DIO is usually the largest component and the slowest to move. Reducing inventory touches procurement, sales and delivery reliability, and the effect only becomes visible after a quarter or two. Start with the product groups that turn over slowest, rather than the ones carrying the highest value.

Pitfalls

• VAT on one side only. Receivables and payables are carried gross on the balance sheet, while revenue and cost of goods sold are net. At 21% that structurally inflates the number of days by 21%.
• Measuring DIO or DPO against revenue. Both belong against cost of goods sold. Using revenue compresses the days by exactly the gross margin percentage and makes the result incomparable with any sector series.
• Ignoring work in progress. In construction and project companies most of the pre-financing sits under work in progress rather than inventory. Leave it out and the cycle looks dozens of days shorter than it is.
• Including intercompany positions. Current account balances between group entities carry no real payment term and distort a consolidated measurement completely. Filter them out before consolidating.
• Celebrating a decline that is only a shift. Factoring, early payment discounts and stretched supplier terms shorten the cycle immediately, yet merely move the financing elsewhere. Always read a decline alongside gross margin and interest cost.

Frequently asked questions

What is the cash conversion cycle formula?

DSO + DIO − DPO. Days sales outstanding plus days inventory outstanding, minus days payables outstanding. The outcome is a number of days rather than an amount, which makes it comparable across periods and across entities of different sizes.

How do you calculate it in Excel?

Set up five monthly columns: receivables, inventory, payables, revenue and cost of goods sold, all net of VAT. Derive DSO, DIO and DPO next to them and add a sixth column for the cycle itself. The twelve-month trend says far more than any single month.

Is a negative cash conversion cycle good?

For a retailer or a subscription business, negative is normal and healthy: customers pay before suppliers have to be paid. For a manufacturer with long lead times the same figure would suggest suppliers are structurally paid late. The outcome only makes sense next to the business model.

How does it differ from the operating cycle?

The operating cycle is DSO plus DIO and covers the time from purchase to cash collection. Subtracting DPO leaves only the portion the company finances itself.

From ratio to monthly steering

The cycle changes daily, yet in many organisations it gets calculated once a year for the annual accounts. That is far too late to act on. Smartbooks shows the aging analysis for receivables and payables per entity and consolidated, with intercompany relations filtered out, and lets you drive planned receivables and payables from DSO and DPO metrics. Working capital then moves along with the revenue plan and the cash flow forecast rolls out of the same model, putting the cycle in the same reporting set as the result.

Start with twelve months of history on a fixed basis and read the cash conversion cycle formula alongside the adjacent ratios: cash flow calculation for the cash flow itself, and 13-week cashflow planning for the short term.