Fees can be imported into fee schedules (e.g., if insurance sends a new fee schedule).

In Fee Tools, at the lower left, is an Import button.

See our video: Updating Your UCR (Office) Fees.

For fees to import, the corresponding code must already exist in the Procedure Codes list.

Usually, it is easiest to manually enter or edit fees in a fee schedule instead of importing it (create the fee schedule, nine-key in the fees). Often the fee schedules provided to offices have no standard format. Thus, taking a PDF, printed fee schedule, or custom formatted fee list and editing it for import can be difficult. Large offices may have IT staff handle fee schedule importing, but in general, importing fees is a technical process and an advanced feature.

File Format Requirements: Fees must be saved as a tab-delimited file (text file is preferred). To see an example of the correct file format, Export Fees. When opened with Notepad, it looks similar to the screenshot shown below:

• The first column of the imported file must contain the procedure code; the second column must contain the fee with no monetary symbols or extra characters/spaces.
• Columns must be separated by tab.
• Columns containing additional information (e.g., abbreviation or description) are not required and are ignored during import.
• Fee sort order does not matter.
• Close the file before importing the fees.

To import fees into an existing fee schedule:

1. Make a backup copy of the existing fees as a preventative measure. See Fees Copy for detailed instructions.
2. Import the fees into the original fee schedule.
1. In the Fee Tools window, under the Select Fees section, select the fee schedule to import into.
• Selecting only a fee schedule will export the default (i.e., global) fee schedule.
• Select a Provider and/or Clinic to further narrow the export to Clinic or Provider-Specific Fees.
• Provider or Clinic can only be selected for Fee Schedules with Use Global Fees unchecked.
2. (Optional) To start with a blank fee schedule, click Clear. All existing fees are deleted.
3. Click Import.
4. A warning message appears. Click OK to proceed.

If fees were cleared before importing, only the imported fees remain. If fees were not cleared before import, any existing fees are overwritten with imported fees and procedure codes that did not contain a fee in the import remain unchanged.

To apply updated fees to treatment planned procedures, see Fees Update.