Accounts receivable aging report: what it shows and how to use it

An accounts receivable aging report lists unpaid customer invoices and groups them according to how long they have been outstanding.

A typical report might look like this:

You can immediately see that Greenfield has older debt than Northstar, even though Northstar owes more on one recent invoice.

That is much more useful than knowing only that total accounts receivable is $33,500.

Most aging reports use 30-day periods.

The exact buckets can vary.

Current

The invoice has not reached its due date yet.

You may not need to chase it, although larger invoices or customers with complex payment processes can benefit from a pre-due reminder.

1 to 30 days overdue

The invoice is late, but this is usually still normal accounts receivable follow-up.

Check whether the customer received it and whether anything is blocking payment.

31 to 60 days overdue

The invoice needs more attention.

By this stage, you should normally know why it is unpaid and have either a payment commitment or a clear blocker.

61 to 90 days overdue

The debt is becoming more serious.

Repeated generic reminders are unlikely to be enough.

Review payment promises, disputes, customer communication and whether escalation is needed.

90+ days overdue

These balances deserve close attention.

That does not automatically mean they are bad debts, but you should understand exactly why they remain unpaid and whether normal collections activity is still appropriate.

These are mostly different names for the same type of report.

In the US, common terms include:

• Accounts receivable aging report
• AR aging report
• Aging report
• Aged receivables report

In the UK, you are more likely to hear:

• Aged debt report
• Aged debtor report
• Aged receivables report

The underlying purpose is the same.

You want to see how much customers owe and how old those balances are.

Accounting systems often provide two versions.

Accounts receivable aging summary

The summary report gives you the high-level balance for each customer and aging bucket.

This is useful when you want to answer questions such as:

• Which customers owe us the most?
• How much of our AR is more than 30 days overdue?
• Are older balances increasing?
• Which customers deserve attention first?

Accounts receivable aging detail

The detail report shows the individual transactions behind those totals.

This is normally where collections work actually starts.

A customer with $25,000 in the 31 to 60 day column might have:

• One $25,000 invoice.
• Five $5,000 invoices.
• One disputed invoice and four normal ones.
• Several invoices that were sent to the wrong contact.

Those situations should not all be handled the same way.

Do not just start at the 90+ column and work backwards.

Use a few different lenses.

Which customers owe you the most?

A $50,000 invoice that is 20 days overdue may matter more to cash flow than a $200 invoice that is 95 days overdue.

Amount matters.

Old balances are an obvious warning sign.

Ask:

• Why has this remained unpaid for so long?
• Is anybody actively working on it?
• Has the customer responded?
• Is there an unresolved dispute?
• Has a payment promise been missed?

If you cannot answer those questions, the invoice probably needs attention.

This is where aging reports become especially useful.

Say a customer has:

• $30,000 in 1 to 30 days this month
• $30,000 in 31 to 60 next month
• $30,000 in 61 to 90 the month after

The balance is not just overdue.

It is sitting still.

That tells you the existing follow-up process is not moving the invoice toward payment.

Suppose your 90+ day bucket is $100,000.

That sounds worrying.

But the next question is whether that consists of:

• 50 small customers, or
• One customer owing $95,000

The collection risk is very different.

The aging bucket tells you how old an invoice is.

It does not tell you why it is unpaid.

You still need to know whether the customer:

• Forgot.
• Never received the invoice.
• Needs a PO.
• Sent it to the wrong contact.
• Disputes the work.
• Promised a payment date.
• Is having cash flow problems.
• Has stopped responding.

This is one of the limitations of treating the aging report as the collections process itself.

It tells you where the problem is.

You still need to understand what the problem is.

A useful collections priority is not simply:

Oldest invoice first.

Consider four things together:

Amount

How much cash is tied up?

Age

How far beyond the due date is it?

Risk

Does this customer regularly pay late? Have they stopped responding? Are there signs the debt may be difficult to collect?

Actionability

Can you actually do something right now?

An invoice blocked by an internal dispute may need someone in operations to act before finance can make progress.

Meanwhile, another customer may simply need a follow-up on a missed payment promise.

That second invoice could be much easier to move.

Imagine this report:

Which do you chase first?

There is no perfect answer.

But a sensible sequence could be:

Customer B first.
They made a payment promise that has just been missed. This may require one straightforward follow-up.

Customer A next.
The amount is large, and you need to find out why there has been no reply.

Customer C needs resolution, not chasing.
Someone needs to deal with the dispute.

Customer D needs escalation.
At 100 days overdue with no contact, standard reminders may have run their course.

The aging report helps you find the work.

It does not replace judgment.

A few patterns deserve investigation.

More money is moving into older buckets

If 60+ and 90+ balances are rising month after month, collection performance may be deteriorating.

One customer dominates overdue AR

You may have concentration risk.

The same customers are always late

Your payment terms or credit decisions may need reviewing.

Large invoices jump directly into older buckets

There may be disputes or process failures that are not being resolved.

Credits or payments have not been applied properly

Your report may not reflect reality.

So before chasing a customer, make sure the report itself is accurate.

For a business with meaningful B2B receivables, monthly is usually too infrequent for actual collections work.

The finance close might happen monthly.

Collections should be more active.

Depending on invoice volume and cash flow needs, review overdue receivables weekly or even more frequently.

The important thing is that invoices do not sit untouched simply because the report is only formally reviewed at month end.

A customer who promised to pay on Tuesday should be followed up after Tuesday if payment does not arrive.

You do not need to wait for the next aging meeting.

An aging report and days sales outstanding tell you different things.

DSO gives you the overall trend.

The aging report gives you the invoices behind that trend.

If your days sales outstanding rises from 35 to 48 days, the aging report can help you understand why.

Maybe:

• More invoices are moving past 30 days.
• A few large customers are paying later.
• Disputes are sitting unresolved.
• Missed payment promises are not being followed up.

Use the two together.

DSO tells you something has changed.

The aging report helps you find it.

Once you understand the report, the actions are fairly practical.

Chase before invoices become very old

Do not wait until they hit the 60-day bucket.

Ask why payment is delayed

The reason determines the next action.

Track payment promises

If a customer gives you a date, record it.

Follow up missed promises

Do not restart the whole reminder sequence.

Follow up on the commitment they already made.

Resolve disputes

A disputed invoice needs someone to own the resolution.

Fix recurring process problems

If the same customer repeatedly says the PO is missing, fix how POs are captured.

If invoices regularly go to the wrong contact, update your customer records.

Escalate when normal chasing stops working

An invoice sitting in 90+ after repeated unanswered messages may need a different approach.

Our guide to collecting unpaid invoices covers the broader escalation process.

Yes.

QuickBooks Online provides both accounts receivable aging summary and detail reports, with customizable aging periods.

Xero also provides aged receivables reporting.

That means most businesses do not need to build this report manually.

The harder part is what you do with the information once you have it.