Skip to content

What is an accounts receivable aging report? Definition and example

Accounts receivable, billing and collections

Definition

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.

CustomerCurrent1 to 3031 to 6061 to 90Over 90Total
Alder Foods42,00042,000
Brookline Hotels18,0009,00027,000
Crestview Clinics6,0008,00014,000
Dunmore Retail4,0005,0009,000
Total60,00015,0008,0004,0005,00092,000
% of total65.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, 2026Amount
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.

BucketBalanceLoss rateAllowance needed
Current60,0001%600
1 to 30 days15,0003%450
31 to 60 days8,00010%800
61 to 90 days4,00025%1,000
Over 90 days5,00050%2,500
Total92,0005,350

The allowance holds $4,100 before adjustment, so Westbrook books the $1,250 difference.

DateAccountDebitCredit
Sep 30, 2026Credit loss expense1,250
Allowance for credit losses1,250
Total1,2501,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.

TermWhat it isHow it differs from the AR aging report
AP aging reportReport listing unpaid supplier invoices grouped by age past the invoice or due dateAges payables, not receivables
Customer statement of accountSummary sent to a customer listing invoices, payments, and credits over a period, with the balance still owedSent to one customer; the aging is internal and covers all
Accounts receivable subledgerDetailed record of each customer invoice, payment, and credit that supports the accounts receivable balance in the general ledgerThe data the aging reads from
Aging bucketsTime bands used to group receivables by how long they are outstanding, such as current, 1 to 30, 31 to 60 daysThe 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.

  1. 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
  2. Apply cash: Clear unapplied payments so paid invoices leave the report
  3. Tie out: Agree the aging total to the AR control account at Difference $0 (AP and AR reconciliation)
  4. Allowance: Rerun loss rates on the new buckets
  5. 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