How to Read an AR Aging Report (And What Most People Miss)

An AR aging report is one of the most common financial reports in business — and one of the most commonly misread.

Most people look at the total, note whether it's going up or down, maybe flag anything over 90 days, and move on. That's checking a box. It's not managing receivables.

What the report actually tells you

An AR aging report sorts outstanding invoices into buckets based on how long they've been unpaid — typically Current, 31-60 days, 61-90 days, 91-120 days, and over 120 days. The real value is in the patterns underneath those numbers.

Concentration risk: the number most people ignore

Add up the total AR for each customer and calculate what percentage of your total receivables they represent. If any single customer is more than 20% of your total AR, you have concentration risk — the kind that doesn't show up until it's too late.

A customer representing 35% of your receivables who starts paying 30 days slower doesn't just affect one line item — it moves your entire cash position.

The aging migration pattern

Look at how invoices move through buckets over time. If the same customer's invoices consistently appear in the 61-90 day bucket, that's not a one-time delay — that's their actual payment behavior. Your credit terms say Net 30, but their reality is Net 75.

Track the average days to pay for each customer. That trailing indicator is far more predictive than what bucket they happen to be in this week.

What the aging report doesn't tell you

The aging report is backward-looking. It tells you what's already overdue, but it doesn't project forward. That gap between what the aging report shows and what your cash position will actually look like in three weeks is where businesses get caught off guard.

Start with a quick health check

Before you build a full collection forecast, get a baseline read on where your AR stands. Our free AR Aging Health Check tool lets you enter your receivables by customer and aging bucket and instantly see your weighted average days outstanding, concentration risk, and actionable flags — no spreadsheet required.

Turning aging data into a cash forecast

The bridge between a static aging report and an actionable cash plan is a collection forecast. Take your current aging balances, apply expected collection rates by bucket, and spread them across the next 13 weeks. Now you're projecting when cash will actually arrive.