Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Days Payable Calculator
Accounting Calculators

Days Payable Calculator

Published onJuly 19, 2025 Updated onOctober 21, 2026 4:38 am

Every supplier invoice sits in a gap between two choices: pay it now and part with the cash, or pay it on the last day the terms allow and keep the cash working. This calculator measures where your business actually lands in that gap: days payable outstanding (DPO), the average number of days you take to pay suppliers.

Enter beginning and ending accounts payable, cost of goods sold for the period, and the period length. You get average payables, DPO, payables turnover, and a plain reading of what the figure says about your cash position.

Days Payable Outstanding Calculator
Average payables, DPO, and payables turnover for your period

Days payable outstanding
—
Average accounts payable—
Payables turnover—

Estimate only. Use trade payables tied to COGS (not all current liabilities); service businesses can substitute total supplier purchases for COGS.

Quick Answer

Quick answer: Payables of $70,000 at the start of the year and $90,000 at the end average to $80,000. Against $500,000 of annual COGS, DPO is 58.40 days with payables turnover of 6.25x: the business pays its suppliers in just under two months, inside the typical 30 to 60 day range for standard supplier terms.
On this page
  • Quick Answer
  • How to use this days payable outstanding calculator
  • The DPO formula, and the period-matching rule
  • Worked example: 58.40 days and 6.25x turnover
  • Where DPO sits in the cash conversion cycle
  • Stretching payables: the honest trade-off
  • What competing calculators miss
  • Frequently Asked Questions
  • Add This Calculator to Your Website
  • References

How to use this days payable outstanding calculator

Pull trade accounts payable from the balance sheet at the opening and closing dates of your period, and COGS from the income statement for the same period. Pick the period length that matches your COGS figure, then press Calculate DPO. The result shows the averaged payables balance it used, so you can see at a glance whether the average or the ending-only fallback produced your number.

If you have only the ending balance, leave the beginning field blank. The tool uses the ending figure and labels it as ending-only in the result, which matters: a balance captured the day after a large payment run understates DPO, and one captured the day before a payment run overstates it. Either way, keep the method consistent period to period. A DPO series that switches between average and ending balances will show jumps that are bookkeeping artifacts, not changes in how you pay. Once you have DPO, set it against the money coming in: the days outstanding calculator gives you DSO, the collection side of the same cash cycle, and the comparison section below explains why the gap between the two numbers matters more than either one alone.

The DPO formula, and the period-matching rule

DPO divides what you owe suppliers by the daily cost of what you sell, which converts a balance into a count of days.

The formulas: Average AP = (beginning AP + ending AP) / 2. DPO = average AP / (COGS / days in period), which is the same as (average AP / COGS) x days. Payables turnover = COGS / average AP = days / DPO. With the pre-filled figures: average AP is $80,000, DPO is $80,000 / ($500,000 / 365) = 58.40 days, and turnover is 6.25x.

AccountingTools sets out the same structure from the turnover side in its accounts payable days formula: total supplier purchases divided by average payables gives turnover, and 365 divided by turnover gives payable days. That source also flags the denominator trap this calculator is built around: COGS alone can understate the purchases figure when a business buys significant services and overhead on credit, which shrinks DPO on paper. Using total credit purchases instead of COGS, when you can isolate them, is the more faithful denominator. Whichever denominator you choose, the Corporate Finance Institute applies the same component logic in its cash conversion cycle guide, where DPO is subtracted because supplier credit funds part of the operating cycle.

The period rule is absolute: COGS and days must describe the same window. Annual COGS of $500,000 with the 90-day quarterly setting returns a DPO of 14.40 days, a figure roughly four times too small, produced entirely by the mismatch. The period selector exists to make that error hard to commit by accident.

Worked example: 58.40 days and 6.25x turnover

The calculator is pre-filled with this case, and every number below is what it returns when you press Calculate.

StepFigureResult
Beginning accounts payable$70,000Opening balance sheet figure
Ending accounts payable$90,000Closing balance sheet figure
Average accounts payable($70,000 + $90,000) / 2$80,000
Daily COGS$500,000 / 365$1,369.86 per day
DPO$80,000 / $1,369.8658.40 days
Payables turnover$500,000 / $80,0006.25x Typical range

Two checks confirm the arithmetic ties together. Turnover times DPO should return the period length: 6.25 x 58.40 = 365 days. It does. And the interpretation follows from the terms, not the number alone: 58.40 days against Net 60 terms is a business using nearly all the credit its suppliers granted, on time. The identical 58.40 days against Net 30 terms would mean paying a month late on average, with late fees and strained suppliers as the likely cost. DPO has no meaning until it is read against the terms behind it.

