Key Takeaways

• Your aged receivables report shows every unpaid invoice sorted by how long it has been outstanding. It is available in QuickBooks Online (QBO), Xero, and most accounting software.
• Total AR should be around two to four weeks of monthly revenue. If it exceeds one month's revenue, you are carrying too much.
• Invoices over 90 days old have less than a 70% chance of being collected. Act before you hit that threshold.
• The 60+ day column is your priority. Anything there needs a phone call or formal notice, not an email.
• Review this report every week. The most common reason invoices age out is that nobody followed up.

How to Read Your Aged Receivables Report

You've sent the invoices. The work is done. But the money isn't in your account yet. That gap between "earned" and "collected" is where a lot of small businesses get into trouble, and your aged receivables report is the tool that shows you exactly how big that gap is.

If you've never looked at this report (or you glance at it and move on), this guide will show you what it's telling you and what to do about it.

What the Aged Receivables Report Is

The aged receivables report (also called the AR aging report) lists every unpaid invoice your business has outstanding, organized by how long each one has been unpaid. It's a snapshot of all the money owed to you, sorted by age.

Most accounting software (QBO, Xero, FreshBooks) generates this report automatically. You just need to know where to find it and how to read it.

The Columns That Matter

A standard AR aging report has these columns:

• Customer name. Who owes you money.
• Invoice number and date. Which invoice, and when it was issued.
• Total amount due. How much they owe.
• Current. Invoices that aren't past due yet. These are within your payment terms (for example, Net 30 means the invoice was sent less than 30 days ago).
• 1 to 30 days past due. The invoice is overdue, but only recently. This is normal. Many businesses pay a few days late.
• 31 to 60 days past due. This is the warning zone. The client either forgot, is having cash flow issues, or is deprioritizing your invoice. Action is needed.
• 61 to 90 days past due. This is a problem. The older an invoice gets, the less likely you are to collect it. Industry data suggests that invoices over 90 days old have less than a 70% chance of being collected.
• Over 90 days past due. This is critical. These invoices need immediate, direct action or a decision about whether to write them off.
• Total. The sum across all aging buckets for each customer, and a grand total at the bottom.

How to Read It

Don't just look at the total amount owed. The age distribution is what matters.

Start with the total. How much money is outstanding right now? Compare this to your monthly revenue. If your total receivables are more than one month's revenue, you're carrying too much. For most service businesses, total AR should be around two to four weeks of revenue.

Look at the 60+ day column. This is your priority. Any amount here is at risk. Add up everything in the 61-90 and 90+ columns. That's the money most likely to become a problem.

Identify repeat offenders. Is the same customer showing up in the 30+ or 60+ columns every month? That's a pattern, not a one-time issue. This client needs different payment terms, upfront deposits, or a conversation about whether the relationship is worth maintaining.

Check the concentration. If one client represents more than 25% of your total receivables, that's a risk regardless of age. If that client pays late or disputes the invoice, it creates a disproportionate impact on your cash flow.

What Each Aging Bucket Tells You

Current: everything is fine. No action needed beyond normal follow-up.

1 to 30 days past due: send a friendly reminder. Most of these are administrative delays. An email is usually enough. Keep it short: "Just following up on invoice #1234, which was due on [date]. Let me know if you have any questions."

31 to 60 days past due: this needs a phone call, not just an email. Emails are easy to ignore. A direct conversation gets answers. Ask when payment will be made. If the client is having cash flow issues, discuss a payment plan now rather than waiting for the invoice to age further.

61 to 90 days past due: escalate. This is now a collections issue. Send a formal written notice referencing the invoice, the original terms, and the overdue period. If you have a contract, reference the late payment terms. Consider whether to pause any ongoing work for this client until the balance is cleared.

Over 90 days past due: decision time. You have three options: pursue collections (internal or through an agency), negotiate a settlement for a reduced amount, or write it off as bad debt. The longer you wait past 90 days, the lower your chances of collecting. Make a decision and act on it.

The Actions That Actually Move the Needle

Knowing what the report says is step one. Here's what to do with that information.

• Set a weekly AR review. Every week (or at minimum, every two weeks), pull the report and act on anything in the 30+ day columns. The most common reason invoices age out is that nobody followed up.
• Tighten your payment terms for slow payers. If a client consistently pays at 45 days on Net 30 terms, either adjust your terms to Net 15 (so they effectively pay at Net 30) or require deposits on future work. You're running a business, not a lending service.
• Invoice immediately. Don't wait until month-end to send invoices. The clock starts when the invoice is sent, not when the work is done. Every day you delay invoicing is a day added to your collection timeline.
• Offer early payment incentives. A 2% discount for payment within 10 days (written as "2/10 Net 30") costs you less than the cash flow gap of waiting 45 or 60 days. For larger invoices, this is often worth it.
• Require deposits on new projects. For project-based work, a 25% to 50% deposit upfront changes the dynamic completely. You've already collected a portion, and the client has financial commitment to the project.

The Mistake in One Sentence

Sending invoices and waiting, without a system for tracking who is late, by how much, and for how long.

When to Worry

Pull the report right now. If any of these are true, you need to act this week:

• Your total AR is more than six weeks of revenue. You're effectively lending too much money to your clients. Tighten terms and accelerate follow-up.
• More than 20% of your AR is in the 60+ day column. A significant portion of your outstanding money is at risk. Prioritize collection on these accounts immediately.
• One client represents more than 30% of your total AR. This is a concentration risk. If that client doesn't pay, the impact is severe. Diversify your client base and tighten terms with this client.
• You have invoices over 90 days that you haven't addressed. Every week that passes reduces your chances of collecting. Make the call or make the write-off decision. Waiting is the worst option.

Quick Checklist

• Do you know your total outstanding AR right now?
• Have you checked the 60+ day column in the last two weeks?
• Do you have a weekly calendar reminder to review your AR aging report?
• Have you addressed every invoice over 90 days (either follow-up, collections, or write-off)?
• Do you require deposits on project-based work over $2,500?

If you answered "no" to two or more of these, your AR process has gaps worth fixing now.

Why It Matters

The gap between "earned" and "collected" is a cash flow problem. Late receivables don't just delay cash. They create a chain reaction: you delay paying suppliers, rely more on your line of credit, and make decisions based on what's in your bank account instead of what's owed to you.

A consistent AR review habit is the simplest way to close that gap before it becomes a crisis.

What to Do Next

Open your accounting software and pull the aged receivables report. Look at the 60+ column first. If there's money there, pick up the phone this week. Then set a recurring calendar reminder to review this report every Monday or Friday.

If your AR is consistently high and you're not sure how to fix the pattern, that's a process problem worth solving before it turns into a cash flow crisis.

Book an initial consult with Mesa CPA.