Days Payable Calculator

Calculate your Days Payable Outstanding (DPO) to see how efficiently you manage supplier payments and working capital

Days Payable Calculator — Understand how long you take to pay suppliers:

  • Calculate your Days Payable Outstanding (DPO) using the standard formula
  • Compare your payment behaviour against industry benchmarks
  • See how much working capital is preserved by your current payment terms
  • Identify opportunities to optimise cash flow without straining supplier relationships

A higher DPO generally means better cash preservation — but paying too slowly can damage supplier relationships and cost you early-payment discounts.

DPO = ( Average Accounts Payable ÷ Cost of Goods Sold ) × Number of Days in Period

Enter Your Figures

$

AP balance at the start of the period

$

AP balance at the end of the period

$

Total COGS (or total credit purchases) for the period

Time period the figures cover

Used for industry benchmark comparison

%

Annual rate used to value working capital

This calculator provides an estimate based on the information provided. Industry benchmarks are general guidance and will vary by sub-sector and region.

Understanding Days Payable Outstanding (DPO)

What is Days Payable Outstanding?

Days Payable Outstanding (DPO) is a financial ratio that measures the average number of days a company takes to pay its suppliers and vendors after receiving an invoice. It's one of the three metrics that make up the cash conversion cycle, alongside Days Sales Outstanding (DSO) and Days Inventory Outstanding (DIO, sometimes called Days on Hand).

In plain English: your DPO tells you how long you sit on invoices from suppliers before paying them. A DPO of 45 days means, on average, your suppliers wait about six and a half weeks for their money after they send you a bill.

DPO is sometimes called the payables ratio, average days payable, AP days, or accounts payable days outstanding. The formula is the same regardless of the name.

Days Payable Outstanding Formula

DPO = (Average Accounts Payable ÷ Cost of Goods Sold) × Number of Days in Period

Where: Average Accounts Payable = (Beginning AP + Ending AP) ÷ 2

And: Cost of Goods Sold = total cost of goods sold during the period (some analysts substitute total credit purchases for a purer measure)

The period is typically 365 days for annual calculations, 90 for quarterly, or 30 for monthly.

Why DPO matters

DPO is more than an accounting trivia number. It's a direct lever on your working capital:

  • Working capital preservation. Every extra day of DPO is a day your cash stays in your bank account instead of a supplier's. Stretched across annual COGS, those days add up to meaningful liquidity.
  • Supplier relationship signal. DPO that drifts well above industry norms flags you as a slow payer. Suppliers may tighten terms, demand deposits, charge interest under legislation like the UK Late Payment of Commercial Debts Act or the EU Late Payment Directive, or deprioritize you when supply is short.
  • Early-payment discount math. If a supplier offers 2/10 net 30, paying at day 30 costs you a 2% discount — equivalent to an annualized cost of around 37%. The Early Payment Discount Calculator can run the math on whether extending DPO is actually worth it against specific discount terms.
  • Cash flow forecasting. Knowing your average payment lag makes short-term cash forecasts far more accurate.
  • Benchmark visibility. Lenders and investors look at DPO alongside DSO and inventory days when assessing working capital efficiency.

A worked DPO example

Say a wholesale distributor has the following figures for the year:

Beginning Accounts Payable $180,000
Ending Accounts Payable $220,000
Average Accounts Payable ($180,000 + $220,000) ÷ 2 = $200,000
Cost of Goods Sold (annual) $1,825,000
Days in Period 365
DPO ($200,000 ÷ $1,825,000) × 365 = 40 days

A DPO of 40 days sits roughly in the middle of the typical wholesale range, so this business is managing its payables about as you'd expect for the sector.

Industry benchmarks for DPO

What counts as a "good" DPO depends heavily on industry. Sectors with perishable inventory and frequent supplier deliveries (food and beverage) operate on much shorter payment cycles than project-based businesses like construction, where progress billing and retention terms naturally stretch payables.

