What is an AR aging report and how to read it

An accounts receivable aging report lists every unpaid invoice and groups it by how long it has been outstanding. The buckets usually run current, 1-30 days, 31-60, 61-90, and over 90 days past due. Read left to right, it shows how much cash is overdue and how badly, customer by customer.

The report answers a question a single AR balance cannot: not just how much you are owed, but how old and how risky each piece of it is. A 500,000 balance that is all current is healthy. The same 500,000 with 200,000 sitting past 90 days is a problem hiding behind a tidy total.

Aging report buckets explained

The columns split the receivables by age relative to the due date.

• Current. Invoices not yet past due. Money you expect on time.
• 1-30 days. Recently late. Usually an oversight, a slow approval, or a payment in transit. Most of this collects with a nudge.
• 31-60 days. Aging. The customer has missed the due date by a clear margin. Worth a firmer touch and a closer look.
• 61-90 days. At risk. Something is wrong, often a dispute, a cash-flow problem, or a lost invoice. These need active work.
• 90-plus days. High risk. The longer an invoice sits here, the less likely it is to be paid in full. Some of this becomes bad debt.

A widely cited pattern is that collectability drops sharply as invoices age. The probability of collecting an invoice in full falls the further right it lands, which is why moving balances out of the older buckets fast matters so much.

How to read an aging report

Start with the totals at the bottom of each bucket to see the shape of the ledger. A book weighted toward current is healthy. A book with a fat tail in 61-plus signals collections are slipping.

Then read across each customer row. One customer with a large 90-plus balance often explains most of the risk, and that single account deserves direct attention before anything else. Watch for patterns too. A customer who is always 45 days late on net-30 terms has effectively rewritten the terms, and that is worth addressing at the relationship level, not invoice by invoice.

Finally, compare the report against last month's. The absolute numbers matter less than the direction. Balances drifting right month over month mean the function is losing ground even if the total receivable looks flat.

Why AR aging matters

The aging report drives three decisions. It tells collections where to spend effort, since the oldest and largest balances carry the most risk. It flags which accounts may never pay, which feeds the allowance for doubtful accounts you book against the ledger. And it gives finance leaders an early read on cash flow, because a ledger aging to the right will turn into slower collections next quarter.

How to use aging to prioritize collections

The report is only useful if it turns into action. The mistake most teams make is treating it as a month-end artifact, reviewed in a meeting and then ignored until the next close.

To prioritize well, rank accounts by a mix of age and amount, not age alone. A 40,000 invoice at 45 days outstanding usually deserves attention before a 800 invoice at 95 days. Pair each overdue account with the right next step: a reminder for the recently late, a call for the aged-and-large, a dispute check for the stuck ones. Then work down the list and refresh it as cash lands and new invoices age in.

How Rex acts on the aging report

Rex treats the aging report as a live worklist, not a snapshot. It watches every invoice cross from current into each successive bucket and acts the moment a balance ages, prioritizing by amount and risk across the whole ledger at once. A recently late invoice gets a reminder, an aged-and-large one gets a firmer push, and a stuck one gets checked for a dispute.

Because Rex works the buckets continuously rather than at month-end, balances move out of the older columns faster, and a person only sees the accounts that need a human call. See how Rex runs collections end to end.