Days Payable Outstanding Calculator - DPO and Terms

Use this days payable outstanding calculator to turn supplier payables, COGS, and period days into DPO, turnover, target gap, and payables at target.

Updated: June 7, 2026 • Free Tool

Days Payable Outstanding Calculator

Accounts payable balance at the start of the period.

Accounts payable balance at the end of the period.

COGS or comparable supplier-cost base for the same period.

Use 365 for a year, 90 or 91 for a quarter, or the exact period length.

Optional supplier term, benchmark, or internal payment-days goal.

Results

Days payable outstanding
0days
Average accounts payable $0
Payable turnover 0turns
Average daily COGS $0
Target gap 0days
Payables at target $0
Result note 0

What Is Days Payable Outstanding Calculator?

The days payable outstanding calculator estimates how many days a business takes, on average, to pay supplier obligations tied to the cost base you enter. Use it for monthly close review, supplier-term analysis, working-capital planning, covenant discussions, or cash-flow forecasting when payables timing matters. The result is most useful when accounts payable, COGS, and the period length all come from the same accounting period.

  • Month-end close: Turn beginning and ending accounts payable into a DPO result that can be compared with prior periods.
  • Supplier-term review: Compare actual payment timing with negotiated 30-day, 45-day, or 60-day terms.
  • Working-capital planning: See whether supplier credit is helping fund inventory and receivables or whether cash is leaving earlier than expected.
  • Liquidity discussion: Give finance, purchasing, and operations teams one ratio when deciding whether payment timing is sustainable.

DPO is not a payment promise and it is not a supplier scorecard by itself. It is a financial-statement ratio that converts average payables into days of cost. A higher value usually means cash stays in the business longer before suppliers are paid. A lower value usually means the business pays vendors faster or carries fewer outstanding supplier bills.

Read the result beside supplier relationships, early-payment discounts, credit holds, and the rest of the operating cycle. Stretching payables can improve short-term cash, but it can also damage supply reliability if it exceeds agreed terms or normal industry practice.

After calculating supplier-payment timing, use the Cash Conversion Cycle Calculator to combine DPO with inventory days and receivable collection days.

How Days Payable Outstanding Calculator Works

This days payable outstanding calculator uses the common DPO formula based on average accounts payable, cost of goods sold, and days in the measured period.

DPO = (average accounts payable / cost of goods sold) x period days
  • Average accounts payable: Beginning accounts payable plus ending accounts payable, divided by two. Use the payables balance connected to the cost base being analyzed.
  • Cost of goods sold: The cost assigned to goods sold during the same period. Some internal analyses use purchases when that better matches trade payables.
  • Period days: The number of days in the reporting period. Use 365 for a standard full year or the exact day count for a quarter or month.
  • Target DPO: An optional supplier term, benchmark, or internal goal used only for the target-gap and payables-at-target outputs.

The calculator also returns payable turnover, which is COGS divided by average accounts payable. DPO and payable turnover move in opposite directions: a higher turnover ratio usually means payables are being cleared more frequently, while a higher DPO means payables remain outstanding for more days.

The payables-at-target output reverses the formula. It estimates the average payables balance that would match your target DPO for the entered COGS and period length. Use that number as a planning reference, not as an instruction to delay valid supplier payments.

Annual DPO from average payables

Inputs: beginning accounts payable of $200,000, ending accounts payable of $260,000, COGS of $1,840,000, 365 period days, and a 45-day target.

Average accounts payable = ($200,000 + $260,000) / 2 = $230,000. DPO = ($230,000 / $1,840,000) x 365 = 45.63 days.

Result: DPO is 45.63 days and payable turnover is 8.00 turns.

The result is 0.63 days above the 45-day target, so the difference is small enough to investigate with actual supplier terms before drawing a broad conclusion.

According to Corporate Finance Institute days payable outstanding guide, days payable outstanding equals average accounts payable divided by cost of goods sold, multiplied by the number of days in the accounting period.

If the same review needs inventory timing, the Days Inventory Outstanding Calculator calculates the DIO component that sits beside DPO in the operating cycle.

Key Concepts Explained

These concepts help you use the calculator consistently before comparing the result with supplier terms or an industry benchmark.

Accounts payable

Accounts payable is the unpaid supplier obligation shown on the balance sheet. For DPO, use the payables balance that matches the cost base in the denominator.

Cost base

COGS is commonly used because it is widely available from income statements. Internal teams may prefer purchases when purchases better match trade payables.

Payable turnover

Payable turnover shows how many times average payables are covered by COGS during the period. It is the companion ratio to DPO.

Supplier terms

Supplier terms are the negotiated payment timing, such as net 30 or net 60. Compare DPO with terms only when the accounting period and vendor mix are comparable.

The most common mistake is treating DPO as a simple average invoice age. It is a ratio derived from financial statement totals, so it can move because payables changed, COGS changed, or the period length changed.

Seasonality matters. A retailer that builds inventory before a peak season may show a different payables pattern than it does after the season, even if supplier contracts did not change.

For the customer-payment side of the cycle, the Average Collection Period Calculator estimates how long receivables take to turn into cash.

How to Use This Calculator

