What it means
Not all unpaid invoices carry the same risk. An invoice that is five days past due is rarely a worry, while one that is 120 days overdue may never be paid.
An ageing schedule makes this visible by grouping receivables into time buckets. The schedule is built from the receivables ledger, listing each customer's balance in the bucket that matches how long it has been unpaid.
Totals across the buckets must equal the total receivables on the balance sheet. A second version, the payables ageing schedule, does the same for amounts the company owes its suppliers.
Credit controllers use the schedule to decide whom to call first. They chase the oldest and largest balances, consider stopping further sales to repeat late payers and escalate when invoices pass a set age.
The schedule also reveals if a few customers account for most overdue debt. For accounting purposes, the schedule supports the allowance for doubtful accounts.
The company applies a rising percentage to each bucket, such as 1% for current balances and 50% for those over 90 days, to estimate expected losses. The percentages should reflect the company's own collection history.
A schedule is a snapshot, so trends matter. If the share of balances over 60 days is rising month after month, collection is deteriorating, even if total receivables look steady.
Reviewing the schedule monthly lets management act before bad debts pile up. Software makes the work easier, because accounting systems can produce the schedule at the click of a button.
The risk is that people look at the totals and ignore the detail. The most useful version lists customers individually within each bucket, so a controller can see at once which names to chase.
In practice
Real-world examples
Example 1
A wholesaler runs its ageing schedule every Monday. It spots that one retailer has moved from the 31 to 60 day bucket to the 61 to 90 day bucket. The credit controller phones that day and agrees a payment plan, which stops the balance from sliding into a worse bucket.
Example 2
An accountant uses the schedule at year end to set the allowance for doubtful accounts. The bank reviewing the accounts can see the supporting calculation. It accepts the allowance without further questions, because the logic is clear and the rates are based on history.
Example 3
A manufacturer examines its payables ageing schedule and finds several supplier bills approaching 60 days. It pays the oldest first to protect its credit terms. The treasurer schedules payments weekly to avoid surprises, and keeps the largest suppliers on time first.
Think of it
An aging schedule sorts receivables by age-showing how long customers have owed you money.
Formula
Calculation
Estimated uncollectible amount = Sum of (Balance in each bucket x Estimated loss rate for that bucket)
A company has $200,000 of receivables split into five buckets. Current is $110,000 at 1%, which is $1,100. Overdue 1 to 30 days is $50,000 at 3%, which is $1,500. Overdue 31 to 60 days is $25,000 at 10%, which is $2,500. Overdue 61 to 90 days is $10,000 at 25%, which is $2,500, and over 90 days is $5,000 at 50%, which is $2,500. The buckets add up to $110,000 + $50,000 + $25,000 + $10,000 + $5,000 = $200,000, and the estimated uncollectible amount is $1,100 + $1,500 + $2,500 + $2,500 + $2,500 = $10,100.Case study
Seen in the real world
Quayside Marine Supplies is a fictional distributor that, in this illustrative story, reported receivables of $600,000 and assumed everything would be collected. Its new credit manager produced an ageing schedule for the first time.
The schedule showed that $90,000 was over 90 days old, and that $70,000 of that belonged to a single boatyard that was in financial difficulty. Applying a 50% loss rate to the over-90 bucket gave a provision of $45,000, more than the company had expected.
The credit manager stopped further shipments to the boatyard until it paid, negotiated a payment plan for part of the debt and began producing the schedule monthly. Over the next year the share of balances over 90 days fell from 15% to 4%. The board asked for the schedule to be included in every monthly pack.
Watch out
Common mistakes
- Producing the schedule but not acting on it. The value lies in chasing the older balances early.
- Using loss percentages unrelated to actual experience. Rates should be reviewed against what customers have really paid in the past.
- Letting the buckets stop reconciling to the ledger. The totals should always match the balance sheet.
Questions
People also ask
How often should an ageing schedule be prepared?
Monthly is common, and weekly for businesses with many invoices. The more frequent the review, the earlier problems appear.
Can I use it for payables as well?
Yes. A payables ageing schedule shows how long supplier bills have been outstanding and helps manage cash and supplier relationships.
What are the standard time buckets?
Many firms use current, 1 to 30, 31 to 60, 61 to 90 and over 90 days overdue. The buckets can be adapted to the payment terms of the industry, as long as they are applied consistently from month to month.
Watch