Study guide
5.1 Accounts Receivable Management, Aging Buckets & Days in AR Benchmarks
AAPC Certified Physician Practice Manager CPPM
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: The CPPM Exam, Blueprint & Study Strategy
1.1 CPPM Exam Format, Scoring & the 15-Area Blueprint
2 Chapter 2: Healthcare Business Operations and Patient Workflow
2.1 Types of Medical Practices & Organizational Governance 2.2 Patient Intake, Registration, Scheduling & Office Triage Workflows 2.3 Clinical Flow Optimization & Patient Care Coordination 2.4 Leadership, Management Functions & Effective Communication
3 Chapter 3: Revenue Cycle Management: Front-End & Charge Capture
3.1 Insurance Verification, Eligibility & Prior Authorization 3.2 Patient Financial Counseling & Point-of-Service Collections 3.3 Charge Capture Protocols, Superbills & Encounter Documentation
4 Chapter 4: Claims Processing, Clearinghouse & Denial Management
4.1 Electronic Claims Submission, EDI Transactions & Clearinghouse Edits 4.2 Claim Adjudication, Remittance Advice & Payment Posting 4.3 Denial Management Strategies, Appeals Process & Root Cause Tracking
5 Chapter 5: Accounts Receivable, Billing & Patient Collections
5.1 Accounts Receivable Management, Aging Buckets & Days in AR Benchmarks 5.2 Patient Statements, Payment Plans & Credit Balance Resolution 5.3 Collections Management, Bad Debt Write-Offs & FDCPA Compliance
6 Chapter 6: Principles of Physician Reimbursement
6.1 Commercial Payers, Managed Care Models & Contract Management 6.2 Government Payers: Medicare, Medicaid & TRICARE 6.3 RBRVS, Relative Value Units (RVUs) & Conversion Factor Calculations
7 Chapter 7: Medical Coding Essentials & Alternative Payment Models
7.1 Managerial Overview of CPT, HCPCS Level II & ICD-10-CM Code Sets 7.2 E/M Documentation Guidelines, MDM & Coding Integrity 7.3 Value-Based Reimbursement, Capitation & Alternative Payment Models
8 Chapter 8: Healthcare Fraud, Abuse & Regulatory Statutes
8.1 The False Claims Act (FCA), Qui Tam & Civil Monetary Penalties 8.2 Anti-Kickback Statute (AKS) & Regulatory Safe Harbors 8.3 Physician Self-Referral Law (Stark Law) Exceptions & Enforcement 8.4 Malpractice, Risk Management, CLIA & EMTALA
9 Chapter 9: Corporate Compliance Programs & Medical Practice Audits
9.1 The OIG Seven Core Elements of an Effective Compliance Program 9.2 Internal Auditing, Baseline Reviews & Chart Sampling Methodologies 9.3 Compliance Investigations, Corrective Action Plans & Self-Disclosure
10 Chapter 10: Medical Office Accounting, Budgeting & Internal Controls
10.1 Medical Practice Financial Statements: Balance Sheet, P&L & Cash Flow 10.2 Cash vs. Accrual Accounting, Chart of Accounts, Accounts Payable & Internal Controls 10.3 Practice Budgeting Techniques & Variance Analysis
11 Chapter 11: Human Resource Management in the Medical Practice
11.1 Staff Recruitment, Job Descriptions, Credentialing & Onboarding 11.2 Federal Employment Laws (FLSA, FMLA, ADA, Title VII) & Workplace Safety 11.3 Performance Appraisals, Progressive Discipline & Staff Retention 11.4 Compensation, Benefits & Payroll Administration
12 Chapter 12: Space Planning, Facility Operations, Marketing & Business Relationships
12.1 Medical Office Space Planning, ADA Compliance & Ergonomics 12.2 Medical Equipment Procurement, Asset Management & Inventory Control 12.3 Ethical Healthcare Marketing, Patient Experience & Reputation Management 12.4 Strategic Planning, SWOT, Branding, Hospital Relationships & Negotiation
13 Chapter 13: HIPAA Privacy, Security & Patient Data Protection
13.1 HIPAA Privacy Rule: PHI, Notice of Privacy Practices & Minimum Necessary 13.2 HIPAA Security Rule: Administrative, Physical & Technical Safeguards 13.3 Breach Notification Rule, Risk Assessments, BAAs & OCR Enforcement
14 Chapter 14: Health Information Technology, EHR & Interoperability
14.1 Certified EHR Technology (CEHRT) Requirements & Implementation 14.2 Health Information Exchange, Interoperability & Cures Act Rules 14.3 Telehealth, Remote Patient Monitoring & E-Prescribing
15 Chapter 15: Healthcare Reform, Quality Improvement & Business Continuity
15.1 Healthcare Reform: ARRA, HITECH, the ACA & Accountable Care 15.2 MACRA & The Quality Payment Program: MIPS vs. Advanced APMs 15.3 Clinical Quality Improvement, CAHPS Patient Surveys & PDCA Methodology 15.4 Disaster Preparedness, Emergency Management & Business Continuity Planning
5.1 Accounts Receivable Management, Aging Buckets & Days in AR Benchmarks
Key Takeaways Explain This Topic AI
Accounts receivable (AR) aging buckets segment outstanding claims into 0–30, 31–60, 61–90, 91–120, and >120 day categories to track cash conversion velocity and overdue balances.
Days in AR measures the average time required to convert billed services into cash, with a target benchmark of 30 to 40 days, while metrics exceeding 50 days signal financial distress.
High-performing physician practices maintain less than 15% to 20% of total AR over 90 days and strictly under 10% over 120 days.
Segmenting AR by payer class (commercial, Medicare, Medicaid, self-pay) isolates root-cause processing backlogs and guides prioritized collector work queues based on balance size and timely filing limits.
The Net Collection Rate (target ≥95% to 98%) assesses actual revenue recovery against legally collectible dollars, providing a superior performance indicator compared to the Gross Collection Rate.
Last updated: September 2026
Accounts Receivable Management, Aging Buckets & Days in AR Benchmarks
In medical practice management, accounts receivable (AR) represents the total dollar amount owed to the medical group for healthcare services rendered to patients that have been billed but not yet collected. Whether owed by commercial health plans, government programs (Medicare and Medicaid), or patients directly as out-of-pocket cost-sharing, accounts receivable serves as the financial lifeblood of the clinical enterprise. Failing to actively monitor, manage, and collect receivables leads directly to cash-flow shortages, operational borrowing, and administrative insolvency.
A Certified Physician Practice Manager must deploy quantitative benchmarks and rigorous aging analysis to evaluate revenue cycle health. This section explores the operational mechanics of AR aging buckets, critical financial indicators such as Days in AR and Net Collection Rate, payer-specific aging variations, and the structure of high-efficiency collector work queues.
1. The Structure of Accounts Receivable Aging Buckets
Accounts receivable aging reports classify outstanding balances into standard chronological categories based on the elapsed time since the claim was submitted or the initial date of service (DOS). Aging reports provide practice leaders with an immediate snapshot of billing department velocity, payer processing delays, and delinquent accounts.
Industry standard aging reports organize outstanding balances into five standard aging buckets: +-------------------------------------------------------------------------------------------------+
- | ACCOUNTS RECEIVABLE AGING SPECTRUM |
- +-------------------+-------------------+-------------------+-------------------+-----------------+
- | 0 - 30 Days | 31 - 60 Days | 61 - 90 Days | 91 - 120 Days | > 120 Days |
- | Fresh Claims | First Adjudication| Payer Delays / | Serious Delays / | Distressed Debt |
- | In Adjudication | Secondary Billing| Appeals / Patient | Final Dunning | Pre-Collection |
- | | | Statement 1 & 2 | Pre-Collect Notice| Agency / Loss |
- +-------------------+-------------------+-------------------+-------------------+-----------------+
- | Benchmark: 50-60% | Benchmark: 15-25% | Benchmark: 10-15% | Benchmark: 5-8% | Benchmark: <10% |
- +-------------------+-------------------+-------------------+-------------------+-----------------+
- Operational Meaning of Aging Buckets
Aging Bucket Operational Status & Claim Milestone Managerial Action Trigger
0 – 30 Days Claims recently transmitted to the clearinghouse; in active adjudication with primary payers. Electronic remittances and payments are actively posting. Ensure clean claim submission rates exceed 95%; investigate any front-end clearinghouse rejections within 24 hours.
31 – 60 Days Payer adjudication lag; claims requiring simple data correction; secondary claims billed following primary crossover; initial patient statements mailed. Generate electronic claim status requests (EDI 276/277); identify payers exceeding standard 30-day prompt pay windows.
61 – 90 Days Complex denials under review; first-level appeals pending; secondary insurance delays; second patient statements dispatched with escalating dunning text. Initiate formal telephone follow-up with payer provider relations; review denial queues for common CARC/RARC patterns.
91 – 120 Days Serious operational distress; unworked denials; disputed coordination of benefits; third patient statements issued with urgent pre-collection warnings. Elevate to supervisory collector review; verify timely filing deadlines; offer structured patient payment arrangements.
> 120 Days Severely delinquent receivables; exhausted payer appeal limits; uncollectible self-pay accounts; imminent bad debt write-offs or agency referral. Conduct executive audit; determine final administrative write-off, third-party debt agency placement, or legal dismissal.
2. Calculating and Interpreting Days in Accounts Receivable
Days in Accounts Receivable (Days in AR) is the foundational key performance indicator (KPI) used to evaluate the overall velocity of a medical practice's revenue cycle. It quantifies the average number of days that elapse between the date a medical service is billed and the date payment is received and posted.
The Days in AR Formula
To calculate Days in AR, the practice manager first determines the Average Daily Gross Charges (ADC) , and then divides total outstanding accounts receivable by that daily charge figure: Step 1: Calculate Average Daily Charges (ADC)
- Total Gross Charges for Given Period (e.g., 90 or 365 Days)
- Average Daily Charges = -----------------------------------------------------------
- Number of Days in Period
Step 2: Calculate Days in AR
- Total Accounts Receivable (All Aging Buckets)
- Days in AR = ---------------------------------------------
- Average Daily Charges (ADC)
- Mathematical Demonstration
Consider a four-physician internal medicine group that generated $3,650,000 in gross charges over the preceding 365-day calendar year . The practice's current total accounts receivable balance across all aging buckets is $340,000 .
Calculate Average Daily Charges: ADC = $ 3 , 650 , 000 365 days = $ 10 , 000 per day \text{ADC} = \frac{\$3,650,000}{365 \text{ days}} = \$10,000 \text{ per day} ADC = 365 days $3 , 650 , 000 = $10 , 000 per day
Calculate Days in AR: Days in AR = $ 340 , 000 $ 10 , 000 per day = 34.0 days \text{Days in AR} = \frac{\$340,000}{\$10,000 \text{ per day}} = 34.0 \text{ days} Days in AR = $10 , 000 per day $340 , 000 = 34.0 days
Industry Benchmarks & Strategic Thresholds
High-Performing Benchmark: 30 to 40 days . A Days in AR figure within this range indicates an efficient revenue cycle characterized by high clean claim rates, prompt electronic remittance posting, and swift patient billing.
Warning Zone: 41 to 50 days . Indicates emerging backlogs, delayed claim submission lag, unworked clearinghouse rejections, or sluggish patient statement cycles.
Distress Threshold: > 50 days . Reflects severe operational breakdown. The practice is experiencing substantial cash flow delays, significant revenue cycle leakage, and an elevated probability of uncollectible bad debt.
Unusually Low Metrics (< 25 days): While seemingly positive, a Days in AR under 25 days often signals aggressive premature write-offs, delayed charge entry (under-reporting charges), or failure to capture full fee-schedule opportunities.
3. Aging Distribution Benchmarks & Payer Class Stratification
Calculating total Days in AR alone can mask underlying problems if a large portion of the balance is concentrated in aged categories. A practice might report 38 Days in AR, yet harbor an accumulating backlog of unpaid claims older than 90 days. Practice managers must evaluate the percentage distribution of receivables across aging categories .
Distribution Benchmarks Percentage of AR > 90 Days = ( Total AR Balance Older Than 90 Days Total Accounts Receivable Balance ) × 100 \text{Percentage of AR } > 90 \text{ Days} = \left( \frac{\text{Total AR Balance Older Than 90 Days}}{\text{Total Accounts Receivable Balance}} \right) \times 100 Percentage of AR > 90 Days = ( Total Accounts Receivable Balance Total AR Balance Older Than 90 Days ) × 100
Target Benchmark for AR > 90 Days: < 15% to 20% of total AR.
Target Benchmark for AR > 120 Days: < 10% (top-performing practices maintain < 5% to 8% ).
If more than 20% of a practice's total receivables exceed 90 days, immediate remedial intervention is required to prevent statutory timely filing deadlines from expiring.
Aging Analysis by Payer Category
Accounts receivable behavior varies widely by payer type. Practice management software must generate stratified aging reports categorized by payer classification: +---------------------------------------------------------------------------------------------------+
- | RECEIVABLES PERFORMANCE BY PAYER CLASS |
- +------------------------+--------------------------------------------------------------------------+
- | Payer Category | Operational Characteristics & Revenue Expectations |
- +------------------------+--------------------------------------------------------------------------+
- | **Commercial / HMO / | Expected adjudication within 14 to 30 days. Payer contracts dictate |
- | PPO Plans** | prompt-payment statutory interest for clean claims exceeding 30-45 days. |
- +------------------------+--------------------------------------------------------------------------+
- | **Medicare Part B** | Clean claims are paid within 30 days; the payment floor bars payment |
- | (Fee-for-Service) | before day 14 (electronic) or day 29 (paper). Little aging past 30 days.|
- +------------------------+--------------------------------------------------------------------------+
- | **Medicaid / Managed | High vulnerability to enrollment status changes, complex prior- |
- | Medicaid Plans** | authorization rules, and slower state disbursement schedules. |
- +------------------------+--------------------------------------------------------------------------+
- | **Self-Pay / Patient | Highest aging velocity. Without point-of-service collections, patient |
- | Balance** | balances rapidly migrate past 90 days, with recovery dropping sharply. |
- +------------------------+--------------------------------------------------------------------------+
- 4. Resolving Aged Payer Backlogs & Collector Work Queues
Managing an accounts receivable department requires transitioning billing personnel from passive, reactive task lists to structured, prioritized collector work queues. Common operational mistakes include having collectors work accounts chronologically (first-in, first-out) or alphabetically by patient surname.
Priority Queuing Strategy
Collector work queues should be algorithmically configured based on financial impact and risk: +-----------------------------------------------------------------------------------+
- | COLLECTOR WORK QUEUE PRIORITIZATION MATRIX |
- +-----------------------------------------------------------------------------------+
- | |
- | [ Tier 1: High Dollar / Approaching Timely Filing Limits ] |
- | Claims over $1,000 sitting at 60-90 days where payer filing limit is 90-120 days.|
- | | |
- | v |
- | [ Tier 2: Payer-Specific Batch Disputes & Edit Clusters ] |
- | Groupings of claims sharing identical CARC/RARC codes or clearinghouse edits. |
- | | |
- | v |
- | [ Tier 3: Mid-Value Aged Claims (61–90 Days) ] |
- | Moderate dollar balances ($250 - $1,000) with no activity for 30 days. |
- | | |
- | v |
- | [ Tier 4: Low-Balance Work Queue (< $50) / Automated Small-Balance Write-Off ] |
- | Automated rule-based resolution to eliminate disproportionate administrative labor.|
- | |
- +-----------------------------------------------------------------------------------+
- Dedicated Payer Blitz Projects
When a particular payer develops an aged backlog—often due to internal claim system migrations, unannounced policy updates, or contract disputes—the practice manager should organize a Payer Blitz . All aged claims for that specific payer identification number are extracted into a unified project file. A senior revenue cycle specialist contacts the payer's regional provider representative with a consolidated spreadsheet to resolve multiple claims simultaneously rather than placing individual phone calls.
5. Collection Performance Metrics: Gross vs. Net Collection Rate
A critical responsibility of the practice manager is measuring how effectively billed charges convert into real cash collections. Two distinct mathematical indicators are used across the healthcare industry: the Gross Collection Rate and the Net Collection Rate .
Gross Collection Rate (GCR)
The Gross Collection Rate reflects the raw percentage of gross billed charges collected, without adjusting for contractual discounts: Gross Collection Rate = ( Total Payments Received Total Gross Charges Billed ) × 100 \text{Gross Collection Rate} = \left( \frac{\text{Total Payments Received}}{\text{Total Gross Charges Billed}} \right) \times 100 Gross Collection Rate = ( Total Gross Charges Billed Total Payments Received ) × 100
Managerial Flaw of GCR: In modern healthcare, participating provider agreements mandate contractual write-offs that discount standard fee schedules by 40% to 60%. Consequently, a practice with a full fee schedule set at 250% of Medicare will show a deceptively low GCR (e.g., 40% to 50%), even if every single collectable dollar was successfully recovered. GCR is useful primarily for tracking fee schedule inflation over time, but is inadequate for assessing revenue cycle performance.
Net Collection Rate (NCR) / Adjusted Collection Rate
The Net Collection Rate (NCR) —also termed the Adjusted Collection Rate —is the gold standard revenue cycle KPI. It measures the percentage of legally collectable dollars that the practice actually collected after deducting mandatory contractual write-offs: Net Collection Rate (NCR) = ( Total Payments Received Total Gross Charges − Contractual Adjustments ) × 100 \text{Net Collection Rate (NCR)} = \left( \frac{\text{Total Payments Received}}{\text{Total Gross Charges} - \text{Contractual Adjustments}} \right) \times 100 Net Collection Rate (NCR) = ( Total Gross Charges − Contractual Adjustments Total Payments Received ) × 100
Target Benchmark: ≥ 95% to 98% .
Operational Interpretation: An NCR of 96% means that for every $100 the practice was legally and contractually entitled to receive from payers and patients, $96 was successfully collected, while $4 was lost to bad debt, uncollected patient balances, or administrative write-offs.
Warning Threshold: An NCR below 90% indicates severe revenue cycle leakage, unauthorized write-offs, or unworked claim denials.
Mathematical Comparison: GCR vs. NCR
A surgical practice reports the following monthly financial figures:
- Gross Billed Charges: $500,000
- Contractual Adjustments (CO-45): $220,000
- Total Payments Collected (Insurance + Patient): $266,000
Non-Contractual / Bad Debt Write-offs: $14,000 Gross Collection Rate = ( $ 266 , 000 $ 500 , 000 ) × 100 = 53.2 % \text{Gross Collection Rate} = \left( \frac{\$266,000}{\$500,000} \right) \times 100 = 53.2\% Gross Collection Rate = ( $500 , 000 $266 , 000 ) × 100 = 53.2% Net Collection Rate = ( $ 266 , 000 $ 500 , 000 − $ 220 , 000 ) × 100 = ( $ 266 , 000 $ 280 , 000 ) × 100 = 95.0 % \text{Net Collection Rate} = \left( \frac{\$266,000}{\$500,000 - \$220,000} \right) \times 100 = \left( \frac{\$266,000}{\$280,000} \right) \times 100 = 95.0\% Net Collection Rate = ( $500 , 000 − $220 , 000 $266 , 000 ) × 100 = ( $280 , 000 $266 , 000 ) × 100 = 95.0%
While the GCR appears low at 53.2% due to standard payer fee schedule discounts, the NCR reveals a healthy, high-performing revenue cycle operating exactly at the 95.0% industry benchmark.
- 6. Practical Practice Management Scenario
- Case Study: The Post-Migration Receivables Crisis
A multi-provider cardiology clinic completed an EHR and Practice Management System migration six months ago. During a quarterly executive review, the managing partner expresses alarm that practice bank balances have fallen by $180,000. The practice manager pulls the accounts receivable aging report and calculates the following key metrics:
- Total AR: $1,450,000
- Gross Charges Billed in Past 365 Days: $9,125,000
- AR Over 90 Days: $435,000 (30.0% of total AR)
- AR Over 120 Days: $217,500 (15.0% of total AR)
Analysis:
Calculate Average Daily Charges (ADC): ADC = $ 9 , 125 , 000 365 = $ 25 , 000 \text{ADC} = \frac{\$9,125,000}{365} = \$25,000 ADC = 365 $9 , 125 , 000 = $25 , 000
Calculate Days in AR: Days in AR = $ 1 , 450 , 000 $ 25 , 000 = 58.0 days \text{Days in AR} = \frac{\$1,450,000}{\$25,000} = 58.0 \text{ days} Days in AR = $25 , 000 $1 , 450 , 000 = 58.0 days
Benchmark Evaluation: Days in AR stands at 58 days, well above the 30–40 day healthy target and deep in the >50 day distress zone. Receivables older than 90 days comprise 30.0% of the balance (benchmark is <15–20%), and receivables older than 120 days comprise 15.0% (benchmark is <10%).
Investigation: The manager audits the >90 day aging bucket and discovers that following software migration, electronic claim transmission reports were not properly monitored. A major commercial payer's clearinghouse connection failed due to an outdated submitter ID, causing 420 claims totaling $310,000 to remain suspended in clearinghouse holding queues without entering payer adjudication.
Managerial Action Plan:
Update the clearinghouse payer ID credentials and batch-retransmit all suspended claims within 48 hours, submitting electronic proof of original timely transmission to prevent timely filing denials.
Reorganize the billing staff into prioritized work queues, assigning two experienced collectors to conduct a dedicated payer blitz on all balances over $1,500.
Institute weekly executive revenue cycle reviews tracking Days in AR and percent >90 days until Days in AR drops below 38 days.