Accounts Payable Turnover Ratio and DPO: How to Calculate

How quickly does a business pay its suppliers? The answer matters to finance teams managing cash, to suppliers deciding on credit terms, to lenders assessing liquidity and to investors comparing companies. Two closely related ratios answer it: the accounts payable turnover ratio and days payable outstanding (DPO).

This guide explains both formulas, how to choose the inputs, how to calculate them step by step with worked examples, how to interpret the results, how they relate to the cash conversion cycle, and the most common mistakes. For background on payables, see what is accounts payable.

The formulas

Accounts payable turnover ratio

AP turnover = total purchases on credit ÷ average accounts payable

Where:

Total purchases on credit are supplier purchases for the period made on credit terms.
Average accounts payable = (opening AP + closing AP) ÷ 2, or a more frequent average such as the mean of month-end balances.

The result is a number of times per period, so a higher figure means faster payment. An AP turnover of 8 means the business paid off its average AP balance eight times in the year.

Days payable outstanding

DPO = days in period ÷ AP turnover

or equivalently:

DPO = average accounts payable ÷ total purchases on credit × days in period

DPO expresses the same information in days: how long, on average, the business takes to pay suppliers.

Choosing the inputs

Purchases vs cost of goods sold

The conceptually correct numerator is credit purchases, because AP arises from purchases. Purchases are not always disclosed, though, so analysts often use cost of goods sold (COGS) as a proxy, especially when comparing companies from published accounts.

Purchases can be estimated from the accounts:

Purchases = COGS + closing inventory − opening inventory

COGS can distort the ratio because:

It excludes purchases that are not inventory, such as services, utilities and overheads, which often also run through AP.
It includes non-purchase costs in some businesses, such as direct labour in manufacturing.

When analysing your own business, use actual supplier purchases from the ledger if you can. When comparing with other companies, use the same definition consistently.

Which payables to include

Use trade payables: amounts owed to suppliers. Exclude accrued expenses, taxes, payroll liabilities and loans, which do not relate to supplier purchases and would distort the ratio.

Average balances

Opening and closing balances can be unrepresentative if the business has seasonal peaks or pays a large batch of invoices just before year-end. Averaging month-end balances gives a better picture.

Worked example 1: annual calculation

A distribution company's figures for the year:

Item	Amount
Opening inventory	410,000
Closing inventory	470,000
Cost of goods sold	3,240,000
Opening trade payables	380,000
Closing trade payables	420,000

Step 1: purchases = 3,240,000 + 470,000 − 410,000 = 3,300,000.

Step 2: average AP = (380,000 + 420,000) ÷ 2 = 400,000.

Step 3: AP turnover = 3,300,000 ÷ 400,000 = 8.25 times.

Step 4: DPO = 365 ÷ 8.25 ≈ 44.2 days.

If most suppliers offer 45-day terms, the company is paying roughly on time. If most offer 30-day terms, it is paying about two weeks late on average, and the ageing report should be checked for overdue balances.

Using COGS instead of purchases: 3,240,000 ÷ 400,000 = 8.1, and DPO = 365 ÷ 8.1 ≈ 45.1 days. The difference is small here because inventory changed modestly, but for businesses building or running down stock it can be larger.

Worked example 2: monthly tracking

Finance teams often track DPO monthly using the last three months of purchases to reflect current behaviour:

Month	Purchases	Month-end AP
April	270,000	395,000
May	290,000	430,000
June	280,000	455,000

For June, using the three-month total purchases of 840,000 over 91 days and June's closing AP:

DPO = 455,000 ÷ 840,000 × 91 ≈ 49.3 days.

If DPO in the same quarter last year was about 42 days, the business is now taking a week longer to pay. That could be deliberate, such as negotiated longer terms, or a sign of cash pressure or slow approvals. The numbers prompt the question; the answer requires looking at the ageing report.

Interpreting the results

High AP turnover, low DPO

The business pays suppliers quickly. Possible reasons:

Short supplier terms, typical in some industries.
Taking early payment discounts.
Strong cash position.
Inefficient cash management: paying before due dates without benefit.

Low AP turnover, high DPO

The business takes longer to pay. Possible reasons:

Long negotiated terms, common for large buyers with bargaining power.
Supply chain finance programmes extending effective terms.
Cash shortages leading to late payments.
Disputed invoices or approval bottlenecks.

Compare with terms

The most useful benchmark is your own suppliers' terms. If weighted average terms are 30 days and DPO is 55, the business is paying late on average, which can damage relationships, lead to late payment charges where they apply, and in some jurisdictions breach payment practice rules. If DPO is 15 against 45-day terms, cash is leaving earlier than necessary.

Compare over time and with peers

Trends often reveal more than a single number. A steadily rising DPO without a change in terms is a warning sign. Comparisons with industry peers are useful, but differences in business models, supplier terms and definitions limit them.

