How do I calculate days payable outstanding?

Days payable outstanding is how long credit purchases sit unpaid. A DPO calculator is that day count for the balances you type.

The SBA’s glossary of business financial terms defines Days Payable as accounts payable divided by annual credit purchases, times 365. The same glossary defines Days Receivable the same way, with credit sales in the denominator. The days payable outstanding calculator uses that definition, and it lets you change the day count when the period is not a year:

DPO = accounts payable ÷ credit purchases × days

Payables turnover = credit purchases ÷ accounts payable

Credit purchases per day = credit purchases ÷ days

Customer invoices are the days sales outstanding calculator and the DSO post. The three-leg cycle that subtracts payable days from inventory days and receivable days is the cash conversion cycle calculator and the cycle post. The dollar cushion on the balance sheet is the working capital calculator.

Use credit purchases only. A cash purchase never sits in payables. These examples are the ratio. They are not a vendor plan, and they do not say what a “good” day count is. The glossary defines the ratio. It does not publish a target.

Example 1. Thirty days on $365,000

The calculator’s published year.

• Accounts payable: $30,000
• Annual credit purchases: $365,000
• Days: 365

DPO = 30,000 ÷ 365,000 × 365 = 30 days.

Payables turnover = 365,000 ÷ 30,000 = 12.17×.

Credit purchases per day = 365,000 ÷ 365 = $1,000.00.

Thirty days is one month of that $1,000 daily credit book still unpaid: 30 × 1,000 = $30,000. The turnover says the payable balance is replaced 12.17 times in the year. 365 ÷ 30 = 12.166…, which the page rounds to 12.17.

Example 2. What if the balance is $45,000?

Keep purchases at $365,000 and the year at 365 days. Payables rise to $45,000.

DPO = 45,000 ÷ 365,000 × 365 = 45 days.

Turnover = 365,000 ÷ 45,000 = 8.11×.

Purchases per day stay $1,000.00.

You are holding an extra $15,000 against the same purchase flow. The day count rises by 15, because 15,000 ÷ 1,000 = 15. Turnover falls from 12.17 to 8.11. A longer day count keeps cash in the business longer. It can also mean a bill is past the terms you agreed. The ratio cannot tell those apart.

Example 3. Paying in 15 days

Payables $15,000, purchases $365,000, days 365.

DPO = 15 days.

Turnover = 365,000 ÷ 15,000 = 24.33×.

Purchases per day $1,000.00.

Half the payable balance of example 1, half the days, twice the turns. 12.17 × 2 = 24.34, and the page prints 24.33 because it divides 365,000 by 15,000 and rounds to two decimals, rather than doubling the rounded 12.17.

Example 4. Stretch the same purchase book

Purchases stay $365,000. Days stay 365. Only the payable balance changes. Purchases per day stay $1,000, so the day count equals payables divided by 1,000.

At $120,000 you are holding about four months of the credit book. Turnover is 3.04 times. Whether the vendors agreed to that is outside the formula.

Example 5. A quarter, and the 365-day mistake

The purchase book for one quarter:

• Accounts payable: $15,000
• Credit purchases: $91,000
• Days: 91

DPO = 15,000 ÷ 91,000 × 91 = 15 days.

Turnover = 91,000 ÷ 15,000 = 6.07×.

Purchases per day = 91,000 ÷ 91 = $1,000.00.

Same daily flow as the year, same 15-day count as example 3. Turnover is lower because this ratio uses the quarter’s purchases, not a full year of them. 6.07 turns in 91 days is the same pace as 24.33 turns in 365 days. Check: 24.33 × 91 ÷ 365 is about 6.07.

Leave the purchases at $91,000 and the payables at $15,000, and type 365 days by habit.

DPO = 15,000 ÷ 91,000 × 365 = 60.2 days.

Purchases per day = 91,000 ÷ 365 = $249.32.

Turnover stays 6.07×, because turnover does not use the day count. The day count quadruples, from 15 to 60.2, because 365 ÷ 91 is about 4. You asked how many days of a year’s pace sit in the payable, while the purchases only cover a quarter. Use the day count that matches the purchase total.

Example 6. Cash purchases mixed into the denominator

Payables are $30,000. Credit purchases are $200,000. Another $165,000 was paid at delivery, so the total purchase line on a report might read $365,000.

On credit purchases only:

DPO = 30,000 ÷ 200,000 × 365 = 54.8 days.

Turnover = 200,000 ÷ 30,000 = 6.67×.

Purchases per day = 200,000 ÷ 365 = $547.95.

If the $165,000 of cash purchases is added to the denominator:

DPO = 30,000 ÷ 365,000 × 365 = 30 days.

That is example 1’s printout, and it is the wrong denominator. Cash at delivery never sat in the $30,000. Mixing it in shortens the day count from 54.8 to 30. The glossary’s Days Payable uses annual credit purchases.

Example 7. Customers at 45 days, vendors at 30

The receivable twin of example 1, with a larger balance.

• Accounts receivable: $45,000
• Annual credit sales: $365,000
• Days: 365

DSO = 45,000 ÷ 365,000 × 365 = 45 days.

Receivables turnover = 8.11×.

Credit sales per day = $1,000.00.

You collect in 45 days and, in example 1, you pay in 30. Customers take 15 days longer than you take to pay vendors, on two flows that both run at $1,000 a day. The cash gap on those two legs alone is 15 × 1,000 = $15,000, which is also 45,000 - 30,000.

Other pairs on the same $365,000 credit sales and a 365-day year:

