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.
In practice
Real-world examples.
Example
TechStart Agency runs an ageing schedule and notices a client owes 5,000 pounds that is now 75 days overdue. They immediately pause new project work and call the finance director.
Example
Bakers Delight, a wholesale bakery, reviews its schedule monthly. They spot that local cafes are consistently paying at 45 days instead of the agreed 30 days, prompting a policy update.
Example
BuildPro Supplies uses an ageing schedule for its trade credit accounts. They notice 20,000 pounds sitting in the 90-plus days bucket and hand those specific accounts to a debt collection agency.
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 pounds current, 5,000 pounds at 1-30 days, and 2,000 pounds at 60+ days, total receivables equal 17,000 pounds.Case study
Seen in the real world.
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 pounds, nearly 40,000 pounds 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. They introduced automated payment reminders starting five days before the due date and implemented a strict policy to halt services once an invoice passed 45 days overdue. The business also contacted the three long-overdue clients, agreeing to payment plans for two of them and writing off the third as a bad debt.
Within three months of acting on the ageing schedule, Brighton reduced its over-90-days balance to under 5,000 pounds. This brought a vital cash injection into the business, funded upcoming payroll without needing a bank overdraft, and taught the management team the importance of monitoring invoice age weekly rather than quarterly.
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.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related