Logo

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

Your numbers

$

$

$

$

$

$

Sales made on invoice over the last 12 months. Leave out sales paid at the time of purchase.

Loss assumptions

%

Illustrative starting points, not accounting standards. Replace them with your own collection history.

%

%

%

%

Total receivables

$77,000*

45.5% is past due, and you wait about 47 days to be paid.

Current55%
1–30 days23%
31–60 days12%
61–90 days6%
Over 90 days5%
Past due$35,000
Past due share45.5%
More than 60 days past due$8,000
Share more than 60 days past due10.4%
Days sales outstanding (DSO)46.8 days
Estimated uncollectible$4,735
Estimated loss as a share of receivables6.1%
Receivables you can expect to collect$72,265

*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.

Book a consultation
Aging schedule with expected losses
BucketAmount% of totalLoss rateExpected loss
Current$42,00054.5%1.0%$420
1–30 days$18,00023.4%3.0%$540
31–60 days$9,00011.7%10.0%$900
61–90 days$4,5005.8%25.0%$1,125
Over 90 days$3,5004.5%50.0%$1,750
Total$77,000100.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.

Keep exploring

All resources

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.