Skip to content
Nika

What is Accounts Receivable Aging?

Accounts receivable aging is a report that sorts every unpaid customer invoice by how long it has been outstanding, grouping balances into time buckets — typically 0–30, 31–60, 61–90, and over 90 days. It shows at a glance which customers are paying on time, which are slipping, and how much cash is trapped in late or doubtful debts.

The aging report is the single most-used collections tool in a finance department. Each customer’s outstanding invoices are listed under the bucket that matches their age, so a single glance reveals the shape of the receivables: healthy businesses show most of the money in the 0–30 column, while a drift of balances into 61–90 and 90+ signals that collections are breaking down. The 90+ column is also the starting point for the bad-debt provision — older invoices are progressively less likely to be collected, and accounting standards require a reserve for the expected loss.

Beyond credit risk, the aging report drives cash-flow forecasting: the 0–30 bucket is the cash expected within the next few weeks, and the longer buckets are warnings that revenue has been booked but the money has not arrived. A small business running a tight cash position watches this report weekly. Automation helps by sending automatic reminder emails at each bucket boundary, escalating tone as invoices age, and surfacing the worst offenders to a human for a phone call before the debt becomes unrecoverable.

Example

A wholesale distributor’s aging report at month-end shows €60,000 in 0–30 days, €20,000 in 31–60, €8,000 in 61–90, and €3,000 in 90+. The €3,000 in the oldest bucket belongs to one customer who has stopped responding — flagged for a collection agency — while the 31–60 bucket triggers reminder emails to four customers who are two weeks behind.

Questions

What do the time buckets in an aging report mean?

They group invoices by how many days have passed since the invoice date or due date — typically 0–30, 31–60, 61–90, and 90+ days. The older the bucket, the less likely the invoice is to be collected. Most finance teams focus management attention on the 61–90 and 90+ columns, where bad-debt risk concentrates.

How does an aging report relate to the bad-debt provision?

It is the primary input. Accounting standards require a business to estimate how much of its receivables will not be collected. The aging report makes that estimate systematic: invoices in the 90+ bucket carry a far higher expected loss rate than those in 0–30, so the older the average receivable, the larger the bad-debt provision required on the balance sheet.

See how Nika handles this

Related terms