If you've ever been surprised by a cash crunch while your books showed plenty of sales, the problem usually isn't sales — it's collections. An accounts receivable aging report is the tool that shows you exactly which customers owe you money, how much, and how long it's been outstanding. It turns a vague feeling of 'we're owed a lot' into specific numbers you can act on.
Most accounting systems can generate this report in a few clicks, but a lot of business owners never pull it up until a bank balance looks thin. Reading it regularly, instead of reactively, is what separates businesses that stay ahead of cash problems from those that get blindsided by them.
What the Report Actually Shows
An AR aging report lists every open invoice, grouped by how long it's been since the invoice date (or due date, depending on how your software is set up). The standard buckets are current, 1-30 days past due, 31-60, 61-90, and over 90 days.
Each row typically shows the customer name, invoice number, invoice amount, and which bucket it falls into. At the bottom you'll see totals for each column, giving you a quick snapshot of how much money is tied up where.
The report doesn't tell you why an invoice is unpaid — it just tells you that it is. That's useful on its own, but the real value comes from what you do with that information next.
Reading the Buckets: What's Normal and What's a Warning Sign
A healthy aging report is weighted heavily toward the 'current' and '1-30 days' columns. That means most customers are paying on time or close to it, which is exactly what you'd expect if your payment terms are net 30.
Once invoices start piling up in the 61-90 or over-90 buckets, that's a signal worth paying attention to. Money sitting there for three months or more is money you may never fully collect — the longer an invoice ages, the lower the odds it gets paid in full.
A useful gut check: compare the percentage of your total AR sitting in the 90+ bucket from month to month. If that percentage is creeping up even as your total revenue stays flat, your collections process is slipping, not just one customer having a bad month.
Spotting Collection Problems Before They Hurt Cash Flow
The aging report lets you separate two very different problems: a handful of large invoices from a few slow-paying customers, versus a broad pattern where almost everyone is paying late. The first is a conversation with specific accounts. The second usually means your invoicing process, payment terms, or follow-up habits need to change.
Watch for customers who show up in the 31-60 bucket every single month. That's often not a one-time cash flow hiccup on their end — it's become their normal payment rhythm, and it will keep happening until you change the terms or require a deposit upfront.
It's also worth checking whether certain invoice types or project sizes consistently age worse than others. If large invoices always slip past 60 days, you may want to bill in smaller installments instead of one lump sum at project completion.
Turning the Report Into Action
A simple routine works better than an occasional deep dive. Pull the aging report weekly or at minimum monthly, and have a standing rule: anything crossing into the 31-60 bucket gets a follow-up email or call that week, not whenever someone gets around to it.
For invoices that hit 90 days, decide in advance what happens — a final notice, a payment plan, or writing it off as bad debt if collection looks unlikely. Deciding this ahead of time removes the awkwardness of figuring it out invoice by invoice under pressure.
The report is also a good forcing function for prevention: if the same customers keep aging out, consider requiring deposits, shortening payment terms, or adding late fees for future work. Fixing the pattern going forward is more valuable than chasing any single overdue invoice.
Keeping Your Books Accurate Enough to Trust the Report
An aging report is only as useful as the data behind it. If invoices aren't recorded promptly, payments aren't applied correctly, or old balances never get cleaned up, the report will show noise instead of a clear picture — and you'll stop trusting it, which defeats the purpose.
This is where consistent bookkeeping matters more than people expect. At EVO Bookkeeping, we reconcile every account and categorize every transaction, then deliver your P&L and Balance Sheet by day 2 of the following month, so reports like this one are accurate and ready when you need them — not reconstructed after the fact.
It's $199 a month, flat, with no contracts and cancel anytime. If you're behind on bookkeeping right now, we catch up the backlog for free when you start a subscription, or we can do a one-time catch-up for $199 per month behind, completed within two days and guaranteed in writing. You can get an instant quote on the site in a couple of minutes.