How to Read and Act on Your Accounts Receivable Aging Report
The accounts receivable aging report is the financial document most businesses generate, look at briefly, and don't act on systematically.
That's a cash flow problem. Because the aging report tells you exactly which customers owe you what, for how long — which is precisely the information you need to drive systematic collections.
Here's how to read it, what the buckets mean, and what to do with each one.
What an AR Aging Report Shows
An aging report groups your outstanding receivables by how long they've been outstanding — typically:
- Current (0-30 days): Within payment terms, not yet due
- 31-60 days: Overdue by up to 30 days
- 61-90 days: Overdue by 31-60 days
- 91-120 days: Seriously overdue
- 120+ days: At risk of being uncollectible
For each bucket, you see which customers have invoices there, what amounts, and what the original invoice details are.
The total of all buckets is your total accounts receivable balance — what all customers collectively owe you right now.
What a Healthy Aging Report Looks Like
For a business with Net 30 payment terms and a reasonably clean collections process:
- 80-90% of outstanding receivables in the current bucket
- 5-10% in 31-60 days (recent late payers)
- Under 5% in 60+ days
- Very little or nothing in 90+ days
If your aging looks significantly different from this — heavy concentration in the 60+ day buckets — you either have collections process problems, credit control problems, or both.
Reading the Report Strategically
Total outstanding vs. your DSO target: Calculate your current Days Sales Outstanding from the report. Compare it to your target (ideally your stated payment terms plus 5-7 days buffer). If DSO is significantly higher than your terms, collections performance needs attention.
Customer concentration in overdue buckets: Which specific customers have significant balances in the 60+ day buckets? These need personal attention from your collections or account management team, not automated reminders.
Invoice-level detail in old buckets: An invoice in the 90+ day bucket either has a dispute attached to it (which needs resolution) or represents a collection failure that needs escalation. Know which situation you're dealing with for each old invoice.
Change from last month: Is the percentage of receivables in old buckets growing or shrinking? A growing overdue balance is a trend that will continue until something changes.
What to Do With Each Bucket
Current (0-30 days): No action needed unless payment due date is within 5 days — a proactive reminder call or email at this stage is reasonable for large invoices.
31-60 days (just overdue): Immediate payment reminder. This is the stage where most late payments respond to a professional reminder. Email first; if no response within 48 hours, a phone call.
61-90 days: Escalate from automated reminder to personal outreach. Your collections team (or account manager) should be making direct contact. Understand if there's a dispute that's holding payment — disputes in this age bucket need urgent resolution. The longer a dispute sits unresolved, the harder collection becomes.
91-120 days: Formal overdue notice. Consider stopping supply until the account is brought current. Escalate to senior management if the customer is significant. Assess whether you need external collection support.
120+ days: Serious intervention required. Options include: formal legal notice, engaging a collections agency, or negotiating a payment plan if the customer has the will but not the immediate capacity. At this point, also assess whether the debt is recoverable or needs to be provisioned as a bad debt in your financial records.
The Dispute Dimension
Many invoices sit in overdue buckets not because customers won't pay, but because there's an unresolved dispute — wrong quantity, wrong price, missing documentation, damage claim.
Your aging report should flag invoices with open disputes separately. These need a different process from straightforward late payments: resolve the dispute first, then collect.
If a high percentage of your overdue invoices have disputes attached, you have an upstream process problem — either invoicing errors or documentation issues that are triggering disputes. Invoice accuracy and proper dispatch documentation prevent most disputes before they happen.
The Credit Control Connection
Your aging report is also an input to credit decisions. A customer who consistently appears in the 60+ day bucket has demonstrated that they don't respect your payment terms. They're using your business as an extended credit provider — without your explicit agreement.
Use aging patterns to inform credit limit decisions:
- Customers consistently in current bucket: maintain or extend credit limits
- Customers consistently in 31-60 day bucket: monitor, send reminders, hold credit limit
- Customers consistently in 60+ day bucket: reduce credit limit or move to prepayment
The point of credit control isn't to be punitive. It's to ensure that your working capital isn't being used to finance customers who haven't earned that trust.
Bad Debt Provision
When a receivable has been outstanding for a very long time and collection looks unlikely, your accountant will recommend provisioning for it — creating a bad debt reserve that recognizes the loss in advance of writing the debt off officially.
The provision reduces your reported receivables balance to a more realistic view of what you'll actually collect. It hits your P&L as a bad debt expense.
Provisioning rules of thumb (adjust for your business context):
- 10-15% provision on 90-120 day balances
- 25-50% provision on 120-180 day balances
- 75-100% provision on 180+ day balances
If you're running a large balance in the 180+ day bucket with no provision, your financial statements are overstating your assets.
Frequency
Review your aging report weekly for the overdue buckets (61 days and older). Review the full report monthly for trend analysis and credit limit decisions.
The weekly review drives collections actions. The monthly review drives credit policy decisions and bad debt provisioning.
Sevenledger generates real-time AR aging reports that update with every payment, invoice, and credit note — so your collections team is always working from current data, not last week's export.