DPO and the cash conversion cycle

DPO is one of three components of the cash conversion cycle (CCC):

CCC = days inventory outstanding + days sales outstanding − days payable outstanding

Longer DPO shortens the cycle, meaning less cash is tied up in working capital. Our article on accounts payable vs accounts receivable explains the cycle with a worked example.

How much cash a change in DPO releases

Cash effect ≈ daily purchases × change in DPO

For the distribution company in example 1, daily purchases are 3,300,000 ÷ 365 ≈ 9,041. Paying on terms at 45 days instead of 44.2 changes little; but if the company had been paying at 30 days against 45-day terms, moving to terms would release about 9,041 × 15 ≈ 135,600 of cash.

Worked example 3: comparing two companies

Two competing wholesalers publish these figures:

	Company X	Company Y
Cost of goods sold	12,000,000	9,500,000
Opening inventory	1,800,000	1,100,000
Closing inventory	2,000,000	1,050,000
Opening trade payables	1,500,000	700,000
Closing trade payables	1,700,000	650,000

Company X: purchases = 12,000,000 + 2,000,000 − 1,800,000 = 12,200,000. Average AP = 1,600,000. Turnover = 7.63. DPO ≈ 47.9 days.

Company Y: purchases = 9,500,000 + 1,050,000 − 1,100,000 = 9,450,000. Average AP = 675,000. Turnover = 14.0. DPO ≈ 26.1 days.

Company X takes almost three weeks longer to pay suppliers. Before concluding that X manages working capital better, an analyst would ask: does X have longer negotiated terms because of its size? Is X paying late? Does Y take early payment discounts that improve its margins? The ratio frames the question; the answer needs more information, such as disclosed payment practices, supplier terms or the AP ageing.

AP turnover for service businesses

Service businesses have little or no inventory, and their supplier spending is mostly services, rent, software and subcontractors. COGS may be small or defined differently, so a COGS-based DPO can be misleading. Better options:

Use total supplier purchases from the ledger, including services and overheads.
Or use operating expenses excluding payroll, depreciation and non-supplier costs as an approximation.

Be explicit about the definition when reporting the ratio internally, and keep it consistent over time.

Seasonality and timing effects

Businesses with seasonal purchasing, such as retailers stocking up before holidays or agricultural suppliers, can show very different DPO depending on when it is measured. A year-end balance taken just after a peak buying period may show high AP and a high DPO, while the same business might show a low DPO in a quiet month.

To handle seasonality:

Use monthly averages of AP over the year.
Compare each month with the same month last year.
Use rolling three-month purchases to calculate monthly DPO.

Payment run timing also matters. If a large payment run happens on the last day of the month, month-end AP will look low; if it happens on the first day of the next month, AP will look high. Note payment run dates when interpreting monthly figures.

Payment practice reporting

Some governments require large businesses to publish information about how quickly they pay suppliers. In the United Kingdom, for example, large companies have been required to report on payment practices and performance, including average days to pay and the proportion of invoices paid within set periods. Other jurisdictions have late payment directives or prompt payment codes. Where such rules apply, DPO is not only an internal metric but also a public one that affects reputation with suppliers. Check the rules that apply in your country.

Building a simple DPO dashboard

A monthly dashboard for finance leaders might include:

Rolling three-month DPO, with the same month last year for comparison.
Weighted average supplier terms, to compare with DPO.
Percentage of invoices paid on time, by count and by value.
AP ageing, with overdue balances highlighted.
Discounts available and taken.
Top suppliers by spend, with their terms and actual days to pay.

Together these show whether changes in DPO reflect better terms, late payment or simply timing.

What lenders and analysts look for

Consistency with terms and history. Sudden increases in DPO, especially with growing overdue balances in the AP ageing, can indicate cash stress.
Quality of earnings and cash flow. Operating cash flow boosted by stretching suppliers is less sustainable than cash flow from profits.
Evidence in the bank. Bank statements show when suppliers were actually paid. Comparing payment dates with invoice dates verifies the reported DPO. A bank statement converter makes this practical for large volumes. See our bank statement analysis guide.

Measuring actual days to pay from invoices and bank data

DPO is an average derived from balances. A more direct measure is actual days to pay: for each paid invoice, the number of days between the invoice date and the payment date, weighted by invoice value.

Worked example

A small manufacturer exports its paid invoices for the quarter from the accounting system and converts its bank statements into a spreadsheet to confirm the payment dates. A sample of the results:

Supplier	Invoice date	Amount	Terms (days)	Payment date on bank statement	Days to pay
Steel Co	3 Jan	24,000	45	20 Feb	48
Packaging Ltd	10 Jan	3,600	30	6 Feb	27
Freight Co	15 Jan	5,400	14	12 Feb	28
Tools Inc	22 Jan	1,800	30	21 Feb	30