Where DPO sits in the cash conversion cycle

DPO is the third leg of the cash conversion cycle: days inventory outstanding plus days sales outstanding, minus days payable outstanding. The subtraction is the whole point. Every day you legitimately hold a supplier payment is a day your own cash does not have to fund inventory sitting on a shelf or an invoice waiting to be collected.

1

Inventory days (DIO): stock arrives and sits. Cash is committed from this point, even if the supplier invoice is not yet due.

2

Collection days (DSO): the goods sell, the customer is invoiced, and you wait to be paid. In the companion worked example, that wait is 30.4 days.

3

Payment days (DPO): you settle with the supplier at 58.40 days in the example above. Because this runs longer than the collection wait, supplier credit covers the gap.

4

The cycle: CCC = DIO + DSO - DPO. A longer DPO shortens the cycle and reduces the working capital the business must supply itself, as long as payments stay inside agreed terms.

This is also where DPO and DSO are most often confused, so the distinction is worth stating plainly. DSO is about receivables: your customers, your credit sales, money flowing in. DPO is about payables: your suppliers, your COGS, money flowing out. Raising DPO and lowering DSO both shorten the cash cycle, but they involve opposite relationships and opposite risks. Squeezing customers too hard costs sales; squeezing suppliers too hard costs supply. A business funding a long collection wait by paying suppliers late is borrowing from the party least able to refuse, and the strain surfaces in both ratios at once. Plotting DPO against your days of cash on hand shows whether a rising DPO is a deliberate terms strategy backed by reserves, or a symptom of cash running short.

Stretching payables: the honest trade-off

Extending DPO is the cheapest working capital lever most businesses have, and the easiest to abuse. The two columns below are the same decision read from opposite sides.

What a longer DPO buys you

  • Cash stays in the business longer, funding operations instead of sitting with suppliers.
  • The cash conversion cycle shortens, so growth needs less outside financing.
  • At $1,369.86 of daily COGS, each extra DPO day holds about $1,370 of cash in the business.
  • Payment runs can be batched to agreed dates, cutting processing cost per invoice.

What it can cost you

  • Paying past agreed terms triggers late fees and damages your standing with key vendors.
  • Early-payment discounts are forfeited: a 2% discount for paying 20 days early is expensive credit to give up.
  • Suppliers respond to chronic lateness with tighter terms, deposits, or lower priority in shortages.
  • A rising DPO reads to lenders and acquirers as possible cash stress, not cleverness, when it outruns your terms.

The discipline that separates strategy from stress is simple: pay on the last day of agreed terms, not a day later, and negotiate longer terms openly instead of drifting into them. If your DPO is rising because approvals sit in inboxes for two weeks, that is a process fault, not a financing strategy, and fixing it usually recovers the discount income as well. Track the result alongside your days working capital figure so a payables improvement is not quietly cancelled out by slower collections or heavier inventory.

What competing calculators miss

The DPO tools ranking for this term are mostly a single payables field, a COGS field, and a day count. Three gaps recurred across that set.

Gap 1: ending balance only, with no averaging prompt. Payables swing hard around payment runs, so a single snapshot can move DPO by a week or more depending on the day it was pulled. This tool asks for both balances, averages them, and still handles the ending-only case honestly by labeling it in the result.

Gap 2: free-form day counts that invite the mismatch error. A blank days box accepts 90 next to annual COGS without complaint, returning a DPO a quarter of its true size. The period selector here ties the choice to named windows (annual, quarterly, monthly) so the COGS period and the day count stay matched.

Gap 3: a day count with no turnover and no reading. DPO and payables turnover are the same fact in two units, and AP teams think in turnover while treasurers think in days. This result shows both, checks them against each other (turnover x DPO = period days), and adds the fast, typical, or slow reading so a first-time user knows whether 58.40 days is a problem or a policy working as intended.

Frequently Asked Questions

DPO equals average accounts payable divided by COGS, multiplied by the days in the period. With average payables of $80,000, COGS of $500,000, and a 365-day year: ($80,000 / $500,000) x 365 = 58.40 days. The business takes about 58 days on average to pay its suppliers.

There is no universal good DPO. It depends on your industry, your size, and the terms you negotiated. A DPO close to your agreed terms, using the full credit period without paying late, is the practical target. Compare your figure with peers in your industry and with your own past periods, not with a fixed benchmark.

No. A higher DPO holds cash longer, which helps liquidity, but paying beyond agreed terms risks late fees, lost early-payment discounts, and suppliers tightening your terms or deprioritizing your orders. A high DPO reached by negotiated terms is a strength; the same figure reached by paying late is a warning sign.

