Days Payable Outstanding Calculator

Last reviewed 13 August 2026

Work out how many days you take to pay suppliers, using cost of goods sold or credit purchases, then see the result against your sector and what each extra day of terms is worth in cash.

Days payable outstanding is the average number of days you take to pay a supplier after their invoice arrives. Divide average accounts payable by cost of goods sold for the period, then multiply by the days in that period.

DPO = (Average Accounts Payable / Cost of Goods Sold) x Days in Period

Example: $200,000 average payables, $1,825,000 cost of goods sold, 365 days. 200,000 / 1,825,000 = 0.1096, and 0.1096 x 365 = 40 days.

Calculate your DPO

Your payables balances and cost of goods sold. Two other denominators are below if your accounts give you a purchases figure.

$

Payables cannot be negative.

$

Payables cannot be negative.

$

Enter cost of goods sold above zero.

Use a different denominator

Key takeaways

  • Days payable outstanding is the average number of days you take to pay a supplier.
  • DPO = (average accounts payable / cost of goods sold) x days in the period.
  • Use trade payables only. Accruals, payroll and tax can add 20 days to the figure.
  • DPO is the one working capital metric where higher is better, up to your agreed terms.
  • Each day of DPO is worth one day of your cost of goods sold in cash.

Your days payable outstanding

40 days

0254575100+

Conservative. There is usually room to extend. The Paidnice customer data benchmark for wholesale and distribution is 42.5 days.

Average accounts payable$200,000
Daily cost through payables$5,000
Payables turnover9.1x
Cash held by 10 more days$50,000
Value of those 10 days, per year$4,000
Value of your whole float, per year$16,000
Benchmark for your sector35 to 50 days, midpoint 42.5 (Paidnice customer data)
Gap to that benchmark2.5 days below
Cash if you matched that benchmark$12,500 freed up

Paidnice works on the other side of this equation

Paidnice works the other side of the cycle, chasing what your customers owe you.

No card required.

What days payable outstanding actually tells you

Days payable outstanding turns your supplier balance into a single number: the average number of days between a supplier invoice arriving and the money leaving your account.

It is the mirror image of DSO. Where DSO measures the credit you extend to customers, DPO measures the credit your suppliers extend to you.

That credit is free, it needs no facility and nobody underwrites it. Every day of DPO is a day your cash sits in your account instead of a supplier's.

Three readers care about it, for three reasons:

  • Finance uses it to forecast the outflow side of cash.
  • A lender reads it beside DSO and inventory days, to see whether your working capital is funded by operations or by stretching people.
  • An acquirer reads payables climbing faster than purchases as cash managed by delay rather than by collection. That is a quality of earnings problem, not an efficiency win.

The quick version. Take your average payables balance and divide it by what you spend per day. If you buy $5,000 of goods a day and $200,000 sits unpaid, you are taking about 40 days to pay.

The formula, part by part

The formula has four inputs, and each one has a standard way of going wrong: DPO = (Average Accounts Payable / Cost of Goods Sold) x Days in Period.

1
Average accounts payable

Opening balance plus closing balance, divided by two. Use the average rather than the closing balance, otherwise a big delivery invoiced in the last week of the period drags the whole result upward.

2
Trade payables only

Strip out accruals, payroll liabilities, tax payable and loan balances. Only supplier invoices belong in the numerator. Taking the whole current liabilities line inflates the result, sometimes by 20 days or more.

3
Cost of goods sold, or credit purchases

Cost of goods sold is what everyone publishes, so it is the default. Credit purchases is the more correct denominator, because payables come from buying, not from selling. Pick one and keep it.

4
Days in the period

365 for a year, 90 or 91 for a quarter, 28 to 31 for a month. Use the real count. A 90 day assumption applied to a 92 day quarter puts about 2 percent of error into the answer before you start.

A worked example

A wholesale distributor opens the year with $180,000 in trade payables and closes with $220,000. Cost of goods sold for the year is $1,825,000.

  • Average payables: (180,000 + 220,000) / 2 = $200,000
  • Divide by cost of goods sold: 200,000 / 1,825,000 = 0.1096
  • Multiply by days in the period: 0.1096 x 365 = 40 days

Daily cost through payables is 1,825,000 / 365 = $5,000, so each day of DPO is worth $5,000 of cash.

