What is a good DPO (Days Payable Outstanding)?

DPO reflects the average time taken to pay suppliers. Optimal DPO balances cash management (paying later preserves cash) against supplier relationship risk (paying too late damages credit). Industry norms vary: retail operates at 30 to 60 DPO; manufacturing at 45 to 75 DPO; construction often 60 to 90 DPO due to project billing cycles. Extending DPO beyond industry norms or supplier terms creates relationship risk. Shorter DPO than terms suggests an opportunity to preserve cash by taking the full payment period.

What happens when AP invoices reach 90+ days past due?

At 90 days past due, many suppliers will: place the account on credit hold (no new orders until balance is resolved), require cash in advance (CIA) or cash on delivery (COD) for future orders, refer the balance to a collection agency, or report the delinquency to commercial credit bureaus (Dun & Bradstreet, Experian Business). Any of these consequences disrupts supply, increases cost, and signals financial distress to the broader credit market. Proactive communication with suppliers before reaching 90 days is always preferable.

How does AP aging affect the cash conversion cycle?

The cash conversion cycle (CCC) measures how long cash is tied up in operations: DIO (inventory days) + DSO (receivables days) - DPO (payables days). A longer DPO reduces the CCC and means suppliers effectively finance a portion of your operations. But DPO can only be extended to the extent that supplier relationships and terms allow. AP aging analysis helps you understand your current DPO and whether it is sustainable or already strained.

Should I pay suppliers early if I have excess cash?

Only if there is an economic benefit: an early payment discount worth capturing, a relationship benefit (priority allocation during supply tightness), or a discount on future pricing. Otherwise, paying before terms is an interest-free loan to your supplier that foregoes the return you could earn on that cash. Excess cash should generally be invested at the risk-free rate or used to pay down interest-bearing debt before prepaying suppliers who offer no discount.

Business Finance

Accounts Payable Aging Calculator

Analyze accounts payable by aging bucket (current, 30, 60, 90, 120+ days) with weighted days payable outstanding, vendor detail, and early payment discount savings analysis.

Vendor Payables Entry

Vendor 1

Vendor Name

Current (0 to 30 days) $

31 to 60 Days $

61 to 90 Days $

91 to 120 Days $

Over 120 Days $

Discount Terms

Discount % Available

Vendor 2

Vendor Name

Current (0 to 30 days) $

31 to 60 Days $

61 to 90 Days $

91 to 120 Days $

Over 120 Days $

Discount Terms

Discount % Available

Vendor 3

Vendor Name

Current (0 to 30 days) $

31 to 60 Days $

61 to 90 Days $

91 to 120 Days $

Over 120 Days $

Discount Terms

Discount % Available

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

Accounts payable aging is the other side of the cash flow equation that many businesses ignore until a supplier cuts off credit. While most finance teams track accounts receivable aging (who owes you money and how old it is), the AP aging report -- who you owe and how overdue each balance is -- directly determines your credit standing with suppliers, your eligibility for early-payment discounts, and your exposure to late payment fees and supply disruptions. According to the Dun & Bradstreet Payment Study, approximately 50% of B2B invoices in the US are paid past due. Businesses that pay consistently on time gain access to extended payment terms, better pricing, and priority allocation during supply shortages. This calculator organizes your payable balances by age bucket (current, 1-30 days late, 31-60 days, 61-90 days, 90+ days), calculates your weighted average payment lag, and flags outstanding balances where late fees or supply interruptions are likely.

What This Calculator Does

This accounts payable aging calculator takes your outstanding supplier invoices with their due dates and balances to produce an AP aging report bucketed into standard aging columns (current, 1-30 days, 31-60 days, 61-90 days, 90+ days past due), total AP balance by bucket, weighted average days payable outstanding (DPO), and an estimate of potential late payment fees on overdue balances.

The Formula

Days Past Due = Current Date - Invoice Due Date | DPO = (Accounts Payable Balance / COGS) × Days in Period

Days past due for each invoice is calculated from the due date to today. Invoices due today or in the future are 'current.' Invoices past their due date fall into the aging buckets. DPO (Days Payable Outstanding) is a summary metric: the average number of days taken to pay suppliers, calculated as total AP balance divided by daily COGS (annual COGS / 365). A DPO of 45 means the business takes 45 days on average to pay its suppliers after receiving goods or services.

Step-by-Step Example

List all open payables with due dates

