What days payable outstanding tells you
Days payable outstanding expresses trade payables as a number of days of the purchases supporting those liabilities. It is commonly called payable days, creditor days or the average supplier payment period. The measure summarizes the financing provided through ordinary supplier credit. It does not show exactly when each invoice was received, approved or paid.
Start with the question you want to answer. Historical DPO describes a balance relative to a period of spending. Forecast DPO turns a payment assumption into an estimated payable balance. A target comparison isolates the cash tied to a change in that assumption, holding the purchasing base constant. These uses are connected, but should not be mistaken for identical observations.
Calculate DPO from average payables
DPO = average trade payables ÷ credit purchases × days in the period. Enter a direct average or supply opening and closing payables. The calculator then uses (opening AP + closing AP) ÷ 2. More frequent averages can be preferable if spending or invoice settlement varies substantially within the year. Closing-only input remains available as a simplified approximation.
For example, opening payables of 500 and closing payables of 700 produce average AP of 600. With credit purchases of 3,650 over 365 days, daily purchases are 10 and DPO is 60 days. The answer represents the balance in relation to spending, rather than proving that every supplier receives payment exactly sixty days after delivery.
Why purchases and COGS are different
Purchases relate to what the business acquired during the period. Cost of goods sold relates to what was recognized as an expense for items sold. A retailer building stock may purchase substantially more than its cost of sales. A stock drawdown can produce the reverse relationship. Using COGS when inventory changes materially can therefore distort the implied payment period.
For a simple resale business, purchases can be estimated as COGS plus closing inventory minus opening inventory, subject to adjustments for write-offs, acquisitions, exchange rates and other movements. Manufacturing adds further complications because inventory includes conversion costs. This calculator does not manufacture an exact purchases figure from incomplete data. Choose COGS only as a stated approximation when an appropriate credit-purchases measure is unavailable.
Match the payable balance to the spending base
Use trade payables that arise from the purchases in your denominator. Payroll accruals, income taxes payable, financial debt and customer advances do not automatically belong in the same balance. Capital-expenditure creditors may also need a separate schedule if the denominator contains only operating purchases. Mixing different obligations can make an apparently high DPO economically misleading.
Invoice values may include recoverable sales taxes while costs exclude them. Goods received but not invoiced and supplier-finance arrangements can complicate both classification and timing. Review the accounting perimeter before comparing businesses. A stable, documented approximation is often more useful than a highly precise ratio assembled from incompatible balances and flows.
Period length, invoice timing and seasonality
Select 365 or 360 days for a consistently defined annual analysis, or enter the actual days of a shorter period. Quarterly purchases should be paired with quarterly days. A year-end payable spike divided by full-year spending can exaggerate how slowly the business usually pays. Two endpoint balances reduce some noise but do not necessarily capture seasonal purchasing peaks.
Month-end payment runs can produce large differences between two nearby reporting dates. Delayed invoice processing may leave obligations in another accrual account, rather than ordinary payables. Investigate such timing before treating the DPO change as improved negotiation. Where available, compare average ledger balances and purchases over several periods using the same cutoff policy.
Forecast accounts payable from target days
Implied AP = credit purchases ÷ period days × target DPO. With purchases of 3,650, a 365-day year and a 60-day target, forecast payables are 600. If purchases are expected to rise to 4,380 with the same target, payables become 720. The larger balance reflects increased activity, not a change in supplier behavior.
In an annual model this equation is often used as a year-end balance convention. Actual closing payables can differ when the final months have a different spending rate from the annual average. Use procurement plans and contractual terms to support the assumption. A monthly forecast is more suitable where purchases are concentrated around a launch, harvest or holiday season.
Cash effect: higher payables retain cash
At purchases of 3,650, increasing DPO from 45 to 60 raises implied AP from 450 to 600. The increase of 150 produces an approximate positive working-capital cash impact of 150. Reducing DPO from 60 to 45 has the opposite effect: paying down the balance absorbs 150. The sign is reversed relative to an increase in receivables or inventory.
This is an all-else-equal comparison between two balances. It is not additional revenue, a reduction in the purchase expense, or a permanent cash benefit repeated every year. A payable increase caused by currency translation or acquiring another company is not the same as retaining cash by paying suppliers later. Separate those movements when reconciling the forecast with a cash-flow statement.
Longer terms have commercial trade-offs
Higher DPO can reduce short-term borrowing needs, but it is not automatically desirable. Early-payment discounts, supply continuity, supplier financial health and access to scarce capacity may matter more than a few additional days. A negotiated extension differs from overdue invoices created by payment stress. Both can raise the ratio while sending very different signals about the business.
Evaluate a proposed change with procurement and treasury. Compare any discount lost with the financing benefit, but do not ignore operational consequences. This calculator makes the balance and cash arithmetic transparent; it does not recommend delaying suppliers. A neutral presentation helps keep the calculation separate from decisions about contract compliance and relationships.
DPO, payable turnover and the combined cycle
Payable turnover is purchases divided by average AP. For positive payables, period days divided by turnover equals DPO. In the example, 3,650 ÷ 600 is approximately 6.08 times and 365 ÷ 6.08 is about 60 days. A zero balance can produce zero DPO, but it does not support a finite turnover multiple.
DPO is subtracted in the cash conversion cycle because supplier credit offsets some of the time spent holding inventory and waiting for customers. The combined calculator estimates all three balances and their separate cash contributions. For current assets and liabilities beyond these operating accounts, use the Working Capital Calculator and keep its broader scope distinct.
Connect supplier terms to the financial model
A usable forecast separates the income-statement expense from the cash settlement of the associated liability. Costs can be recognized before payment. Increasing trade payables may therefore improve cash during a period without improving operating profit. In a multi-year model, calculate each closing payable balance, compare it with the preceding opening balance and reconcile non-cash changes.
Document whether DPO uses purchases or COGS, which liabilities are included and which day convention applies. This makes future revisions auditable. The Three-Statement Model connects payment assumptions to the wider forecast. ACCA’s working-capital guidance discusses the operating-cycle relationship and the use of cost of sales as a purchases approximation.
Frequently asked questions
Can I use COGS if purchases are not available?
Yes. Select the COGS approximation and keep the warning with the result. The estimate is less reliable when inventory builds or declines materially, or when the liability and cost scopes differ.
Is negative DPO useful?
This calculator expects nonnegative trade payables. Supplier prepayments or debit balances should normally be analyzed separately rather than interpreted as a negative supplier-credit period.
Does a higher DPO increase profit?
Not by itself. It changes the amount and timing of supplier financing. Discounts, financing charges or operational disruptions may affect profit, but those require separate assumptions.