Moving from 40 days to 50 keeps about $50,000 in the account permanently. At an 8 percent cost of capital that is worth roughly $4,000 a year, which is both the commercial case for negotiating terms and the size of the prize to weigh against the supplier goodwill you spend getting there.

How to read your number

Unlike DSO, where lower is almost always better, DPO reads as an upside down U. Too low and you hand cash over earlier than the terms require. Too high and you finance yourself with somebody else's patience.

The healthy zone sits at or slightly above your sector norm, and it should come from terms you agreed rather than payments you delayed.

Very fast

Under 25 days

You are paying ahead of terms. Worth it only if you are taking early payment discounts.

Conservative

25 to 45 days

Safe, and there is usually room to extend terms without any friction at all.

Optimal

45 to 75 days

Where most well run businesses sit. Terms are being used, not abused.

Supplier risk

Over 75 days

You are relying on patience. Expect tighter terms, deposits or statutory interest.

Direction matters as much as level. A DPO of 55 days that has been stable for two years is a negotiated position. The same 55 days after a climb from 35 in six months is usually a cash flow symptom, and your suppliers will have noticed before your board does.

Days payable benchmarks by sector

Two sets of figures sit below, and they are kept apart because they describe different businesses. The first is our own customer data, from small businesses running Xero and QuickBooks. The second is published data on listed companies. Every row says which set it belongs to.

Paidnice customer figures, small businesses on Xero and QuickBooks

SectorTypical DPOMidpointWhy
Construction 55 to 75 days 65 days Progress billing and retentions stretch the figure, 90 plus is not unusual
Automotive 50 to 70 days 60 days Long supply chains and negotiated manufacturer terms
Healthcare 45 to 65 days 55 days Supplier contracts often allow extended terms
Manufacturing 45 to 60 days 52.5 days Longer terms on raw materials and components
Technology and SaaS 40 to 55 days 47.5 days Hosting, software and contractor invoices, mostly net 30 to 45
Wholesale and distribution 35 to 50 days 42.5 days Tends to mirror the downstream retail payment cycle
Retail 30 to 45 days 37.5 days Suppliers push for fast settlement, terms usually net 30
Professional services 30 to 45 days 37.5 days Small payables base, mostly subcontractors and overhead
Food and beverage 20 to 30 days 25 days Perishable stock, suppliers expect rapid settlement

Source: Paidnice customer data, August 2026.

Published figures, US listed companies

IndustryDPOWhy
Electronics (general) 81 days Component suppliers carry the terms across long build cycles
Retail (general) 65 days Buying scale converts directly into supplier terms
Auto parts 60 days Long supply chains and negotiated manufacturer terms
Machinery 58 days Longer terms on raw materials and components
Healthcare products 57 days Supplier contracts often allow extended terms
Retail (distributors) 55 days Trade credit on both sides of the transaction
Engineering and construction 43 days Subcontractor and materials invoices, paid against progress claims
Business and consumer services 37 days Small payables base, mostly subcontractors and overhead
Retail (grocery and food) 29 days Perishable stock, suppliers expect rapid settlement

Your days payable against every benchmark

Your bar moves as you type. The highlighted row is the sector selected in the calculator.

Your DPO 40 days

Paidnice customer data, small businesses

Construction 65 days
Automotive 60 days
Healthcare 55 days
Manufacturing 52.5 days
Technology 47.5 days
Wholesale 42.5 days
Retail 37.5 days
Prof. services 37.5 days
Food and bev 25 days

NYU Stern, listed companies

Electronics 81 days
Retail 65 days
Auto parts 60 days
Machinery 58 days
Healthcare 57 days
Distributors 55 days
Construction 43 days
Services 37 days
Grocery 29 days

Source, listed company table. Each figure is derived from two datasets published by Aswath Damodaran, NYU Stern School of Business, both as of January 2026: Working Capital Requirements by Industry Sector, which gives accounts payable as a percent of revenue, and Margins by Sector, which gives cost of goods sold as a percent of revenue. Dividing the first by the second and multiplying by 365 is the standard accounts payable over cost of goods sold calculation, so you can reproduce any row from the two source tables. Industry names and sample sizes are his.

Read those as large company figures. The sample is listed companies, which negotiate harder terms than a small business gets. The same calculation across the whole market excluding financials gives 63 days, and The Hackett Group's 2025 Working Capital Survey put DPO at 59 days for the 1,000 largest US listed companies. Reviewed 15 August 2026.

