DPO measures how long you take to pay suppliers. Longer isn't always better.
Days payable outstanding equals trade payables divided by purchases or cost of sales for the period, multiplied by the number of days. It shows how many days, on average, you take to pay suppliers. Compare it with your agreed terms: paying earlier than agreed wastes cash, but paying later than agreed damages supplier trust and can cost you discounts or supply.
DPO = trade payables ÷ purchases (or cost of sales) × days in the period
Purchases is the more accurate denominator, because payables arise from everything you buy on credit, not only cost of sales. Many teams use cost of sales because it is easier to obtain. Pick one and use it consistently.
| Item | Amount |
|---|---|
| Trade payables at month end | 150,000 |
| Purchases for the month | 120,000 |
| Days in the month | 30 |
| DPO = 150,000 ÷ 120,000 × 30 | 37.5 days |
In Excel: =B2/B3*B4
Late payment can trigger supplier credit holds, loss of discounts, worse prices at renewal and, in some countries, statutory interest and compensation claims. It also strains small suppliers who depend on you. A fair, predictable payment practice is a better long-term lever than stretching.
DPO is one third of the cash conversion cycle. For how payment timing feeds into your forecast, see the 13-week cash flow forecast, and for the approval side, the payment run approval checklist.
An average DPO can hide very different behaviour. Calculate days to pay for your largest suppliers individually: you may be paying some early and others very late. Paying strategic or small suppliers on time, every time, protects supply. Payment terms with your largest suppliers are often the best place to negotiate, because a small change there has the biggest effect on cash.
UK teams often call DPO "creditor days". The UK has statutory late payment interest for business-to-business debts, and larger UK companies have payment practices reporting duties. US rules vary by state and contract. Check current rules where you operate.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Working capital, the working capital ratio, operating working capital, days of working capital and the cash conversion cycle, with every formula. Free to use online.
The Cash Flow Forecasting & Liquidity Control System tests every week of a rolling cash forecast against your minimum cash buffer and lending covenants, and flags a breach before it lands. Excel, no macros, one-time price.
Only up to your agreed terms. Beyond that, it usually means paying late, which damages supplier relationships and can cost discounts or interest.
Purchases is more accurate, because payables come from all credit purchases. Cost of sales is a common, simpler alternative; be consistent.
Each extra day of DPO keeps roughly one day of purchases in your bank account for longer, which is why it appears in the cash conversion cycle.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.