The Three Levers of Cash Flow: DSO, DIO & DPO

Working capital is one of the clearest links between operating activity and cash flow.

Three metrics are especially useful:

• DSO — Days Sales Outstanding
• DIO — Days Inventory Outstanding
• DPO — Days Payables Outstanding

Together, they help explain how quickly cash enters the business, how long it remains tied up in operations, and how quickly it leaves.

For forecasting and FP&A, these metrics can also serve as practical drivers for projecting receivables, inventory and payables.

Why These Three Metrics Matter

Revenue growth does not automatically translate into stronger cash flow.

A company may sell more but still experience cash pressure if:

• customers take longer to pay
• inventory levels increase
• supplier payments accelerate

This is why DSO, DIO and DPO are useful not only as historical ratios, but also as forecasting and management levers.

They connect operating behaviour directly to liquidity.

DSO — Days Sales Outstanding

DSO measures approximately how many days of sales remain outstanding in Accounts Receivable.

In simple terms:

“How long does it take customers to pay?”

A higher DSO usually means more cash is tied up in receivables.

A lower DSO usually means cash is collected faster.

Simplified forecasting relationship

For example, if:

• annual revenue is ₹365 crore
• average daily revenue is approximately ₹1 crore
• forecast DSO is 45 days

then:

This does not replace detailed customer-level forecasting where such detail is required.

But for planning purposes, it provides a fast and transparent way to connect revenue assumptions with working-capital requirements.

Management actions that can influence DSO

• invoice customers promptly
• improve invoice accuracy
• monitor overdue balances
• resolve disputes quickly
• review credit terms
• strengthen collection processes

The objective is not necessarily to minimise DSO at all costs.

The right level depends on customer relationships, competitive conditions and commercial terms.

DIO — Days Inventory Outstanding

DIO measures approximately how long inventory remains in the business before being sold.

In simple terms:

“How long is cash tied up in inventory?”

Higher DIO generally means more cash is locked into stock.

Lower DIO generally means inventory is turning faster.

Simplified forecasting relationship

For example, if:

• annual cost of goods sold is ₹182.5 crore
• average daily cost of goods sold is approximately ₹0.5 crore
• forecast DIO is 60 days

then:

This type of relationship allows the inventory forecast to move automatically as sales and operating assumptions change.

Management actions that can influence DIO

• improve demand forecasting
• reduce slow-moving stock
• review order quantities
• optimise safety stock
• improve production planning
• reduce obsolete inventory
• strengthen SKU-level monitoring

The goal is not to eliminate inventory.

Insufficient stock can create lost sales, service failures and supply disruption.

The objective is to hold enough inventory to support the business without unnecessarily tying up cash.

DPO — Days Payables Outstanding

DPO measures approximately how long the business takes to pay suppliers.

In simple terms:

“How long can the business retain cash before paying suppliers?”

Higher DPO generally means cash stays inside the business for longer.

Lower DPO means cash leaves sooner.

Simplified forecasting relationship

Suppose:

• relevant annual purchases are ₹146 crore
• average daily purchases are approximately ₹0.4 crore
• forecast DPO is 45 days

then:

DPO can therefore act as a source of short-term operating finance.

Management actions that can influence DPO

• negotiate appropriate supplier terms
• coordinate payments with cash collections
• avoid unnecessary early payments
• use early-payment discounts only when economically attractive
• improve accounts-payable planning

DPO requires particular judgement.

Extending supplier payments too aggressively may damage supplier relationships or create supply risk.

The Three Levers Work Together

DSO, DIO and DPO should not be viewed independently.

They form a connected working-capital system.

• Higher DSO → more cash tied up in receivables
• Higher DIO → more cash tied up in inventory
• Higher DPO → more supplier financing and slower cash outflow

This means the same revenue forecast can produce very different cash outcomes depending on operating assumptions.

A business with strong growth but deteriorating DSO and DIO may require significantly more funding.

Another business with similar growth but better collections and inventory efficiency may generate much stronger cash flow.

View full-size infographic

The Cash Conversion Cycle

A useful way to combine these measures is the Cash Conversion Cycle.

For example:

• DSO = 45 days
• DIO = 60 days
• DPO = 40 days

Then:

A shorter cash conversion cycle generally means operating cash is recovered more quickly.

A longer cycle generally means more funding is required to support operations.

However, the target should always reflect the realities of the industry and business model.

Why Driver-Based Forecasting Is Useful

A detailed working-capital model can include customer invoices, supplier schedules, inventory movements and individual payment terms.

That level of detail can be valuable.

But it is not always necessary for every planning exercise.

A driver-based model using DSO, DIO and DPO can provide several advantages:

• fast scenario modelling
• clear links between operational assumptions and financial statements
• easier sensitivity analysis
• simpler management communication
• straightforward integration with revenue and cost forecasts

• “What happens to cash if DSO increases by 5 days?”
• “What happens if inventory turns more slowly?”
• “What happens if supplier terms improve?”

This is where the model becomes useful for decision-making rather than simply reporting historical balances.

A Simple Scenario

Suppose a business expects strong sales growth next year.

Management assumes:

• DSO rises from 40 to 48 days
• DIO rises from 55 to 65 days
• DPO remains at 40 days

Even if profitability improves, two important cash pressures have appeared:

• customers are paying more slowly
• inventory is remaining in the business for longer

The cash conversion cycle has increased by 18 days.

That additional 18 days may create a significant funding requirement.

The business should therefore consider the working-capital consequences of growth before finalising financing and operating plans.

What Management Should Monitor

A practical working-capital dashboard can track:

• DSO
• DIO
• DPO
• cash conversion cycle
• Accounts Receivable
• overdue receivables
• inventory value
• slow-moving inventory
• Accounts Payable
• operating cash flow
• cash balance
• working-capital requirement

Trend matters as much as the absolute number.

A deteriorating DSO or DIO trend may provide an early warning long before liquidity becomes critical.

Final Perspective

DSO, DIO and DPO are more than accounting ratios.

They are practical links between operations, forecasting and cash flow.

Used properly, they help management understand:

• where cash is tied up
• how operating behaviour affects liquidity
• how growth changes funding requirements
• which levers can improve cash conversion
• how different scenarios affect future cash flow

The purpose is not simply to calculate the metrics.

The purpose is to use them to make better decisions.