Only the Paidnice table carries a range. The NYU dataset publishes one aggregate figure per industry rather than quartiles, so a range for those rows would have been invented.

The two sets disagree, and that is the useful part. Retail pays suppliers in 65 days on the listed company data and 30 to 45 days in ours. A listed retailer buys at a volume that converts directly into terms. A small business rarely has that leverage, so the Paidnice row is the closer comparison if you run one. Neither set is wrong. They describe different sides of the same negotiation.

A benchmark is not a goal. If your suppliers trade on net 30 and the benchmark is 55 days, hitting 55 means paying 25 days late every time. The NYU figures come from listed companies that negotiated the terms they use. Benchmark against the terms you actually agreed first, and treat either table as a sense check on those terms.

The three methods, and when to use each

All three are accepted. They differ only in the denominator, and the gap between them widens as your inventory moves.

MethodDenominatorBest forWeakness
Cost of goods soldCOGS for the periodReporting, comparison against published accountsIgnores inventory movement, so it drifts when stock builds
Credit purchasesPurchases on creditThe most accurate read of supplier payment behaviorMost accounting systems do not report it directly
Derived purchasesCOGS + closing inventory - opening inventoryBusinesses whose stock level changed materiallyInherits any inventory valuation error

In the worked example above, a stock build from $300,000 to $375,000 means the business bought $1,900,000 of goods while only $1,825,000 passed through cost of goods sold. On purchases, the same $200,000 payables balance gives 38.4 days rather than 40.

That gap is small here. In a business that doubles its inventory in a year it can be ten days or more, and always in the direction that flatters the cost of goods sold version.

What pushes days payable outstanding the wrong way

Before you read a moving number as a policy change, check which of these is driving it. Two of the four are accounting effects rather than payment behavior.

  • Disputes sitting unresolved. A queried invoice ages in the ledger and inflates DPO without any cash benefit, while the supplier records you as a late payer. This is the worst of both outcomes.
  • Payment runs that are too infrequent. A single monthly run adds up to 15 days of average delay on its own. Twice monthly halves that, and it is a scheduling change rather than a negotiation.
  • An inventory build. If you bought hard near period end, payables rise while cost of goods sold does not. The cost of goods sold method reads this as slower payment when nothing about your payment behavior changed.
  • Cash flow stress. The one that matters. Deliberate delay because the money is not there shows up as a rising DPO, and it is usually accompanied by a rising DSO, which is where the actual problem started.
Working on the other side of the cycle?

Paidnice does not manage payables, but it does collect your own invoices faster, which improves the same cash conversion cycle without leaning on suppliers.

Try the DSO calculator

How to improve your days payable outstanding

Improving DPO is not paying as slowly as possible. It is taking the terms you are entitled to, using all of them, and never taking more without asking.

  1. Pay on the due date, not on the approval date. Scheduling payment for the actual due date typically adds 10 to 20 days of DPO with no renegotiation and no relationship cost. Most accounting software will do this for you.
  2. Ask for longer standard terms. Most suppliers default to net 30 because nobody asked for anything else. A direct request to move to net 45 usually lands with suppliers who value your volume. Get it in writing so accounts payable works to the right schedule.
  3. Price every early payment discount. A 2/10 net 30 discount is worth roughly 37 percent annualized, far above any cost of capital, so take it. A 0.5 percent discount for paying 20 days early is not. Run each set of terms through the early payment discount calculator.
  4. Move to at least two payment runs a month. Fewer runs increase average delay, which flatters DPO but pushes individual invoices past their due date. Two runs let you pay on time and still use the full term.
  5. Segment your suppliers. Critical suppliers with no alternative get paid on time, every time. Commodity suppliers with flexible terms are where you extend. Categorize the ledger once, then apply the rule.
  6. Resolve disputes within five working days. Flag within 48 hours, assign a named owner, close within a week. This keeps the number honest and stops a small query becoming a 90 day balance.
  7. Fix the collection side at the same time. A payables stretch buys days once. Faster collection produces the same working capital improvement every month, and no supplier can withdraw it.

To be direct about that last point: Paidnice does not manage accounts payable. It works on receivables.

Automated email and SMS reminders chase your customers on a schedule, customer statements go out without anyone remembering, and AR reporting keeps the aging picture visible. If your DPO is high because cash is tight, that is the end of the cycle worth fixing.

