Skip to content

DPO calculator

DPO is a liquidity and working-capital metric, calculated as (Ending AP ÷ COGS for the period) × Days in the period. Some use purchases rather than COGS, which suits a business whose AP is mostly opex. Render with on-time payment rate adjacent — see procure to pay.
Formula
(Ending AP ÷ COGS for the period) × Days in the period
Days payable outstanding (DPO)DPO = (Ending AP ÷ COGS) × Days in the period
$
$

90 for a quarter, 365 for a year.

Days payable outstanding

32.0 days

How it’s worked out

  1. 1(Ending AP ÷ COGS) × days($320,000 ÷ $900,000) × 9032.0 days

Runs in your browser; nothing you type is sent anywhere. Amounts in US dollars.

Worked on a real month of books

Northwind Traders, Inc., September 2026 (accrual basis, USD), the month the free course is taught on. Every figure is read off the course's posted ledger, not typed.

  1. 1(Ending AP ÷ cost of revenue) × days($6,000 ÷ $17,000) × 3010.6 days

See the statements these come from in the course.

How to read it

DPO converts the payables balance into days of purchases: how long the company holds its cash before paying suppliers.

It offsets DSO and inventory days in the cash conversion cycle. Paying on terms — not early, not late — is usually optimal.

Common mistakes

  • Using revenue instead of cost of goods sold or purchases as the flow.
  • Stretching payables past terms to improve the number.

Questions

What does DPO mean?
Days payable outstanding: how many days of purchases are still unpaid at the period's end.
Is a higher DPO better?
Close to supplier terms. A DPO far above terms usually means paying late, which costs discounts and goodwill.

Read it with

The metrics read alongside this one, and the terms it is confused with.

The formula is the one the glossary states, and the arithmetic is unit-tested. A ratio with nothing to divide by shows a dash — undefined is not zero. General information, not financial advice.

Works in your QuickBooks Online or Xero file

Get your books closed every month

Lopifi is building AI bookkeeping that keeps your books closed on US GAAP as transactions happen, with a CPA review every quarter, for $200 a month. We’re not open yet.

$200/month when we open. No card now.