Industry Typical DPO Range Notes
Retail 30–45 days Pressure from suppliers to pay quickly; credit terms often net 30
Manufacturing 45–60 days Longer terms common for raw materials and components
Wholesale & Distribution 35–50 days Usually mirrors downstream retail payment cycles
Construction 55–75 days Progress billing and retention inflate the figure; 90+ not unusual
Technology / SaaS 40–55 days Hosting, software, and contractor invoices; generally net 30–45
Healthcare 45–65 days Supplier contracts often allow extended terms
Food & Beverage 20–30 days Perishable inventory; suppliers expect rapid settlement
Professional Services 30–45 days Lower AP base overall; dominated by subcontractors and overhead
Automotive 50–70 days Long supply chains and negotiated manufacturer terms

Ranges compiled from Hackett Group working-capital benchmarks, CFO Magazine industry studies, and REL Working Capital Survey data. Use as guidance — your specific sub-sector, supplier mix, and geographic region will shift the numbers.

How to interpret your DPO

Unlike DSO, where lower is almost always better, DPO is shaped like an upside-down U. Too low means you're paying faster than you need to. Too high means you're straining suppliers and potentially damaging your credit profile. The best DPO sits comfortably around the industry average — or modestly above it.

Low DPO Giving up cash

A low DPO usually means you're paying suppliers faster than necessary. That can signal:

  • Over-conservative AP policies (paying the day an invoice lands)
  • Strong early-payment discounts that justify fast payment
  • Cash-rich business with nowhere better to deploy the capital
  • Missed opportunity to extend terms and boost working capital

Unless early-payment discounts justify the speed, consider negotiating standard net 30 or net 45 terms with key suppliers.

High DPO Relationship risk

A high DPO — well above industry average — often signals:

  • Cash flow stress leading to intentional payment delay
  • Disorganized AP processes missing due dates
  • Disputes or credit-note backlog holding invoices up
  • Risk of supplier escalation, statutory late payment interest, or withdrawn credit terms

A rising DPO should trigger a cash flow review before it starts costing you supplier goodwill.

DPO, DSO, and DOH — the cash conversion cycle

DPO doesn't tell the whole story on its own. The three working-capital metrics work together to describe how long your business takes to turn cash outflows into cash inflows. This is the Cash Conversion Cycle (CCC):

CCC = DSO + DOHDPO

Cash Conversion Cycle = Days Sales Outstanding + Days Inventory on Hand − Days Payable Outstanding

Each component answers a different question:

Metric What it measures Direction you want
DSO (Days Sales Outstanding) How long customers take to pay you after you invoice them Lower is better
DOH (Days Inventory on Hand) How long inventory sits before being sold Lower is better (without stock-outs)
DPO (Days Payable Outstanding) How long you take to pay suppliers Higher is better (without straining relationships)

The cleanest way to shrink your cash conversion cycle is to push DSO and DOH down while holding DPO at or slightly above the industry average. A wide gap between DSO and DPO — where customers pay you far more slowly than you pay suppliers — is one of the most common working-capital traps for SMBs. The AR Turnover Calculator and Collection Efficiency Calculator are the quickest way to check whether that gap is forming in your business.

To see all three metrics combined into a single working-capital picture, run your numbers through the Cash Collection Cycle Calculator.

Strategies to optimize your DPO

Optimizing DPO isn't about paying as slowly as possible — it's about matching your payment timing to your supplier terms, preserving cash along the way, and keeping supplier relationships healthy.

Practical ways to improve DPO without damaging supplier relationships
1Negotiate longer standard terms

Most SMB suppliers default to net 30 without being asked for anything longer. A direct conversation — "we'd like to move to net 45" — often works, particularly with suppliers who value your volume. Document the new terms in writing so AP knows the schedule.

2Pay on the due date, not before

Many AP teams pay invoices as soon as they're approved. Scheduling payment for the actual due date — not earlier — can add 10–20 days to your DPO without any renegotiation. Your accounting software can automate this.

3Evaluate early-payment discounts carefully

A 2/10 net 30 discount is worth roughly 37% annualized — far more than most cost of capital. Take the discount. Skip marginal discounts (0.5/10 net 30, for example) where the math doesn't justify the cash outflow. Use the Early Payment Discount Calculator to evaluate each supplier's terms.

4Automate invoice processing

Paper invoices, manual data entry, and email bottlenecks cause invoices to slip past due dates unintentionally. A modern AP workflow — OCR capture, automated approvals, scheduled payments — eliminates most accidental late payments while letting you pay deliberately on the due date.

