AR aging report

What an AR aging report is

An AR aging report is a standard revenue cycle report that lists open accounts receivable and groups them by age. The age is calculated from the date of service or claim date, depending on how the practice management or billing system is configured.

Columns usually include payer, patient, service dates, total AR, and amounts in each aging bucket. Reports can be run for insurance-only AR, patient-only AR, or combined, and can be summarized at the payer, location, program, or rendering provider level.

For behavioral health, an AR aging report often includes large per-diem balances for residential, PHP, and IOP, plus separate carve-out behavioral health payers and Medicaid managed care plans that have very different payment timelines.

Why AR aging matters operationally

AR aging is the early warning system for cash flow. A growing 60-90 or 90+ day bucket usually means claims are stuck in rework, sitting in concurrent review, tied up in authorization or medical necessity denials, or never sent correctly in the first place.

Leadership uses AR aging to see where cash is trapped: specific payers, programs, or locations. Collectors use it to create daily worklists and decide what to call on first. Finance uses it to estimate bad debt and decide when to move balances to collections or write-off.

In behavioral health, long-stay episodes and per-diem contracts can hide real problems. A residential claim might sit in the 31-60 bucket only because billing waited for discharge to bill the full stay. Without reading the AR aging report correctly, a center can miss that Medicaid MCO or a carve-out vendor systematically pushes BH claims past 60 days, which quietly starves cash for payroll and rent.

How to read and use an AR aging report

Operators usually slice AR aging in a few common ways:

• By payer: to see which plans or BH carve-outs are driving the oldest balances.
• By financial class: commercial, Medicare, Medicaid, self-pay, state or county contracts.
• By program or level of care: outpatient therapy, IOP, PHP, residential, withdrawal management.
• By balance type: insurance-responsibility vs patient-responsibility.

A practical review routine looks like this:

• Scan total AR and the percent over 90 days. If the 90+ bucket is creeping up, cash risk is growing.
• Drill into the biggest 90+ payers and programs. Look for patterns: same denial codes, missing authorizations, carve-out vendors, or specific Medicaid MCOs.
• Separate true denials from unresolved claims. Use remittance data and clearinghouse status to distinguish claims that need appeals from claims that were never received, rejected, or held for concurrent review.
• Identify patient-responsibility balances sitting in 60+ days that should either be in an active payment plan, referred to collections, or moved to bad-debt write-off per policy.

Most high-performing teams pair the AR aging report with detailed denial reports, days in AR, and write-off tracking. In behavioral health, it is also important to cross check aging against authorization spans and continued stay reviews so units past the auth are not quietly aging into write-offs.

• Reviewing a combined AR aging report without separating insurance AR from patient AR, which hides the fact that most 90+ balances are small patient co-pays that should be in payment plans, while large unpaid PHP or residential claims sit untouched in the 30-60 bucket.
• Letting claims with CO-197 or CO-50 denials age in the 60-90 bucket while waiting on clinical staff, instead of flagging those balances immediately for peer-to-peer review or retro auth requests before timely appeal limits hit.
• Not segmenting AR aging by behavioral health carve-out payer or Medicaid MCO, so slow-paying BH vendors look diluted in the overall payer mix and recurring authorization or medical necessity issues never get escalated or re-contracted.
• Including obvious contractual write-offs in AR aging, such as known per-diem rate differences for residential treatment, which inflates AR, distorts days in AR, and makes the billing team look less effective than it actually is.
• Ignoring credit balances and negative AR on the aging report, which can signal duplicate payments on bundled OTP or IOP codes, incorrect COB posting, or overpayments that will later trigger recoupments and audit attention.

Behavioral health AR aging behaves differently from a primary care practice, mainly because of long episodes, per-diem billing, and carve-outs. A single residential stay can create a large balance that hits AR only at discharge, so aging from service date can make AR look older than operationally reasonable, while aging from claim date can hide long billing delays.

Carve-out behavioral health payers and Medicaid managed care plans often have slower adjudication cycles and strict concurrent review processes. If AR aging is not sliced by payer and program, units delivered past the last approved auth date quietly age into the 60-90 bucket and then into write-offs. You see this with PHP and IOP where continued-stay reviews were missed or denied, but the balances sit in AR as if they were collectible.

State and county substance use contracts and OTP bundled payments add another layer. Claims may not follow standard 30-day commercial cycles, so an AR aging report that uses generic thresholds can make state-funded programs look like chronic underperformers. Behavioral health leaders need AR aging views by funding source, level of care, and authorization status to know whether old AR is collectible, under appeal, or effectively charity-care or bad debt.

AI can help with AR aging by reading every 835 remittance and 277 status update, then tagging open balances with the right denial codes, status, and next-step action. An agent can continuously re-aggregate that data into payer and program level aging views, highlight spikes in 60-90 and 90+ day buckets, and auto-build worklists that prioritize high-dollar residential or PHP balances that are at risk of aging out of appeal or timely filing windows.

Supabill's agents can ingest your AR aging extract, match each line to remittances and clearinghouse data, and classify balances by root cause, such as authorization issues, coordination of benefits, or missing documentation. A denials agent can call out patterns like CO-16 or CO-197 driving the 90+ bucket for a specific Medicaid MCO, while a claims-scrubbing agent reduces future aging by catching errors before submission. A human still has to set collection policies, decide which old balances to pursue versus write off, and handle payer escalations and peer-to-peer reviews where judgment and relationships matter.

How often should an AR aging report be run for a behavioral health practice or facility?

At minimum, run a detailed AR aging report monthly for leadership and weekly for the billing team. High-volume outpatient or multi-site behavioral health organizations usually benefit from a daily insurance-aging snapshot so denial spikes or payment delays from a key payer do not sit for weeks before anyone notices.

What aging buckets are standard on an AR aging report?

Most systems default to 0-30, 31-60, 61-90, and 91+ days, but many behavioral health teams add a 121+ or 180+ bucket to highlight balances that are realistically uncollectible. Some also break out a separate bucket for not-yet-billed charges in long residential or PHP stays so those do not skew insurance AR metrics.

Should small patient balances be included on the AR aging report?

Yes, but they should be visible as a separate low-balance segment with clear rules for when to collect, combine, or write off. Many behavioral health programs focus billing staff on higher-dollar insurance and patient balances first, especially for residential and IOP, while using automated statements or payment plans for low-dollar outpatient therapy balances.

What is the difference between an AR aging report and days in AR?

An AR aging report is a snapshot that shows how much money is outstanding in each age bucket on a given date. Days in AR is a performance metric that summarizes how quickly you collect overall, often used by finance and leadership for benchmarking. They use the same underlying AR data but answer different questions.

How should credit balances appear on an AR aging report?

Credit balances often show as negative amounts and should usually be summarized separately from positive AR. Consistent review of credits helps catch duplicate payments, posting errors, and overpayments that may need refunds or could trigger payer recoupments if ignored.

• HFMA: Revenue Cycle