The accounts receivable aging report, explained

Every unpaid invoice is cash the business has earned but can't use yet. The accounts receivable aging report shows how much of that cash is waiting, who owes it and how long it's been outstanding. It's one of the simplest reports in accounting and one of the most useful: read well, it tells you where collections need attention before a late payment becomes a write-off.

This guide explains what an AR aging report is, how to prepare and read one, and why finance leaders watch it closely, using one illustrative month-end report whose figures match the rest of this site.

What is an accounts receivable aging report?

An accounts receivable aging report, also called an AR aging report or aged receivables report, lists every unpaid customer invoice on a given date and groups it by how long it's been outstanding. The groups, called aging buckets, are usually current (not yet due), 1–30 days past due, 31–60 days, 61–90 days and over 90 days. The report's total equals the accounts receivable balance in the general ledger on the same date.

What an aging report shows

• Each customer, and each open invoice under them, with its invoice number and due date.
• The amount still owed on each invoice, after any partial payments and credit notes.
• Which aging bucket each amount falls into on the report date.
• Totals by customer and by bucket, with the share of the total in each bucket.
• The grand total, which should agree with accounts receivable in the ledger.

Aging summary and aging detail

Most systems offer two versions. The aging summary shows one line per customer with a total in each bucket: it's the version a CFO reads to see the overall picture. The aging detail lists every open invoice behind those totals: it's the version the collections team works from, because each line is a specific conversation with a specific customer.

How to prepare an AR aging report in five steps

1. 1Pick the report date. Use the last day of the month for the close, or today's date for collections work. Every age is measured from this date.
2. 2List every open invoice. Include the customer, invoice number, due date and the balance still owed, after partial payments, credit notes and unapplied cash.
3. 3Sort each balance into a bucket. Count the days between the due date and the report date, and place each balance in current, 1–30, 31–60, 61–90 or over 90 days.
4. 4Total by customer and by bucket. Add up each customer's balance and each bucket, then check the grand total agrees with accounts receivable in the general ledger.
5. 5Review and act. Note the reason and the next step for every past-due invoice, and escalate the oldest balances first.

Step four is also a month-end close task: if the aging total and the ledger disagree, something was recorded in one place and not the other. Our month-end close checklist includes it in the reconciliation stage.

How to read an AR aging report: a worked example

The report pictured above is the same illustrative company used across this site, at month-end. Customers owe $186,400 in total. Of that, $182,950, or 98.1%, is current, meaning not yet due. Only $3,450 is past due: $2,400 in the 1–30 day bucket and $1,050 in 31–60 days. Nothing is older than 60 days.

The detail explains each past-due amount. Maple Freight owes $2,160 on INV-1036, 12 days late, and has promised payment on Monday. Keller & Rowe paid INV-1039 but $240 short: their bank took a fee, and the difference is waiting for sign-off to be written off rather than chased. Orchid Labs owes $1,050 on INV-1031, 38 days late, because it disputes the delivery date.

Each of these needs a different response. A promise to pay needs a reminder if Monday passes. A small short payment needs a decision. A dispute needs the delivery records, not another reminder. That's the real value of the detail: it turns one overdue number into specific next steps.

Notice what isn't on the report. Invoice INV-1042 to Northwind Studio for $12,400 was paid in full, so it no longer appears. Our guide to journal entry examples shows how that payment was recorded.

Why CFOs analyze the aging of accounts receivable

• Cash forecasting: current invoices are likely to arrive soon; the oldest balances are the least certain.
• Credit risk: a customer drifting into older buckets is an early sign of trouble, before it shows up as a loss.
• Collections focus: the report shows where a call or a reminder will recover the most cash.
• Credit terms: customers who pay late every month may need shorter terms, a deposit or a lower credit limit.
• Reserves: the aging is the usual starting point for estimating how much of receivables won't be collected.
• Process problems: a cluster of disputes or short payments often points to a billing or delivery issue, not a customer issue.

What to do with each aging bucket

• Current: make sure the invoice was received and is correct, and send a friendly reminder before the due date.
• 1–30 days: follow up in writing, confirm there's no dispute and ask for a payment date.
• 31–60 days: call the customer's accounts payable contact, resolve any dispute and agree on a plan.
• 61–90 days: escalate to the account owner or finance lead, and consider holding new orders or credit.
• Over 90 days: decide whether to pursue formal collection, agree on a settlement or provide for the balance as doubtful.

The aging report and the allowance for doubtful accounts

Under accrual accounting, a business estimates how much of its receivables it won't collect and records that estimate as an allowance for doubtful accounts. The aging method applies a higher expected-loss percentage to each older bucket, based on the business's own collection history, and adds up the results. The older the balance, the less likely it is to be paid, so the aging report is the natural basis for the estimate.

Common problems with aging reports

• Customer payments received but not yet matched to invoices, so paid invoices still look overdue.
• Credit notes and short payments left open, inflating the past-due total.
• A report pulled from billing that doesn't agree with accounts receivable in the ledger.
• No reason recorded against past-due invoices, so the same customers are chased for disputes nobody is working on.
• A report produced once a month, too late to act on what it shows.

Receivables metrics that go with the aging report

• Days sales outstanding (DSO): how long, on average, customers take to pay. Divide accounts receivable by credit sales for the period, then multiply by the number of days in the period.
• Percentage past due: past-due receivables divided by total receivables. Watch the trend, not just the number.
• Accounts receivable turnover: credit sales divided by average accounts receivable; a higher number means faster collection.
• Collection effectiveness: how much of what was collectible in a period was actually collected.

What changes on one system

An aging report is only as good as the records behind it. When invoicing, incoming payments and the books run as one system, each payment is matched to its invoice as it arrives, short payments are flagged with the original invoice in view, and the aging total always agrees with the ledger. The report is current every day, not once a month, so collections act on today's balances. See how it works on the Accounts Receivable and Accounting pages.