DPO, DSO and DOH: the cash conversion cycle

DPO on its own covers one leg of your working capital. The three metrics together describe how long your money is out of the business:

Cash Conversion Cycle = DSO + DOH - DPO

It is the only formula in working capital that carries a minus sign, and that sign is the whole reason DPO is the metric where higher is better.

MetricWhat it measuresDirection you want
DSOHow long customers take to pay you after you invoiceLower
DOHHow long stock sits before it sellsLower, without stock outs
DPOHow long you take to pay suppliersHigher, without straining suppliers

The cleanest way to shorten the cycle is to push DSO and DOH down while holding DPO at or slightly above your sector norm.

The common trap runs the other way: customers take 60 days to pay you and you pay suppliers in 30, so you fund both sides of the trade. Run all three figures through the cash conversion cycle calculator, and the DSO calculator to check whether collection is the half costing you.

Calculating days payable outstanding in Excel

Put opening payables in A1, closing payables in A2, cost of goods sold in B1 and the day count in C1.

  • Basic DPO: =(AVERAGE(A1:A2)/B1)*C1
  • Written out without the AVERAGE function: =((A1+A2)/2)/(B1/C1)
  • Derived purchases, with opening inventory in D1 and closing inventory in D2: =B1+D2-D1
  • Rolling twelve month, month end payables in B2:B13 and monthly cost of goods sold in C2:C13: =(AVERAGE(B2:B13)/SUM(C2:C13))*365
  • Accounts payable turnover from the same cells: =B1/AVERAGE(A1:A2)
  • Cash value of one extra day: =B1/C1

Copy the row for each month and chart the output. A DPO creeping up two or three days every month, with no terms renegotiation behind it, is one of the earliest cash flow warning signs you can get from your own ledger.

Check the numerator before you trust the trend. If your payables export includes accruals or tax liabilities, the number will look 10 to 20 days higher than reality and it will move every quarter for reasons that have nothing to do with suppliers. Filter to trade creditors first.

Days payable against the other working capital metrics

DPO answers how long you hold on to supplier money. These answer the rest of the cycle.

MetricQuestion it answersUnit
Days payable outstandingHow many days until we pay suppliersDays
DSOHow many days until customers pay usDays
Inventory days on handHow long stock sits before it sellsDays
Cash conversion cycleTotal days from paying suppliers to banking cashDays
AR turnoverHow many times receivables convert per yearRatio
Early payment discountWhether paying early beats keeping the cashPercent

Read DPO next to DSO and the picture resolves quickly. If DSO is 55 and DPO is 30, you are financing your customers and your suppliers at the same time. If DSO is 30 and DPO is 55, your suppliers are financing you, and the question becomes whether they agreed to it.

Common mistakes

  • Using total current liabilities instead of trade payables. Accruals, payroll and tax do not belong in the numerator. This one error can add 20 days.
  • Using the closing balance instead of the average. Makes the figure jump whenever a large delivery is invoiced near period end.
  • Switching between cost of goods sold and purchases between periods. The change in method will look like a change in behavior. It is not a trend.
  • Treating a high figure as an achievement. A high DPO caused by disputes, lost invoices or missing cash is a problem wearing the costume of an efficiency win.
  • Chasing a benchmark past your agreed terms. Beyond terms you are not optimizing working capital, you are late, and in the UK and EU that carries a statutory interest entitlement for the supplier.
  • Reading one month in isolation. Monthly DPO swings on the timing of a single payment run. Three points make a trend.

Sources

  • Paidnice customer data, reviewed 15 August 2026. The sector table headed "Paidnice customer figures" only. Drawn from our own customers' Xero and QuickBooks ledgers. It is not a survey and carries no published sample size.
  • Aswath Damodaran, NYU Stern School of Business, Working Capital Requirements by Industry Sector, data as of January 2026. Accounts payable as a percent of revenue, plus the industry names and sample sizes.
  • Aswath Damodaran, NYU Stern School of Business, Margins by Sector, data as of January 2026. Cost of goods sold as a percent of revenue, which converts the ratio above into days.
  • The Hackett Group, 2025 Working Capital Survey. DPO of 59 days across the 1,000 largest US listed non financial companies, which is the independent check on the derivation above.
  • US Census Bureau, Quarterly Financial Report, trade payables and cost of goods sold by industry sector.

Sources are cited for the benchmark figures only. Everything else on this page is computed from the figures you enter. Reviewed 15 August 2026.

