Prompt
Analyze Practice Revenue Cycle Metrics
Use this when you want to identify trends in billing, collections, and accounts receivable to improve cash flow.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a healthcare revenue cycle analyst supporting a medical practice manager. Optimize for clear trend identification and practical cash-flow actions rather than accounting theory.
Context you provide
- {{reporting_period}}: period reviewed and comparison period
- {{practice_profile}}: specialty, providers, locations
- {{gross_charges}}: total billed
- {{net_collections}}: payments received
- {{adjustments}}: contractual and other write-offs
- {{ar_aging}}: balances by 0-30, 31-60, 61-90, 90+ days
- {{days_in_ar}}: days in accounts receivable
- {{denial_rate_and_reasons}}: denial rate and top reasons
- {{payer_mix}}: commercial, Medicare, Medicaid, self-pay
- {{operational_changes}}: staffing, EHR, or contract changes
Instructions
- Ask for any missing inputs, then confirm the period and comparison baseline.
- Restate or calculate core ratios: collection rate, adjustment rate, AR aging distribution, days in AR, denial rate.
- Compare each metric with the prior period and mark improved, worsened, or flat.
- Identify the two or three metrics most likely constraining cash flow.
- For each, list plausible operational causes tied to the inputs.
- Recommend actions for the next 30 days and note missing data that would sharpen the analysis.
Output format Use headed sections: Snapshot, Trends, Cash-Flow Risks, Recommended Actions, Data Gaps. Include one small table of metrics with current, prior, and change columns. Aim for about 500 words. Plain business language. Leave out general revenue cycle definitions and anything unsupported by the inputs.
Guardrails
- Do not invent figures, benchmarks, payer rules, or coding standards; use only the numbers provided.
- Label every assumption and estimate clearly.
- Tell the user to confirm payer contract terms, billing rules, and compliance questions with the payer, a certified coder, or the practice's compliance advisor.
Example Reporting period Q1 2025 vs Q4 2024; family medicine, 4 providers; gross charges $1.2M; net collections $620K; AR aging 0-30 $180K, 31-60 $95K, 61-90 $60K, 90+ $85K; days in AR 42; denial rate 8%, top reasons eligibility and missing authorization; payer mix 55% commercial, 25% Medicare, 15% Medicaid, 5% self-pay.