Skip to content

DPO: days payable outstanding, formula and example

DPO (Days Payable Outstanding) shows how many days on average it takes a company to pay its suppliers' invoices. A higher DPO (within reasonable limits) reduces the need for working capital financing and improves OCF, but excessive delays can put supplies and prices at risk.

What the metric measures

How quickly obligations to suppliers are turned into payments. It reflects negotiating power, the quality of procurement processes, and payment calendar discipline.

Calculation

  • DPO = (Average accounts payable / COGS) × Number of days in the period
  • Preferred: DPO = (Average accounts payable / Purchases for the period) × Days
  • Monthly estimate: DPO ≈ APaverage / (Purchasesmonth / 30)

Calculate **excluding VAT**, use average accounts payable, and separate operating suppliers from CAPEX/taxes.

Calculation example

Average payables to suppliers are 900,000 and monthly purchases (or cost of sales) are 1,350,000. DPO = 900,000 / 1,350,000 × 30 = 20 days. The longer DPO within contract terms, the less own cash is needed for working capital.

Data sources

ERP/1C (AP ledgers, purchases, COGS), contracts and payment terms, source documents (invoices, acceptance certificates), bank statements/payment calendar, supplier master data, credit notes/returns.

Interpretation

  • High DPO: better terms or approval delays — check SLAs and supply risks
  • Low DPO: fast payments/early payment discounts — assess the cost to liquidity
  • Cash effect: all else being equal, DPO reduces CCC and increases OCF

Useful breakdowns

  • Suppliers / categories / currencies
  • Payment terms (Net 30/45/60), key suppliers vs the "long tail"
  • OPEX vs CAPEX
  • Disputed invoices / invoices missing source documents

Dashboard visualizations

  • DPO trend with targets
  • Accounts payable aging (current/overdue)
  • Top 20 suppliers by amount and days
  • Scatter: amount of liabilities vs days
  • Bridge chart of the impact of payment term changes on CCC/OCF

How to set targets

Define a target DPO by category/supplier, rules for early payment discounts (compared against the cost of capital), approval SLAs, and payment calendar prioritization.

Common mistakes

  • Calculating from revenue rather than from purchases/COGS
  • Including VAT, taxes, and CAPEX in operating DPO
  • Using ending AP instead of average AP
  • Ignoring credit notes/returns
  • Comparing periods/currencies without normalization

Questions for discussion

  • What OCF uplift would +5 days of DPO deliver without supply risk?
  • With which suppliers should payment terms be renegotiated first?
  • What is slowing down payments: approval of source documents, disputes, or the payment process?
  • Are early payment discounts worthwhile for us, given the cost of capital?

Questions and answers

What is DPO?

Days Payable Outstanding — the average number of days a company takes to pay supplier invoices.

How do you calculate DPO?

DPO = average accounts payable / purchases or cost of sales for the period × number of days in the period.

Is a long DPO always good?

Only within agreed terms: late payments damage supplier relationships, lose discounts and can stop deliveries.