Accounts Receivable Aging: Spot Collections Problems Early

An accounts receivable aging report lists unpaid invoices by how late they are: current, 1–14 days, 15–30, 31–60, and 60+. Read the 15–30 column every week. That is where a collections problem is still cheap to fix. Waiting for 90 days turns a slow payer into a story you tell your accountant.

Why aging beats a single AR total

A rising receivables balance can mean growth. It can also mean one customer stopped paying. Aging splits those. Xero’s U.S. Small Business Insights for the second quarter of 2026 found average time to get paid at 29.3 days, up from 28.6 in the first quarter, while late payments improved slightly to 8.5 days. Totals can look calmer than the wait. Aging shows the wait.

Hackett’s working-capital survey, reported by CFO.com in September 2026, showed days sales outstanding up 2.1 days among the largest 1,000 nonfinancial U.S. public companies in 2025. If your buyers are in that set, your 15–30 bucket will fill without anyone “being late” against their new terms. Change your forecast, not only your tone of voice.

How to build the report this afternoon

Export open invoices with issue date, due date, customer, and amount. Bucket by days past due, not days since issue, unless you sell on receipt. Exclude invoices you have already credited. Keep disputed invoices visible in a separate flag so they do not disappear into hope.

Clockwork.ai’s July 2026 analysis found 72 percent of small firms heading for a 90-day cash crunch were profitable. Unpaid invoices are the usual bridge between those two facts. Aging is the map of the bridge.

Call order that respects cash, not politeness

Largest amount in the 15–30 bucket first. Then anything that slipped from current this week. Then 31–60. Ancient 90-day invoices need a decision: payment plan, credit, or stop work. They do not need another polite template.

Bluevine’s October 2025 survey found 51.3 percent of owners would tap emergency funds within 48 hours to cover payroll. That is what happens when aging is a monthly PDF. Make it a Monday list.

Terms versus lateness

If you extended terms to win a deal, the invoice can be current and still wreck the 13-week model. Aging will not save you if “current” means 45-day terms you cannot fund. Put terms next to the customer name.

SoFi’s 2026 survey found 55 percent of owners had three months of cash or less. A single large invoice in 60+ can be a month of runway. Name that invoice in the forecast.

What not to do

Do not stop delivery on a current customer because an old invoice is messy without talking to them. Do not hide founder-friends who do not pay. Do not average days outstanding into one vanity number and skip the buckets.

Protiviti’s 2026 Global Finance Trends Survey found 83 percent of CFOs ranked cash management among their top three concerns. Collections is cash management. Aging is the instrument.

Frequently asked questions

What is an accounts receivable aging report?

A list of unpaid invoices grouped by how overdue they are. It shows who is becoming a problem before the total AR line does.

Which bucket should I watch first?

The 15–30 day column, plus any large invoice that left current this week.

How often should I refresh it?

Weekly, and the day a large invoice is due. Monthly aging is an autopsy.

What if customers pay late but always pay?

Then your terms are fiction. Rebuild the 13-week forecast on their real cycle and price the delay or shorten new terms.

Should I outsource collections at 30 days?

Usually not. Call yourself first. Outside collections are for invoices you have already decided are distressed.

How does aging connect to runway?

Every invoice that slips is a week of cash that did not arrive. Move the receipt in the 13-week model the same day the bucket changes.