5Segment suppliers by strategic importance

Not every supplier deserves the same treatment. Critical suppliers with few alternatives should be paid on time every time. Commodity suppliers with flexible terms are where you extend. Categorize your AP ledger once, then apply rules.

6Resolve disputes faster

Disputed invoices often sit in AP limbo for weeks, inflating DPO artificially and damaging supplier trust. A clear dispute workflow — flagged within 48 hours, owned by a named person, resolved within 5 business days — keeps DPO clean and honest. Pair this with an AR aging review on your own receivables so disputes don't cascade in both directions.

Calculating DPO in Excel

You can track DPO directly in Excel or Google Sheets using a straightforward formula:

Excel formula for DPO
=((Beginning_AP + Ending_AP)/2)/(COGS/Days_in_Period)

With typical spreadsheet cell references:

  • Beginning AP in cell A2
  • Ending AP in cell B2
  • COGS in cell C2
  • Days in Period (e.g. 365) in cell D2

The Excel formula becomes:

=((A2+B2)/2)/(C2/D2)

For a monthly DPO tracker, duplicate the row for each period and chart the output to watch trends over time. A DPO that's creeping up month over month is often the earliest warning sign of a cash flow problem.

Your DPO is half the story. What about your DSO?

Most businesses focus hard on paying suppliers on time — and far less on making sure their own customers do the same. Paidnice automates late fees, payment reminders, and escalations on Xero and QuickBooks so your DSO shrinks to match the working-capital discipline you already bring to your payables. Paidnice customers see an average 25% reduction in DSO. Curious what that's worth to your business? Try the Paidnice ROI Calculator.

See how Paidnice works →

Frequently Asked Questions

How do you calculate days payable?

To calculate days payable, use the standard Days Payable Outstanding (DPO) formula:

DPO = (Average Accounts Payable ÷ Cost of Goods Sold) × Number of Days in Period

The steps:

  1. Add your beginning and ending accounts payable for the period, then divide by 2 to get your average accounts payable.
  2. Find your cost of goods sold (COGS) for the same period. Some analysts use total credit purchases instead, which is more precise but harder to isolate in most accounting systems.
  3. Divide average AP by COGS.
  4. Multiply the result by the number of days in the period — typically 365 for annual, 90 for quarterly, or 30 for monthly.

The output is the average number of days your business takes to pay suppliers after receiving an invoice.

What is the DPO formula?

The DPO formula is:

DPO = (Average Accounts Payable ÷ COGS) × Days in Period

You'll also see it written in an equivalent form:

DPO = Average Accounts Payable ÷ (COGS ÷ Days in Period)

Both produce the same result. The second form is useful when you already have daily COGS calculated.

For a quick sanity check: if your average AP is roughly 10% of your annual COGS, your DPO is about 36 days (10% of 365). The ratio translates directly into days.

How do you work out DPO?

Working out DPO takes three pieces of information from your financial statements:

  1. Accounts payable balances at the start and end of the period (from the balance sheet)
  2. Cost of goods sold for the period (from the income statement)
  3. Number of days in the period (365 for annual, 90 for quarterly, 30 for monthly)

Plug these into the DPO formula — (Average AP ÷ COGS) × Days — and you have your number. Most accounting platforms including Xero and QuickBooks will give you the underlying figures in a single report.

For a shortcut, use our Days Payable Calculator at the top of this page, or run it alongside the DSO Calculator to see both sides of your working capital in one sitting.

What is DSO, DOH, and DPO?

DSO, DOH, and DPO are the three working-capital metrics that make up the cash conversion cycle:

  • DSO (Days Sales Outstanding) — the average number of days it takes your customers to pay you after you invoice them. Lower is better. Typical range: 30–60 days.
  • DOH (Days on Hand), also called DIO (Days Inventory Outstanding) — the average number of days inventory sits before being sold. Lower is better, within the constraints of avoiding stock-outs. Typical range varies wildly by industry, from ~20 days (food) to 120+ days (furniture).
  • DPO (Days Payable Outstanding) — the average number of days you take to pay suppliers after they invoice you. Higher is generally better (more cash preserved), but only up to the point where it strains supplier relationships.

