How do I read an accounts receivable aging report?

Read it top to bottom as a risk ranking, not a customer list. The report sorts everything you're owed into buckets by how late it is: 0–30, 31–60, 61–90, and 90+ days. The number that matters is not the total at the bottom. It's how much of that total is stacked in the 61–90 and 90+ columns, and how few accounts it's stacked in. A big balance sitting in 0–30 is a normal Tuesday. A smaller balance sitting in 90+ is the one that threatens your month.

Which overdue invoices should I chase first?

Chase by concentration and age, not alphabetically. In most trades shops, three or four balances carry the bulk of the real risk. Sort the aging report by amount inside the 61–90 and 90+ buckets, and start with the accounts that are both large and old. A repeat late-payer of a small amount can wait; a first-time commercial account that's crossed 60 days cannot. Work the top three before you touch the rest.

What do the AR aging buckets mean for a home-service business?

The buckets measure how late a balance is past your terms. 0–30 days is usually nothing: residential customers pay on receipt and commercial accounts run on net-30. 31–60 is a reminder window. 61–90 is the cliff, where collection odds start dropping fast. 90+ is where money goes to become a write-off. The point of the report is to catch invoices while they're still in the collectible range instead of after they've aged out of it.

How to read an A/R aging report: which overdue invoices actually threaten your month: Guidepost

It’s Friday afternoon. The office manager pulls the aging report, starts at the top, and works down the list in the order QuickBooks printed it. Which is to say, alphabetically. Abbott’s HVAC repair from three weeks ago gets a call before Riverside Apartments, which crossed ninety days sometime in the spring and nobody noticed. By the time she gets to the R’s it’s 4:45 and the week is gone.

That’s the wrong order. Not because she’s doing it wrong, but because the report isn’t a to-do list. It’s a risk ranking, and nobody ever told her to read it that way.

The aging report is a ranking, not a list

An accounts receivable aging report sorts everything you’re owed into columns by how late it is: 0–30 days, 31–60, 61–90, and 90+. In QuickBooks it’s the A/R Aging Summary. Every field-service shop has one, and most owners glance at the total at the bottom and close the tab.

The total is the least useful number on the page. What matters is the shape. Read the buckets in trades terms:

0–30 days is usually nothing. Residential customers pay on receipt. Commercial accounts run net-30 and pay on day 29. A five-figure balance sitting here is a normal week, not a problem.
31–60 days is the reminder window. A balance here has slipped past terms but is still very collectible. One friendly nudge fixes most of it.
61–90 days is the cliff. Collection odds start falling here, and they fall fast. This is where a balance stops being late and starts being at risk.
90+ days is where money goes to become a write-off. Anything that lands here needs a real conversation, not another emailed reminder.

The skill isn’t chasing. The skill is reading which column the money is stacked in, and then how few accounts it’s stacked across.

Triage: concentration, age, and the repeat offender

Here’s the pattern I see in almost every shop I sit with: three or four balances carry most of the actual threat, and the rest is noise you can work later. Chasing all of it with equal energy is how a Friday disappears.

Take our sample shop, Northside Comfort (a fictional HVAC and plumbing business we use to show the product on real-shaped numbers). Its aging report shows $11,700 past due, and if you read the total alone you panic evenly across the whole list. Read it as a ranking and it collapses into three accounts, all sitting in the 60 to 90+ range:

Riverside Apartments: $6,200
Bella Vista Cafe: $3,400
Greenpoint Dental: $2,100

That’s the entire threat, in three phone calls. Those three carry the money and the age. Everything else on Northside’s report is under thirty days and paying itself.

Three rules decide the order:

Concentration. Find the balances that are both large and old. One $6,200 account at 90 days outranks twenty small residential invoices combined.
Age wins ties. Between two similar balances, the older one gets the call first. Every week past ninety days lowers the odds you ever see it.
The repeat offender is a category, not a crisis. A customer who’s always thirty days late and always pays is a cash-timing annoyance, not a risk. Note them, don’t burn Friday on them.

Before you call: check whether the job is even done

This is the step the aging report can’t show you, and it’s the one that separates a real overdue balance from a false alarm. QuickBooks tells you a balance is late. It does not tell you why.

So before you pick up the phone on Riverside’s $6,200, open Jobber and check the job behind it. Is the work actually finished and signed off? Was there a change order that never got invoiced? Did the customer dispute a line and it’s been sitting in someone’s inbox since? Disputed is not the same as forgotten, and a customer you dun for money over a job they think is unresolved is a customer you might lose.

Reading the aging line against the job status in your field-service tool turns a blind collection call into an informed one. It’s a two-source read, and it’s exactly the kind of cross-check no single tool does for you: QuickBooks owns the balance, Jobber owns the job, and the answer lives in both.

The three-account focus, then the cadence

Once you’ve triaged and cross-checked, the actual chasing is the easy part, and it’s a separate discipline. We wrote the weekly system for that in Stop letting money sit. The short version: work the top three, use a fixed escalation (a reminder in the 31–60 window, a phone call at 61–90, a firmer conversation past 90), and run it as a standing weekly slot with one owner. That post is the how. This one is the what: which balances earn the call in the first place.

For Northside, the week’s work is three calls, not thirty. Riverside and Bella Vista get phone calls today because they’re over sixty. Greenpoint gets a call too, since it’s crossed the same line. Nothing else on the report needs a human this week.

When aging explains a good month with no cash

Sometimes the aging report is the answer to a different question. If you had a strong revenue month and your bank balance still went the wrong way, the cause is often sitting right here. Revenue is booked when the work is done; cash arrives when the invoice is paid. A pile of large balances stuck at 61–90 days is the most common reason a busy month feels broke.

If that’s the shape you’re seeing, the aging report is the first place to look, and it usually points straight at two or three commercial accounts. Reading the weekly numbers together, jobs, books, and what’s owed, is the Monday review habit that catches this before it becomes a payroll scramble.

My take

An aging report will not tell you who to call. It will not sort itself by risk, and it will not check whether the job’s done. All of that is on you, every Friday, in a spreadsheet or a QuickBooks tab, which is precisely the work I built Guidepost to stop doing by hand. It reads your QuickBooks A/R against your Jobber jobs every week and flags the balances that crossed the line, with the amount, the age, and the source next to each one, before you’ve thought to look. Overdue money is the one thing it will raise without being asked.

If you’d rather the triage was done before you sit down Friday, book a demo and bring your own aging report. We’ll read it together on the call, and you can see whether the three accounts we’d flag are the three you’d have found by 4:45.

How to read an A/R aging report: which overdue invoices actually threaten your month