What it means
When you run a business, you often let customers pay after delivery. Invoice aging takes all your unpaid bills, known as accounts receivable, and organizes them by age.
Typically, the report splits amounts into 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 matters because the longer a bill goes unpaid, the less likely you are to collect the money.
By reviewing this report regularly, you can quickly identify which clients are slow payers and take action before the debt becomes uncollectable. In practice, finance and sales teams use this report during weekly reviews.
It guides credit control by showing who to chase for payment, helps forecast your incoming cash flow, and tells you how much money you might need to write off as bad debt. Invoice aging is like checking the expiration dates on food in your pantry, helping you use or throw out items before they spoil, except here you are checking unpaid bills to collect cash before it goes bad.
In practice
Real-world examples
Example 1
A freelance designer sorts her five unpaid client invoices by age. She notices one client is 45 days late, so she sends a polite reminder email to secure the payment before it moves into the severely overdue bracket. The client pays within a week, explaining that the invoice had been sent to the wrong person.
Example 2
A small manufacturing firm reviews its monthly aging report and spots that a regular retail buyer has moved from the current bucket into the 60 days past due category, prompting it to pause further shipments. The sales manager calls the buyer and agrees a payment plan before resuming deliveries. The firm avoids adding fresh debt on top of an overdue balance.
Example 3
An IT consultancy uses an aging report to discover that 15% of its total unpaid invoices are over 90 days old, leading it to introduce stricter payment terms for all new corporate contracts. The new terms require a 30% deposit before work begins. Within six months the over 90 days share falls to under 5%.
Think of it
Invoice aging is like checking the expiration dates on food in your pantry, helping you use or throw out items before they spoil, except here you are checking unpaid bills to collect cash before it goes bad.
Formula
Calculation
Invoice Aging Report = Unpaid invoices grouped into Current, 1-30 days past due, 31-60 days past due, 61-90 days past due and over 90 days past due
Share of Bucket = Bucket Total / Total Unpaid Invoices x 100
Example: if Client A owes $1,000 that is 40 days past due, it sits in the 31-60 days past due bucket, which tells you the payment is more than five weeks late.
Full report example: a business has $50,000 of unpaid invoices, made up of $18,000 current, $7,000 at 1-30 days, $3,000 at 31-60 days, $2,000 at 61-90 days and $20,000 over 90 days (18,000 + 7,000 + 3,000 + 2,000 + 20,000 = $50,000). The over 90 days bucket is 20,000 / 50,000 = 40% of the total, which is a warning sign. If the business decides to provide for half of that bucket as possible bad debt, the provision is 20,000 x 0.50 = $10,000, which reduces reported profit.Case study
Seen in the real world
This is a fictional, illustrative scenario. GreenLeaf Landscaping, a medium-sized grounds maintenance firm, noticed its bank balance dropping despite strong sales. The owner asked the finance manager to run an invoice aging report. The report revealed that while total unpaid bills stood at $50,000, a staggering $20,000 had been sitting in the over 90 days past due bucket. Many of these old bills belonged to three commercial clients who assumed GreenLeaf had forgotten about the charges.
Armed with this clear breakdown, the finance team immediately launched a targeted phone campaign and offered a small administrative fee discount for immediate settlement. Within two weeks, GreenLeaf recovered $15,000 of the overdue cash. That left $5,000 in the over 90 days bucket, which was now only 10% of a smaller total, and the team agreed to provide for it as a doubtful debt. They also changed their policy to require credit checks and upfront deposits for any new commercial projects, stopping future cash flow gaps. The finance manager now presents the aging report at every monthly management meeting.
Watch out
Common mistakes
- Ignoring the report until cash flow runs critically low.
- Failing to follow up promptly on invoices that just entered the 1 to 30 days past due bucket.
- Continuing to deliver new goods or services to clients with severely aged debt.
Questions
People also ask
How often should I review my invoice aging report?
You should review it at least once a month, though weekly reviews are better for businesses with high transaction volumes.
What should I do with invoices in the over 90 days bucket?
You should make direct phone calls, send final demand letters, or pass the debt to a professional collection agency.
Does invoice aging affect my profit and loss statement?
The report itself does not, but it helps you calculate bad debt provisions, which do reduce your reported profit.