Transparent method
The formula
Worked example
Example inputs
How to interpret the result
Payables turnover and days payable outstanding measure the identical underlying relationship from two different angles, turnover as a frequency and DPO as a duration, so the two figures should always move in opposite directions together. A rising turnover with a rising DPO at the same time signals a period-matching error in the underlying inputs, not a genuine business change.
Before you rely on it
What to check
Match purchases and average payables to the identical time period before calculating either figure, since a mismatched period between the two produces internally inconsistent results.
The common error
Where people go wrong with accounts payable turnover calculator
Calculating purchases over one period and average payables over a different one. That mismatch produces a turnover and DPO figure that don't actually describe a coherent, consistent picture of payment behavior.
Sensitivity evidence
How annual credit purchases changes the days payable outstanding
| Annual credit purchases | Days payable outstanding | Payables turnover | Average daily purchases |
|---|---|---|---|
| $960,000 | 57.0 days | 6.40× | $2,630 |
| $1,080,000 | 50.7 days | 7.20× | $2,959 |
| $1,200,000worked example | 45.6 days | 8.00× | $3,288 |
| $1,320,000 | 41.5 days | 8.80× | $3,616 |
| $1,440,000 | 38.0 days | 9.60× | $3,945 |
Every input, tested
Which input moves the days payable outstanding most
| Input | Tested from | To | Days payable outstanding at each end | Swing |
|---|---|---|---|---|
| Average accounts payable | $135,000 | $165,000 | 41.1 days to 50.2 days | 9.1 days (20%) |
| Annual credit purchases | $1,080,000 | $1,320,000 | 50.7 days to 41.5 days | 9.2 days (20%) |
Two variables at once
Days payable outstanding by annual credit purchases and average accounts payable
| Annual credit purchases \ Average accounts payable | $120,000 | $150,000 | $180,000 |
|---|---|---|---|
| $960,000 | 45.6 days | 57.0 days | 68.4 days |
| $1,080,000 | 40.6 days | 50.7 days | 60.8 days |
| $1,200,000 | 36.5 days | 45.6 days | 54.8 days |
| $1,320,000 | 33.2 days | 41.5 days | 49.8 days |
| $1,440,000 | 30.4 days | 38.0 days | 45.6 days |
Step by step
The worked example, input by input
| Input | Value used |
|---|---|
| Annual credit purchases | $1,200,000 |
| Average accounts payable | $150,000 |
| Days payable outstanding | 45.6 days |
| Payables turnover | 8.00× |
| Average daily purchases | $3,288 |
Where the inputs come from
Annual credit purchases are the goods and services you bought on credit from suppliers during the year, from purchase records, not total expenses; if you cannot separate them, cost of goods sold is a rough substitute. Average accounts payable is the mean of opening and closing payables from the balance sheet. Use the same year for both. Cash purchases are not included since they never enter payables.
Using the days payable outstanding in a real decision
Compare the number with your suppliers' actual terms.
When the result stops applying
A very high turnover may mean you pay early and give up cash you could use, or that suppliers demand quick payment. A very low turnover may signal cash trouble. Averages hide the mix of suppliers with different terms. Seasonal buying distorts the annual figure. Purchases and payables that include non-trade items overstate the result.
What to compare it with
This page sits beside the days payable outstanding calculator, which reports the same result from a supplier-payment view, and both feed the cash conversion cycle page. Compare with days sales outstanding to see whether you are financing customers more than suppliers finance you.
People also ask
Frequently asked questions
Is paying suppliers later always better?
Only within the agreed terms. Paying late can cost early-payment discounts, late fees and goodwill, and can make suppliers cut credit or raise prices.
What is a 2/10 net 30 discount?
A term giving a 2% discount if you pay within 10 days, otherwise the full amount is due in 30. Taking it earns a high annual return, so it is often worth using.
What does low payables turnover mean?
You take a long time to pay suppliers, which may reflect strong terms or cash strain. Check whether you are actually paying late.