Accounts Receivable Aging Analyzer
Analyze an accounts receivable aging report to identify collection priorities, problem accounts, and systemic billing issues. This prompt helps healthcare revenue cycle managers transform AR aging data into actionable collection strategies and process improvement priorities.
This prompt helps revenue cycle managers analyze an accounts receivable aging report by working with aggregate AR bucket totals, payer distribution, and high-level practice metrics — no individual patient account details are entered. It produces an analysis covering AR performance benchmarks, bucket-level assessment, payer-specific AR concerns, high-risk balance criteria, a collection priority queue, systemic issue indicators that point to upstream billing problems, and a 30-day action plan. It is used by revenue cycle directors, practice administrators, and billing managers at physician practices, community health centers, and hospital outpatient departments conducting monthly AR performance reviews.
The prompt
You are a senior healthcare administrator with expertise in accounts receivable management, collection strategy, and revenue cycle performance improvement. Analyze the following accounts receivable aging data (aggregate, no PHI): Organization context: - Practice/facility type: [PRACTICE_TYPE] - Monthly gross charges: [MONTHLY_CHARGES] - Primary payer mix: [PAYER_MIX] AR aging summary: [PASTE AR AGING DATA — e.g., bucket totals: 0-30 days $X, 31-60 days $X, 61-90 days $X, 91-120 days $X, 120+ days $X, total AR $X] Payer distribution in AR (if available): [PAYER_AR_DISTRIBUTION] Analyze the AR data covering: ## AR Performance Benchmarks Comparison of the provided AR metrics against industry benchmarks for this practice type: days in AR, AR over 90 days as a % of total, and collection rate. ## AR Bucket Analysis Assessment of each age bucket — is the distribution healthy or does the aging pattern indicate systemic problems? ## Payer-Specific AR Concerns Any payers with disproportionately aged balances relative to their share of charges — indicating a payer-specific billing or payment issue. ## High-Risk Balance Identification Criteria for identifying accounts at risk of being uncollectable — age, balance threshold, payer type. ## Collection Priority Queue A prioritized approach to working the AR: which accounts to pursue first, which require appeals, which should be written off or sent to collections. ## Systemic Issue Indicators Patterns in the AR aging that suggest upstream billing problems (eligibility errors, coding issues, authorization gaps) rather than collection problems. ## 30-Day Action Plan Immediate actions to improve AR performance — focused on the highest-impact, shortest-timeline interventions.
Runner beta coming — join the waitlist.
In-product execution isn't live yet. Leave your email and we'll let you know if the Runner beta opens.
How to use this prompt
1. Pull the AR aging report from your practice management system organized by both age bucket and payer — the payer breakdown is essential for identifying payer-specific issues.
2. Compare your AR metrics against specialty-specific benchmarks (MGMA or HFMA publish annual benchmarks by specialty).
3. Assign AR work queues by bucket and payer to appropriate staff — self-pay balances, insurance follow-up, and denial management require different skills and approaches.
Customization tips
Sample output
Related prompts
Frequently asked questions
This AI-generated content is for informational and educational purposes only. It does not constitute medical or legal advice. Always follow HIPAA guidelines and consult qualified healthcare professionals for specific clinical or regulatory matters.