A higher DPO keeps cash in the business longer, but paying too slowly can damage supplier relationships or lose early-payment discounts (such as 2/10 net 30).
How to use the DPO Calculator — Days Payable Outstanding
- Beginning accounts payable
- Ending accounts payable
- Cost of goods sold
- Days in the period
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter beginning and ending accounts payable, cost of goods sold and the number of days.
Tips
- Use consistent periods (a year or a quarter) for flow figures and period-end values for balances.
- Average opening and closing balances when a ratio mixes a flow with a stock.
- Benchmark against competitors in the same industry.
- Read the ratio together with others – profitability, liquidity and efficiency tell different stories.
Common mistakes to avoid
- Using sales instead of cost of goods sold for inventory ratios.
- Mixing gross, operating and net profit.
- Ignoring one-off items that distort a single year.
Inputs explained
| Field | What to enter |
|---|---|
| Beginning accounts payable | Amount in your currency |
| Ending accounts payable | Amount in your currency |
| Cost of goods sold | Amount in your currency |
| Days in the period | A number |
What each result means
- Days payable outstanding = ([Beginning accounts payable] + [Ending accounts payable])÷2÷[Cost of goods sold]×[Days in the period]
- Payables turnover = [Cost of goods sold]÷(([Beginning accounts payable] + [Ending accounts payable])÷2)
Example values
How the main result changes when Beginning accounts payable changes and everything else stays at the example values above:
| Beginning accounts payable | Days payable outstanding (days) |
|---|---|
| 45,000 | 21.8 |
| 67,500 | 24.9 |
| 90,000 | 28.1 |
| 112,500 | 31.2 |
| 135,000 | 34.4 |
| 180,000 | 40.7 |
Formula
DPO = average accounts payable ÷ COGS × days in the periodPayables turnover = COGS ÷ average payablesWorked example
Inputs — Beginning accounts payable: $90,000; Ending accounts payable: $110,000; Cost of goods sold: $1,300,000; Days in the period: 365.
Results — Days payable outstanding = 28.1 days; Payables turnover = 13.
Frequently asked questions
What is a good DPO?
Close to your suppliers' terms – often 30–60 days.
Is a high DPO good?
It helps cash flow, but too high may signal payment difficulties.
How does DPO affect the cash conversion cycle?
A higher DPO shortens it.
What formula does the DPO Calculator — Days Payable Outstanding use?
DPO = average accounts payable ÷ COGS × days in the period.