Allowed Fee Exception Report

Allowed Fee Exception Report

To find underpayments, this report compares posted allowed amounts to contractual allowed amounts.

  • The Allowed Fee Exceptions Report shows discrepancies on Posted Allowed amounts against the Allowed Fee Schedule. 
  • It does not report on CO's and adjustments.
  • If the report is Output As a CSV Text File, it will include the Patients' DOBs and Policy #s.
  • These can be used as part of the Insurance appeal process.
  • If the report is Output As a CSV File and Group By is -Select- or if Insurance is selected.
  • If Plans are not selected in Fee/RVU Managementthe allowed amounts will not be reported.


Allowed Fee Exception Report

(Reports > Financial Panel > Allowed Fee Exceptions)

Allowed Fee Criteria

Report Options

  • Date TypeDOSCharge Post Date, or Payment Post Date
  • Date Span: Choose the dates for reporting purposes.

  • InsuranceCPTModifierBillingRendering, Facility, Patient, Case

Allowed Fee Filters

  • Force Fee ScheduleThis option allows you to compare the Insurance(s) selected above to the Allowed Fee Schedule of a different Insurance.
  • Example: Compare the reimbursements from a Payer where there are no contractual fees loaded in the System to the Medicare fees that have been loaded.
  • Include:
  • Under and Over Payments
  • Under Payments Only
  • Over Payments Only
  • Discrepancy is greater than: Dollar amount or Percentage
  • Include Non-Discrepancies: Select to include all posted Allowed amounts and not just the discrepancies.  
  • This provides a comprehensive look at posted Allowed amounts for a given Insurance and time-frame. 
  • Review the adjudication of claims for correct payment.

  • Group By one of the following:
  • - Select - (no grouping)
  • If left as - Select - and the report is output to a csv file, the report will include an Insurance Reporting Group column.

  • Billing Provider
  • Rendering Provider
  • Facility
  • Insurance
  • If Insurance is selected and the report is output to a csv file, the report will include an Insurance Reporting Group column.

  • Procedure

Report Examples

Grouped By Insurance (PDF Format)

Grouped By Insurance (CSV Text File)

Learn More

Fee/RVU Management

Reports Criteria Overview

My Favorite Reports and My Reports Panels

Schedule Reports Using the Job Scheduler

    • Related Articles

    • Fee/RVU Management

      Add Charge Fee, Allowed Fee, and RVU Schedules If the Items Number is 0, there is a problem with the file that was uploaded. Reference the File Formatting Guidelines to ensure a successful upload. The Procedure Code must exist in the Procedure Code ...
    • Fee/RVU File Formatting and Resources

      All Fee and RVU Schedules can be created in the Fee/RVU Management Library. The following resources can be found on the CMS website. Physicians Fee Schedule: https://www.cms.gov/apps/physician-fee-schedule/license-agreement.aspx#TopOfPage ...
    • Custom Encounter Query (CEQ) Report

      The CEQ is a custom report/query tool that queries Encounter Data. Reports > Custom Encounter Query Build a Custom Encounter Query Filter Criteria: Add your filter criteria by clicking the Plus symbol beside "And". The filters you choose will ...
    • Daily Charges Report

      The Daily Charges Report is a detailed breakdown of each Patient's Charges for a day or a date range. This report can be run at the end of the day to capture your Charges, or it can be run for a different period to report Charges and Payments for the ...
    • 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 ...