What is accounts receivable aging?

Also called: AR aging, aging report

Accounts receivable aging sorts customers' unpaid invoices by how much time has passed since each invoice was issued, or since its due date. An aging report groups the balances into time buckets and shows, for each customer, how much they owe in each bucket. The older a balance, the harder it is to collect.

Example

Customer A usually pays on time. The aging report shows one of their invoices still open, well past its due date, while everything else is paid. Before calling, you check their account statement and find the payment already arrived. It just was never applied to the invoice. Instead of an awkward call, you only need to apply the payment.

Why it matters for distributors

Distributors sell on credit: the goods ship today, and the money arrives after the payment terms agreed with the customer. So open balances are normal. The question is which of them are already overdue.

The aging report answers that question and helps you decide whom to collect from first. The older a balance, the harder it is to collect, and the longer that cash is missing from your cash flow. It also pays to check the report against the customer's account statement, so you never call a customer about a bill they already paid.

Aging buckets in an AR aging report

Most aging reports group balances into 30-day buckets:

  • Current: not due yet.
  • 1 to 30 days past due: usually just needs a reminder.
  • 31 to 60 days: worth checking what happened and talking to the customer.
  • 61 to 90 days: getting harder to collect.
  • Over 90 days: the most urgent to act on.

How it works in Insighting

Vera, Insighting's collections agent, analyzes the open balances in your ERP every morning, sorts them by urgency, and checks each customer against their account statement. She emails the ready collections list to the team members your company chose. Reaching out to the customer stays with your team.

Meet Vera, the collections agent

AR aging FAQ

What is an AR aging report?

An AR aging report shows each customer's open balances, grouped into time buckets by how long they are past due. It shows who is late, by how much, and whom to collect from first.

What's the difference between AR aging and DSO?

AR aging shows open balances by age, customer by customer. DSO (days sales outstanding) is a single number: how many days, on average, pass from the sale until the money arrives. Aging tells you whom to collect from; DSO shows whether collections are improving.

Why check the aging report against the customer ledger?

Because sometimes a payment has arrived but was never applied to the invoice. Without the check, the report shows a balance that's already paid, and someone calls the customer for no reason. Vera, Insighting's collections agent, checks every customer against their ledger before she sends the collections list.

More in the glossary

Connect your ERP. Up and running in 4 weeks.

Insighting learns your business and tells everyone on the team what to do next.

Book a demo