How to Read an A/R Aging Report Like an Owner (Not a Bookkeeper)

Disclaimer: The information on this website (including all examples, explanations, and content) is for general informational purposes only and should not be considered tax, legal, or financial advice. Always consult with a qualified professional about your specific situation.

What an A/R Aging Report Actually Tells You

Most practice owners receive an accounts receivable aging report from their bookkeeper or practice management system every month. Most of them glance at the total and move on. That is a missed opportunity, because the A/R aging is one of the most useful single reports a small business owner has access to. It tells you exactly where the cash is, how long it has been sitting there, and which clients (or insurance companies, or carriers) need a phone call.

This guide walks through how to read an A/R aging report from an owner's perspective. Not from a bookkeeper's perspective (which is mostly about correctness) but from an owner's perspective (which is about decision making and cash recovery).

This post complements our broader profit but no cash post and the niche cash flow posts for dental, medical, veterinary, med spa, chiropractic, pharmacy, law firm, and insurance agency practices.

What the Report Actually Is

An A/R aging report is a list of every unpaid receivable broken into time buckets based on how long the receivable has been outstanding.

The standard buckets are:

• Current (also called 0 to 30 days): invoices billed in the last 30 days that are not yet overdue
• 31 to 60 days: invoices that are past due but still in the early aging stage
• 61 to 90 days: invoices that are getting old enough to require active attention
• Over 90 days: invoices that are far past due and may or may not collect

Some practice management systems use slightly different buckets (1 to 30, 31 to 60, 61 to 90, 91 to 120, over 120). The principle is the same.

Each row of the report is a client (or an insurance company, or a carrier, depending on what kind of receivable you are tracking). The total of each row is what that client owes you. The columns tell you how old each piece of the balance is.

What Each Bucket Means

The buckets are not just time periods. Each one tells a different story about the receivable.

Current (0 to 30 Days)

This is normal. Every business has receivables in this bucket. The invoices are recent. The customer (or payor) has not had time to pay yet.

The number to watch in this bucket is whether it makes sense relative to your monthly billing volume. If you bill $200,000 per month and your current bucket is $180,000, that is normal. If you bill $200,000 per month and your current bucket is $400,000, something is wrong upstream (either the billing is happening but not arriving with the customer, or the customer is sitting on invoices without paying).

31 to 60 Days

This is where invoices start to need active attention. Most clients who pay within 60 days were going to pay. Most clients who hit 60 days without paying are either having internal issues (cash flow problems of their own, missed the invoice, dispute over the work) or have started the pattern of slow paying.

The right action on this bucket is a polite follow up call or a second statement. Not collections. Not a threat. Just a check in.

61 to 90 Days

This is the bucket where the receivable starts to feel real. Customers who hit 90 days without paying are giving you a signal. Either they cannot pay, they will not pay, or they are testing whether you will follow up. All three require a response.

The right action on this bucket is a direct conversation with the customer. Not an email. Not a statement. A phone call where you confirm they received the invoice, ask whether there is a dispute or issue, and agree on a payment timeline.

Over 90 Days

This is the bucket that needs the hardest decisions. Customers in this bucket fall into a few categories:

• Real dispute: the customer disagrees with the bill and has not been engaged on it. Resolution requires direct work.
• Cannot pay: the customer is genuinely struggling and may need a payment plan or partial settlement
• Will not pay: the customer has decided not to pay and is hoping you give up
• Forgot or lost the invoice: rare, but it happens

The right action on this bucket is decisive. Payment plan, partial settlement, send to collections, or write off. Letting balances sit in this bucket indefinitely produces nothing.

What "Normal" Looks Like

Normal A/R aging depends on the business and the payor mix.

Hourly Billing Practices (Law Firms, Most Professional Services)

• Current bucket: 80 to 90% of total A/R
• 31 to 60: 5 to 10%
• 61 to 90: under 5%
• Over 90: under 5%

If the over 90 bucket is growing past 5 to 10% of total A/R, the firm has a collection problem.

Insurance Billed Practices (Dental, Medical, Vet, Chiropractic)

• Current bucket: 50 to 70% of total A/R
• 31 to 60: 15 to 25%
• 61 to 90: 5 to 15%
• Over 90: 5 to 15%

