Aging Schedule Calculator
An aging schedule takes the one number every business owner knows, total receivables, and splits it by how long each part has been waiting to be paid. That split is the whole point. A $78,200 receivables book is healthy if most of it was invoiced last week, and a cash-flow problem if a third of it has sat unpaid since last quarter. Until you age it, the two situations look identical in your accounts.
The Aging Schedule Calculator below takes your five standard buckets (current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due), totals them, and shows each bucket as a share of the whole book, plus the two subtotals that drive decisions: everything past due, and everything past 60 days, where collection rates fall off a cliff.
Enter outstanding balances by due-date aging (how late each invoice is), and keep the same basis every month. Mixing due-date and invoice-date aging in one trend makes the percentages meaningless.
Quick Answer
Key takeaways
- Total receivables = current + 1 to 30 + 31 to 60 + 61 to 90 + over 90. Bucket share = bucket / total x 100, and the five shares must add to 100%.
- Read the past-60-days share first: under 10% is healthy, 10 to 20% is a forming tail, over 30% is bad-debt territory.
- Age outstanding balances by due date, on the same basis every period. The basis matters more than the arithmetic.
- The schedule total must agree with the receivables control account on your balance sheet. If it does not, the export was incomplete and every percentage after it is wrong.
- Quick Answer
- How to build the schedule before you trust it
- Worked example: a $78,200 book with a forming tail
- From schedule to allowance: the step the schedule exists for
- Reading the schedule like a lender does
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to build the schedule before you trust it
The division at the end is trivial. Everything that goes wrong happens in the three steps before it, which is why this section comes before the worked example.
First, choose the aging basis and never mix it. Aging by due date measures how late a customer is. Aging by invoice date measures how long your cash has been out. QuickBooks and Xero both default to due date. Pick one, write it down, and use it every month, because a trend that switches basis halfway through is fiction.
Second, age the outstanding balance, not the invoice. A $10,000 invoice with $6,000 paid belongs in the schedule at $4,000, in the bucket its due date puts it in. Aging the original value double-counts money you already have. Credit notes and unapplied payments belong in the schedule as reductions of their bucket, or the old buckets overstate what is owed.
Third, reconcile. The bottom line of the schedule must equal the accounts receivable control account. A gap means invoices are missing from the export, and no percentage computed from a partial book deserves a decision.
Worked example: a $78,200 book with a forming tail
The calculator is pre-filled with this book, and the figures below are exactly what it returns.
| Bucket | Balance | Share of total | What it usually means |
|---|---|---|---|
| Current | $42,000.00 | 53.71% | Inside terms. A reminder a few days before the due date keeps it that way. |
| 1 to 30 days | $18,500.00 | 23.66% | Usually a missed payment run. Automated reminder, then a short email naming the invoice. |
| 31 to 60 days | $9,400.00 | 12.02% | Something is wrong: dispute, lost invoice, or stuck approval. Phone the AP contact. |
| 61 to 90 days | $5,200.00 | 6.65% | The account is drifting. Escalate, hold new orders, offer a dated payment plan. |
| Over 90 days | $3,100.00 | 3.96% | At risk until proven otherwise. Formal demand, plan, or write-off decision. |
| Total | $78,200.00 | 100% | Past due in total: $36,200 (46.29%). Past 60 days: $8,300 (10.61%). |
The headline is not the 46.29% past due: on net-30 terms, a book invoiced evenly through the month always carries a large recently-overdue slice. The headline is the direction of the tail. This month 10.61% sits past 60 days. If next month shows 14%, the problem is not any single customer, it is the follow-up routine at day 30, and that is fixable.
From schedule to allowance: the step the schedule exists for
Accountants use the aging schedule to estimate the allowance for doubtful accounts: the older the bucket, the larger the share you expect never to collect. Multiply each bucket by an uncollectible percentage drawn from your own write-off history, and add the results. Using the textbook pattern of rates (1%, 3%, 10%, 25%, 50%) on the worked example:
| Bucket | Balance | Estimated uncollectible | Allowance |
|---|---|---|---|
| Current | $42,000.00 | 1% | $420.00 |
| 1 to 30 days | $18,500.00 | 3% | $555.00 |
| 31 to 60 days | $9,400.00 | 10% | $940.00 |
| 61 to 90 days | $5,200.00 | 25% | $1,300.00 |
| Over 90 days | $3,100.00 | 50% | $1,550.00 |
| Estimated allowance | $4,765.00 (6.09% of the book) |
Those percentages are assumptions, not a standard: replace them with your own three-year write-off rate per bucket, which is the figure an auditor will ask for. This aging method is also a standard input to expected-credit-loss estimates under the CECL standard (FASB ASU 2016-13) for US firms. If the allowance itself is the number you need to book, the bad debt provision calculator works that calculation directly. And when an old balance moves from doubtful to actively pursued, the debt collection interest calculator prices the interest side of chasing it.
Reading the schedule like a lender does
Four audiences read the same table differently, and knowing their angle changes what you fix first. Finance works it as a call list, largest old balance first. A lender advancing against receivables usually excludes balances past 90 days from the borrowing base outright, so a fat 90+ bucket directly cuts your credit line. An acquirer reads the same tail as a discount on the purchase price. Your auditor reads it as the evidence behind the allowance.
Signs the book is healthy
- Past-60-days share under 10% and stable month to month.
- The 31 to 60 bucket shrinks as the 1 to 30 bucket feeds it: invoices move out by payment, not by aging.
- No single customer dominates the over-90 bucket.
Signs to act this week
- Past-60-days share climbing two months in a row, whatever its level.
- A 31 to 60 balance with no dispute on record: it is lost, unapproved, or the customer has a cash problem they have not mentioned.
- Schedule total that no longer ties to the balance sheet control account.
The schedule also feeds the wider working-capital picture: receivables that sit longer stretch the cash cycle even when sales look strong, which is the relationship the cash flow to sales calculator measures from the other side.
What competing calculators miss
We reviewed the tools and guides ranking for this search. The best of them is genuinely good, and it is built to sell you something.
Winning move 1: the verdict without the subscription. The leading tool (Paidnice) computes shares and a past-60 headline well, then funnels you into its invoice-chasing product, and its collection risk score is a house formula with no published basis. This calculator gives the shares, the past-due and past-60 subtotals, and a health verdict keyed to the past-60 share with its bands stated in plain text, free-standing.
Winning move 2: the allowance worked end to end. Guide pages describe the allowance method and calculator pages skip it. Here the worked example continues past the schedule into a full allowance table ($4,765 on the example book), with the honest caveat that the percentages must come from your own history.
Winning move 3: no invented split. Some aging tools take one total receivables figure and spread it across buckets on a fixed assumption, then report risk off numbers you never entered. This schedule uses only the five buckets you type in. If you did not enter it, it is not in the result.
Frequently asked questions
It is a table that sorts every unpaid invoice into age buckets (current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due) and totals each bucket. Accountants use it to judge collectability, set the allowance for doubtful accounts, and prioritize collection work. The calculator on this page totals the buckets and converts each to a share of total receivables.
Bucket share = (balance in the bucket / total receivables) x 100. In the worked example, current is $42,000 / $78,200 x 100 = 53.71%. The five shares always add to 100%, which is a quick check that the buckets were entered completely.
Either is defensible; mixing them is not. Due-date aging measures how late customers are and is the default in QuickBooks and Xero. Invoice-date aging measures how long cash has been out. Pick the basis that matches the question you are asking, then use it consistently so month-to-month comparisons mean something.
As a working rule: under 10% of the book past 60 days is healthy, 10 to 20% means a tail is forming, 20 to 30% points to a collections gap, and over 30% is real bad-debt risk. The right level varies by industry and terms, so the trend in your own schedule matters more than any single reading.
Multiply each bucket by the percentage you historically fail to collect from that bucket, then add the results. Older buckets carry much higher rates: a common textbook pattern is 1% current, 3% at 1 to 30 days, 10% at 31 to 60, 25% at 61 to 90, and 50% past 90, which gives a $4,765 allowance on this page's $78,200 example. Use your own write-off history in place of the textbook rates.
Monthly is the minimum for the financial statements, but the schedule earns its keep as a weekly work list: the 31 to 60 bucket is where a phone call still changes the outcome cheaply. By the time a balance reaches the monthly report at 90 days, the cheap options are mostly gone.
Then the schedule is built on an incomplete export, and its percentages should not be used until it reconciles. Common causes are unapplied payments and credit notes left out of the export, or invoices aged on their original value after a part payment. Fix the export first; the arithmetic after it is the easy part.
Add This Calculator to Your Website
References
- AccountingTools, "Accounts Receivable Aging" - the standard definition of the aging report and its role in estimating uncollectible balances. AccountingTools: Accounts Receivable Aging. Accessed October 2026.
- Corporate Finance Institute, "Accounts Receivable (AR) Aging" - bucket structure and how the schedule supports credit and collection decisions. CFI: Accounts Receivable Aging. Accessed October 2026.
- Investopedia, "Aging Schedule" - the method definition and its use in assessing a company's receivables management. Investopedia: Aging Schedule. Accessed October 2026.
- FreshBooks, "Accounts Receivable Aging" hub guide - practical aging report preparation for small businesses. FreshBooks: Accounts Receivable Aging. Accessed October 2026.
- NetSuite, "Accounts Receivable Aging" resource article - aging categories and their use in cash-flow management. NetSuite: Accounts Receivable Aging. Accessed October 2026.
- Financial Accounting Standards Board, Accounting Standards Update 2016-13 (CECL) - the expected-credit-loss framework for which aging schedules are a standard input. FASB: Current Expected Credit Losses. Accessed October 2026.