What Is Days Payable Outstanding (DPO)?
Days payable outstanding measures the average number of days a company takes to pay its suppliers after receiving goods or services. It converts the accounts payable balance into a number of days, showing how long the business holds onto its cash before settling bills. A higher DPO means the company takes longer to pay, keeping cash on hand longer; a lower DPO means it pays quickly. Unlike most efficiency metrics, a higher DPO is not automatically better or worse: it reflects a deliberate balance between conserving cash and maintaining good supplier relationships.
How to Calculate Days Payable Outstanding
DPO = (Accounts Payable / Cost of Goods Sold) x Number of Days in the Period
Worked example, for a year:
- Accounts payable: $500,000
- Annual cost of goods sold: $6,000,000
- Days in period: 365
- DPO: (500,000 / 6,000,000) x 365 = about 30 days
On average, the company pays its suppliers about 30 days after purchase.
DPO in Power BI (DAX)
Replace the measures with the ones in your model:
DPO = DIVIDE ( [Accounts Payable], [Total COGS] ) * [Days In Period]What Is a Good DPO?
There is no universal target. A higher DPO conserves cash, which is valuable, but stretching it too far can strain supplier relationships, forfeit early-payment discounts, or signal cash trouble. A very low DPO may mean a company is paying faster than it needs to and leaving working capital on the table. The healthy level balances cash management against the terms and goodwill of suppliers, and the trend matters more than the absolute number.
DPO and the Cash Conversion Cycle
DPO is one of the three components of the cash conversion cycle, where it appears as a subtraction: Cash Conversion Cycle = DIO + DSO – DPO. The longer a company takes to pay suppliers, the shorter its cash cycle, because supplier credit funds part of its operations. This is why DPO is the one component of the cycle where a higher number shortens it.
DPO vs Accounts Payable Turnover
Days payable outstanding and accounts payable turnover describe the same thing from opposite directions. Turnover counts how many times payables are paid off in a period; DPO converts that into the average days taken to pay. A higher DPO corresponds to a lower turnover, and vice versa.
Reporting DPO From Your ERP Data
DPO depends on accounts payable and cost of goods sold drawn consistently from the ERP, which is harder across entities and currencies. A governed data foundation brings payables and cost data onto one model so DPO is consistent and traceable. QuickLaunch ships pre-built models for JD Edwards, Vista, NetSuite, and OneStream that surface payables data for cash and working-capital reporting.
Frequently Asked Questions
How is days payable outstanding calculated?
Divide accounts payable by the cost of goods sold, then multiply by the number of days in the period. A company with $500K in payables and $6M annual COGS has a DPO of about 30 days.
Is a higher DPO better?
Not automatically. A higher DPO conserves cash, but stretching payment too far can strain supplier relationships and forfeit early-payment discounts. The healthy level balances cash management against supplier terms and goodwill.
How does DPO affect the cash conversion cycle?
DPO is subtracted in the cash conversion cycle (DIO + DSO – DPO). The longer a company takes to pay suppliers, the shorter its cash cycle, because supplier credit funds part of operations.
