Calculate days payable outstanding from your AP and COGS. See how far you sit from supplier terms and what five more days of DPO is worth in cash.
Free · no signup · runs in your browser·Updated
Short answer
Days payable outstanding is accounts payable divided by COGS for the period, multiplied by the days in that period. With $2,850,000 of AP against $6,300,000 of quarterly COGS over 91 days, DPO is 41.2 days. Read it against your supplier terms: below terms means you are paying early and funding your suppliers.
DPO measures how long you hold onto supplier cash. It is the cheapest financing on your balance sheet when it matches agreed terms, and the fastest way to lose supplier goodwill when it does not.
This DPO calculator takes closing accounts payable and the COGS or credit purchases for the same period. It returns days payable outstanding, the gap to your supplier terms, average daily purchases, and the cash a shift of a few days would move either way.
Your numbers
Denominator basis
$
Trade AP only. Remove accruals, intercompany and non-trade balances.
$
Cost of goods sold for the same period. Understates DPO while inventory is growing.
days
Actual calendar days: 30 or 31 monthly, 90 or 91 quarterly, 365 annually.
Spend-weighted average if terms vary by supplier.
days
The shift in DPO you want to price, in each direction.
Result
Days payable outstanding
41.2 days
3.8 days inside your 45-day terms
Average daily COGS$69,231
Gap to supplier terms-3.8 days
Supplier financing in place (AP)$2,850,000
AP if you paid exactly on 45-day terms$3,115,385
Cash from 5 more days of DPO$346,154
Annualised COGS (implied)$25,269,231
AP ÷ COGS = $2,850,000 ÷ $6,300,000 = 0.4524
× 91 days in period
DPO = 41.2 days · terms 45 days → gap -3.8 days
Each day of DPO moves $69,231 of cash.
Shift in DPO
New DPO
AP balance
Cash impact
-10 days
31.2 days
$2,157,692
-$692,308
-5 days
36.2 days
$2,503,846
-$346,154
0 days
41.2 days
$2,850,000
$0
+5 days
46.2 days
$3,196,154
$346,154
+10 days
51.2 days
$3,542,308
$692,308
DPO of 41.2 days sits within 5 days of your 45-day terms. Payment runs are doing what they were designed to do.
Everything is computed in your browser. Nothing you type is sent anywhere or stored.
The formula
DPO = (Accounts payable ÷ COGS) × Days in period
Accounts payable
Closing trade AP for the period. Strip out accruals, intercompany and non-trade balances.
COGS
Cost of goods sold for the same period. Credit purchases is the purer denominator if you can get it.
Days in period
Actual calendar days: 30 or 31 for a month, 90 or 91 for a quarter, 365 for a year.
Two denominators are in common use. Credit purchases is technically correct, because AP is created by purchasing, not by consumption. COGS is what most ERPs hand you without extra work, and it understates DPO whenever inventory is growing. Pick one and never mix them across periods.
Worked example
Accounts payable (closing)
$2,850,000
COGS in period
$6,300,000
Days in period
91
Supplier terms
Net 45
Result
DPO = 41.2 days · 3.8 days inside terms
$2,850,000 ÷ $6,300,000 = 0.4524. Multiply by 91 days and DPO is 41.2 days, which sits 3.8 days inside net-45 terms. Average daily purchases are $69,231, so paying exactly on terms instead of 3.8 days early would hold another $265,385 in the bank permanently.
Reading your DPO against supplier terms
A DPO of 41 days tells you nothing on its own. On net-30 terms it means you are 11 days late; on net-60 it means you are paying 19 days early and handing a supplier free working capital. The gap is the number to manage.
DPO vs terms
What it usually means
First thing to check
More than 5 days inside terms
You are paying early and financing your suppliers.
Whether early payment is buying a discount worth more than your cost of capital.
Within 5 days of terms
Payment runs are behaving as designed.
How much spend sits on the shortest terms you have granted.
5 to 15 days beyond terms
Approval and receipting delays, not a deliberate policy.
Three-way match failures and invoices parked in approval queues.
More than 15 days beyond terms
Suppliers are financing you without having agreed to it.
Credit holds, prepayment demands, and lead times quietly lengthening.
Where stretching DPO costs more than it saves
You give up a discount worth more than the cash. Taking 2/10 net 30 is worth roughly 36% a year annualised. Check it with the early payment discount calculator before you extend anything.
Price creeps back. Suppliers who fund you for 60 days price that in at the next renewal, usually as a 1–3% uplift that never shows up in a DPO report.
Allocation goes elsewhere. When a part is short, the supplier ships to whoever pays on time. Stretched DPO buys stockouts that cost far more than the interest saved.
Late fees and interest. Statutory late-payment interest applies in many jurisdictions whether or not the supplier chases it.
The number becomes fiction. A DPO inflated by disputed and unposted invoices is not free financing; it is an unrecorded liability waiting for the auditor.
Getting a clean AP denominator
The arithmetic is trivial. The work is in the inputs: trade AP only, with accruals and intercompany removed, matched to purchases or COGS for exactly the same period, split by entity because terms differ by entity. Most teams rebuild that from a saved search and a pivot table every month.
With ERPray you ask for it in plain words — "DPO by subsidiary for the last six months on trade AP only" — and get the number computed live from your own account, with the query shown underneath so you can check the definition rather than trust it.
Frequently asked questions
How do you calculate DPO?
Divide closing accounts payable by COGS or credit purchases for the period, then multiply by the days in that period. For example, $2,850,000 of AP against $6,300,000 of quarterly COGS over 91 days gives 41.2 days. Use trade AP only, and keep the denominator basis consistent between periods.
What is a good DPO?
One that lands within a few days of the terms you actually agreed. Paying materially early gives away free financing; paying materially late buys price increases and supply risk. If your weighted average terms are net 45, a DPO of 43 to 48 days is the healthy band.
Should DPO use COGS or credit purchases?
Credit purchases is the more accurate denominator, because payables are created by buying rather than by consuming. COGS is the practical substitute most systems report directly. COGS understates DPO whenever inventory is rising, so if you switch basis, restate your history at the same time.
Is a high DPO good or bad?
It depends entirely on whether the terms were agreed. A high DPO from negotiated net-60 terms is cheap working capital. The same DPO from unapproved invoices and late payment runs is a supplier relationship problem that shows up later as higher prices, prepayment demands and longer lead times.
How does DPO affect the cash conversion cycle?
DPO is subtracted in the cycle: CCC equals DIO plus DSO minus DPO. Every extra day of DPO shortens the cycle by one day and releases one day of purchases in cash. Model all three legs together with the cash conversion cycle calculator.
This calculator needs you to find the inputs first. ERPray pulls them from your own ERP account and computes the answer live — with the exact query shown so you can check it.