Add a contract from Imported Prices

Follow the steps below to add a new contract based on imported prices. 

Part 1: Create a Spreadsheet

  1. The first row of the spreadsheet should only contain column names

  2. The first column of the spreadsheet should list your billing codes.

  3. The second column of the spreadsheet should list the code descriptions.

    If the code is not in your local list, it will be added with this description.

  4. The third column of the spreadsheet should list the default billing prices.

    If the code is not in your local list, it will be added with this default price.

  5. The fourth and subsequent columns should list contract prices.

  6. Save the spreadsheet as a Comma delimited (.csv), Excel (.xls or .xlsx) file. 

    Only the first sheet/tab will be imported. 

Part 2: Importing into CollaborateMD

  1. Select Customer Setup > Codes... > Contracts.

  2. Click the New Contract button. 

  3. Select the Import Prices option. 

  4. Use the File to Import field to upload the spreadsheet.

  5. Click the Show Preview to import the spreadsheet.

  6. Type the name for the contact in the Name field.

  7. Use the Type drop-down menu to select whether the contract will be FFS (Fee For Service) or CAP (Capitated).

    This is only used for tracking purposes.

  8. Place a check in the box to Allow users posting payments to update prices

  9. The Sequence# will auto-populate once the contract is saved.

  10. In the table below, you'l find all the codes that have been added or created for your account.

    To learn how to add or create codes, please visit our Procedure Codes Help Article.

  11. In the Price column, enter your contract price for each billing procedure code as agreed upon with the payer.

  12.  Optional: If the payer does not cover a particular procedure, check the Exclusion checkbox. Checking this box will make any remaining balance due to the patient after the insurance payment; meaning, the status of the charge will be set to Balance Due Patient automatically.

  13. Open the Payers window to associate this contract with a payer.

    To learn how to associate contracts with the payer, please visit our Add Payer Association Help Article.

  14. Click Save.