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.

  • 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
  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 %

 


    • Related Articles

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

    • Reports Criteria Overview

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

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

    • Custom Query Reports Overview

      Custom Query Reports Overview Custom Query Reports can be custom-built to produce the output and columns you want specifically. A Default Report is System delivered for each Custom Query Report. They all operate in the same way but pull specific ...

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