Executive Summary Report Overview
Executive Summary Report
The Executive Summary Report provides Monthly totals incorporating key revenue cycle KPI components, broken down for each month over a 12 month reporting period.
Report Features
Beginning & Ending A/R (Charges, Payments, Adjustments, and Write-offs).
The month calculation is Payments/(Payments + Adjustments) by Post Date.
Work RVUs
To Collections (Net): Write-offs (WOCOL) and Reversal of Collections (WOPR)
# of Patients: Number of unique Patients for the reporting period.
# of Encounters: Number of unique Encounters with the option to Exclude Reversals at the Report level.
# of Visits: Number of unique Visits (Dates of Service) per Patient and Provider
- APC (Average Patient Charge): Charges divided by the # of Patients.
- APR (Average Patient Revenue): Net Payments divided by the # of Patients.
- Gross Collection Rate: Net Payments divided by Charges
- Net Collection Rate: Net Payments divided by Actual Allowed (Charges minus Contractual Adjustment). Users can define the look-back period.
- Write-offs (current month) divided by Average Posted Allowed over last 6 months.
- Bad Debt Ratio
- Days in A/R: Total A/R divided by the average billed amount per day over a given time period
- Average Days to Add an Encounter: Days from DOS to Add Date
- Average Days to Complete an Encounter: Days from DOS to Charge Completion
- Average Days to Bill an Encounter: DOS of Service to Billed Date
- Percent of Charges Billed within 48 hours
- Clean Claim calculated rates: Claims Rejected by Clearinghouse and Rejected by Payer divided by total Claims submitted.
- Calculated Allowance %: 6-month Review (looking back at the period of 9 months to 3 months ago) for paid Claims.
- Example: In September, run for February to July DOS for Encounters that have $0.00 balance.
- (Charges minus Payments) divided by Charges
- Activity by Payer by Claim Filing Indicator (CFI) and/or Reporting Group: Breakdown by $ or %
- A/R Aged by Billed and Post Date
- Breakdown by CFI or Reporting Group
- Breakdown by $ or %
Related Articles
Reports Criteria Overview
Most Reports default to the Post Date which is controlled by the date used in the Reference Batch. My Reports Panel: The Reports that the User has run are shown in this Panel. You can choose to see Unread reports only. Report History: This is the ...
Charge Summary Report
Charge Summary Overview The Charge Summary Report is found on the Reports Dashboard. Use Filters and Reporting Groups to determine the information that appears on the Report. Use the Save Report Filters to retain the same filters for running later. ...
Payroll Report
The Payroll Report cannot be run with a single total. Instead, use the Practice Analysis Report. The Payroll Report calculates the total amount of Revenue generated by a Procedure (displayed by the Procedure Code) for a Provider and reports the total ...
Executive Summary Calculations
The Executive Summary Report provides Monthly totals incorporating key revenue cycle KPI components, broken down for each month over a 12 month reporting period. Net Payments: The Dollars Posted for the selected time period, not the Dollars Received. ...
Productivity Analysis Report
Productivity Analysis Report The Productivity Analysis Report contains Totals for Receipts, Charges, and Applied Payments grouped by specific categories. Access the Productivity Analysis Report: From Reports on the Left Side Menu, select the ...