Use the same reporting scope for every input, then read the DPO result with the supporting outputs.

  1. 1 Enter beginning payables: Use the accounts payable balance at the start of the period you want to analyze.
  2. 2 Enter ending payables: Use the balance at the end of the same period so the calculator can estimate average accounts payable.
  3. 3 Enter COGS: Use cost of goods sold for the same period, or a comparable supplier-cost base if you are doing internal analysis.
  4. 4 Set period days: Use 365 for a fiscal year or the exact day count for a quarter or month.
  5. 5 Add a target: Enter a supplier term or internal goal if you want a target gap and payables-at-target comparison.
  6. 6 Review the note: Check whether the result is above, below, or equal to the target before using it in a liquidity discussion.

For a quarterly purchasing review, suppose beginning payables were $120,000, ending payables were $150,000, COGS was $600,000, and the quarter had 90 days. The calculator returns 20.25 DPO days. If supplier terms are net 30, the business is paying faster than the headline term and may want to confirm whether early-payment discounts or vendor requirements explain the gap.

Benefits of Using This Calculator

DPO is useful because it turns supplier-payment timing into a number that can be compared across periods.

  • Working-capital diagnosis: DPO shows whether supplier credit is offsetting cash tied up in inventory and receivables.
  • Supplier-term comparison: The target gap helps compare actual payment timing with negotiated terms or internal policy.
  • Cash-flow planning: Average daily COGS makes one additional payable day visible as an approximate cash-timing amount.
  • Trend review: A rising or falling DPO trend can prompt a closer look at payment runs, purchasing volume, and vendor mix.
  • Cross-team discussion: Finance, procurement, and operations can discuss the same metric without mixing invoice aging with turnover math.

The benefit is strongest when DPO is reviewed beside the rest of the cash conversion cycle. Supplier credit can reduce outside financing needs, but only if inventory and receivables are also under control.

Use the calculator as a diagnostic step. If DPO moves sharply, inspect the accounts payable aging, payment approvals, vendor concentration, and unusual purchases before assuming the change is permanent.

When DPO changes because liquidity is tight, the Current Ratio Calculator helps compare current assets with current liabilities.

Factors That Affect Your Results

Several inputs and business choices can move the result even when supplier contracts have not changed.

Vendor mix

A shift toward vendors with longer or shorter terms can change DPO without any change in payment discipline.

COGS timing

Large seasonal purchases, inventory builds, or cost spikes can move the denominator and change the DPO result.

Early-payment discounts

Paying earlier can lower DPO but may still be rational if the discount return is attractive.

Late-payment pressure

A high DPO may reflect strong bargaining power, but it can also point to stretched liquidity or strained suppliers.

Accounting scope

Including non-trade payables or mismatched cost categories can make the result harder to compare.

  • DPO is an approximation from period balances. It does not replace invoice-level aging or actual payment-date analysis.
  • COGS is a common denominator, but purchases may be a better internal denominator when payables relate to purchases not yet sold.
  • A higher DPO is not automatically better. Supplier reliability, discounts, and credit status can matter more than a longer ratio.

When the result supports lender reporting or board analysis, keep definitions consistent from period to period. If one quarter uses trade payables and another uses all current liabilities, the trend will not be meaningful.

For public-company analysis, use financial statement notes to understand what sits inside payables and accrued expenses. For internal analysis, separate trade payables from payroll accruals, taxes, and unrelated liabilities when that distinction affects the decision.

According to CFA Institute financial analysis techniques, major activity ratios include payables turnover and number of days of payables.

According to OpenStax Principles of Finance working capital chapter, the cash conversion cycle combines days inventory outstanding, days sales outstanding, and the payable period to review working-capital timing.

If longer payable timing appears to be driven by cash pressure, the Cash Ratio Calculator gives a stricter liquidity check using cash-like assets.

days payable outstanding calculator showing DPO, payable turnover, target gap, and payables at target
days payable outstanding calculator showing DPO, payable turnover, target gap, and payables at target

Frequently Asked Questions

Q: How do I calculate days payable outstanding?

A: Average the beginning and ending accounts payable balances, divide that average by cost of goods sold for the same period, then multiply by period days. The calculator performs those steps and also shows payable turnover and target gap.

Q: What does a high DPO mean?

A: A high DPO means supplier bills remain unpaid for more days relative to the cost base. That can preserve cash, but it can also signal stretched payment timing. Compare it with supplier terms, prior periods, and vendor relationships.

Q: Is DPO the same as accounts payable turnover?

A: No. DPO expresses payables timing in days, while accounts payable turnover shows how many times average payables are covered by COGS during the period. They are related, but they answer different questions.

Q: Should I use purchases or COGS for DPO?

A: COGS is commonly used because it is available from income statements and aligns with cash conversion cycle analysis. For internal vendor analysis, purchases may be better when payables relate to goods bought but not yet sold.

Q: What is a good days payable outstanding number?

A: A good DPO depends on industry norms, supplier terms, seasonality, bargaining power, and discount policy. Compare the result with the same business over time and with similar companies before calling it strong or weak.

Q: How does DPO affect the cash conversion cycle?

A: The cash conversion cycle adds inventory days and receivable days, then subtracts payable days. A higher DPO reduces the reported cycle, but the improvement is useful only when supplier relationships and credit terms remain healthy.