This accounts payable days calculator estimates the average supplier payment period using credit purchases and average trade payables. Compare the result with agreed terms, calculate the payable balance at a target payment period, and export your results.
Accounts payable days results
How to use the accounts payable days calculator
The accounts payable days calculator works best when every input covers the same reporting period. Choose a reporting period and enter its net credit purchases. Use beginning and ending trade accounts payable from the same period, excluding unrelated debt and accruals. Enter the actual day count: for example, 365 for a common year or 90 for a 90-day quarter. Finally enter your target and supplier terms. All money values must use the same currency.
For a consistent accounts payable days calculator result, select the COGS estimate option if credit-purchase data is unavailable. It uses the same arithmetic but reports an approximation, since inventory movements and cash purchases can make COGS different from supplier credit purchases. The currency menu changes display formatting only; it does not retrieve exchange rates.
Accounts payable days calculator formula and symbols
EAP = Ending trade accounts payable
AAP = (BAP + EAP) ÷ 2
P = Net credit purchases, or selected COGS estimate
D = Days in reporting period
Accounts payable days = AAP ÷ P × D
AP turnover = P ÷ AAP
Daily cost basis = P ÷ D
AP at target = Daily cost basis × Target days
Cash retained at target = AP at target − Current average AP
When AAP is zero and purchases are positive, payable days are zero and turnover is undefined. Zero purchases are not accepted because the payment-period ratio cannot then be calculated. The target can be zero, representing immediate payment.
Accounts payable days calculator example: 36.5 days
This accounts payable days calculator example uses a business with annual credit purchases of $1,200,000, beginning AP of $100,000 and ending AP of $140,000. Its average trade AP is ($100,000 + $140,000) ÷ 2 = $120,000. Daily purchases are $1,200,000 ÷ 365 = $3,287.67.
Accounts payable days are $120,000 ÷ $1,200,000 × 365 = 36.5 days. AP turnover is 10.00×. Compared with 30-day supplier terms, the aggregate estimate is 6.5 days longer; it does not prove that any specific invoice is overdue.
A 30-day target implies $98,630.14 average AP. Moving from $120,000 to that balance would require approximately $21,369.86 in additional cash, assuming purchases and other conditions remain unchanged.
Interpret the accounts payable days calculator result
A longer payment period can preserve cash when suppliers have agreed to longer terms. It can also reflect cash pressure, disputed invoices or late payments. A shorter period may reflect prompt settlement, cash purchases, early-payment discounts or shorter contractual terms. Neither direction automatically indicates better performance.
Use the accounts payable days calculator to compare consistent periods and similar businesses. Pair the ratio with a supplier aging report, payment histories and discount terms. An aggregate calculation cannot identify the actual payment date of an invoice or determine whether a particular supplier has been paid on time.
Credit purchases versus COGS
Credit purchases measure purchases made on supplier credit during the period. COGS measures the cost of goods sold during that period. For a simple inventory business, total purchases may be estimated as COGS plus ending inventory minus beginning inventory. Cash purchases must then be removed to estimate credit purchases; returns and other adjustments also need consistent treatment. Do not assume every inventory purchase was made on credit.
The existing Days Payable Outstanding Calculator provides a related working-capital view. Use this page when your focus is the supplier credit-purchase basis and the cash effect of a payment-period target.
Assumptions and limitations
The accounts payable days calculator uses a two-point average, which may be misleading for seasonal businesses or rapid growth. Monthly or daily average payables can provide a more representative analysis. Foreign-exchange movements, supplier financing, acquisitions, changing purchase mix and reclassifications can affect comparisons. Match the AP balance to the included purchase categories.
The target cash estimate assumes a constant daily purchase rate. It excludes discounts, interest, taxes, supplier restrictions and invoice timing. It is a planning estimate, not a cash-flow forecast or a recommendation to delay contractual payments.
Accounts payable days FAQs
How do you calculate accounts payable days?
Divide average trade accounts payable by net credit purchases for the same period, then multiply by the period’s days.
Can I use cost of goods sold?
Yes, as an approximation. Select the COGS estimate basis and keep that basis consistent when comparing periods.
Is a higher number always better?
No. Longer payment cycles can preserve cash but can also indicate overdue bills or lost discounts. Compare supplier agreements and an aging report.
What if average accounts payable is zero?
With positive purchases, payable days are zero. Turnover is undefined because its denominator is zero.
Does the currency selection convert exchange rates?
No. It formats amounts only. Enter every amount in the same currency.
Source and related calculators
Reference: AccountingTools: accounts payable days formula. Results are educational estimates and do not replace professional accounting advice.