Small Business calculator
Accounts Payable Aging Calculator
Enter what you owe suppliers by how late each bill is. You will see how much is overdue, how long you take to pay on average, and what passing up an early-payment discount really costs.
Reviewed November 2026
Total payables
$43,000*
$13,000 is overdue, and cash on hand covers it 1.9 times.
*Estimate based on the figures you entered. Actual results depend on your full situation. This is not tax, legal or financial advice.
Want exact numbers for your situation?
A uTaxes CPA or enrolled agent can review it with you. The first consultation is free.
| Bucket | Amount | % of total |
|---|---|---|
| Not yet due | $30,000 | 69.8% |
| 1–30 days past due | $8,000 | 18.6% |
| 31–60 days past due | $3,000 | 7.0% |
| 61–90 days past due | $1,500 | 3.5% |
| Over 90 days past due | $500 | 1.2% |
| Total | $43,000 | 100.0% |
How this calculator works
The schedule adds up your unpaid bills and shows what share is past its due date. Days payable outstanding is total payables divided by annual credit purchases, multiplied by 365: the average number of days you take to pay a supplier. Cash coverage divides cash on hand by the bills that are already overdue, and by all payables.
Skipping an early-payment discount is a form of borrowing. The cost is the discount divided by one minus the discount, multiplied by 365 over the extra days you get to hold the money. On 2/10 net 30 you pay 2% more to keep the cash 20 more days, which works out to roughly 37% a year, far above most loan rates.
Discounts available per year is annual purchases times the share that offers a discount times the discount rate. The calculator assumes purchases are spread evenly through the year and does not model late fees or the effect of slow payment on supplier relationships.
Related tools
Common questions
Short answers to what people ask most about this topic.
What does 2/10 net 30 mean?
You may take 2% off the invoice if you pay within 10 days; otherwise the full amount is due in 30 days. Other versions work the same way: 1/10 net 30 is a 1% discount for paying within 10 days.
If you have the cash, or can borrow at a normal rate, taking the discount is almost always the cheaper choice. Paying on day 30 instead of day 10 costs about 37% on an annual basis.
Is a high days payable outstanding good or bad?
Both, depending on why it is high. Paying on the last day your terms allow keeps cash in your account longer and costs nothing. Paying after the due date also raises DPO, but it risks late fees, lost discounts, stricter terms and suppliers who put your orders last.
Compare DPO with the terms you were actually given. A figure well above your terms usually means bills are going unpaid, not that cash is being managed well.
How often should I review accounts payable aging?
Weekly is a sensible habit for most small businesses, before each payment run. It takes a few minutes if bills are entered when they arrive, and it prevents both surprises and duplicate payments.
At month end, the total on the aging report should match accounts payable on the balance sheet. If it does not, something was entered or paid incorrectly.
Talk to uTaxes
Want a professional to run your numbers?
Our CPAs and enrolled agents handle tax filing, bookkeeping and payroll for individuals and small businesses. The first consultation is free.
Related services
Keep exploring
All resourcesTools
Tax Prep Checklist
A printable checklist of every document to gather before you file.
Reference
Tax Brackets & Rates
Federal brackets, standard deductions and capital gains rates for 2026 and 2027.
Reference
Tax Deadlines
Every federal filing and payment date for the 2027 calendar, by who it applies to.
This page is general information, not tax, legal or financial advice. Tax rules change and depend on your situation; talk to a qualified professional before acting on it.