Payables turnover is COGS divided by average accounts payable: how many times per period you pay off your supplier balance. It is the same fact as DPO in different units, and the two check against each other, because turnover multiplied by DPO equals the days in the period. In the worked example, 6.25 x 58.40 = 365 days.

Use the average of both when you can. Payables swing around payment runs, so a single ending balance can overstate or understate your real payment speed depending on the day it was captured. If only the ending balance is available, this calculator uses it and labels the result as ending-only.

Substitute total supplier purchases for COGS: contractor invoices, production costs, and supplier-related operating spend. Keep the same expense accounts in the denominator every period so the trend stays comparable, and benchmark against similar service businesses rather than product businesses.

DPO measures how fast you pay your suppliers, using payables and COGS, so it tracks money flowing out. DSO (days sales outstanding) measures how fast your customers pay you, using receivables and credit sales, so it tracks money flowing in. In the cash conversion cycle, DPO is subtracted and DSO is added.

No. Use trade accounts payable tied to the goods and services in your denominator, not all current liabilities. Accrued wages, taxes payable, and short-term debt are not supplier credit, and including them inflates the payables balance and overstates DPO.

Add This Calculator to Your Website

Embed the Days Payable Outstanding Calculator on your own site. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. AccountingTools, "Accounts payable days formula" - supplier purchases over average payables for turnover, 365 over turnover for payable days, and the warning that COGS alone can understate the denominator. AccountingTools: Accounts Payable Days Formula. Accessed October 2026.
  2. Corporate Finance Institute, "Cash Conversion Cycle" - CCC as DIO plus DSO minus DPO, with interpretation guidance and trend comparison. CFI: Cash Conversion Cycle. Accessed October 2026.
  3. Wall Street Prep, "Cash Conversion Cycle (CCC)" - the DPO formula using average or ending payables over COGS, and the operating cycle definition. Wall Street Prep: Cash Conversion Cycle. Accessed October 2026.
  4. Relay, "Days payable outstanding: what it is and how to calculate" - average payables construction, period matching, and the service-business purchases substitution. Relay: Days Payable Outstanding. Accessed October 2026.
  5. Ramp, "Days Payable Outstanding: how it is calculated and optimized" - the average payables over COGS formula with a fully worked annual example. Ramp: Days Payable Outstanding. Accessed October 2026.
  6. Brex, "Formula and example for how to calculate accounts payable" - AP turnover from net credit purchases over average payables, and DPO as 365 over turnover. Brex: How to Calculate Accounts Payable. Accessed October 2026.
  7. Indeed Career Guide, "DPO calculation: an in-depth guide with steps and an example" - the average payables over daily cost of sales formulation and high versus low DPO reading. Indeed: DPO Calculation Guide. Accessed October 2026.
  8. AccountingTools, "Operating performance ratios" - cash conversion cycle components, including days payables outstanding computed from ending payables and cost of sales. AccountingTools: Operating Performance Ratios. Accessed October 2026.
  9. Taulia, "Cash Conversion Cycle (Cash Cycle) Definition and Formula" - the CCC formula and the worked example combining DIO, DSO, and DPO. Taulia: Cash Conversion Cycle. Accessed October 2026.
  10. Touro University, "The Cash Conversion Cycle" (Corporate Finance, open textbook) - trade credit as a short-term free loan and the cash-to-cash timeline. Open Textbook: The Cash Conversion Cycle. Accessed October 2026.

Related calculators

Accounting CalculatorsSales to Working Capital Ratio CalculatorEvery dollar of sales a business makes has to be carried for a while by money tied up in stock, unpaid customer invoices and the gap before suppliers are paid.Accounting Calculators Mca Calculator Give this calculator four numbers: the advance amount, the factor rate, the payback period and the payment...Accounting CalculatorsUnderpayment Penalty Calculator An underpayment penalty calculator answers two questions in order: do you actually owe the IRS a penalty for paying too little during the year, and if so, roughly how much?Accounting CalculatorsForm 2210 Penalty CalculatorA Form 2210 penalty calculator figures the IRS underpayment penalty the same way the form itself does: quarter by quarter, at the IRS rate in effect for each period.Accounting CalculatorsDiminishing Value Depreciation Calculator Straight-line depreciation spreads an asset's cost evenly, but most assets lose value fastest in their first years.Accounting CalculatorsPercentage Profit CalculatorMargin and markup describe the same profit with different denominators, and confusing them is one of the most expensive pricing mistakes a seller can make.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search