AR Aging Report: Read It, Run It, Collect Every Bucket

Key takeaways

• An AR aging report groups unpaid invoices by days outstanding to show exactly which payer or patient balances to chase first.
• Most dollars should sit in the current bucket, with each older bucket shrinking; a growing 90+ share signals upstream revenue cycle problems.
• Run the A/R Aging Summary in QuickBooks using the Days Overdue method, and filter by customer type to separate payer and patient balances.
• Triage 90+ day balances weekly by appealing valid payer denials before timely filing deadlines close, and moving patient balances to payment plans.
• Track five metrics monthly: percentage in each bucket, days in AR, collection rate, denial rate, and 90+ as a share of total AR.

An AR aging report sorts every unpaid invoice by how long it has been outstanding, grouped into buckets of current, 30, 60, 90, and 120+ days. Read it correctly and it tells you exactly which payer or patient balances to chase first, which claims are quietly rotting past filing deadlines, and how much of your collected revenue is sitting in someone else's bank account.

What is an AR aging report and what is it used for?

An AR aging report shows every unpaid patient and payer balance in your practice, grouped by how long each invoice has been outstanding: current, 30, 60, and 90+ days. It answers one question fast: where is your money stuck, and for how long?

What an AR aging report is used to do in a neurology practice

For a neurologist-owner carrying the P&L, the report does three jobs. It shows which payers pay slowly, so you can see whether your payer mix is quietly extending your AR. It flags old balances before they become uncollectible, which matters because the older a claim sits, the lower your odds of collecting it. And it gives your billing lead a worklist: which accounts to call, appeal, or write off this month.

You can generate one in minutes using QuickBooks' built-in A/R Aging Summary, which Intuit documents in its official help guide: run an A/R Aging Summary report in QuickBooks. Pairing that report with the revenue-cycle side of your billing, including denial and prior-authorization patterns, is where tools like Scryber's neurology billing workflows come in.

How do you read the aging buckets (current, 30, 60, 90+)?

An AR aging report sorts every unpaid invoice into four buckets by days since the invoice date. In a healthy medical practice, most dollars sit in Current, and each older bucket shrinks.

Current and 1-30 days

This is normal cycle time. Payers take 14-30 days on clean claims, so patient balances and recent payer claims belong here. If most of your AR is in this bucket, your revenue cycle is working.

31-60 days

Balances here usually mean a slow payer or a claim missing information. A follow-up call this week still resolves most of it.

61-90 days

This is where denial and appeal problems surface. Incorrect E&M levels, missing documentation of localization or cranial nerve findings, and prior authorization gaps push claims here (see https://www.scryber.ai/neurology-cpt-coding for the coding side).

90+ days

In a practice, 90+ balances are rarely forgetful patients. They are payer denials awaiting appeal, or balances you may need to write off.

What does an AR aging report look like? (worked example)

Sample report: three-provider neurology group

Here's a filled-in AR aging report for a hypothetical three-neurologist group, as it would print from QuickBooks. Total outstanding: $412,000.

• Current: $148,000 — mostly patient copays from this month's visits and two EEG batches billed last week.
• 1–30 days: $96,000 — infusion claims awaiting payer adjudication, plus one payer with a 21-day clearinghouse lag.
• 31–60 days: $71,000 — EEG batches from six weeks ago and a stack of claims held for prior authorization.
• 61–90 days: $52,000 — a denial cluster from one commercial payer, resubmitted but unconfirmed.
• Over 90: $45,000 — aged patient balances and two workers' comp claims nobody has chased.

How to read the rows

Each row tells you where your collections process breaks. Current and 1–30 are normal payer lag. The 31–60 bucket is usually prior auth stalls or slow batch submission; the 61–90 bucket is where denials surface if you're not reworking them weekly. MGMA benchmarks suggest high-performing physician practices keep days in AR near or under industry targets, with minimal balances past 90 days (see MGMA's revenue cycle resources). In this sample, 23% sits over 90 days, which is the line to fix first. Infusion claims aging past 60 days often trace to incomplete units or missing start/stop times, which is where neurology infusion billing errors typically start.

How do you run an AR aging report in QuickBooks?

QuickBooks Online steps

Go to Reports, search for "Accounts Receivable Aging Summary," and set the report date to today or your month-end close date. Choose "Days Overdue" as the aging method so buckets reflect how late each invoice actually is, not the invoice date. Run "Aging Detail" instead of "Summary" when you want invoice-level rows to work collections from.

QuickBooks Desktop steps

Open Reports, then Customers & Receivables, then A/R Aging Summary. Set the "As of" date to your close date and confirm the aging method is by due date. The Detail version under the same menu gives you per-invoice rows for your collection calls.

Filtering payers from patients

