You are a senior healthcare analytics consultant.

Create an executive-level monthly reporting packet for a vascular and interventional practice modeled on MDManagement-style reports.

Primary focus:

Provide a comprehensive financial and operational review with particular emphasis on accounts receivable (A/R) performance, including:

* Percentage of A/R greater than 90 days.
* A/R aging distribution.
* A/R aging breakdown by payer.
* Identification of payer-specific revenue cycle risk.

Use an executive consulting tone that is concise, data-driven, and neutral.

## Report Sections

## Executive Summary

Provide a high-level overview of key financial and operational performance indicators, including:

* Revenue performance.
* Collection performance.
* A/R health.
* Production trends.
* Facility utilization.
* Key operational risks.
* Significant variances or outliers.

Highlight the most important findings and areas requiring attention.

## Financial Performance

Include financial performance metrics:

* Charges.
* Revenue.
* Collections.
* Accounts receivable balance.
* Collection rate.
* Variance from prior periods.
* Month-over-month (MoM) comparison.
* Year-over-year (YoY) comparison.

Compare CY2026 performance against CY2025 where available.

## Production Summary

Analyze clinical production metrics, including:

* Procedures performed.
* Patient visits.
* New patient volume.
* Follow-up volume.
* Procedure volume trends.
* Utilization trends.

Highlight changes, growth opportunities, and operational constraints.

## Facility Performance

Evaluate performance by facility type:

* Clinic.
* Office-Based Lab (OBL).
* Ambulatory Surgery Center (ASC).

Include:

* Volume.
* Revenue contribution.
* Utilization.
* Productivity trends.
* Operational variances.

## Payer Mix

Analyze payer distribution using both:

* Patient population mix.
* Revenue-based payer mix.

Include:

* Payer volume percentage.
* Revenue percentage.
* Changes over time.
* High-risk payer concentration.

Highlight payers contributing disproportionately to A/R risk or collection delays.

## Claims Performance

Evaluate claims cycle performance, including:

* Claim acceptance rate.
* Claim error rate.
* Claim rejection rate.
* Denial trends.
* Processing issues.

Identify operational causes contributing to claim delays or revenue leakage.

## A/R Aging Analysis

Provide a detailed accounts receivable analysis.

Include aging categories:

* 0–30 days.
* 31–60 days.
* 61–90 days.
* 91–120 days.
* 121–180 days.
* 180+ days.

Include:

* Total A/R balance.
* Percentage of A/R in each aging category.
* Percentage of A/R greater than 90 days.
* Trend compared with prior periods.

Provide payer-level A/R aging analysis, including:

* Total A/R by payer.
* Aging distribution by payer.
* Percentage of payer A/R greater than 90 days.
* Identification of concentrated A/R risk.

Highlight:

* Aging outliers.
* Slow-paying payers.
* Potential collection risks.

## Trend Analysis

Provide trend analysis including:

* Month-over-month comparisons.
* Year-over-year comparisons.
* CY2026 versus CY2025 comparisons.

Include trends for all major KPIs:

* Charges.
* Revenue.
* Collections.
* A/R balance.
* Collection rate.
* Procedure volume.
* Visit volume.
* Utilization.
* Claims performance.
* A/R aging.

## Visualizations

Include charts and tables where appropriate:

* Bar charts for financial comparisons.
* Line charts for monthly and yearly trends.
* Pie charts for payer mix.
* Stacked bar charts for A/R aging distribution.
* Comparative tables for KPI performance.

Use visualizations to clearly communicate:

* Variances.
* Outliers.
* Trends.
* Risk areas.

## Insights and Recommendations

Provide actionable analysis focused on:

* Revenue cycle risks.
* A/R management opportunities.
* Payer-specific issues.
* Claims process improvements.
* Operational bottlenecks.
* Facility utilization opportunities.

Prioritize recommendations based on financial impact and operational importance.

## Output Format

Deliver the report in the following order:

1. Executive Summary.
2. Financial KPIs.
3. Production Summary.
4. Facility Performance.
5. Payer Mix.
6. Claims Performance.
7. A/R Aging Analysis.
8. Trend Analysis.
9. Insights and Recommendations.

Rules:

* Maintain an executive-level consulting tone.
* Use concise, data-driven analysis.
* Highlight meaningful variances and operational concerns.
* Provide payer-level insights for A/R risk concentration.
* Include MoM and YoY comparisons for all major KPIs where data is available.
* If data is missing, use clearly labeled structured placeholders without disrupting report formatting.