AR aging report: how to read it and act on it

An AR aging report sorts your open invoices by how long they have been outstanding, grouping them into buckets like current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due. You read it by looking at the share of your total book sitting in each bucket, because the mix shows where collection risk is concentrated. You act on it by turning the riskier balances into a prioritized worklist, working the accounts where a touch actually changes whether the cash arrives.

Most teams treat the aging report as a month-end artifact: run it, glance at it, file it. That wastes its real value. Read and worked continuously, it is the single best worklist a collections function has, because it points straight at the accounts where money is at risk right now.

What an AR aging report shows

The report lists every open invoice and slots it into a time band based on how far past due it is. Sum the balances in each band and you get the classic aging snapshot: how much is current, how much is mildly late, and how much has aged into the danger zone.

It answers three questions at once. How much is owed in total, how overdue that money is, and which customers carry the aged balances. The dollar total tells you the size of the book. The distribution across buckets tells you its health. A ledger with most of its value in current is healthy; one with a fat 90-plus band is carrying losses it has not booked yet.

Reading the aging buckets

Each bucket carries a meaning, and the meaning is about probability of collection:

• Current. Not yet due. This is where you want the bulk of the book to sit.
• 1 to 30 days past due. Recently late. Usually friction, a missed invoice, a slow approver, and highly recoverable with a prompt nudge.
• 31 to 60 days. Sliding. Recoverable, but the account needs real attention, not just a reminder.
• 61 to 90 days. At risk. The probability of full collection has dropped noticeably; escalate.
• 90-plus days. Danger zone. Collection odds fall sharply here, and a growing 90-plus band is the leading indicator behind a rising bad debt ratio.

Read the percentages, not just the totals. A $50,000 balance means one thing if it is 2% of the book and another if it is 20%. The shift of value from younger to older buckets over time is the signal that matters, the same trend that drives DSO up before the metric itself moves.

Turning aging data into actions

An aging report is only useful once it becomes a list of things to do. Translate each bucket into an action:

1. Current. Maintain the cadence. A reminder just before due dates keeps invoices from slipping in the first place.
2. 1 to 30. Prompt, polite follow-up. Resolve any friction, a wrong PO, an unclear due date, before it becomes a real delay.
3. 31 to 60. Direct outreach to the person who approves payment. Find out what is actually holding it up.
4. 61 to 90. Escalate. Bring in a manager, propose a payment plan, and make the consequences of further delay clear.
5. 90-plus. Decide. Either a final escalation and possible handoff to collections, or a write-off under policy if the account has gone dark. Working these accounts is the heart of collecting overdue invoices.

The report tells you which bucket each account is in. The action plan tells your team what to do about it.

Prioritizing which accounts to chase

Aging alone is a crude sort. The oldest invoices are not always the best use of time, because the very oldest are often unrecoverable while a large balance about to slip is still very much in play. Prioritize by two things together: dollars at risk and the probability that contact changes the outcome.

A practical ranking multiplies the balance by the risk of it aging further and the likelihood a touch helps. A $40,000 invoice at day 55, from a customer who still answers, outranks a $3,000 invoice at day 200 from one who has gone silent. Work the list top down, and re-rank it as accounts move and cash lands, so effort always flows to where it matters most that day.

Tracking aging trends over time

A single aging report is a snapshot. The trend is the insight. Track the share of the book in each bucket month over month and watch the direction. Value drifting from current into the 30 and 60 bands is an early warning that collections is falling behind, weeks before DSO confirms it. A thinning 90-plus band means recovery efforts are working.

Pair the trend with a forecast. The aging report is the raw input to forecasting collections: each bucket carries a different expected collection rate and timing, and rolling those up turns the aging snapshot into a cash timeline you can plan against.

How Rex acts on aging automatically

Rex treats the aging report as a live worklist, not a month-end export. It works every bucket continuously, sending the right touch for each invoice's age, prompting on current invoices before they slip, following up firmly as accounts cross into the 30 and 60 bands, and escalating the 90-plus cases that need a human decision. Nothing waits for someone to open a spreadsheet.

Because cash application runs in the same loop, the aging stays accurate in real time, so Rex never chases a paid invoice and the priority re-sorts as balances move. The accounts that need judgment come to a person with the history attached, while the routine follow-up across the whole ledger just happens. The aging report stops being a report and becomes the work, handled.

See how Rex works your aging buckets automatically instead of leaving them on a spreadsheet.