What Is Aging Accounts Receivable?

An aging report groups open receivable items by defined age ranges. It can support collection, cash planning, dispute management, credit review, and close when it is reconciled and paired with named actions.

How it is structured

Invoices are grouped into buckets, typically current and then successive periods past due, with a total per customer and a total overall. Aging is normally measured from the invoice date or the due date, and it is worth knowing which your report uses, since they produce different pictures.

How to read it

• The total tells you your working capital tied up in unpaid work
• The distribution across buckets tells you whether collection is healthy or deteriorating
• The customer breakdown tells you where the risk is concentrated
• Movement between months tells you whether the problem is growing

The most important reading is the trend. A single snapshot says little; the same report month over month says whether your process is working.

What distorts it

• Credit balances from overpayments or unapplied deposits
• Non-trade items such as tax refunds or employee advances sitting in receivables
• Payments received but not applied to specific invoices
• Credit notes issued and never applied
• Invoices raised in error and never voided

Each of these makes the report less trustworthy, and an untrusted report stops being used, which is how collection quietly deteriorates.

Working it weekly

• Fix a slot in the week and keep it
• Work in order of value, largest first, rather than top to bottom
• Anything just past due gets a reminder; anything well past due gets a call
• Record the outcome and the promised date against the account
• Escalate according to a threshold you set in advance

Older is harder

Older balances may require different evidence, communication, credit, allowance, or escalation review. Choose an operational cadence based on invoice volume, contractual terms, cash needs, customer risk, and the cost of follow-up rather than a universal schedule.

Watch concentration

If one customer represents a large share of the aging, their payment behaviour is a structural risk. That is worth monitoring as a number in the report rather than as a background awareness.

Define how age is calculated

An aging can group open items by invoice date, due date, accounting date, or another configured basis. State the report date, aging basis, bucket boundaries, currency, entity, customer population, and treatment of credits and unapplied cash. The choice affects every bucket.

Reconcile before using it

Tie the detailed aging to the accounts-receivable control account. Investigate journal entries outside the subledger, unapplied payments, credit balances, duplicate customers, foreign currency, write-offs, cutoff differences, and transactions posted after the report date.

Make the report operational

For each overdue item, capture customer, invoice, amount, due date, dispute reason, last contact, promised date, owner, next action, and escalation status. Separate missing-document or billing issues from customers who have not paid an undisputed invoice.

Review credit and negative balances

Credits can arise from overpayments, credit notes, duplicate receipts, refunds due, or misapplication. Do not hide them by netting across unrelated customers. Assign an owner, confirm the source, apply or refund under policy, and retain approval.

Support recoverability review

Use aging as one input alongside subsequent collections, disputes, customer condition, concentration, historical experience, current facts, and the applicable accounting policy. Preserve the estimate, assumptions, data, preparer, reviewer, and approved adjustment.

Aging review checklist

• Detailed aging reconciles to the ledger
• Report date and aging basis are documented
• Credits and unapplied cash are visible
• Disputes have reason codes and owners
• Promised dates and subsequent receipts are updated
• Non-trade items are excluded
• Adjustments and write-offs have approval evidence

Example cleanup sequence

Freeze a dated copy of the report, reconcile its total, and sort exceptions by type. Resolve unapplied cash, customer credits, duplicate invoices, duplicate customers, incorrect due dates, old disputes, unsupported journal entries, inactive customers, and non-trade balances. Do not erase history needed to explain prior reporting.

After corrections, rerun the aging using the same date and basis, compare changes, approve adjustments, and preserve the reconciliation. Use the clean report as the baseline for collection actions and allowance review.

Customer-level review questions

Is the invoice valid and delivered? Does the customer have required documentation? Is the contact correct? Is a dispute open? Was a payment promised? Are credits available? Has service continued beyond the limit? What action, owner, evidence, and date are required next?

Preserve dated aging reports used for close, allowance, financing, or management decisions. Later corrections should be documented rather than silently replacing the original evidence. Restrict report filters and configuration changes, and record the user, reason, review, and effective date when definitions change.

Retain the approved report, reconciliation, actions, and subsequent receipt review with the close file.