Charge & Payment: Fully Paid Claims by Visit

This report is currently in Limited Release to a select group of Members and will be gradually rolled out over the following weeks.

Fully Paid Claims by Visit is a Data Table style report that helps clinics understand the percent of billable charges the insurance companies have paid. Users are able to evaluate this by insurance or by clinic location.

Run and Customize the Report

  1. You can filter which clinics appear in the report using the View Clinics by: drop-down menu and corresponding (…) button.
  2. Select Date Range.
  3. You can choose to View Data by: Insurance or Clinic.
  4. Export to Excel or CSV for further manipulation.

Tip: Set your date range to at least a month (a quarter is better) to get an accurate idea of these metrics.  If you only set it for a week, you will primarily see claims billed with no payments.

RevFlow Replacement Reports

This Analytics report replaces Claims By Financial Class By Visit legacy RevFlow Report. Key Differences include:

  • The Insurance Code and Insurance Name columns replaced InsCode and InsClass Description columns in RevFlow.

  • All payment data is rolled up under the Primary Insurance (i.e. the payments and adjustments columns can include a mix of primary, secondary, and patient data).
  • The Visits column has been updated to pull based on notes finalized in the WebPT EMR (this number generally differs from what is available in the RevFlow report. We’ve also included Paid Visits, which is the count of visits where the payments and adjustments equal the charge amount, you can see the full definition in the table below. 
  • Updated the calculation fields (Charge Per Paid Visit, Pay Per Paid Visit, and Adjustment Per Paid Visit) to calculate based on Paid Visit instead of Visit.
  • You can now group by Insurance and Clinic, instead of Insurance and Payer.
Payments included in this report
  • Insurance Payments: All payments posted from the insurance (Batch Payments or Release 835s page.)
  • Unassigned payments: Payments entered directly in RevFlow via the Unassigned Payments page. This includes payments that have been distributed to dates of service, and those waiting to be allocated based on system rules.
  • WebPT EMR Payments: Payments collected from the patient and posted in the WebPT EMR. These payments flow into RevFlow (Unassigned Payments) and include payments that have been distributed to dates of service, and those waiting to be allocated based on system rules.

Location

ou can locate this report in the Charge & Payment section of Reports in Analytics.  If you do not see the report listed in this section, ensure that you have the correct Analytics Access permission.

Column Field Descriptions

Column Description Data Source
Insurance Code Unique code associated with the primary insurance for the case. RevFlow
Insurance Name The name of the insurance. RevFlow
Clinic Name The location where the patient was treated and the note was finalized. WebPT EMR
Visits The number of visits (finalized, billable notes). WebPT EMR
Paid Visits The number of visits where the payments and adjustments are equal to the charge amount. This does not include non-billable visits, visits where the only active charge is a copay, interest payment, or insurance overpayment, or patients inactive in the EMR. RevFlow
Charges The dollar amount billed to insurance. RevFlow
Payments The dollar amount of insurance payments received. The payment column includes both Insurance Payments and Patient Payments. RevFlow
Adjustments The dollar amount of insurance adjustments applied. RevFlow
Charge Per Paid Visit The average amount charged per paid visit. This is calculated by dividing Charges by Paid Visits.  Calculated by Report
Pay Per Paid Visit The average amount paid per paid visit. 
This is calculated by dividing Payments by Paid Visits. 
Calculated by Report
Adjusted amount per Paid Visit The average insurance adjustment amount per paid visit. 
This is calculated by dividing Adjustments by Paid Visits.
Calculated by Report
Collection % The percent of charges that have been paid. This is calculated by dividing Payments by Charges. Calculated by Report