Articles

How do you calculate days payable outstanding (DPO)?

Divide trade payables by annual purchases and multiply by 365. The hard part is choosing the payables balance and the denominator, and reading the result against terms.

Days payable outstanding is trade payables / annual purchases x 365. On one fictional manufacturer, the same payables give 42.1 days on cost of goods sold, 40.9 days on average payables and 48.0 days on the spend that actually passes through accounts payable. Against spend-weighted terms of 33.4 days, the last figure shows a company paying late.

Worked in full in The Accounts Payable Handbook by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback

The company

The case is a fictional machined-parts maker, Marlow Precision Products, with revenue of $186,000,000 in 2026, cost of goods sold of $128,340,000 and $112,600,000 of third-party spend paid through accounts payable. Trade payables were $13,960,000 at 31 December 2025 and $14,820,000 at 31 December 2026.

Step 1: pick the payables balance

Use trade accounts payable: amounts owed to suppliers for goods and services received and invoiced. Leave out accrued liabilities, payroll, taxes and debt. A closing balance is simple; an average of opening and closing smooths growth. Marlow's average is $14,390,000.

Step 2: pick the denominator

Purchases are rarely published, so analysts substitute cost of goods sold. Inside the company, the better denominator is AP spend, because it is the flow that creates the payables.

Three DPO figures for one company, 2026
VersionPayablesDenominatorDPO (days)
Closing payables, cost of goods sold14,820,000128,340,00042.1
Average payables, cost of goods sold14,390,000128,340,00040.9
Closing payables, AP spend14,820,000112,600,00048.0

Cost of goods sold contains labor, overhead and depreciation that never pass through AP, and leaves out services and freight booked to operating expenses that do. That is why the figures differ. Pick one definition and keep it: a DPO that improves because the formula changed is not an improvement.

Step 3: compare with terms

A company paying exactly on terms has a DPO close to its spend-weighted terms, or slightly below them, since invoices entered late sit in accruals rather than in trade payables. Marlow's spend by terms gives a weighted average of 33.4 days:

Spend by payment terms, 2026
TermsSpend
2/10 net 3018,400,000
1/10 net 452,600,000
Net 3062,000,000
Net 4514,200,000
Net 609,800,000
Due on receipt5,600,000
Total112,600,000

DPO on AP spend is 48.0 days, almost 15 days above terms. At year-end, $1,778,400 of payables, 12% of the total, were past due. The gap was late payment and slow invoice processing, not negotiating skill.

One day of DPO on Marlow's AP spend is worth $308,493.15 of cash (112,600,000 / 365). That is the temptation to stretch, and the reason to measure it carefully.

Step 4: release cash the right way

Paying late costs discounts, invites credit holds and moves a company to the back of the queue when capacity is short. Agreed terms are different. Moving 40% of Marlow's net 30 spend, $24,800,000, to net 45 releases $24,800,000 x 15 / 365 = $1,019,178.08 once, without a single late payment. Discounts worth more than the cost of funds should still be taken: 2/10 net 30 is worth 37.24% a year against a 7.25% credit line.

Takeaway

Free Excel template: Accounts Payable Workbook (three-way match, discounts, DPO, accruals, duplicates, Form 1099 and the automation case).

Also on this site: the three-way match, worked · finding duplicate payments.

Questions readers ask

What is a good DPO?

One close to the terms the company has agreed with its suppliers, measured consistently. A DPO well above weighted terms usually means late payment, which costs discounts and supplier goodwill.

Should DPO use cost of goods sold or purchases?

Purchases are more accurate, and inside a company the spend paid through accounts payable is the best measure. Cost of goods sold is used for comparing companies from published statements.

Do accrued liabilities count in DPO?

Usually not. DPO uses trade accounts payable. Accruals such as goods received not invoiced can be added if the denominator is built the same way, but the definition must be fixed and kept.

Does a supplier finance program change DPO?

It can lengthen DPO if terms are extended. Lenders and rating agencies may treat program balances as debt-like, and US GAAP requires disclosure of the program and a roll-forward of confirmed obligations.

Sources: IRS instructions for Forms 1099, Nacha Operating Rules, FASB ASU 2022-04 (as cited in the text). Figures computed by the author's model and checked on 18 November 2026. Education only, not accounting, legal or tax advice.

Read the whole case

This article is one calculation from The Accounts Payable Handbook. The book follows one AP team through a year, from the purchase order to the 1099 season, and every figure it prints is a live formula in the free workbook.

Get the PDF edition, $19.99 Paperback · Free companion files