Replace Fee Schedule From Excel File

Updated by Steven Garand

 All existing fees not specified as Fee For Service are deleted.
All existing fees not matching a code and modifier in the Excel file are deleted.
To keep Fee For Service and unmatched fees use Merge instead of Replace.

Excel File Structure Allowed

  1. Same Modifier: All items in the file pertain to a single modifier
  2. Single Column Mixed Modifiers: Single column in the file contains different modifiers for each row. Each row only has one allowable.
  3. Multiple Column Allowables: Multiple columns with allowables in each column. Each column contains an allowable for a specific Modifier. Each row has multiple allowables.

Actions

  1. Import same modifier
  2. Import single column mixed modifiers
  3. Import multiple column allowables


How did we do?