Value-weighted days to pay for these four: (24,000 × 48 + 3,600 × 27 + 5,400 × 28 + 1,800 × 30) ÷ 34,800 = (1,152,000 + 97,200 + 151,200 + 54,000) ÷ 34,800 = 1,454,400 ÷ 34,800 ≈ 41.8 days.

The analysis also reveals that Freight Co, on 14-day terms, is being paid two weeks late, and Steel Co three days late, while Packaging Ltd is paid early. This level of detail is invisible in the balance-based DPO, and it is where process improvements are found.

Ratio	Formula	Use
Days sales outstanding	Average AR ÷ credit sales × days	Customer collection speed
Days inventory outstanding	Average inventory ÷ COGS × days	Stock holding period
Cash conversion cycle	DIO + DSO − DPO	Working capital tied up
Current ratio	Current assets ÷ current liabilities	Short-term liquidity
Quick ratio	(Current assets − inventory) ÷ current liabilities	Liquidity excluding stock

DPO interacts with liquidity ratios: paying suppliers faster reduces both cash and AP, which can change the current ratio even though the business is no better or worse off.

Improving DPO the right way

Healthy ways to manage DPO:

Pay on the due date, not when invoices arrive.
Negotiate terms that reflect your volume and relationship.
Take discounts when the effective return beats your cost of capital; a 2/10 net 30 discount is worth roughly 37% a year.
Fix approval bottlenecks so invoices are ready to pay on time.
Use scheduled payment runs aligned with due dates.

Unhealthy ways:

Paying late systematically, which can harm supply, pricing and reputation, and may breach legal payment rules in some countries.
Delaying approvals deliberately.

AP turnover in different industries

Industry characteristic	Typical effect on DPO
Large retailers with bargaining power	Often longer DPO
Small businesses buying from larger suppliers	Often shorter DPO
Perishable goods supply chains	Often shorter terms
Construction with staged payments	Varies with contract terms
Businesses with supply chain finance	Longer effective DPO

Because DPO depends heavily on industry norms and negotiating power, comparisons are most meaningful within the same sector and size range.

Calculating in a spreadsheet

Cell	Label	Formula
B2	Opening inventory	Input
B3	Closing inventory	Input
B4	Cost of goods sold	Input
B5	Purchases	=B4+B3-B2
B6	Opening AP	Input
B7	Closing AP	Input
B8	Average AP	=(B6+B7)/2
B9	AP turnover	=B5/B8
B10	DPO	=365/B9

For monthly tracking, keep a table of monthly purchases and month-end AP and calculate a rolling three-month DPO.

Common pitfalls

Mixing definitions: purchases in one period, COGS in another.
Including non-trade payables like accruals or taxes.
Using year-end balances only when they are unrepresentative.
Ignoring non-inventory purchases that run through AP.
Treating higher DPO as always better.
Not checking the ageing report, which shows whether a change comes from terms or from overdue invoices.

Frequently asked questions

What is the accounts payable turnover ratio?

It measures how many times a business pays off its average accounts payable balance in a period. It is calculated as credit purchases divided by average accounts payable.

How do you calculate days payable outstanding?

Divide average accounts payable by purchases (or cost of goods sold) and multiply by the number of days in the period, or divide the days in the period by the AP turnover ratio.

Is a high DPO good or bad?

It depends. A higher DPO keeps cash in the business longer, which helps working capital, but if it exceeds supplier terms it means paying late, which can damage relationships and signal financial strain.

What is the difference between AP turnover and DPO?

They measure the same thing differently. AP turnover is the number of times payables are paid off in a period; DPO is the average number of days taken to pay. DPO equals days in the period divided by AP turnover.

Why did my DPO suddenly increase?

Common reasons are a large batch of purchases near the period end, a payment run that slipped into the next period, newly negotiated longer terms, invoices stuck in approval, or cash pressure leading to late payments. Check the AP ageing report and payment run dates to find out which.

Can DPO be calculated from bank statements?

Not directly, because bank statements show payments but not invoice dates. Combine paid invoice data from your accounting system with payment dates from bank statements to calculate actual days to pay, which is more precise than balance-based DPO.

Should I use COGS or purchases to calculate AP turnover?

Purchases are more accurate because accounts payable arise from purchases. COGS is a common proxy when purchases are not available, especially in published accounts, but use the same basis consistently.

Summary

AP turnover and DPO measure how quickly a business pays suppliers. Calculate them with credit purchases and average trade payables, compare the result with supplier terms, your history and your industry, and look at the AP ageing to understand changes. Aim to pay on terms, take worthwhile discounts and avoid stretching suppliers.

To verify actual payment timing from bank records, convert statements with StatementPilot and compare payment dates with invoice due dates.