---
title: "Days Payable Outstanding Calculator: DPO Formula + Benchmarks"
description: "Free days payable outstanding calculator. Work out DPO from COGS or credit purchases, see the result against sector benchmarks, and price what each extra day of payment terms is worth."
url: https://www.paidnice.com/calculators/days-payable-calculator
---

# 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.

Opening accounts payable
$

Payables cannot be negative.

Closing accounts payable
$

Payables cannot be negative.

Cost of goods sold for the periodThe published denominator. Use it when you do not have a purchases figure.
$

Enter cost of goods sold above zero.

Use a different denominator

Credit purchases for the periodThe purer denominator. Payables are created by what you bought, not by what you sold.
$

Enter credit purchases above zero.

Purchases = cost of goods sold + closing inventory - opening inventory. Use this when stock levels moved during the period.

Cost of goods sold for the period
$

Opening inventory
$

Closing inventory
$

Derived purchases came out at zero or below. Check your inventory figures.

Derived purchases: $1,900,000

Days in period

Days in your period, 1 to 366

Enter between 1 and 366 days.

Your sectorSets the benchmark row only. It does not change your result. The two groups come from different sources.

Cost of capital, annual percentUsed to price the cash that longer terms keep in your account. Optional.

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.

Try it Now - It's Free

Book a demo

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

| Sector | Typical DPO | Midpoint | Why |
| --- | --- | --- | --- |
| 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

| Industry | DPO | Why |
| --- | --- | --- |
| 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](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wcdata.html), which gives accounts payable as a percent of revenue, and [Margins by Sector](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/margin.html), 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](https://www.thehackettgroup.com/2025-working-capital-survey-payables-rebound-receivables-inventory-lag/) 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.

| Method | Denominator | Best for | Weakness |
| --- | --- | --- | --- |
| **Cost of goods sold** | COGS for the period | Reporting, comparison against published accounts | Ignores inventory movement, so it drifts when stock builds |
| **Credit purchases** | Purchases on credit | The most accurate read of supplier payment behavior | Most accounting systems do not report it directly |
| **Derived purchases** | COGS + closing inventory - opening inventory | Businesses whose stock level changed materially | Inherits 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](https://www.paidnice.com/calculators/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](https://www.paidnice.com/email-sms-reminders) chase your customers on a schedule, [customer statements](https://www.paidnice.com/automated-customer-statements) go out without anyone remembering, and [AR reporting](https://www.paidnice.com/accounts-receivable-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.

| Metric | What it measures | Direction you want |
| --- | --- | --- |
| [DSO](https://www.paidnice.com/calculators/days-sales-outstanding) | How long customers take to pay you after you invoice | Lower |
| [DOH](https://www.paidnice.com/calculators/inventory-days-on-hand) | How long stock sits before it sells | Lower, without stock outs |
| DPO | How long you take to pay suppliers | Higher, 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](https://www.paidnice.com/calculators/cash-conversion-cycle-calculator), and the [DSO calculator](https://www.paidnice.com/calculators/days-sales-outstanding) 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.

| Metric | Question it answers | Unit |
| --- | --- | --- |
| Days payable outstanding | How many days until we pay suppliers | Days |
| [DSO](https://www.paidnice.com/calculators/days-sales-outstanding) | How many days until customers pay us | Days |
| [Inventory days on hand](https://www.paidnice.com/calculators/inventory-days-on-hand) | How long stock sits before it sells | Days |
| [Cash conversion cycle](https://www.paidnice.com/calculators/cash-conversion-cycle-calculator) | Total days from paying suppliers to banking cash | Days |
| [AR turnover](https://www.paidnice.com/calculators/accounts-receivable-turnover) | How many times receivables convert per year | Ratio |
| [Early payment discount](https://www.paidnice.com/calculators/early-payment-discount-calculator) | Whether paying early beats keeping the cash | Percent |

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](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wcdata.html), 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](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/margin.html), 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](https://www.thehackettgroup.com/2025-working-capital-survey-payables-rebound-receivables-inventory-lag/), 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](https://www.census.gov/econ/qfr/index.html), 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

Cash Conversion Cycle CalculatorCombine DSO, inventory days and payables days.Inventory Days on Hand CalculatorHow long stock sits before it sells.Invoice Factoring CalculatorThe true cost of factoring against waiting.DSO CalculatorHow many days you wait to get paid, four ways.

## Start getting paid on time with Paidnice

Connect Xero or QuickBooks and Paidnice prepares draft policies for you. Nothing runs until you approve them.

Try it FreeBook a Demo

[Rated 5 stars, 160+ reviews](https://www.paidnice.com/reviews) · [App of the Year](https://www.paidnice.com/blog/winner-xero-global-app-awards-2026)