Accounts receivable aging report: how to read and use it

An accounts receivable aging report groups every unpaid invoice by how long it has been outstanding. It is the single most useful report for deciding who to chase today. If you only look at one receivables document each week, make it this one.

What the report contains

• One row per customer, or per invoice in a detailed version.
• Columns for current and for each overdue band.
• The total owed by each customer across all bands.
• A grand total that should reconcile to your receivables balance.

The standard aging buckets

• Current: not yet due.
• 1 to 30 days past due: usually administrative delay.
• 31 to 60 days: a genuine problem that needs a person, not another email.
• 61 to 90 days: escalate to a decision maker and consider a formal letter.
• Over 90 days: low likelihood of routine payment; decide on formal recovery or write-off.

Summary versus detail

The summary report shows one line per customer and is best for a weekly review. The detail report lists each open invoice and is what you need before contacting anyone, because you have to reference specific invoice numbers and dates.

How to read it in five minutes

• Start at the oldest column and work left. The oldest money is the most at risk.
• Look for a single customer appearing across several buckets — that is a pattern, not an accident.
• Check whether the total reconciles to your ledger. If it does not, your data is wrong before your chasing is.
• Flag anything past 60 days for a call rather than an email.
• Note any balance that is genuinely disputed and handle it separately.

Mistakes that make the report misleading

Unapplied credits, duplicate invoices, invoices raised to the wrong entity and payments received but not matched will all distort the report. Clean the ledger first; otherwise you will chase customers who have already paid, which damages relationships fast.

Turning the report into action

A report only helps if someone acts on it. Set a weekly slot, work the oldest bucket first, and record the outcome of every contact against the invoice. AI Money Recovery reads your invoice data, builds that queue for you, and keeps an audit trail of what was sent and when — with your approval required before anything goes out.

Frequently asked questions

What is an accounts receivable aging report?

A report that groups unpaid invoices by how long they have been outstanding, usually in current, 30, 60, 90 and 120 day buckets.

How do you read an accounts receivable aging report?

Start with the oldest bucket, look for customers appearing in several bands, confirm the total reconciles to your ledger, and prioritise anything past 60 days for a phone call.

What do the aging buckets mean?

Each bucket shows how many days past the due date an invoice is. Older buckets carry a higher risk that the balance will never be collected.

How often should I run an aging report?

Weekly is a practical rhythm for most small businesses, with a fuller review at month end.