If you bill payers and patients in the same file, tag each invoice with a customer type (payer name versus "Patient") or use separate jobs under each customer. Then filter the report by that field so insurance AR and patient-responsibility AR never blend. A $4,200 balance sitting in 90+ means something different when the payer owes it than when the patient does, and your collection emails should differ accordingly. If you want the clinical documentation side handled so you can spend that recovered time on AR, Scryber offers a 60-Day Free Trial — Then $85/month per user (https://www.scryber.ai/pricing).

How do you act on each aging bucket?

Each bucket gets a different touch. Current and 1–30 day balances need a reminder, not pressure. 31–60 needs a firmer nudge with a specific amount and due date. 61–90 needs a phone call and a payment plan. 90+ needs triage: it is either a denial you can appeal or money you are about to lose.

The 90+ bucket deserves the long look. Before you write anything off, separate payer balances from patient balances, because they fail for different reasons. Payer claims at 90 days are usually denials or timely filing problems, and most commercial and Medicare contracts set filing deadlines of 90 to 180 days from the date of service, so a denied claim sitting in this bucket is a claim approaching zero value (CMS timely filing guidance). Pull the denial reason, fix the root cause, whether it was a missing prior authorization or a bad payer ID, and resubmit before the deadline closes.

Patient balances at 90+ respond to a short payment plan offer, not a fourth email. Track which bucket each dollar lands in after your intervention, because that tells you whether the leak is in your front office, your coding, or your collections. The same logic applies upstream: documentation that supports the E&M level you billed is what keeps claims out of the 90+ bucket in the first place, which is why we built Scryber's terms of service around accurate, defensible notes rather than volume.

Collection email template for 1-30 days

Subject: Invoice #____ from [Practice Name]

Hi [First name], a quick reminder that invoice #____ for $____ was due on ____. You can pay online at [link] or call us at ____. Thanks for your care with this.

Collection email template for 31-60 days

Subject: Second notice: Invoice #____ ($____)

Hi [First name], invoice #____ for $____ is now past due. Please pay by ____ or reply to this email if something is wrong with the claim or you need different arrangements.

Collection email template for 61-90 days

Subject: Invoice #____ — please call us this week

Hi [First name], we have not received payment for invoice #____ ($____), now 60+ days past due. Please call ____ so we can set up a payment plan or resolve any issue with the claim.

What to do with 90+ balances

Run triage weekly, not monthly. Appeal valid payer denials, escalate timely filing exceptions immediately, and move remaining patient balances to a documented plan or collections decision.

What causes invoices to age and how do you prevent it?

Charge capture lag

Encounters billed days or weeks late hit payer filing deadlines and lose appeal windows. Close the gap by reconciling your schedule against charges every Friday, so no visit leaves the week unbillable. A scribe that finishes the SOAP note before you leave the exam room removes the usual bottleneck: the note waiting on you at night.

Documentation that does not support the code

If your note documents a detailed history but skips localization, cranial nerve findings, or the longitudinal disease tracking that justifies a higher E&M level, the claim gets downcoded or denied, and the balance ages. Prevention is documentation completeness at the point of care, not a scramble before billing. Tools built for neurology workflows, including Scryber, aim to capture exam detail that supports the level billed; a general scribe may not prompt for it.

Prior authorization and eligibility gaps

An infusion or EEG done without a valid auth becomes a self-pay balance that ages fast. Verify eligibility and auth status at scheduling, not the day of service, and recheck for recurring visits when the auth has visit limits.

Which AR aging metrics should you track monthly?

Pull five numbers on the first of each month, in this order:

1. Percentage in each bucket. Healthy small practices keep current plus 1-30 at roughly 70-80% of total AR and 90+ under 15%.
2. Days in AR. Total receivables divided by average daily charges. Under 35 days is strong for a 1-10 provider group; over 45 means follow-up is slipping.
3. Collection rate. Payments received divided by charges, adjusted for your contracted rates. Watch the trend, not one month.
4. Denial rate. Initial denials divided by claims submitted. Industry surveys put average denial rates near 10-12% (American Medical Association), and neurology's prior authorization volume pushes some practices higher.
5. 90+ as a share of total AR. This is your write-off forecast. If it grows two months running, fix the front end before you chase old balances.

Log all five in one spreadsheet row per month so trends are visible at a glance.

Where does an AR aging report fit in your revenue cycle?

The AR aging report is the last checkpoint, not the fix. Most invoices that land in the 60 and 90+ buckets were born upstream: a missing cranial nerve finding that drops your E&M level, an unclear localization statement, or a SOAP note that leaves the payer room to deny.

Cleaner documentation at the encounter means the claim goes out at the correct level the first time, which lowers your denial rate and shrinks the buckets before they fill. That is the logic behind Scryber: capture the neurological exam accurately, support the code, and track the patient longitudinally, so the aging report you run in QuickBooks shows less to collect.

FAQ

What is an AR aging report?

It lists every unpaid invoice grouped by how long it has been outstanding, typically in buckets of current, 30, 60, and 90+ days. In a practice it shows where money is stuck: which payers pay slowly, which claims are aging toward uncollectible, and which patient balances need a payment plan rather than another reminder email.

How do I run an AR aging report in QuickBooks?

In QuickBooks Online, go to Reports and search Accounts Receivable Aging Summary, then set the report date to today or your close date and use Days Overdue as the aging method. In Desktop, open Reports, then Customers & Receivables, then A/R Aging Summary. Use the Aging Detail version when you want invoice-level rows for collection calls.

What is a healthy AR aging distribution for a medical practice?

Most dollars should sit in the current bucket, with each older bucket shrinking. A reasonable target is 60-75% in current, 15-25% in the 31-60 day bucket, under 10% at 61-90, and under 5% past 90 days. If your 90+ share keeps growing month over month, the problem is upstream in your revenue cycle.

Is there an AR aging report template I can copy?

QuickBooks generates the report itself, so the practical template is a tracking sheet: log five numbers monthly, one spreadsheet row per month. Record the percentage in each bucket, days in AR, collection rate, denial rate, and 90+ as a share of total AR. Watching those five columns trend is what turns the report into action.

What does 90+ days in AR mean?

Balances past 90 days are rarely forgetful patients. They are usually payer denials awaiting appeal or claims approaching timely filing deadlines, since most commercial and Medicare contracts allow 90 to 180 days from the date of service. Triage this bucket weekly: appeal valid denials, escalate filing exceptions, and move remaining patient balances to a documented plan.