Executive Summary Report Overview

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).

    • Calculation of Ending A/R: Beginning A/R plus Charges minus Net Payments minus All Adjustments

    • The Beginning and Ending A/R are available on the A/R Analysis Report.

  • The month calculation is Payments/(Payments + Adjustments) by Post Date.

    • This calculation is the same as the Prof% column in the Practice Analysis Report run by Post Date for the same period of time.


  • Bad Debt: Transaction Codes marked as "Report as Write-Off" in the Transaction Code Library.

  • Other Adjustments: Transaction Codes marked as "Report As Adjustment", "Report as Transfer In", and "Report as Transfer Out".

    • This calculation excludes CO45.

  • 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

    • Calculation is by Post Date

  1. APC (Average Patient Charge): Charges divided by the # of Patients.
  2. APR (Average Patient Revenue): Net Payments divided by the # of Patients.
  3. Gross Collection Rate: Net Payments divided by Charges
  4. Net Collection Rate: Net Payments divided by Actual Allowed (Charges minus Contractual Adjustment). Users can define the look-back period.
  5. Write-offs (current month) divided by Average Posted Allowed over last 6 months.
  6. Bad Debt Ratio
  7. Days in A/R: Total A/R divided by the average billed amount per day over a given time period
    1. Days in A/R can only be included on the Report if the System Setting DAYSINAR is set to YES.
  8. Average Days to Add an Encounter: Days from DOS to Add Date
  9. Average Days to Complete an Encounter: Days from DOS to Charge Completion
  10. Average Days to Bill an Encounter: DOS of Service to Billed Date
  11. Percent of Charges Billed within 48 hours
  12. Clean Claim calculated rates: Claims Rejected by Clearinghouse and Rejected by Payer divided by total Claims submitted.
  13. Calculated Allowance %: 6-month Review (looking back at the period of 9 months to 3 months ago) for paid Claims.
    1. Example: In September, run for February to July DOS for Encounters that have $0.00 balance.
    2. (Charges minus Payments) divided by Charges
  14. Activity by Payer by Claim Filing Indicator (CFI) and/or Reporting Group: Breakdown by $ or %
  15. A/R Aged by Billed and Post Date
    1. Breakdown by CFI or Reporting Group
    2. Breakdown by $ or %