The three combine as: Cash Conversion Cycle = DSO + DOH − DPO. A shorter cash conversion cycle means faster cash recycling — which directly improves liquidity, reduces reliance on external financing, and frees up capital for growth. The Cash Collection Cycle Calculator brings all three metrics into a single view.

How do I calculate how many days DPO I am?

To calculate how many days DPO you are running, you need three numbers from your accounting records:

  • Your average accounts payable balance for the period (beginning AP + ending AP, divided by 2)
  • Your cost of goods sold for the same period
  • The number of days in the period

Then apply the DPO formula: DPO = (Average AP ÷ COGS) × Days in Period.

A worked example: if your average AP is $50,000, your annual COGS is $500,000, and the period is 365 days, your DPO is ($50,000 ÷ $500,000) × 365 = 36.5 days. That's the average number of days you're taking to pay suppliers.

For ongoing tracking, calculate DPO monthly — the trend matters more than any single data point.

What is the DPO method?

The DPO method refers to the standard accounting approach for measuring how long a business takes to pay its suppliers. It's a universally accepted metric in corporate finance and is reported in virtually every annual report, lender credit review, and working-capital analysis.

The method has three core elements:

  1. Average accounts payable rather than a spot balance, to smooth out timing effects at period boundaries
  2. Cost of goods sold as the denominator, representing the underlying supplier spend (or total credit purchases, for a more precise calculation)
  3. A time-period multiplier to convert the ratio into days

Some analysts use a slightly different approach — substituting total purchases for COGS, or using ending AP instead of average AP. These variants produce slightly different numbers, but the standard DPO method using average AP and COGS is the most widely reported and the version you'll find on Bloomberg, S&P, and most financial databases.

What is a good DPO in finance?

A good DPO depends heavily on industry, but some general rules apply:

  • Below 20 days — you're probably paying faster than necessary. Unless you're capturing meaningful early-payment discounts, consider extending.
  • 30–50 days — healthy range for most sectors, aligning with standard net 30 and net 45 supplier terms.
  • 50–70 days — optimal for industries with longer natural payment cycles (manufacturing, construction, healthcare) and for businesses that have successfully negotiated longer terms.
  • Above 75 days — entering supplier-risk territory for most industries. Check whether this reflects negotiated terms or slipping payments.

The best approach is to benchmark against your specific industry rather than chase an absolute number. A DPO of 60 days is excellent for a construction business and alarming for a food distributor.

What is the difference between DPO and accounts payable turnover?

DPO and accounts payable turnover are two ways of expressing the same underlying relationship — how quickly a business pays its suppliers — just measured in different units.

Accounts Payable Turnover Days Payable Outstanding
Expressed as a frequency (how many times AP is paid and replaced per year) Expressed as a time period (average days to pay)
Formula: COGS ÷ Average AP Formula: (Average AP ÷ COGS) × Days in Period
Higher turnover = faster payment Higher DPO = slower payment

The relationship is: DPO = Days in Period ÷ AP Turnover.

An AP turnover of 9 corresponds to a DPO of about 40 days (365 ÷ 9). Both metrics are valid — pick the one that communicates more clearly to your audience. Most CFOs work in DPO because time in days is more intuitive than turnover counts. The same logic applies on the receivables side — see the AR Turnover Calculator for the mirror metric on customer payments.

How does DPO affect cash flow?

DPO has a direct, linear effect on cash flow. Every additional day of DPO means one more day your cash stays in your bank account rather than moving to a supplier.

A simple way to quantify it: if your annual COGS is $1.2 million, your daily COGS is about $3,300. Extending DPO by 10 days adds roughly $33,000 to your working capital — permanently, as long as the longer payment cycle is sustained.

That said, there are two caveats:

  • It's one-time. The working-capital benefit is realized when DPO extends, not continuously. Once you're stable at the new DPO, the benefit becomes part of your ongoing cash base.
  • Early-payment discounts can outweigh it. A 2% discount for paying 20 days early is often worth more than the cost of the capital you're giving up. Run the numbers on each supplier's terms using the Early Payment Discount Calculator before blanket-extending.

For a complete working-capital view, pair your DPO analysis with DSO and inventory days — see the Cash Collection Cycle Calculator for the full picture.