How to Read an Accounts Receivable Aging Report and Spot Risk Fast
Late invoices rarely turn into a problem all at once. They age quietly, one due date at a time, until cash gets tight and collection work becomes harder. An accounts receivable aging report helps you catch that risk early.
The report sorts unpaid customer invoices by how long they have been outstanding. Read it well, and it tells you which accounts are healthy, which need a reminder, and which may need stronger action.
This article is for general information only and is not financial or legal advice.
Start with what the report is showing
An aging report usually groups open invoices into time-based buckets. The most common buckets are:
Current
1 to 30 days past due
31 to 60 days past due
61 to 90 days past due
Over 90 days past due
Some reports label these as current, 30, 60, 90, and 90+ days. The idea is the same. The older the invoice, the higher the collection risk.
The report may be grouped by customer, invoice number, due date, invoice amount, and total balance. A good first read asks three simple questions:
How much money is unpaid?
How old is that money?
Which customers account for the biggest risk?
Do not focus only on the total balance. A Tk 5,00,000 receivable total may look fine if most of it is current. The same total looks very different if Tk 3,00,000 is over 90 days past due.
Read each aging bucket as a risk signal
Each bucket tells a different story. Some balances need routine follow-up. Others may point to disputes, billing errors, cash-flow trouble, or customers who are avoiding payment.
Current invoices show expected cash
Current invoices are not yet due. This bucket should usually be the largest in a healthy receivables file, especially if customers have standard payment terms.
Current does not mean “ignore.” It means “prepare.” Check that the invoice was sent correctly, the customer received it, and the payment terms are clear.
Good actions for current invoices include:
Send invoices promptly after work is completed or goods are delivered.
Confirm purchase order numbers, tax details, and billing contacts.
Schedule a reminder before the due date for larger balances.
The goal is prevention. Many late payments start with simple friction, such as the wrong email address or missing supporting documents.
The 30-day bucket calls for quick follow-up
Invoices in the 1 to 30 days past due bucket are early warning signs. Many are still collectible with a polite reminder.
This bucket often signals:
The customer missed the due date.
The invoice is sitting in approval.
The customer needs a copy or clarification.
Payment was promised but not processed.
Act quickly here. Waiting too long can train customers to treat your payment terms as flexible.
A useful message at this stage is short and factual. Mention the invoice number, amount, due date, and a clear request for payment status. Keep the tone professional. The aim is to remove obstacles, not start a fight.
The 60-day bucket needs closer attention
Once an invoice reaches 31 to 60 days past due, the risk rises. The balance has survived at least one reminder cycle. That may mean there is a dispute, an internal delay, or a cash-flow issue on the customer’s side.
At this stage, move from reminder to resolution.
Check the account history. Has this customer paid late before? Is there a pattern around large invoices? Did anyone record a dispute about pricing, delivery, service quality, or paperwork?
Good actions include:
Call the customer rather than relying only on email.
Ask for a specific payment date.
Document every promise and response.
Pause new credit if the balance is large or growing.
The main goal is to get a firm answer. Silence at 60 days is a risk signal.
The 90-day bucket means collection risk is serious
Invoices that are 61 to 90 days past due need active management. By this point, casual reminders are unlikely to be enough.
This bucket may signal:
A genuine customer dispute.
Weak collection follow-up.
A customer with financial stress.
Poor credit controls.
A possible bad debt risk.
Review the full file before taking stronger action. Make sure the invoice is accurate, the goods or services were delivered, the customer accepted them, and your team has kept records of communication.
Then decide on the next step. That may include a payment plan, formal demand letter, credit hold, or referral to a recovery professional. If the customer still does business with you, set clear limits before accepting more orders.
The 90+ bucket deserves immediate review
The over 90 days bucket is where risk becomes urgent. These invoices are older, harder to collect, and more likely to require outside help.
Do not treat every 90+ invoice the same. Separate them into three groups:
Customers who acknowledge the debt and have a payment plan.
Customers with unresolved disputes.
Customers who are not responding.
Each group needs a different response. A payment plan needs monitoring. A dispute needs evidence and resolution. A non-responsive account may need escalation.
For AR Defense, LLC and any business managing receivables nationwide, this bucket is also a place to review policy. If too many invoices end up here, the issue may not be only the customer. It may be unclear payment terms, weak follow-up timing, or credit being extended too freely.
Use a simple table to spot the pattern
Imagine an aging report with three customers.
Customer | Current | 30 days | 60 days | 90 days | 90+ days | Total |
Customer A | Tk 80,000 | Tk 15,000 | Tk 0 | Tk 0 | Tk 0 | Tk 95,000 |
Customer B | Tk 10,000 | Tk 25,000 | Tk 40,000 | Tk 0 | Tk 0 | Tk 75,000 |
Customer C | Tk 0 | Tk 0 | Tk 20,000 | Tk 30,000 | Tk 50,000 | Tk 1,00,000 |
Customer A looks mostly healthy. Most of the balance is current, with a smaller early overdue amount.
Customer B needs attention. More than half the balance is 60 days old, which suggests follow-up has stalled or a problem has not been solved.
Customer C is the highest risk, even though its total is only slightly higher than Customer A. Most of the unpaid amount sits in the 90 and 90+ buckets. That account should move to urgent review.
The lesson is simple. The age of the balance matters as much as the size of the balance.
Turn the report into a weekly action plan
An aging report only helps if it changes what happens next. Review it on a set schedule, often weekly for active businesses.
A practical process looks like this:
Check the totals
Look at total receivables and the amount in each bucket.
Identify the largest overdue accounts
Start with high-value balances in the 60, 90, and 90+ buckets.
Assign the next action
Choose a reminder, call, dispute review, payment plan, credit hold, or escalation.
Record every contact
Keep dates, names, promises, and documents in one place.
Review what keeps repeating
If the same customers or invoice types keep aging, fix the root cause.
Aging reports are not only collection tools. They also help protect cash flow, improve billing habits, and set better credit limits.
The best time to act is before an invoice becomes old. Current invoices need clean billing. 30-day invoices need fast reminders. 60-day invoices need direct contact. 90-day invoices need firm decisions. Anything over 90 days deserves urgent review.
Read the report this way, and it becomes more than a list of unpaid invoices. It becomes an early warning system for cash risk.
Comments