About the Days Payable Outstanding Calculator
This days payable outstanding (DPO) calculator measures how many days, on average, your business takes to pay its suppliers. Enter accounts payable at the beginning and end of the period and either cost of goods sold or purchases, and it returns DPO, the accounts payable turnover ratio, average payables and the average daily cost you finance through trade credit.
It is built for CFOs, controllers, treasury and procurement teams, lenders and analysts who track working capital. DPO is one leg of the cash conversion cycle: paying later keeps cash in the business longer, but paying well beyond agreed terms can cost early-payment discounts, supplier goodwill and credit standing. Comparing DPO with your standard supplier terms shows whether you pay early, on time or late.
Purchases is the more precise denominator because payables arise from purchases, not from cost of sales. If you do not know purchases, the tool can derive them as COGS + ending inventory − beginning inventory, or you can use COGS directly as most published financial-ratio sources do. Use the same period for payables and costs — a year with 365 days, a quarter with 90.
With the default inputs, the days payable outstanding (dpo) is 45 days. Change any value above to recalculate instantly.
How to use the days payable outstanding calculator
- 1Enter accounts payable at the start and end of the period from your balance sheets.
- 2Choose whether to use COGS, purchases, or purchases derived from inventory.
- 3Enter COGS or purchases (and inventory balances if deriving purchases).
- 4Select the period length and your standard supplier terms.
- 5Compare DPO with terms and review the payables gap.
Formula and method
Average accounts payable is the mean of the opening and closing balances. Dividing it by the cost base for the period gives the share of the period’s purchases still unpaid; multiplying by the number of days converts that into days. DPO is therefore the period length divided by accounts payable turnover.
Purchases are the most accurate cost base because supplier invoices relate to purchases. When purchases are not reported, they can be derived from the inventory equation: COGS plus the increase in inventory. Many analysts simply use COGS, which is fine for comparisons as long as you are consistent. The payables gap multiplies the days above or below terms by average daily cost.
- Average AP
- (Beginning accounts payable + ending accounts payable) ÷ 2
- COGS / Purchases
- Cost base for the same period as the payables
- Days
- Length of the period: 365, 360, 90 or 30
Worked examples
Annual DPO on COGS
Average payables are ($80,000 + $100,000) ÷ 2 = $90,000. With $730,000 of COGS, AP turnover is 8.11 times and DPO is 90,000 ÷ 730,000 × 365 = 45 days — exactly on 45-day supplier terms.
Purchases derived from inventory change
Purchases are $730,000 + $130,000 − $120,000 = $740,000. DPO is 90,000 ÷ 740,000 × 365 = 44.4 days, slightly faster than terms because inventory built up during the year.
Quarter with slow payment
Average payables of $160,000 against $320,000 of quarterly purchases is a turnover of 2, so DPO is 90 ÷ 2 = 45 days — 15 days beyond net 30. At $3,555.56 of purchases a day, that is about $53,333 of extra supplier credit.
Frequently asked questions
What is a good days payable outstanding?+
A good DPO is close to your negotiated supplier terms. A DPO well below terms means you are paying early and giving up free financing; far above terms suggests cash strain or stretched suppliers. Norms vary widely by industry, so compare with peers.
Should DPO use COGS or purchases?+
Purchases is conceptually better because payables come from purchases, but it is rarely disclosed. COGS is the common substitute in ratio analysis. If inventory changed a lot, derive purchases as COGS + ending inventory − beginning inventory.
How does DPO fit into the cash conversion cycle?+
The cash conversion cycle is days inventory outstanding plus days sales outstanding minus days payable outstanding. A higher DPO shortens the cycle because suppliers finance more of your inventory and receivables.
Is a higher DPO always better?+
No. Holding cash longer helps liquidity, but paying late can trigger late fees, lost early-payment discounts such as 2/10 net 30, worse terms or supply interruptions. The best DPO uses the full agreed terms without exceeding them.
What is the accounts payable turnover ratio?+
AP turnover is COGS or purchases divided by average accounts payable. It shows how many times you pay off your average payables balance in the period. DPO equals the number of days in the period divided by AP turnover.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.