How to Read an AR Aging Report (And What to Do With It)

The AR aging report tells you exactly who owes you money, how much, and how long they have owed it.

It is one of the most actionable reports in your accounting software and most business owners never open it. They check their bank balance, see cash is low, and feel anxious. The AR aging report is the answer to that anxiety. It shows you where your cash actually is.

What the Report Shows

An AR aging report lists every outstanding invoice, organized by how old it is:

Current: Not yet due. These are invoices within your payment terms (e.g., net 30 that you just sent).

1-30 days past due: Just missed the deadline. Send a polite reminder.

31-60 days past due: Getting stale. Follow up directly.

61-90 days past due: Problem territory. This needs a phone call, not an email.

90+ days past due: At-risk. These need immediate escalation, a payment plan, or collection proceedings.

Most accounting software (QuickBooks, Xero, FreshBooks) generates this report automatically. In QuickBooks, it is under Reports, then Accounts Receivable Aging Summary or Detail.

How to Actually Read It

Start at the right side: look at your 61+ day columns first. These are the invoices most likely to become uncollectable and they represent cash that should already be in your account.

Then look at concentration: is 60% of your total AR balance owed by one client? That is not a healthy AR balance. That is one client who owes you a lot of money. Concentration risk means that one slow-paying client can create a cash crisis even if everything else is running fine.

Then look at patterns: are the same clients showing up in the 31-60 day column every month? Some clients consistently pay late. You can either build that into your cash planning, charge interest on late balances, or stop extending credit terms to them entirely.

The Action Steps by Bucket

Current and 1-30 days: No action needed unless you want to send an early reminder. Some businesses send a courtesy reminder 5 days before the due date. This reduces late payments without being aggressive.

31-60 days past due: Send a direct email. Subject line: "Invoice [number] — following up." Keep it short. Attach the invoice. Ask for a payment date. Most invoices at this stage are genuinely forgotten, not intentionally unpaid.

61-90 days past due: Call. Do not email. A phone call converts at a much higher rate than email at this stage. Have the invoice number and amount ready. Ask directly: "Can you process this today or do you need to set up a payment plan?"

90+ days: Escalate. Options in order of preference: offer a structured payment plan (better to get paid over 3 months than not at all), add a collection fee if your contract allows it, engage a collections agency (they take a percentage, typically 20-40%, but something beats nothing), or write it off as a bad debt and adjust your credit policy going forward.

What to Do With the Data Going Forward

Calculate your AR days monthly: (AR balance divided by monthly revenue) multiplied by 30. This gives you the average number of days it takes to collect cash after you invoice.

If your AR days are above 45, your collection process needs tightening. Industry benchmarks for professional services businesses are typically 30-45 days. Above 60 days means you are essentially lending money to your clients interest-free for two months.

Three levers that improve AR days:

Shorter payment terms. Net 15 instead of net 30 cuts your average collection time significantly. Add a 2% early payment discount and many clients will pay within 10 days to capture the savings.

Upfront deposits. For new clients or project work, require 25-50% before you start. This is standard practice in most service industries and it eliminates most of the collection risk on new relationships.

Automated reminders. QuickBooks and most accounting software can send automatic payment reminders at 7 days before due, on the due date, and 7 days after. Turn this on if it is not already running. It removes the awkwardness of manual follow-up and it works.

The AR aging report takes five minutes to review. If you run it on the first Monday of every month alongside your P&L and Balance Sheet, you will catch collection problems before they become cash crises. If you want a simple collections follow-up workflow built for your business, book a call.

Next step: run your numbers through the free CFO scorecard.