Days Payable Outstanding (DPO) Calculator

About the DPO Calculator

The Days Payable Outstanding (DPO) Calculator figures out how many days, on average, a business takes to pay its suppliers, using its accounts payable balance and cost of goods sold. It gives finance teams a quick read on how aggressively, or how slowly, the company is stretching payment terms relative to its purchasing volume, which directly affects available cash on hand.

How It Works

Enter your accounts payable balance, cost of goods sold for the period, and the number of days in that period, which defaults to 90 for a quarter. The calculator divides accounts payable by COGS and multiplies the result by the period's day count to produce the average number of days bills go unpaid. A higher result means the business is holding onto cash longer before settling supplier invoices.

DPO = (Accounts Payable / COGS) x Number of Days in Period

Formula & Methodology

To work this out manually, take your accounts payable balance at a point in time, or an average of beginning and ending balances for more precision than the calculator's single input allows, and divide it by the cost of goods sold for the matching period. Multiply the result by the number of days in that period. A 90-day quarter with $65,000 in payables against $480,000 in COGS, for instance, spreads a relatively small payable balance across a comparatively larger purchasing base, producing a modest DPO.

Examples

Quarterly Snapshot

A wholesaler with $65,000 in accounts payable and $480,000 in COGS over a 90-day quarter has a DPO of 12.2 days.

Slower-Paying Distributor

A distributor carrying $220,000 in payables against $900,000 in COGS over the same 90-day period comes out to a DPO of 22.0 days, roughly twice as long as the wholesaler.

Advantages

Turns a payables balance into an intuitive days figure that's easier to benchmark against agreed supplier payment terms
Lets a business track whether it's paying suppliers faster or slower than in prior reporting periods
Feeds directly into the Cash Conversion Cycle calculation alongside DIO and DSO for a full working-capital view

Common Mistakes

Comparing DPO figures calculated over different period lengths without adjusting the days input to match
Reading a rising DPO as purely positive without checking whether it reflects strained supplier relationships or forfeited early-payment discounts
Using total operating expenses instead of COGS in the denominator, which departs from the standard DPO formula this calculator is built around

Edge Cases to Watch For

A COGS value of zero or less returns an error, since the calculation cannot divide by zero.
Using a period length that doesn't match the COGS figure, such as quarterly payables against annual COGS, will produce a misleadingly low DPO, since the days multiplier and the COGS denominator need to describe the same span.
The calculator treats accounts payable as a single snapshot value rather than averaging a beginning and ending balance, so a payable figure taken right after a large batch of invoices were paid down will understate a business's typical DPO.

Common Use Cases

Accounts payable and treasury teams monitoring how payment timing affects available cash
CFOs benchmarking DPO against agreed supplier terms to check whether trade credit is over- or under-utilized
Analysts building out the Cash Conversion Cycle to assess overall working capital efficiency

Frequently asked questions

Is a higher DPO always better?

Not necessarily - a higher DPO means you're holding onto cash longer before paying suppliers, which helps your own cash flow, but paying too slowly can strain supplier relationships, risk late fees, or forfeit early-payment discounts. The right DPO balances your cash flow needs against maintaining good supplier terms.