Revenue is strong. The pipeline is full. Your crews are booked out for weeks. So why does the bank account keep telling a different story?
Here is the uncomfortable answer. The work being done is not the same as the money being collected. And the gap between those two things lives in a report many owners glance at once a quarter, if that.
It is called the AR aging report. This is the most honest document in your business, and learning to read it like an operator instead of a bookkeeper changes how you run everything downstream of it.
What Is An AR Aging Report?
An AR aging report, sometimes written as an accounts receivable aging report, is a breakdown of every unpaid invoice you have outstanding, organized by how long it has been waiting to get paid.
Most accounting platforms sort it into four buckets:
- Current (0–30 days)
- 31–60 days
- 61–90 days
- 90+ days
Each invoice slots into a column based on how far past its issue or due date it sits. The report shows you, at a glance, how much money is owed to you and how long it has been owed.
That is the mechanical definition. Here is the operational one. Your AR aging report is a real-time record of how well your business converts completed work into collected cash. A bookkeeper sees a list of open invoices. An operator sees the exact distance between the field finishing a job and the office turning it into money in the account.
Why Owners May Avoid It
Owners are trained to read two reports: the profit and loss statement and the balance sheet. Those are the financial documents everyone learns first. They tell you whether the business made money and what it owns.
The AR aging report tells you something less comfortable. It reveals how much of the money you already earned is still sitting in someone else’s bank account.
That is a harder thing to look at. A profitable P&L feels like a win. An aging report stacked with 60- and 90-day invoices feels like a problem you have to chase down, one awkward phone call at a time. So it gets skipped.
The avoidance is understandable. It is also expensive.
What The Numbers Say About Late Payments
This is not a niche problem. It is the default condition of running a service business that invoices clients.
A global study by Allianz Trade found that average days sales outstanding, the lag between making a sale and collecting payment, rose to 59 days, with one in five companies waiting more than 90 days for a typical invoice to be paid. In the United States, the average small business is owed more than $17,000 in unpaid invoices at any given time, and 55% of B2B invoices are paid late.
For project-driven businesses, the picture is sharper. Chaser’s 2026 accounts receivable research found that 100% of construction businesses are paid late, with 44% waiting more than 30 days beyond the invoice due date.
Read that again. Not most. All of them. If your business invoices on completed work, milestones, or retainers, late payment is not a possibility you might face. It is the environment you already operate in.
The question is not whether your clients pay late. What matters is whether you can see it happening clearly enough to do something about it.
What Each Aging Bucket Is Actually Telling You
This is where the report stops being a list and starts being a diagnostic. Each column points to a different part of your operation.
Current (0–30 days)
This is healthy. Invoices here are doing what they should. If most of your receivables sit in this bucket, your billing and collections cadence is working. Keep going.
31–60 days
This is the watch zone. A few invoices here is normal, especially with Net 30 terms that clients treat as Net 45. But a cluster forming here usually points to one of two things: invoices that went out late, or a follow-up process that does not start until something is already overdue.
61–90 days
This is the warning zone. Money in this bucket signals a breakdown somewhere upstream. The job closed without a clean handoff to billing. An invoice went out with an error the client used as a reason to delay. Nobody followed up after the first send. Anything this old is rarely a payment problem. It is a process problem wearing a payment problem’s clothing.
90+ days
This is the danger zone, and it is where the math turns against you fast. Industry data from the Commercial Collection Agency Association and NACM shows that roughly 70 to 80% of invoices aged 90 days past due are still collectible, but that figure drops to 45 to 55% at six months and 20 to 30% at twelve months. Every week of delay shaves off another point or so of recovery. Money that ages into this column is not just late. It is at real risk of never coming back. An aging report heavy here is not a collections issue anymore. It is a profit issue.
The Pattern Fiding In Your Buckets
Here is the part that makes the AR aging report worth more than the sum of its columns. The pattern across the buckets tells you where your operation is breaking down.
If your aging report fills up in the same place every month, that is not random. That is a system pointing at itself.
Cluster in 31–60 with one specific client? You have a payment-terms mismatch or a relationship that needs a direct conversation.
Cluster in 61–90 across multiple clients? Your invoicing is going out late, or your follow-up cadence does not exist. The work is fine. The back-office handoff is not.
Cluster in 90+ tied to a single job type or service line? Something about how you scope, deliver, or close that work is creating disputes or delays. The aging report found a delivery problem you could not see from the P&L.
The buckets are symptoms. That cluster is the diagnosis.
The Exercise: A 10-minute AR Aging Diagnostic
You can do this today, before you close your laptop. It takes about ten minutes and it will tell you more about your cash position than your last three P&Ls combined.
Step 1. Open your bookkeeping platform and run the AR aging report. In QuickBooks Online it lives under Reports, then “Accounts Receivable Aging Summary.” Xero, Sage, and FreshBooks all have an equivalent under their reporting menus.
Step 2. Look at the total at the bottom of each column. Write down the dollar amount sitting in each of the four buckets.
Step 3. Calculate what percentage of your total receivables sits past 60 days. Add the 61–90 and 90+ columns together, then divide by your total outstanding.
Step 4. Ask one question: is more than 20% of what I am owed sitting past 60 days?
If the answer is yes, you do not have a sales problem. You have a collections and process problem, and it is quietly funding your clients’ businesses with your money.
Step 5. Find the single largest invoice in your 90+ column. That one invoice is your first phone call tomorrow morning.
How To Fix What The Report Reveals
Reading the report is step one. The fix is operational, and for project-driven businesses it almost always lives in the same place: the gap between the field and the office.
Here is what actually happens. The crew finishes the job on a Thursday. The crew lead moves on to Monday’s site. Nobody tells billing the work is done. The invoice goes out a week or two later, if someone remembers, and the payment clock that should have started Thursday does not start until the invoice lands. You have added two weeks to your DSO before the client has done anything at all. The aging report shows you a payment problem. The real problem is a handoff that never happened.
Close that gap and the buckets take care of themselves. A working collections system has three parts:
- Invoice the day the job closes, not the week after. This is the single highest-leverage fix, and it is an operational one, not a financial one. It means the field has to signal the office the moment work is complete. Build that trigger into how jobs close out.
- Run a follow-up cadence that does not depend on memory. A reminder at the due date, another at 15 days, a direct call at 30. The research is blunt on this: businesses that follow up on 100% of overdue invoices are 76% more likely to be paid within one week. Consistency beats intensity.
- Review the aging report every week, not every quarter. A 90-day problem is far harder to solve than a 30-day one. Weekly review catches the drift while it is still cheap to fix.
This is what strategic bookkeeping actually does, and it is the line between a bookkeeper and an operator. A bookkeeper records the invoice. Strategic bookkeeping builds the system that gets the invoice out the day the job closes and the cash in before the gap strains your payroll.
Frequently Asked Questions
What is a good AR aging report supposed to look like? Most of your receivables should sit in the current 0–30 day bucket, with a small and shrinking amount in 31–60. Anything past 60 days should be the exception you are actively working, not a standing balance you have learned to live with.
How often should I run my AR aging report? Weekly. Monthly at the absolute minimum. The value of the report is in catching invoices before they age into the high-risk buckets, and that only works if you are looking often enough to act early.
What is DSO and how does it relate to the aging report? DSO, or days sales outstanding, is the average number of days it takes you to collect payment after a sale. The aging report shows you which invoices are creating that lag. DSO is the score. Your aging report is the game film.
My books and my invoicing are a mess. Where do I even start? Start with the single oldest invoice in your 90+ column and work backward. A perfect system is not required to make the first collection call. What you need is visibility into what is owed, and the aging report gives you exactly that.
The Bottom Line
Your P&L tells you what you earned. The AR aging report tells you what you actually have. For a project-driven business operating in a market where late payment is the rule and not the exception, the second number is the one that determines whether payroll clears.
The report does not lie to you. It does not flatter a good month or panic over a slow one. What it does is show you, in plain columns, the distance between the work you finished and the cash you are holding.
Many owners are afraid to look because they suspect what they will find. The owners who look anyway, every week, are the ones who never get surprised by their own bank account.
Which bucket is your money sitting in right now?
If you have not looked at your AR aging report in the last 30 days, that is the place to start. Financial clarity does not come from working harder. It comes from seeing your numbers clearly enough to act on them early.
At TruePath Solutions, we help owners of project-driven service businesses build the bookkeeping and operational systems that turn financial visibility into operational clarity. Strong books are not about compliance. They are about protecting the profit you already earned.
If you want a clear read on where your own financial blind spots are, our Business Bookkeeping Health Check is a straightforward place to begin.
Written by the team at TruePath Solutions. A U.S.-based operational strategy and strategic bookkeeping firm helping service businesses turn their numbers into clear, confident decisions.