Insurance billed practices have inherently slower A/R because of the EOB and adjudication cycle. Over 90 day balances are often denied claims that have not been worked. A growing over 90 bucket is a sign the denial process is broken.

Cash Pay Practices

• Current bucket: 90%+
• Everything else: under 10% total

Cash pay practices should have very little aging. If they have meaningful aged A/R, the front desk is not collecting at the time of service.

Insurance Agencies

• The "A/R" for agencies is usually carrier receivables, not client receivables
• Aging patterns depend on carrier remittance schedules
• Over 60 day carrier receivables usually indicate reconciliation issues, not collection issues

What to Look at First on Any Aging Report

Two things, in this order:

1. The over 90 day bucket as a percentage of total A/R. This tells you whether you have a collection problem.
2. The largest balances in the 61 to 90 and over 90 buckets. These are the specific customers or payors that need your attention right now.

Most practice management systems and accounting software let you sort the aging report by balance. Sort it by over 90 day balance, descending. The top of that list is your priority call list for the week.

Common Mistakes Owners Make With A/R Aging

Looking at Total A/R Without Looking at Aging

The total receivable balance is not the most useful number on the report. A practice with $200,000 of A/R that is 85% current is in a different position than a practice with $200,000 of A/R that is 50% over 90 days. The total is the same. The cash recovery picture is very different.

Treating All Aged A/R as Recoverable

Once a receivable is past 90 days, the probability of full collection drops significantly. Past 120 days, it drops more. Past 6 months, you are often looking at partial settlement or write off, not full recovery.

Pretending that every aged receivable will eventually collect produces unrealistic cash forecasts and bookkeeping that overstates the practice's financial position.

Working A/R Without a System

A/R does not collect itself. Statements help, but they are not enough. A system that includes statements, follow up calls, payment plans for customers who cannot pay in full, and escalation to collections or write off for customers who will not pay is what actually recovers cash.

Most practices that have A/R problems do not have a collection problem. They have a system problem.

Ignoring the Insurance or Carrier Side

For insurance billed practices and agencies, the insurance receivable is often larger than the patient or client receivable. The same aging principles apply. Aged insurance claims are denied claims that need to be worked.

Letting Old Balances Sit Indefinitely

Every aging report should have an action plan for balances over 90 days. Send to collections, set up payment plan, write off as bad debt. Doing nothing produces a balance sheet that looks healthier than it actually is and produces no cash.

Frequently Asked Questions

What is a "good" A/R turnover?

Days in A/R (total A/R divided by average daily billing) is the standard metric. For most practices, 30 to 45 days is healthy, 45 to 60 days is acceptable, over 60 days is a warning. Insurance billed practices benchmark higher.

Should I write off aged balances?

If a balance is over 6 to 12 months old and you have made reasonable collection efforts, yes. Writing it off cleans up the balance sheet and (for accrual basis taxpayers) produces a bad debt deduction.

Should I send to collections?

Depends on the balance, the cost of collections, and the relationship. Most collection agencies take a percentage of recovery. The economics work better on larger balances.

Will pursuing collections damage my customer relationships?

Sometimes. Most customers who get sent to collections were not going to remain customers anyway. The relationship damage from chasing payment is often smaller than owners fear.

How often should I work A/R?

Weekly. Statements monthly. Follow up calls weekly on the 61 to 90 and over 90 buckets. Daily is overkill for most practices.

What is the right level of staff time to spend on A/R?

Enough to keep the over 90 bucket from growing. The exact hours depend on practice size and payor mix.

Reading the Aging Report Like an Owner

The A/R aging report is one of the few reports where five minutes of focused attention each week can produce real cash. Look at the bucket distribution. Look at the largest aged balances. Make a call list. Work it.

The practices that consistently have cash on hand are not the ones with the biggest books. They are the ones that read the aging report every week and act on it.

We work with practice owners across Quinlan, Hunt County, Rockwall, Kaufman, and the greater Dallas area on bookkeeping, A/R management, and cash flow reporting that makes the aging report actually useful.

Tired of A/R that just sits there? Contact us here to talk about getting your books and A/R reporting set up so you can see what to collect, when to collect it, and what to write off.