Fee/RVU File Formatting and Resources

Fee/RVU File Formatting and Resources

Release 4.7

Resources for Creating and Using Fee and RVU Schedules

All Fee and RVU Schedules can be created in the Fee/RVU Management Library.

The following resources can be found on the CMS website.


All uploaded files used to create these Schedules must be in csv format and the files must be created exactly as shown below.

  • If a file is uploaded, and it contains 0 Items after the upload, you probably did not create the file correctly.
  • Follow the instructions below exactly as stated.


Prepare a CSV Document for Upload

Download the CMS Physicians Fee Schedule or RVU Schedule, in Excel format.

  • Make the changes to the file as shown below, and save it in a csv (comma delimited) file format.
  • The file will not upload in any other format.
  • All columns must be deleted except the ones shown below.

If you are creating your own file, use the same instructions below.

Formatting the File

  • Three Columns labeled as follows:
  • Column A: CPT® (All CAPS)
  • Column B: Modifier (First letter capitalize; can leave blank)
  • Column C: Fee (Allowed Fees; No $ signs; can be decimals or no decimals)
  • Example: 175 or 175.00
  • No formatting, such as bold, italics, borders, etc.
  • No special characters (unless otherwise specified)
  • No blank rows
  • Save the spreadsheet in csv format.


Billing Provider, Facilities, Insurances, and Plans Panels


The check box beside each section in a panel can be used to Include All or Exclude All in that section.

  • Example: In the Billing Provider panel, PRV B is unchecked, which un-checks all of the subsections underneath it.
  • If the check box is green, it indicates that all Providers are not included.

Use the Collapse link to minimize all subsections in the panel.

Use the Check/Uncheck All to select or deselect all check boxes.


Use the Search Filter in each panel to search specifically.

  • Enter a Payer in the Insurance panel search field.
  • All sections will open that have that Payer.
  • Example: Enter Cigna
  • All segments containing Cigna will open along with the subsections.

 


Section Hierarchy  in the Billing Providers, Facilities, Insurances, and Plans Panels

Each Panel is broken down into these sections and subsections:

Billing Providers

  • All Billing Providers
  • Billing Provider Groups
  • Individual Providers in the Group
  • No Reporting Group
  • No specialty

Facilities

  • All Facilities
  • Facility Group
  • Individual Facilities
  • No Reporting Group
  • Individual Facilities

Insurances

  • All Insurances
  • Insurance Reporting Groups
  • Individual Insurances
  • No Reporting Group by CFI with Individual Insurances as subsections
  • Blue Cross/Blue Shield [BL]
  • Champus [CH]
  • Commercial Insurance [CI]
  • Medicaid [MC]
  • Medicare [MB]
  • Self-Pay [09]
  • Verteran Administration Plan [VA]
  • Workers' Compensation Health Claim [WC]
  • No CFI

Plans

  • All Plans
  • Individual Plans
    • 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. All Charge Fee, Allowed Fee, and RVU Schedules are ...
    • Allowed Fee Exception Report

      This report compares posted allowed amounts to contractual allowed and is beneficial in finding underpayments. If the report is Output As a CSV Text File, it will include the Patients' DOBs and Policy #s, which can be used as part of an Insurance ...
    • Self-Pay Fee Schedule

      Release 4.7 A Self-Pay Fee Schedule(s) can be used as Self-Pay only, or you can use another Fee Schedule, such as an Insurance Fee Schedule, as your Self-Pay Fee Schedule. There can be multiple Self-Pay Fee Schedules. Add a Self-Pay Fee Schedule From ...
    • Schedule Builds

      Schedule Builds The Schedule Builds are the backbone of your Calendar. Builds can be created for each Resource & Facility. Builds define what, when, and where Appointments can be scheduled. If the Calendar is not formatted by using the Builds, some ...
    • Order Procedure Lines by RVU

      By default, the Procedure lines are ordered as entered in the Add/Modify Charge screen. When using RVUs, the lines can be ordered by RVUs. There must be a Work RVU Fee Schedule loaded. System Setting: Admin > System Settings > Charges > LINEORDER. ...