DPO calculator
- Days payable outstanding
- 50.7 days
- Average paid per day
- $24,658
Formula: DPO = accounts payable / cost of goods sold × days in period
Example
- Accounts payable ($)
- $1,250,000
- Cost of goods sold for the period ($)
- $9,000,000
- Days in period
- 365
- Days payable outstanding
- 50.7 days
- Average paid per day
- $24,658
What the calculator works out
The calculator works out days payable outstanding, usually shortened to DPO. The formula is DPO = accounts payable / cost of goods sold × days in period. It answers a simple question: on average, how many days does the business take to pay suppliers? The result is a period measure, not a vendor-by-vendor score. The calculator also returns average paid per day, which gives a scale check on the AP and cost base used in the calculation.
Accounts payable ($) is the AP balance for the period you are measuring. For a single point in time, use the AP total from the AP aging summary or the accounts payable line on the balance sheet, reconciled to the general ledger. When the balance moves a lot during the period, use average AP for the period, (opening + closing) / 2, rather than one closing balance. The opening and closing totals should come from the same source and cover the same population of trade payables.
Cost of goods sold for the period ($) is the cost of sales line on the income statement for the same period as the AP figure. It should exclude operating expenses that sit below the gross margin line. Some analysts use purchases instead of cost of goods sold; if you do, keep the same basis over time so the DPO trend means something. Days in period is the count of calendar days in the same reporting period, not the number of business days and not a different period chosen to make the result look better.
A worked example
Suppose accounts payable are $1,250,000, cost of goods sold for the period is $9,000,000, and days in period is 365. Those are the three inputs: the AP balance, the COGS total for the same period, and the calendar days in that period. The AP figure would normally be pulled from the AP aging summary or the balance sheet AP line, and the COGS figure from the income statement for the same period.
Entering those figures gives days payable outstanding of 50.7 days and average paid per day of $24,658. In plain terms, the business is taking an average of 50.7 days to pay suppliers on this measure, and the COGS base spread across the period is $24,658 per day. The result is a period average; it does not tell you which invoices are late or which vendors are owed.
Use the worked example as a template, not as a benchmark. If the AP balance in your own records is a single closing figure but the balance moved a lot during the period, replace it with average AP, (opening + closing) / 2, using opening and closing totals from the same AP report. Do not mix a closing AP total from one date with a COGS total from another period.
Reading the result
Read DPO against your standard terms first. A DPO well above your standard terms means the business is paying late on average. A DPO below your standard terms may mean the business is paying earlier than required, which can be a cash choice but can also be a sign that invoices are being processed before they need to be. The number is only useful when compared with the terms actually in the vendor record and the payment run dates.
DPO is also a cash signal. A higher DPO keeps cash longer, but it can cost discounts and supplier goodwill. If early-payment discounts are on the table, compare the value of those terms with your own cost of funds rather than treating a higher DPO as automatically better. The right comparison is between the cash retained, the discount given up and the supplier relationship, not a single target number.
Average paid per day helps sanity-check the result. If DPO looks plausible but average paid per day is far from the scale of the business, check that AP and COGS are from the same period and that both are complete. A result produced from a partial AP ledger or a COGS figure that excludes some cost of sales is not a reliable DPO.
Where the inputs go wrong
One common mistake is using a closing AP balance when the balance swung sharply during the period. The fix is average AP, (opening + closing) / 2, using opening and closing totals from the same AP aging report or general ledger account. A single closing balance can make DPO look better or worse than the underlying payment behavior.
Another mistake is period mismatch. AP may be pulled as of the last day of the month while COGS covers a quarter, or COGS may include a post-period adjustment that AP does not. Use the same period for all three inputs and count calendar days in that period. If the AP total includes non-trade items such as accruals, taxes or intercompany balances, either remove them consistently or use a trade payables total that matches the COGS basis.
The third mistake is changing the denominator without saying so. Some analysts use purchases instead of cost of goods sold; that is acceptable only if the same basis is kept over time. Switching between COGS and purchases, or between average AP and closing AP, breaks comparability. Document the basis beside the result so the next person reading the DPO knows what was measured.
Questions
What is a good DPO?
There is no universal good DPO. Compare DPO with your standard terms and with your own trend; a DPO well above your standard terms means paying late, while a DPO below your terms may mean paying earlier than required.
Should I use average AP or closing AP in the DPO calculator?
Use average AP, (opening + closing) / 2, when the balance moves a lot. A single closing balance is simpler but can distort the result if payables swing during the period.
Can I use purchases instead of cost of goods sold?
Some analysts use purchases instead of cost of goods sold. Keep the same basis over time, because switching between COGS and purchases changes the result and makes trend comparison unreliable.
Why is my DPO different from the AP aging total?
DPO is a period measure using AP and COGS, not a vendor-level aging figure. Check that AP and COGS cover the same period and that the AP total ties to the balance sheet or AP aging summary.
Updated Nov 8, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.