Importing Case Data & Billing Codes

Below are instructions explaining how to submit MACRA case data and corresponding ASA and Surgical Billing code(s). 


  • Prepare and submit case data with corresponding ASA and Surgical Billing code(s) to Graphium.


  • Import first quarter ASA and Surgical Billing code(s) for your Graphium cases by April 30th. 

  • Import second quarter ASA and Surgical Billing code(s) for your Graphium cases by July 31st. 

  • Import third quarter ASA and Surgical Billing code(s) for your Graphium cases by October 31st. 

  • Import fourth quarter ASA and Surgical Billing code(s)for your Graphium cases by January 13th.


  1. Format Billing Code Import Files

  2. Import Billing Code File(s) to Graphium

Format Billing Code Import File(s)

  1. If your organization would like to utilize Excel, we highly encourage you to click here and download our Excel import template. However, please note: Excel file types (.xlsx) are not supported within the Graphium Billing Code Importer tool. Therefore, once you have created your Excel file, you will need to save it as one of the acceptable file types (.csv, .tsv, or .txt) before performing your import.

  2. Here are some key points to consider when formatting your “Billing Code Import” file:

    • Each “Billing Code Import” file must only contain data from a single facility. Note: if the facility has a high volume of cases, we recommend importing billing code data on a monthly basis. This will improve user experience and make managing results of the matching process much easier.

    • Each case must only appear once in the “Billing Code Import” file and must include all associated ASA and Surgical Billing code(s).

    • Please ensure header row (containing the column names) is not repeated throughout the file.
    • Data within the “Billing Code Import File” must be formatted correctly:

      • The ASA or Surgical Billing code(s) must contain 5 digits, including any leading 0's. For example, billing code(s) should be entered as "00790" not as "790". In Excel, this can be formatted using a custom format of "00000".

      • Date of Service must be formatted as YYYY-MM-DD. In Excel, this can be formatted using a custom format of “yyyy-mm-dd".

      • Anesthesia Start Time must be formatted as HH:MM:SS. In Excel, this can be formatted using a custom format of “hh-mm-ss". Once selected,  please ensure times do not include AM/PM and there are no extra spaces before or after times.

Import Billing Code File(s) to Graphium

  1. Once you have properly formatted your billing code file and saved it as one of the acceptable file types, click here to log into the Graphium EMR Dashboard™. If you do not have access to the dashboard, please contact your organization's Administrator.

  2. Click on the settings icon in the upper right corner and then choose "Import".

  3. Click on "+ New Import".

  4. Click on the "Billing Code Import" button for the applicable year.

  5. Choose your applicable facility from the “Select Facility” drop down menu and then click "Create". Note: the title for your import will default to the filename you select, but you can enter a different title in the "TITLE" box provided.

  6. Click on "Upload data from file" and use the file explorer to locate your file for upload. Once you select the file it will automatically upload. If you prefer not to upload your data, you will need to manually enter the billing and case data on this page. Note: as mentioned above, you may upload any acceptable file type (.csv, .tsv, or .txt), with any number of columns, as long as it has ONLY 1 record per row. The next step will allow you to match your columns to Graphium's accepted data categories, and you'll be able to clean up or remove data before uploading.

  7. The column titles within your file may not match our system’s default categories. Therefore, you must “map” or match your unique column titles to Graphium's defaults. Your unique column titles will appear on the left side of each section. Choose the matching Graphium category from the drop down menu on the right side of each section and then  click "Review". Note: if a column contains no data, click "ignore this column".image-png-Mar-18-2022-04-02-49-93-PM copy

  8. Use the toggle button in the top left labeled "Only show rows with problems" to review formatting issues found within your file (they will be highlighted in red). If you hover over a red cell, a description of the correct formatting guideline should appear. You can then double click the red cell and correct the formatting error. NOTE: this step ONLY highlights formatting errors, not data matching inaccuracies.

  9. Once you have corrected all errors, click "Continue". If you have a significant number of errors, you may choose to return to your original file, make all necessary corrections, and then re-upload the corrected file.

  10. The following pop-up will appear. Simply click Yes to begin your billing code file import.

  11. You will be automatically redirected back to the Import Batch home page, where you should see your provider import at the top of the list. You will also see the number of providers you uploaded highlighted under the Status column. Note: if the number is highlighted in yellow, simply refresh the page, as the system is simply in the process of finalizing your request.  

  12. Once the number is highlighted in green, the provider(s) have been successfully added to your facility.

  13. Should there be numbers highlighted in red, it means there was a problem with the data you entered, and the error needs to be corrected. 

  14. To correct errors, click the red View Details button under the Actions column. A list of the providers you uploaded will appear. If you click the notebook icon under the Status column, a description of the error will appear. 

  15. Once you have identified the error, click the red Edit Record button under the Actions column and make the necessary corrections to the affected data field. Click the red Save button in the right corner.
  16. You will then need to reprocess that provider, by clicking the red "Reprocess" button under the Actions column.
  17. Navigate back to the Import Batch homepage. If you updated the provider's information correctly, the red highlighted number will now be green. 

Troubleshooting Steps

  1. Are you receiving the following error message "THERE WAS AN ISSUE LOADING THIS CONTENT. PLEASE TRY AGAIN LATER" ? If so, you may not have the appropriate user role in the Graphium dashboard. Please contact your organization's Administrator and request your user role for Graphium's dashboard be changed to one of the following for billing code upload capability:
  • Organization Administrator

  • Facility Administrator

  • Scheduler

  • Provider Administrator

  • Provider

2.     If you have one of the above user roles and/or you were previously able to upload billing

        code files but now you cannot, please contact Graphium Support.