What is an accounts receivable aging report? Definition and example
Accounts receivable, billing and collections
An accounts receivable aging report lists unpaid customer invoices grouped by how long they have been outstanding, such as current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due. Its total should equal the accounts receivable balance in the general ledger, and teams use it to chase payment and estimate credit losses.
- Shows
- Open customer invoices
- Basis
- Due or invoice date
- Ties to
- Gross AR
- Supports
- Credit loss allowance
How does an AR aging report work?
An AR aging report takes every open invoice, measures its age at a report date, and places it in an aging bucket, then totals the buckets by customer.
- Aging basis: Days past the due date (most common for collections) or days since the invoice date. Say which one the report uses.
- Buckets: Usually current, 1 to 30, 31 to 60, 61 to 90, and over 90 days. Companies set their own.
- Report date: Run it as of period end for the close, or today for collections.
- Open items: Unapplied cash and credit memos should show as negatives against the customer, so the net ties to the ledger.
Summary vs detail aging report
A summary aging report shows one line per customer with a total for each bucket; a detail aging report lists every open invoice with its date, due date, and days past due.
Collectors work from the detail; controllers and lenders read the summary. In QuickBooks Online they're called "Accounts receivable aging summary" and "Accounts receivable aging detail," under Reports, Standard reports, Who owes you.
Accounts receivable aging report example
Example: Westbrook Packaging runs its aging as of Wednesday, September 30, 2026, by days past due. All amounts are illustrative.
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Alder Foods | 42,000 | 42,000 | ||||
| Brookline Hotels | 18,000 | 9,000 | 27,000 | |||
| Crestview Clinics | 6,000 | 8,000 | 14,000 | |||
| Dunmore Retail | 4,000 | 5,000 | 9,000 | |||
| Total | 60,000 | 15,000 | 8,000 | 4,000 | 5,000 | 92,000 |
| % of total | 65.2% | 16.3% | 8.7% | 4.3% | 5.4% | 100% |
The aging total ties to the ledger before anyone uses it:
| Tie-out, September 30, 2026 | Amount |
|---|---|
| AR aging report total | $92,000 |
| General ledger accounts receivable control account | $92,000 |
| Difference | $0 |
The report shows Dunmore Retail needs a call and a credit hold, and that 34.8% of receivables are past due.
How the aging report sets the allowance
Many companies estimate the allowance for credit losses by applying a loss rate to each aging bucket, an approach ASC 326 (CECL) permits when rates reflect history adjusted for current conditions and forecasts.
| Bucket | Balance | Loss rate | Allowance needed |
|---|---|---|---|
| Current | 60,000 | 1% | 600 |
| 1 to 30 days | 15,000 | 3% | 450 |
| 31 to 60 days | 8,000 | 10% | 800 |
| 61 to 90 days | 4,000 | 25% | 1,000 |
| Over 90 days | 5,000 | 50% | 2,500 |
| Total | 92,000 | 5,350 |
The allowance holds $4,100 before adjustment, so Westbrook books the $1,250 difference.
| Date | Account | Debit | Credit |
|---|---|---|---|
| Sep 30, 2026 | Credit loss expense | 1,250 | |
| Allowance for credit losses | 1,250 | ||
| Total | 1,250 | 1,250 |
Net accounts receivable on the balance sheet is $86,650 ($92,000 minus $5,350).
What is the AR aging report confused with?
The AR aging report is most often confused with the AP aging report, which ages what you owe suppliers, and with the customer statement, which goes to one customer.
| Term | What it is | How it differs from the AR aging report |
|---|---|---|
| AP aging report | Report listing unpaid supplier invoices grouped by age past the invoice or due date | Ages payables, not receivables |
| Customer statement of account | Summary sent to a customer listing invoices, payments, and credits over a period, with the balance still owed | Sent to one customer; the aging is internal and covers all |
| Accounts receivable subledger | Detailed record of each customer invoice, payment, and credit that supports the accounts receivable balance in the general ledger | The data the aging reads from |
| Aging buckets | Time bands used to group receivables by how long they are outstanding, such as current, 1 to 30, 31 to 60 days | The columns of the report |
AR aging at month end
At month end, run the aging as of the last day of the period after cash application, tie it to the control account, and update the allowance, as part of the month-end close.
- Cutoff: Billing and revenue can differ: recognize revenue for sales whose control passed by period end under the shipping terms, not every invoice or shipment; FOB destination goods still in transit aren't period revenue
- Apply cash: Clear unapplied payments so paid invoices leave the report
- Tie out: Agree the aging total to the AR control account at Difference $0 (AP and AR reconciliation)
- Allowance: Rerun loss rates on the new buckets
- Credit balances: Reclassify material customer credit balances to a liability
our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.
Common AR aging report mistakes
The most common AR aging report mistakes make the report disagree with the ledger or overstate what's late.
- Running it before cash application: Paid invoices look past due
- Mixing aging bases: Invoice-date aging makes on-time net 60 invoices look 31 to 60 days old
- Posting manual entries to the control account: The ledger moves; the aging doesn't
- Tying the aging to net AR: It leaves a false difference equal to the allowance
- Ignoring credit balances: They hide overdue amounts inside a small net total