Accounts Receivable Aging

An accounts receivable aging is a report of every open customer balance sorted into buckets by how long it has been outstanding. The conventional structure is current, 1 to 30 days, 31 to 60, 61 to 90, and over 90, with a total per customer and a total for the report. It is simultaneously a collections tool, an accounting estimate input, and an audit workpaper, and the three uses pull it in slightly different directions.

The first decision is what the buckets measure. Aging by invoice date measures how long the invoice has existed. Aging by due date measures how overdue it is, which is the more useful question when terms differ across customers. A report aged by invoice date on net-60 terms shows a third of the book as 31 to 60 days when nothing is late at all. Whichever basis is used, it should be stated on the report and applied consistently, because comparisons across periods are meaningless otherwise.

The tie-out is non-negotiable: the aging total must agree to the accounts receivable control account in the general ledger at the same date. The aging is a subledger view, the control account is the ledger, and they should be the same number. The differences that show up are consistent. Unapplied cash sits as a credit somewhere in the subledger while the ledger shows the payment. Credit memos issued but not applied age as negatives against invoices they were meant to clear. Journal entries posted directly to the control account bypass the subledger entirely. Foreign currency invoices revalue in the ledger and not in the aging, or the other way round. Write-offs are processed in one system and not the other. Each has a different fix, and a plug has none.

For the allowance, the aging is the starting point rather than the answer. Under the current expected credit loss model the estimate is forward-looking and considers historical loss experience, current conditions, and reasonable and supportable forecasts, which means a straight percentage applied to each bucket is a defensible starting framework only if the rates are derived from the entity's own loss history and adjusted for what is known about the present. Pooling matters too: customers with shared risk characteristics should be evaluated together, and a single large balance with distinct risk is evaluated on its own.

For the auditor, the aging supports existence and valuation, feeds confirmation selection, and provides the population for subsequent-receipts testing. Its usefulness depends entirely on whether it ties and whether the aging basis is what the report says it is.

Two habits keep it clean: apply cash and credits promptly rather than at period end, and review the negative and zero-balance lines every period, because they are usually the visible edge of a matching problem rather than genuine credits.

Related terms: Current Expected Credit Losses, Account Reconciliation, General Ledger, Trial Balance

Related skill: AR aging tie-out

Tying an aging to the ledger and explaining every reconciling item is a monthly exercise that never gets easier. Adopt's agents perform the tie-out, classify the differences, and leave a workpaper behind them. Sign up free.