• Receivables $20,000: DSO 20 days, turnover 18.25×
• Receivables $30,000: DSO 30 days, turnover 12.17×
• Receivables $60,000: DSO 60 days, turnover 6.08×

The stretched pair is the negative-cycle case in the next example: vendors at 90 days, customers at 20.

Example 8. Where DPO sits in the cash cycle

The cycle calculator’s published inputs:

• Beginning inventory $80,000, ending inventory $100,000, so average inventory is (80,000 + 100,000) ÷ 2 = $90,000
• Cost of goods sold $360,000
• Receivables $30,000, credit sales $365,000
• Payables $30,000, credit purchases $365,000
• Days 365

Inventory turns = 360,000 ÷ 90,000 = 4.

Inventory days = 365 ÷ 4 = 91.25, shown as 91.3 days.

DSO = 30 days. DPO = 30 days.

Cycle = 91.25 + 30 - 30 = 91.25, shown as 91.3 days.

The page adds the unrounded legs, then rounds. Adding the printed 91.3 + 30 - 30 also lands on 91.3 here. Example 10 in the cycle post is a case where the last tenth differs.

Move only payables, to the balances in example 4. Inventory days stay 91.3. DSO stays 30.

Each extra 15 days of DPO knocks 15 days off the cycle, until the last step. From $90,000 to $120,000 is 30 days of DPO and 30 days off the cycle, 31.3 down to 1.3.

A negative cycle needs the other legs to shrink, or payables to cover more than inventory days plus DSO. This set of inputs:

• Beginning inventory $40,000, ending $50,000, cost of goods sold $365,000
• Receivables $20,000, credit sales $365,000
• Payables $90,000, credit purchases $365,000
• Days 365

Average inventory = $45,000. Turns = 365,000 ÷ 45,000 = 8.111… Inventory days = 365 ÷ (365,000 ÷ 45,000) = 45 days.

DSO = 20 days. DPO = 90 days.

Cycle = 45 + 20 - 90 = -25 days.

Payable days are longer than inventory days and receivable days combined. On these inputs, the vendor balance funds the stock and the invoices in the arithmetic. The formula does not say the vendors agreed to that.

Example 9. The payable balance inside working capital

The working-capital page’s published snapshot:

• Cash $40,000, receivables $45,000, inventory $90,000, other current assets $5,000
• Payables $35,000, other current liabilities $25,000

Current assets = 40,000 + 45,000 + 90,000 + 5,000 = $180,000.00.

Current liabilities = 35,000 + 25,000 = $60,000.00.

Working capital = 180,000 - 60,000 = $120,000.00.

Current ratio = 180,000 ÷ 60,000 = 3×.

Quick ratio = (180,000 - 90,000) ÷ 60,000 = 1.5×.

DPO is not this ratio. DPO needs credit purchases. This snapshot has no purchase total, so you cannot read a day count from the $35,000 alone.

Raise payables from $35,000 to $70,000 and leave everything else.

Current liabilities = 70,000 + 25,000 = $95,000.00.

Working capital = 180,000 - 95,000 = $85,000.00.

Current ratio = 180,000 ÷ 95,000 = 1.89×.

Quick ratio = 90,000 ÷ 95,000 = 0.95×.

The extra $35,000 of payables removes $35,000 of working capital. The quick ratio slips under 1 because near-cash items, with inventory removed, are $90,000 against $95,000 due inside the year. A longer DPO and a thinner quick ratio can show up together. They are still different tests.

A tighter snapshot, so the dollar cushion itself goes negative:

• Cash $8,000, receivables $22,000, inventory $40,000, other current assets $0
• Payables $55,000, other current liabilities $18,000

Assets = $70,000.00. Liabilities = $73,000.00.

Working capital = -$3,000.00.

Current ratio 0.96×. Quick ratio = (70,000 - 40,000) ÷ 73,000 = 0.41×.

One category still steps through the slices. The stack totals $180,000, which matches current assets. Payables are not in the stack. They come off afterward to reach the $120,000 of working capital.

Example 10. An old bill inside a 30-day average

Example 1’s $30,000 prints as 30 days on $365,000 of purchases. Suppose $9,000 of that balance is a bill that is already 90 days old, and the other $21,000 is the rest of the book.

The blended DPO is still 30 days. The formula has one payable number.

Run the $21,000 on its own, same purchases and same 365 days.

DPO = 21,000 ÷ 365,000 × 365 = 21 days.

Turnover = 365,000 ÷ 21,000 = 17.38×.

The 30-day average hid a 21-day book and a $9,000 bill. The page will not age the $9,000. If you want that bill’s own day count, it needs its own purchases, or you read it off the invoice date instead of this ratio.

Two more edges on the published $30,000 and $365,000.

A 366-day period: DPO = 30,000 ÷ 365,000 × 366 = 30.1 days. Turnover stays 12.17×. Purchases per day = 365,000 ÷ 366 = $997.27. One extra day in the multiplier adds a tenth to the printed count.

Payables at $0, credit purchases $180,000, 365 days: DPO = 0 days. Turnover prints Need payables, because the turnover divisor is zero. Purchases per day = 180,000 ÷ 365 = $493.15. A zero balance is a defined day count. It is what you get when nothing was bought on credit, or when the credit book was paid off before the snapshot.

The day counts side by side

Example 5’s two rows share a turnover and disagree on days. Example 6’s two rows share a payable balance and disagree on days. The day count follows the denominator and the period you type.

When you want the cycle with inventory in it, open the cash conversion cycle calculator and type all three legs. DPO alone cannot see the stock.