What is an AR aging report?

Aging begins with a reference date and a consistent age basis, usually the invoice due date for collection work or the invoice date for a different analytical purpose. Every open balance is assigned to the bucket containing its age on that date.

The report should state which basis it uses. Mixing invoice-date and due-date aging produces misleading comparisons, especially when customers have different terms.

• Current or not due
• 1–30 days overdue
• 31–60 days overdue
• 61–90 days overdue
• More than 90 days overdue

Apply the report in the AR aging workflow.

The report shows concentration by customer, entity, currency and age. It can reveal that a small number of old invoices account for most overdue value, or that a newer bucket contains many small operational issues.

It does not reveal the cause automatically. A large old balance may be disputed, partly paid, promised for a date or already paid but not matched. Finance must connect the bucket to record-level context before acting.

• Value concentration
• Count of open records
• Movement between periods
• Owners and next actions

Start with what is accounts receivable.

Disputes, credits, unapplied payments and agreed payment plans should remain visible rather than being hidden inside one overdue total. The original invoice, current open amount and exception state answer different questions and should all be retained.

Aging should prioritise the queue, while the state determines the action. A disputed 70-day invoice needs resolution; an ordinary 12-day overdue invoice may need a reminder.

• Verify delivery.
• Check matched and unmatched payments.
• Identify disputes and promised dates.
• Confirm approved credit notes or adjustments.

Investigate payments through reconciliation.

Assume a company has $48,000 open: $20,000 current, $12,000 at 1–30 days, $9,000 at 31–60 days, $5,000 at 61–90 days and $2,000 over 90 days. The oldest $2,000 is important, but it is not automatically the only priority.

If the $9,000 middle bucket belongs to one disputed invoice with an approaching resolution date, it may require more immediate ownership than several already-promised older balances. Age supplies sequence; context supplies judgment.

• Total open: $48,000
• Overdue: $28,000
• More than 60 days: $7,000
• Action order: age plus state, value and commitment

Turn priority into accountable collections.

Review aging on a predictable cadence, compare movement between periods and inspect the records behind material changes. Assign an owner and next action to exceptions, then remove matched payments promptly so the queue stays credible.

Do not publish a collection-performance claim from one snapshot. A measured result needs a consistent definition, baseline, observation period, source and explanation of exclusions.

• Use one age basis.
• Retain original and open amounts.
• Review movement, not only the total.
• Tie every priority item to an owner.

Use proportionate payment reminders.