Small Business calculator
Accounts Receivable Aging Calculator
Sort what customers owe you by how late it is. The calculator shows how much is overdue, how long you wait to be paid on average, and a rough estimate of the amount at risk.
Reviewed November 2026
Total receivables
$77,000*
45.5% is past due, and you wait about 47 days to be paid.
*Estimate based on the figures you entered.
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 | Loss rate | Expected loss |
|---|---|---|---|---|
| Current | $42,000 | 54.5% | 1.0% | $420 |
| 1–30 days | $18,000 | 23.4% | 3.0% | $540 |
| 31–60 days | $9,000 | 11.7% | 10.0% | $900 |
| 61–90 days | $4,500 | 5.8% | 25.0% | $1,125 |
| Over 90 days | $3,500 | 4.5% | 50.0% | $1,750 |
| Total | $77,000 | 100.0% | 6.1% | $4,735 |
*The loss rates used to estimate uncollectible receivables are illustrative assumptions, not accounting standards. Your allowance for doubtful accounts should reflect your own collection history and be reviewed by your accountant. The results are for informational and directional guidance only. Actual results may vary. uTaxes does not in any way warrant the results from using this calculator.
How this calculator works
An aging schedule groups unpaid invoices by how far past the due date they are. The past-due share is everything outside the current bucket divided by total receivables, and the same is done for invoices more than 60 days late, where collection problems usually show first.
Days sales outstanding is total receivables divided by annual credit sales, multiplied by 365. It is the average number of days between sending an invoice and getting paid. Compare it with your payment terms: a DSO of 47 on net-30 terms means customers are taking about two extra weeks.
The uncollectible estimate multiplies each bucket by a loss rate and adds the results. The default rates rise with age because older invoices are less likely to be paid, but they are illustrations only. Your own write-off history is the right source, so change the rates to match it.
Related tools
Common questions
Short answers to what people ask most about this topic.
What is an accounts receivable aging report?
It is a list of unpaid customer invoices sorted into columns by age, usually current, 1–30, 31–60, 61–90 and over 90 days past due. Most accounting software produces it in one click, by customer.
Owners use it to decide whom to chase first, lenders use it to judge the quality of receivables, and accountants use it to estimate bad debts at year end.
What is a good days sales outstanding (DSO)?
There is no single number. A common rule of thumb is that DSO should sit within about one and a half times your payment terms, so under 45 days on net-30 terms, but it varies widely by industry and customer type.
The trend is more useful than the level. A DSO that climbs for several months in a row means collections are slipping even if sales look healthy.
How do I estimate bad debts from an aging schedule?
Apply a loss percentage to each age bucket and add the results. The total is the allowance for doubtful accounts, which reduces receivables on an accrual-basis balance sheet.
Base the percentages on what you have actually written off in past years for invoices of each age. The treatment on a tax return differs from the estimate in your books, so ask your accountant before deducting anything.
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.