Frequently asked questions

How do you calculate days payable outstanding?

Divide your average accounts payable by your cost of goods sold for the period, then multiply by the number of days in that period. Days payable outstanding = (Average Accounts Payable / Cost of Goods Sold) x Days in Period. Average accounts payable is your opening payables balance plus your closing balance, divided by two. Use 365 days for a year, 90 or 91 for a quarter and the real day count for a month.

What is the payable days formula?

The payable days formula is DPO = (Average Accounts Payable / Cost of Goods Sold) x Days in Period. Some analysts swap cost of goods sold for total credit purchases, which is the purer version because payables are created by purchases rather than by sales. Both are accepted. What matters is that you use the same denominator every period, or your trend is meaningless.

How do you calculate accounts payable days?

Accounts payable days and days payable outstanding are the same measure. Take your opening and closing payables balances, average them, divide by cost of goods sold for the period, then multiply by the days in the period. For a quick monthly read, divide average payables by daily cost of goods sold instead. Both routes give the same answer because daily cost is just cost of goods sold divided by the day count.

How do you calculate accounts payable?

Accounts payable is the total of supplier invoices you have received but not yet paid, taken from the balance sheet at a point in time. To build it from movements: opening payables plus credit purchases in the period, minus payments made to suppliers, equals closing payables. Average accounts payable, the figure the days payable formula needs, is the opening balance plus the closing balance divided by two.

Should the accounts payable days calculation use COGS or credit purchases?

Credit purchases is the more accurate denominator, because payables arise from what you bought, not from what you sold. Cost of goods sold is used far more often simply because it is published in every set of accounts. If your inventory level moved a lot during the period, the two answers will differ. Derive purchases as cost of goods sold plus closing inventory minus opening inventory.

What is a good days payable outstanding?

There is no universal figure. Read it against your supplier terms first, then your sector. As a working rule, under 25 days usually means you are paying earlier than you need to, 25 to 45 days is conservative, 45 to 75 days is where most well run businesses sit, and beyond 75 days you are relying on supplier patience. Sector matters, and so does your size. In Paidnice customer data, reviewed August 2026, food and beverage runs 20 to 30 days and construction 55 to 75. On published figures for US listed companies, grocery and food retail runs near 29 days and electronics near 81.

How do you calculate days payable outstanding in Excel?

Put opening payables in A1, closing payables in A2, cost of goods sold in B1 and the day count in C1, then enter =(AVERAGE(A1:A2)/B1)*C1. To use purchases instead of cost of goods sold, put purchases in B1. For a rolling twelve month view with month end payables in B2:B13 and monthly cost of goods sold in C2:C13, use =(AVERAGE(B2:B13)/SUM(C2:C13))*365.

What is the difference between DPO and accounts payable turnover?

They are the same relationship in different units. Accounts payable turnover counts how many times you clear your payables balance in a year, while days payable outstanding converts that into days. Turnover equals cost of goods sold divided by average accounts payable, and days payable outstanding equals 365 divided by that turnover figure. A turnover of 9 is a DPO of about 41 days.

How do you calculate days payable outstanding for a quarter or a month?

Use the same formula with the real day count. Quarterly DPO = (Average Accounts Payable for the quarter / Cost of Goods Sold for the quarter) x 91. Monthly DPO uses 28 to 31 days. Short periods swing hard on the timing of a single payment run, so read three or four consecutive months as a trend rather than reacting to one reading.

Can days payable outstanding be too high?

Yes. Past about 75 days you are usually paying beyond agreed terms rather than negotiating better ones. The costs are real: suppliers can withdraw credit terms, ask for deposits, raise prices quietly or charge statutory late payment interest. A high figure caused by disputes and lost invoices is worse again, because it damages the relationship without giving you any deliberate cash benefit.

How does DPO affect the cash conversion cycle?

The cash conversion cycle is DSO plus DOH minus DPO, so every extra day of days payable outstanding removes a day from the cycle. That is why DPO is the one working capital metric where higher is better. The catch is that it improves your cycle using supplier money. Cutting DSO improves the same cycle using your own collection process, which nobody can withdraw.

Related calculators

Stop chasing invoices.
Start getting paid.

Paidnice is accounts receivable automation that enforces your payment terms, trusted by thousands of businesses on Xero and QuickBooks. Credit control and debtor management, run for you.