A distributor's AP ledger as of June 1: Supplier A - Invoice $18,400 due May 15 (17 days past due). Supplier B - Invoice $42,000 due April 30 (32 days past due). Supplier C - Invoice $8,200 due June 10 (current, 9 days remaining). Supplier D - Invoice $31,000 due March 5 (88 days past due). Supplier E - Invoice $5,600 due June 20 (current).

Bucket each invoice by age

Current: $8,200 + $5,600 = $13,800. 1-30 days past due: $18,400. 31-60 days past due: $42,000. 61-90 days past due: $0. 90+ days past due: $31,000. Total AP: $105,200.

Calculate DPO

Annual COGS: $3,480,000. Daily COGS: $9,534. DPO: $105,200 / $9,534 = 11.0 days. Note: DPO is low here because this snapshot is mid-month before most invoices are issued. In a full-period calculation, a DPO of 30 to 45 days is typical for this industry.

Assess risk by bucket

Supplier D at 88 days overdue ($31,000) is approaching the threshold where suppliers typically place accounts on credit hold or send to collections. Priority payment or direct communication with Supplier D is required before the next purchase order. Supplier B at 32 days overdue ($42,000) is the largest 31-60 day balance -- escalate to finance for immediate payment scheduling.

Real-World Use Cases

Qualifying for Early Payment Discounts

A supplier offers 2/10 net 30 terms: a 2% discount if paid within 10 days of invoice, otherwise full amount due in 30 days. A $50,000 invoice: paying in 10 days saves $1,000. Annualized, 2/10 net 30 represents a 36.7% annual return on the cash deployed for early payment. Businesses with available cash and a clean AP aging can realize significant returns by systematically capturing early payment discounts.

Preparing for a Bank Loan Application

A lender reviewing a business loan application requests an AP aging report as part of the financial due diligence package. A heavily aged AP report -- significant balances over 60 days past due -- signals cash flow stress and may result in additional scrutiny, a higher interest rate, or a reduced loan amount. Cleaning up overdue payables before applying (by negotiating payment plans or making scheduled payments) improves the due diligence presentation.

Managing a Cash Shortfall

During a temporary cash shortfall, a business cannot pay all outstanding invoices immediately. The AP aging report enables prioritized payment: pay invoices where late fees are highest first, pay suppliers with the most critical supply relationships next, defer lower-priority and most-flexible suppliers to the following cycle. Without an organized aging view, payment decisions are made ad hoc and suboptimally.

Comparison

AP Aging Bucket	Typical Risk Level	Recommended Action
Current (not yet due)	None	Schedule payment per cash flow plan
1-30 days past due	Low to Medium	Schedule immediate payment; review if systematic
31-60 days past due	Medium	Contact supplier; arrange payment; negotiate if needed
61-90 days past due	High	Immediate action; risk of credit hold or COD requirement
90+ days past due	Critical	Direct supplier call; payment plan; collections risk

Common Mistakes to Avoid

Not reconciling AP aging to the general ledger balance. The sum of all open invoices in the AP aging report should equal the AP balance on the balance sheet. Discrepancies indicate duplicate invoices, unapplied payments, or missing entries that distort both the aging report and financial statements.
Excluding vendor credit memos from the aging report. If a supplier has issued a credit memo (for returned goods or a price adjustment) that has not been applied, the net balance owed is lower than the gross invoice total. An aging report that shows gross invoices without netting credits overstates the AP balance and can trigger unnecessary payment urgency.
Focusing only on old invoices and ignoring large current balances. A $200,000 current invoice due in 5 days requires cash planning today -- it will become overdue very quickly if not addressed. AP aging management means planning for upcoming large payments, not just managing what is already late.

Frequently Asked Questions

Accuracy and Disclaimer

Accounts payable aging calculations are based on the invoice data and due dates provided. Results are for accounts payable management and cash planning purposes only. Late payment consequences vary by supplier contract terms and jurisdiction. This calculator does not constitute legal or financial advice.

Conclusion

AP aging analysis is a cash management tool and a supplier relationship tool simultaneously. Businesses that understand their AP aging can prioritize which invoices to pay first (largest penalties, most critical suppliers) and which can be deferred safely. For the receivables side of the same cash equation, the Accounts Receivable Days Calculator provides the AR aging equivalent. To project how current AP aging affects short-term cash needs, use the Cash Flow Forecast Calculator.