What it means
When you run a business and sell goods or services on credit, you issue an invoice with a payment term, such as 30 days. Until that customer pays, the money they owe sits on your balance sheet as an account receivable.
However, not every customer pays on time. Aged receivables take all those unpaid invoices and sort them into time buckets.
Typically, these buckets show amounts that are current, 1 to 30 days overdue, 31 to 60 days overdue, and more than 60 or 90 days overdue. This layout gives you an instant snapshot of your cash flow health.
This report matters because cash is the lifeblood of any organisation. If too much of your revenue is trapped in unpaid bills, you might struggle to pay your own staff, suppliers, and rent, even if your sales look great on paper.
By reviewing this report regularly, you can spot payment trends early. For instance, if a normally reliable client suddenly slips into the 60 days overdue bucket, you know to reach out before the debt becomes uncollectable.
In daily practice, business owners and finance managers review this report weekly or monthly. It guides credit control efforts, helping you decide who to chase for payment first.
It also feeds into your bad debt provision, which is the money you set aside for invoices you realistically expect never to see. By keeping a close eye on these figures, you protect your working capital and maintain steady business operations.
Aged receivables are like a fruit bowl. The fresh fruit is at the front and ready to eat, but the items at the back have been sitting there for weeks and are starting to rot.
You need to check the back regularly so nothing goes to waste.
In practice
Real-world examples
Example 1
Freelance designer Sarah runs a small agency. She checks her aged receivables report and notices a client is 45 days overdue on a $3,000 website deposit. She halts further design work until the deposit arrives, and the client pays within the week.
Example 2
Apex Engineering, a mid-sized manufacturer, notices that one public sector buyer routinely takes 75 days to settle invoices, while its private clients pay within 30. The finance team uses this pattern to negotiate 45-day terms and milestone billing in future contracts. Its cash forecast now assumes slower receipts from that buyer group.
Example 3
Boutique hotel chain Splendid Stays reviews its corporate accounts and discovers that a local events company owes $12,000 in the 90-plus days bucket. The group sends a final demand letter and places a credit hold on further bookings from that client. After 14 days with no response, the balance is passed to a collections agency.
Think of it
Aged receivables are like a fruit bowl. The fresh fruit is at the front and ready to eat, but the items at the back have been sitting there for weeks and are starting to rot. You need to check the back regularly so nothing goes to waste.
Formula
Calculation
Total Aged Receivables = Current Invoices + 1-30 Days Overdue + 31-60 Days Overdue + 61-90 Days Overdue + 90+ Days Overdue. For example, if a company has $5,000 current, $2,000 thirty days late, and $1,000 ninety days late, total aged receivables equal $8,000. The overdue share of that total is ($3,000 / $8,000) x 100 = 37.5%, which shows how much of the book is at risk of slipping further.Case study
Seen in the real world
This is a fictional, illustrative scenario. Green Gardens, a commercial landscaping contractor based in Bristol, experienced rapid growth last spring, signing several large office parks. Sales looked fantastic on their profit and loss statement. Their bank balance remained stubbornly low, which made no sense on paper. The finance manager pulled an aged receivables report and uncovered a worrying trend.
Out of $60,000 total owed, nearly $25,000 sat in the 60 and 90 days past due buckets. Two property management clients had simply forgotten to process the invoices through their accounts payable departments. Green Gardens immediately instituted a new credit control procedure. They assigned an administrator to call clients five days before an invoice fell due. Automated email reminders were also set up for every overdue account.
They also placed a temporary credit hold on any account entering the 60 days overdue category, and they required a 50% deposit on new jobs above $5,000. Within six weeks, the overdue balance dropped from $25,000 to just $4,000, allowing Green Gardens to buy a new ride-on lawnmower without a bank overdraft. The managing director now reviews the aged receivables report at every Monday meeting, which keeps the overdue share low.
Watch out
Common mistakes
- Waiting until the end of the year to review the aged receivables report instead of checking it weekly.
- Continuing to supply goods or services to customers who have large balances sitting in the 90+ days overdue category.
- Failing to write off bad debts that have zero chance of collection, which artificially inflates company asset values.
Questions
People also ask
How often should I look at my aged receivables report?
At least once a month for small businesses, and weekly for companies with high transaction volumes or tight cash flow.
What is the difference between accounts receivable and aged receivables?
Accounts receivable is the total amount of money all customers owe you. Aged receivables is that same total, sorted by how late the payments are.
When should I give up on collecting an overdue invoice?
Most businesses write off debts after 90 to 180 days of no contact, or when formal legal recovery efforts fail.