All calculators

Guide · Cash Flow

Days Payable Outstanding: Choose the Right Base

Calculate payable days from average trade payables and credit purchases, and disclose when cost of goods sold is only a proxy.

By PriceAndProfit Editorial Updated 3 min read

On this page
  1. Match payables with their purchase base
  2. Check the balance scope
  3. Use the indicator to investigate payment timing

Days payable outstanding, or DPO, expresses a trade-payables balance in days of the purchases that created it. The measurement helps describe supplier-payment timing. It does not authorize paying invoices after their agreed dates, and a higher number is not automatically an improvement. The composition of purchases and the chosen denominator can change the result substantially.

Payable days = average trade payables ÷ credit purchases during the period × days in the period

Match payables with their purchase base

For a hypothetical 90-day period, opening trade payables are $18,000 and closing trade payables are $30,000. Their simple average is $24,000. Credit purchases covered by those payables total $108,000. Payable days are $24,000 divided by $108,000, multiplied by 90, or 20 days.

Input or resultAmount
Opening trade payables $18,000
Closing trade payables $30,000
Average trade payables $24,000
Credit purchases in 90 days $108,000
Payable days 20 days

Suppose cost of goods sold is only $90,000 because inventory increased during the period. Using that amount as a proxy denominator produces 24 days. The difference does not prove suppliers waited four additional days; it reflects the different flow measure. If purchase data are unavailable, disclose the cost-of-goods-sold proxy and use it consistently when comparing periods.

Check the balance scope

Include the trade payables associated with the chosen purchase base. Mixing payroll accruals, equipment balances, or unrelated obligations into the numerator while using only inventory purchases in the denominator produces a ratio with no clean interpretation. Similarly, immediate cash purchases do not create trade payables and may need to be excluded from the credit-purchase base.

Under a simplified inventory model, purchases can be reconstructed as cost of goods sold plus ending inventory minus opening inventory. That reconstruction requires compatible valuation and adjustments for returns, losses, and other movements. It is not reliable if used mechanically across inconsistent records. Actual purchase and supplier ledgers are preferable when available.

Use the indicator to investigate payment timing

Compare DPO with the invoice calendar and the terms actually agreed with suppliers. A rising ratio could reflect a legitimate term change, a seasonal purchase surge, a large invoice just before period end, or overdue bills. Those explanations have different operational implications and cannot be distinguished from the ratio alone.

If credit purchases are zero, the ratio is undefined even when old payables remain. Retain the balance and schedule its payment rather than reporting zero payable days. Use average balances frequent enough to represent the period, and keep a separate forecast of due dates: an average 20-day interval does not tell you how much cash is required tomorrow.

Method references: OpenStax: What Is Working Capital?. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.

Related calculators & guides