Accounts Receivable Aging Report: How to Read It and Act on It

By Newtown Analytics · October 21, 2026 · 7 min read

For finance, fp&a & accounting managers

An accounts receivable aging report lists what customers owe you and sorts each invoice by how long it has been outstanding. It is the single most useful report for managing collections, forecasting cash and spotting credit risk. This guide shows how to read it, how to calculate collection probabilities and a bad debt allowance, what to do for each age bucket and how to use it every week. It supports the methods in how to speed up accounts receivable collections and sits within cash flow management.

What the report shows

A typical aging report has one row per customer and columns for age buckets measured from the invoice date or due date. Using the due date is more useful for collections, because it shows how late the invoice actually is.

Customer	Current	1 to 30 days past due	31 to 60	61 to 90	Over 90	Total
Customer A	$120,000	$0	$0	$0	$0	$120,000
Customer B	$80,000	$30,000	$12,000	$0	$0	$122,000
Customer C	$60,000	$10,000	$0	$10,000	$8,000	$88,000
Customer D	$30,000	$10,000	$10,000	$0	$0	$50,000
Others	$20,000	$0	$0	$0	$0	$20,000
Total	$310,000	$50,000	$22,000	$10,000	$8,000	$400,000

Percent of total: current 77.5 percent, 1 to 30 past due 12.5 percent, 31 to 60 5.5 percent, 61 to 90 2.5 percent, and over 90 2.0 percent. Past due balances total $90,000, or 22.5 percent of receivables.

How to read it

Start with the totals

Total receivables and the share past due. Is the past-due share rising or falling compared with last month?
Weight of the older buckets. Balances over 60 days deserve attention because collection probability drops with age.
Comparison with DSO. If past-due balances are large, DSO will exceed terms. See days sales outstanding.

Look at concentration

Look at the largest balances. In the example, customers A and B hold 60.5 percent of the total ($242,000 of $400,000). A delay by either has a large effect on cash. Customer A is entirely current, while B has $42,000 past due and should be contacted. Customer C is the biggest risk: a smaller balance, but with amounts in every bucket including over 90 days, which suggests a customer that is paying selectively or disputing items.

Look for patterns

A customer with amounts in several buckets may be skipping invoices or disputing items.
Rising balances without rising sales suggest slower payments.
A sudden jump in the oldest bucket may follow a dispute or financial trouble.
A pile of very small old items can indicate short payments or deductions never resolved.

Check for credits and unapplied cash

Unapplied payments and credit memos can make a balance look older than it is. Clean the report before acting. A phone call about an invoice the customer has already paid damages trust.

Actions by bucket

Bucket	Typical action	Owner
Current	Send reminders before the due date for large invoices; confirm receipt	Billing or collections
1 to 30 past due	Email and call; ask for payment date	Collections
31 to 60 past due	Escalate to senior contact; identify disputes; consider credit hold	Collections manager, sales
61 to 90 past due	Formal notice; payment plan; hold shipments	Finance lead, sales leader
Over 90 past due	Collection agency, legal review, write-off assessment	Finance lead, owner

Assign every invoice over 30 days past due to a named person, with a next action and date.

Estimating collections from the report

The aging report is a good basis for forecasting near-term receipts. Apply collection rates to each bucket based on your own history. The rates below are illustrative; calculate yours from the last six to twelve months of data.

Bucket	Balance	Assumed share collected in next 4 weeks	Expected collections
Current	$310,000	60%	$186,000
1 to 30 past due	$50,000	45%	$22,500
31 to 60	$22,000	30%	$6,600
61 to 90	$10,000	15%	$1,500
Over 90	$8,000	5%	$400
Total	$400,000		$217,000

The forecast of $217,000 in the next four weeks comes from existing invoices only. Add expected collections from sales not yet invoiced. For large customers, replace the percentages with their expected payment dates. Method details are in how to build a cash flow forecast you will actually use.

Estimating a bad debt allowance

An allowance for doubtful accounts reflects the portion of receivables you expect not to collect. An aging-based method applies a loss rate to each bucket. The rates below are examples only; set yours from your loss history and consult your accountant.

Bucket	Balance	Assumed loss rate	Allowance
Current	$310,000	1%	$3,100
1 to 30 past due	$50,000	3%	$1,500
31 to 60	$22,000	8%	$1,760
61 to 90	$10,000	20%	$2,000
Over 90	$8,000	50%	$4,000
Total	$400,000		$12,360

The allowance of $12,360 is 3.1 percent of receivables. Compare it with actual write-offs over time and adjust. Specific known problems, such as a customer in bankruptcy, should be reserved separately.

Use the report in a weekly routine

Run the report on the same day each week, cleaned of unapplied cash.
Review changes in the total, past-due share and each large customer.
List the top 10 past-due balances with next actions and owners.
Update the dispute log.
Update the cash forecast with expected payment dates.
Send a one-page summary to the owner or finance lead.

Make the aging report part of the weekly cash meeting. A short agenda is described in how to run a weekly cash review meeting.

Choosing the bucket structure

The common buckets of current, 1 to 30, 31 to 60, 61 to 90 and over 90 suit most businesses. Companies with net 60 or net 90 terms may need wider buckets, and fast-turning businesses may prefer weekly buckets. Keep the structure consistent so you can compare over time. Some teams run two views: by invoice date, to see how old the sale is, and by due date, to see how late the payment is.

Link to terms and credit policy

An aging report is also feedback on your terms. If many customers are paying 15 days past due, either your terms are tighter than market practice or your follow-up is too loose. Compare the pattern with the terms you offer. Related decisions are discussed in net 30 vs. net 60 and 2/10 net 30 explained.

Common mistakes

Ignoring current balances. A large share of current receivables concentrated in one customer is a risk too.
Aging by invoice date only. Use due date for collections.
Not cleaning the report. Unapplied cash and credits distort the picture.
Relying on the report without calling customers. The report shows the symptom; the conversation reveals the cause.
No ownership. A report without actions changes nothing.
Using it only at month-end. Weekly review catches problems sooner.

For product companies

If you sell physical products to retailers or distributors, deductions and chargebacks often show up as unexplained old items on the aging report. Match deductions to promotions and shipping records so you can contest or accept them. Align inventory and sales plans with customers' ordering patterns to reduce disputes. See demand planning and inventory optimization.

FAQs

What is an accounts receivable aging report?

It is a report that lists customer invoices by how long they have been outstanding, grouped into buckets such as current, 1 to 30 days and 31 to 60 days past due.

How do I read an aging report?

Look at total receivables, the share past due, the size of the older buckets and the largest customer balances. Then investigate patterns, such as customers with amounts in several buckets.

What is a bad aging report?

One with a rising share of past-due balances, significant amounts over 60 or 90 days, and heavy concentration in a customer that pays slowly. Compare with your own trend.

How often should I review the aging report?

Weekly for collections and cash forecasting, with a monthly summary for management.

How do I use the aging report to forecast cash?

Apply collection rates by bucket based on your history, or use specific expected payment dates for large customers. Add expected collections from future sales.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.