What Is an Accounts Receivable Aging Report and How Do You Use It?

Most business owners know money is owed to them — what they often don't know is exactly how much, from whom, and how long it's been sitting unpaid. That's precisely the problem that understanding what is an accounts receivable aging report and how do you use it can solve. It's one of the most practical financial reports available in any accounting system, and for businesses that extend credit to customers or clients, it should be reviewed regularly — not just at year-end or when cash gets tight.

What an AR Aging Report Shows

An accounts receivable aging report is a snapshot of all outstanding customer invoices, organized by how long each invoice has been unpaid. It groups your open receivables into time buckets — most commonly:

• Current (0–30 days): Invoices that are still within their payment terms. Normal business.
• 31–60 days: Invoices slightly past due. Worth monitoring, worth a follow-up.
• 61–90 days: Invoices that are meaningfully overdue. These need active attention.
• 90+ days: Invoices that are significantly past due. At this stage, collection risk rises substantially, and the likelihood of full recovery begins to decline.

The report typically lists each customer, the invoice date, the invoice amount, and which bucket each invoice falls into. At a glance, you can see your total outstanding receivables and where the risk is concentrated. A healthy AR aging report shows most of your balance in the current column. A problematic one shows an accumulation in the 60-, 90-, and 90-plus-day buckets.

How to Read the Report Effectively

Pull your AR aging report and look at it in two ways: by aging bucket and by customer.

By aging bucket: What percentage of your total receivables is past due? A high concentration in the 61-90 or 90+ columns is a warning sign — not just for cash flow, but potentially for the underlying health of your customer relationships or your collections process.

By customer: Are the same names appearing in the older columns every month? A pattern of slow payment from a specific customer is useful intelligence. It may indicate a customer in financial difficulty, a dispute you weren't aware of, or simply a customer who needs a firmer collections process applied to their account.

The report only tells you what's happening — your job, or your bookkeeper's job, is to use that information to take action.

Using the AR Aging Report as a Collections Management Tool

The aging report works best when it's tied directly to a collections workflow. Here's a practical approach:

0–30 days: No action required unless invoices are overdue relative to terms. Confirm invoices were sent and received.

31–60 days: Send a polite payment reminder. Many late payments at this stage are simply due to the customer's own payment cycle or an invoice that got lost.

61–90 days: Make a direct phone call. A conversation is significantly more effective than another email. Document all contact attempts.

90+ days: Escalate your approach. Consider requiring partial payment before continuing services, engaging a collections agency for chronic non-payers, or in some cases writing the balance off as bad debt (with proper accounting treatment and a conversation with your CPA about tax implications).

Your bookkeeper or accounting team should be working off the AR aging report monthly — or even weekly for high-volume businesses — to ensure no invoice falls through the cracks.

How It Connects to Cash Flow Forecasting

An AR aging report is a key input into cash flow forecasting. If you know that you have a significant balance in the 31–60 column, you can estimate — with some confidence — how much of that will convert to cash in the next 30 to 60 days. Balances in the 90+ column need to be treated more conservatively; some portion of that may not be collectible.

This connection matters especially for businesses that are profitable on paper but struggling with cash. A healthy P&L combined with a poorly managed AR aging report is one of the most common causes of cash flow crises that business owners describe as coming "out of nowhere." The money is on the books — it just isn't in the bank.

The South Florida Context: Construction and Commercial Services

If you operate a construction subcontracting business or a commercial property services firm in Fort Lauderdale or anywhere in Broward County, you're likely familiar with slow-paying general contractors. It's a widespread pattern in the South Florida construction market — GCs often hold payment until they've been paid by the owner, which can push your receivables into the 60-, 90-, and even 120-plus-day range as a matter of standard practice.

In this environment, an AR aging report isn't just a nice-to-have. It's the tool that tells you which GCs are consistently slow versus which ones have crossed into genuinely delinquent territory, and it gives you the documentation to support lien rights if payment disputes escalate. Florida's construction lien law has specific notice requirements and deadlines — keeping your AR records clean and current helps ensure you don't inadvertently waive your rights by failing to act within the required timeframes. A CPA familiar with construction accounting can help you build a collections process that accounts for these realities.

Frequently Asked Questions

Q: How often should I review my AR aging report?

At minimum, monthly. For businesses with high invoice volume or tight cash flow, weekly review is more appropriate. The aging report loses value if you only look at it once a quarter — by then, invoices that could have been collected at 45 days have drifted to 90+ days, which is substantially harder to collect.

Q: Can I run an AR aging report in QuickBooks?

Yes. QuickBooks Online and QuickBooks Desktop both include AR aging reports as a standard report. Most cloud-based accounting platforms (Xero, FreshBooks, and others) do as well. Your bookkeeper should be generating this report for you regularly as part of the monthly close process.

Q: What's the difference between AR aging and a simple list of unpaid invoices?

An unpaid invoice list shows you what's owed. An AR aging report organizes that list by how long each invoice has been outstanding, which tells you where to focus attention and quantifies your collection risk by time bucket. The aging structure is what makes it actionable.

Q: When should I write off a receivable as bad debt?

This is a question to discuss with your CPA. Generally, after reasonable collection efforts have been exhausted, there may be a point at which writing off an uncollectable receivable is the appropriate accounting treatment — and there are tax implications to that decision. Don't write off balances without understanding those implications first.

Q: How does the AR aging report relate to my balance sheet?

The total of all outstanding invoices on your AR aging report should tie to the accounts receivable line on your balance sheet. If those numbers don't match, it's a sign that your books have a reconciliation issue that needs to be corrected. This is one of the reconciliation checks a bookkeeper performs during the monthly close.

‍