• Accounting: customers, bad debts and postdated checks

How do you prepare an aging schedule of receivables?

Written with AI (How we create content)Target level: Grade 11Last updated: Report an error
Quick answer

To prepare an aging schedule of receivables, sort every customer's balance by how long it is past due, for example not yet due, 1 to 30 days, 31 to 90 days and over 90 days, then multiply each group by a rate that rises with age. The total is the allowance for doubtful accounts the business needs at the year end.

The topic explained

Old debts are riskier debts

A customer whose invoice is not yet due will almost certainly pay. One who is three months late is far less likely to. A single percentage of all customers, as in the simplest allowance, ignores that difference. An aging schedule uses it: each balance is sorted by how long it is past its due date, and each age group gets its own estimated rate of loss, higher for older debts.

A made-up wholesaler is owed ₪300,000 on December 31. Sorted by age: ₪180,000 is not yet due, ₪70,000 is 1 to 30 days late, ₪35,000 is 31 to 90 days late and ₪15,000 is more than 90 days late. Only 5% of the money is very late, but, as the next step shows, it carries much of the risk.

Bar chart drawn to scale of the wholesaler's customers by age: not due ₪180,000, 1 to 30 days late ₪70,000, 31 to 90 days ₪35,000, over 90 days ₪15,000.₪180,000Not due₪70,0001-30₪35,00031-90₪15,000Over 90
Most of the money is not yet due; the risk sits in the small bars.

From the schedule to the allowance

The wholesaler sets its rates from experience: 1% for debts not yet due, 4% for 1 to 30 days, 10% for 31 to 90 days and 40% for more than 90 days. Each group times its rate gives its share of the allowance: ₪1,800, ₪2,800, ₪3,500 and ₪6,000, a total of ₪14,100. The ₪15,000 of very late debts needs ₪6,000, more than the ₪180,000 that is not yet due. A flat 4% of all customers would have given ₪12,000 and missed that risk.

International standards accept this kind of table, called a provision matrix, as a practical way to measure expected credit losses on customers. The rates are estimates; they are checked each year against what was actually lost.

Aging schedule: not yet due ₪180,000 at 1%, ₪1,800; 1 to 30 days late ₪70,000 at 4%, ₪2,800; 31 to 90 days ₪35,000 at 10%, ₪3,500; over 90 days ₪15,000 at 40%, ₪6,000; total ₪300,000 and ₪14,100.AgeBalance ₪RateAllowance ₪Not yet due180,0001%1,8001-30 days late70,0004%2,80031-90 days late35,00010%3,500Over 90 days late15,00040%6,000Total300,00014,100
Illustrative rates, rising with the age of the debt.

The adjusting entry is the gap

The schedule gives the balance the allowance must have, not the entry. After this year's write-offs, the allowance account holds ₪9,600. So the adjusting entry is the difference, 14,100 − 9,600 = ₪4,500: debit Doubtful debts expense ₪4,500, credit Allowance for doubtful accounts ₪4,500. If the account held more than the schedule requires, the entry would reduce it and lower the expense.

The most common mistake is to record the whole ₪14,100 as this year's expense, which is right only when the account starts empty. The second is to count the days late from the invoice date instead of the due date: a 60-day invoice written 50 days ago is not late at all.

Flow: required allowance ₪14,100 from the aging, in the account ₪9,600 after write-offs, so the adjusting entry is an increase of ₪4,500.₪14,100Required₪9,600In the accountIncrease ₪4,500Adjusting entry
Only the gap is recorded.

Reading the schedule as a manager

The aging schedule is also a warning light. If the share of debts more than 90 days late grows from year to year, collection is getting worse even when total sales are rising. A manager reads the list behind each group: which customers are late, how often, and by how much. The usual responses are calling the customer, stopping new credit until the old debt is paid, asking for a postdated check or a guarantee, or, in the end, handing the debt to a lawyer.

The schedule is only as good as its dates. A payment that has not been matched to the right invoice makes an old debt look current, and a credit note that was never recorded makes a customer look later than it is. Before trusting the ages, the bookkeeper checks that every receipt and every return has been posted to the right customer and the right invoice.

Free printable worksheet

Practice: an aging schedule

For 11th grade accounting students. A shop is owed ₪120,000 on December 31: ₪70,000 not yet due, ₪30,000 1 to 30 days late, ₪15,000 31 to 90 days late and ₪5,000 over 90 days late. Its rates are 2%, 5%, 15% and 50%. Its allowance account holds ₪8,000 after write-offs. Check the answers at the end.

Free, no sign-up. The answer key prints on the second page. Regenerating a new worksheet on the same topic needs a free account.

Free printable worksheetlessoons.com
Practice: an aging scheduleName:
  1. Why does an older debt get a higher rate?

  2. Find the days late on December 31 and the age group of each invoice.

    Table of four invoices due January 15, December 10, October 15 and August 1, with the days late at December 31 and the age group marked with question marks.InvoiceDays lateAge groupDue January 15??Due December 10??Due October 15??Due August 1??
  3. Complete the shop's aging schedule.

    The shop's aging schedule: not yet due ₪70,000 at 2%, 1 to 30 days ₪30,000 at 5%, 31 to 90 days ₪15,000 at 15%, over 90 days ₪5,000 at 50%, total ₪120,000; the allowance column is question marks.AgeBalance ₪RateAllowance ₪Not yet due70,0002%?1-30 days late30,0005%?31-90 days late15,00015%?Over 90 days late5,00050%?Total120,000?
  4. Write the adjusting entry.

  5. Which age group needs the largest part of the allowance, and what share of the money owed is it?

    Bar chart drawn to scale of the shop's allowance by age group: not due ₪1,400, 1 to 30 days ₪1,500, 31 to 90 days ₪2,250, over 90 days ₪2,500.₪1,400Not due₪1,5001-30₪2,25031-90₪2,500Over 90
  6. A flat rate of 5% of all customers would give what allowance? Why is the aging schedule a better estimate?

  7. A student applies 50% to every customer who is late at all, including those 1 to 30 days late. What is wrong?

More topics and worksheets at lessoons.com© 2026 Lessons

Common questions

What is an aging schedule of receivables?

A table that sorts the money customers owe by how long it is past due, usually not yet due, 1 to 30, 31 to 90 and over 90 days, and applies a rate of expected loss to each group.

Where do the rates in an aging schedule come from?

From the business's own experience of how much of each age group was lost in past years, adjusted for what it expects now. They are estimates and are reviewed every year.

Is the total of the aging schedule the year's expense?

No. It is the balance the allowance needs. The expense is only the difference between that balance and what is already in the allowance account after the year's write-offs.

Are days late counted from the invoice date?

No, from the due date. An invoice with 60 days of credit is not late until those 60 days have passed.

How does a business use the aging schedule besides the allowance?

To manage collection: to see which customers are late, call them, stop new credit until they pay, and notice if the share of old debts is growing.

Still have a question? Ask Lessi

Any question about this subject. Lessi answers right here, step by step.

Try asking

Asking needs a free account; your question is kept while you sign up. Answers are written by AI and can contain mistakes. Lessi doesn’t give medical or legal advice.

Learn it with a teacher

Learn this topic live with Lessi

Lessi, the AI teacher, explains it out loud on a board, with short quizzes, at your pace. The first 60 minutes are free.