What it means
When you sell goods or services on credit, you record the amount as an account receivable. However, making the sale is only half the battle; collecting the cash is what keeps your business alive.
An ageing schedule takes your total unpaid customer invoices and groups them into time buckets, usually current, 1 to 30 days past due, 31 to 60 days past due, 61 to 90 days past due, and over 90 days past due. This simple layout immediately shows you which clients are paying on time and which are falling behind.
Why does this matter for non-finance managers? Because profit on paper does not pay the bills, cash does.
Without a clear view of invoice age, overdue balances tend to hide in plain sight until cash flow suddenly dries up. By reviewing this report regularly, you can spot payment trends early.
For instance, if a normally reliable client suddenly starts sliding into the 30-day overdue bracket, you can step in before the debt becomes uncollectable. In practice, this report guides your credit control or accounts receivable team on where to focus their energy each week.
Instead of chasing every invoice randomly, your staff can prioritise the oldest and largest balances. Managers also use this data to calculate the allowance for doubtful accounts, which is an estimate of the money you realistically expect never to collect, helping you keep your balance sheet accurate.
An ageing schedule is like a traffic light system for your customer list. Green invoices are flowing smoothly, amber invoices are slowing down and need a gentle beep, and red invoices are stuck and require urgent action.
In practice
Real-world examples
Example 1
TechStart Agency runs its ageing schedule each Monday and notices that one client owes $5,000 that is now 75 days overdue. The agency pauses new project work for that client, and the account manager calls the client's finance director the same day. The two parties agree a payment date within five working days, which is recorded on the schedule.
Example 2
A wholesale bakery supplier reviews its schedule monthly and spots that several local cafes consistently pay at 45 days instead of the agreed 30. Rather than chasing each invoice, the finance manager updates the standard terms for new cafe accounts and adds a late payment fee to the contract. Existing accounts receive a letter explaining the change before it takes effect.
Example 3
Brickfield Supplies uses its ageing schedule for trade credit accounts and notices that $20,000 sits in the 90-plus days bucket. The credit team sends a final notice to each account, then hands the most overdue accounts to a debt collection agency after 30 days with no response. The remaining balances are reviewed each quarter against the allowance for doubtful accounts.
Think of it
An ageing schedule is like a traffic light system for your customer list. Green invoices are flowing smoothly, amber invoices are slowing down and need a gentle beep, and red invoices are stuck and require urgent action.
Formula
Calculation
Total Receivables = Current + 1-30 Days Overdue + 31-60 Days Overdue + 61-90 Days Overdue + 90+ Days Overdue. Example: If Apex Ltd has $10,000 current, $5,000 at 1-30 days, and $2,000 at 60+ days, total receivables equal $17,000.Case study
Seen in the real world
This is a fictional, illustrative scenario. Brighton Marketing, a mid-sized digital agency, was growing rapidly but struggling with a dwindling bank balance despite strong invoiced sales. The managing director asked the finance team for an ageing schedule. The report revealed a startling truth: while total outstanding receivables stood at $100,000, nearly $40,000 of that was over 90 days old, tied up with three clients who had quietly stopped responding to standard reminder emails.
Armed with this clear visibility, Brighton Marketing changed its credit control process. It introduced automated payment reminders starting five days before the due date, and it implemented a strict policy to halt services once an invoice passed 45 days overdue. The finance team also set a weekly call list for any invoice past 30 days. The team contacted the three long-overdue clients, agreeing a payment plan with two of them and writing off the third as a bad debt.
Within three months of acting on the schedule, Brighton reduced its over-90-days balance to under $5,000. The cash injection funded upcoming payroll without a bank overdraft, and the team learned to review invoice age weekly rather than quarterly. The managing director also made the schedule a standing item at the monthly board meeting. The schedule is now shared with account managers, who check a client's payment history before agreeing to new projects or extended credit.
Watch out
Common mistakes
- Waiting until month-end or year-end to look at the report instead of checking it weekly.
- Failing to update invoice statuses when customer payments arrive, leading to awkward follow-up calls.
- Ignoring small overdue balances that add up to significant lost revenue over time.
Questions
People also ask
How often should I look at my ageing schedule?
At least once a month for small businesses, but weekly is much better if you have a high volume of transactions and tight cash flow.
What happens to very old invoices on the schedule?
If an invoice remains unpaid after many months and collection efforts fail, it is usually written off as bad debt and removed from active receivables.
Is the ageing schedule only for finance teams?
No. Sales and account managers should review it too, because a client's payment history is vital before agreeing to new projects or extended credit.