Vendor 1
Vendor 2
Vendor 3
Embed This Calculator on Your Website
Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.
What This Calculator Does
This accounts payable aging calculator organizes outstanding vendor invoices into standard aging buckets (current, 31 to 60 days, 61 to 90 days, 91 to 120 days, and over 120 days), calculates a weighted average days payable outstanding (DPO) for each vendor and overall, and analyzes early payment discount savings opportunities. It supports multiple vendors with individual aging detail and produces summary totals with percentage distribution across buckets. The DPO benchmarks reference 2026 industry averages by sector.
The Formula
Days payable outstanding (DPO) measures the average number of days a company takes to pay its vendors. A weighted DPO assigns greater influence to larger vendor balances. Each aging bucket is assigned a midpoint (current = 15 days, 31-60 = 45 days, 61-90 = 75 days, 91-120 = 105 days, over 120 = 135 days) to calculate the weighted average. Early payment discounts (such as 2/10 Net 30) offer savings for paying before the standard due date.
Step-by-Step Example
Enter vendor payables
Vendor A: $15,000 current, $8,000 in 31-60 days. Vendor B: $5,000 current, $12,000 in 61-90 days. Vendor C: $3,000 in 91-120 days.
View aging distribution
Total payables: $43,000. Current: $20,000 (46.5%). 31-60: $8,000 (18.6%). 61-90: $12,000 (27.9%). 91-120: $3,000 (7.0%).
Calculate weighted DPO
Weighted average DPO: 42 days. Vendor A: 22 days. Vendor B: 62 days. Vendor C: 105 days.
Analyze discount opportunities
Vendor A offers 2/10 Net 30. Paying $23,000 within 10 days saves $460. Annualized return on early payment: 36.7%.
Real-World Use Cases
Cash Flow Management
AP managers use aging reports to prioritize payments, ensuring critical vendors are paid on time while strategically delaying less urgent payments to preserve cash.
Vendor Relationship Management
Identifying vendors with balances over 60 or 90 days helps prevent supply disruptions, late fees, and damaged relationships before they escalate.
Early Payment Discount Analysis
Quantifying the dollar savings from taking early payment discounts versus holding cash helps treasury teams make optimal payment timing decisions. A 2/10 Net 30 discount equals a 36.7% annualized return.
Common Mistakes to Avoid
Ignoring early payment discounts. A 2% discount for paying 20 days early (2/10 Net 30) has an annualized return of 36.7%. This exceeds almost any other use of short-term cash.
Letting payables age past 90 days without communication. Many vendors report delinquent accounts to credit agencies or add late fees at 60 to 90 days. Proactive communication preserves relationships.
Focusing only on total payables without analyzing aging distribution. A company with $500,000 in payables that is 90% current has a very different risk profile than one that is 50% over 60 days.
Not benchmarking DPO against industry norms. A DPO of 60 days is normal in manufacturing but signals problems in professional services where 25 to 40 days is typical.
Frequently Asked Questions
Accuracy and Disclaimer
AP aging analysis is based on the data you enter for each vendor. Actual payment terms, discount eligibility, and DPO calculations depend on your specific vendor agreements. DPO benchmarks are 2026 industry averages. Consult your accountant or controller for formal AP management decisions.
Related Calculators
Gross Margin Calculator
Calculate gross profit, gross margin percentage, and markup from revenue and cost of goods sold.
Use CalculatorBusiness FinanceContribution Margin Calculator
Calculate contribution margin per unit, ratio, total contribution, and break-even from price and variable costs.
Use CalculatorBusiness FinanceMarkup vs Margin Calculator
Convert between markup and margin percentages and calculate selling price from cost using either method.
Use Calculator