Fee Schedule Import Tool

This wiki page is to document how fee schedule data needs to be constructed in order to import using WebChart’s Fee Schedule Import Tool.

  • File format: Data file shall be formatted in Comma Separated Values (CSV).
  • The first row of the file shall contain column header information.
  • Each subsequent row shall represent an fee schedule.

Column Definition

The fee schedule column definition shall contain all columns listed below regardless if their is a value or not.

  • R = Required
  • O = Optional
NameTypeRequiredComments
Fee Schedule Namechar 100RName of fee schedule
CPT Codechar 15RCPT code to load
Descriptionchar 255RDescription of the CPT Code
Amountdouble(9,2)RDollar amount for CPT Code (max 9 digits before decimal, 2 digits after, ie 123456789.00)

Examples of CSV

Fee Schedule Example

This example shows how to import multiple cpt codes into 1 fee schedule labeled ‘DEF Biz’.

  
  
Fee Schedule Name,CPT Code,Description,Amount  
DEF Biz,13153,REPAIR WOUND/LESION ADD-ON,$291.00  
DEF Biz,15050,SKIN PINCH GRAFT,$751.00  
DEF Biz,16000,INITIAL TREATMENT OF BURN(S),$120.00  
DEF Biz,16020,TREATMENT OF BURN(S),$143.00  
DEF Biz,16025,TREATMENT OF BURN(S),$245.00  
DEF Biz,16030,TREATMENT OF BURN(S),$289.00  
DEF Biz,17003,"DESTROY LESIONS, 2-14",$22.00  
DEF Biz,17110,"DESTRUCT LESION, 1-14",$157.00  
DEF Biz,17250,"CHEMICAL CAUTERY, TISSUE",$119.00  
DEF Biz,20000,INCISION OF ABSCESS,$325.00  
DEF Biz,20005,INCISION OF DEEP ABSCESS,$469.00  
  

  
  

Sample CSV files

Here is a sample CSV file to download and view in a text editor or a spreadsheet program. File:Def fee sched.csv


WebChart Documentation

Page Created:
Last Updated:
Last Build: Mon, 14 Nov 2022 01:22:36 EST
WikiGDrive Version: 64fa77a2dd4586094b6074a78ed6769886b60894