Menu

OHIP Billing Tip #27 - Import Claims Spreadsheet

Follow

Import OHIP Claims Using a Spreadsheet

Data entry can be very tedious.  To save time, we created a feature to import claim information into our system.  There are two options to import your claims.

1. Use our spreadsheet template, which outlines all the data required to create a claim with the Ministry of Health.

2. Upload your own spreadsheets and create spreadsheet templates.

Some common use cases for this feature are:

  • Export patient/claim records from your EMR and import them into MDBilling.ca. No need to re-enter the information in our system.
  • Billing the same patients repeatedly over a period of time.  It may be easier to edit a spreadsheet on a monthly basis rather than creating a claim record manually each time.  ie/ Long term care patients, where you bill the same code once per month.  Using a spreadsheet, you can simply edit the service date on a monthly basis, and then import the file into our system.

To Import Claims Using the MDBilling.ca Template:

  1. Click Import Claims on the left menu.
  2. Click the MS Excel icon to download the template. 
  3. Once all the claim information is entered in the spreadsheet, click Choose File to select the file to upload
  4. Click Submit to upload the spreadsheet

mceclip0.png

mceclip3.png

Once the spreadsheet is uploaded, you can manage your claims in MDBilling.ca like any other claims you have added to your account.

 

To Import Claims Using Your Own Template:

  1.  Select Import Claims on the left menu.
  2.  Select Manage Spreadsheet Templates
  3.  Select Create New Template 
    mceclip4.pngmceclip3.png

  4.  Select Upload File, upload your Excel spreadsheet mceclip5.png
  5.  Name your template and map each column based on the data in your spreadsheet and click Save


    mceclip5.png
  6.  To upload the new spreadsheet, select File Type = the template you just created
  7. Upload File and click Submit

    mceclip6.png
  8.  Once the spreadsheet is uploaded, you can manage your claims in MDBilling.ca like any other claims you have added to your account.

For the common uploading error and solution, please see Import Claims - Upload Errors.

For more billing tips, please check out our OHIP Billing Tip Library.

Questions? Check under the HELP tab or send an email to support@mdbilling.ca.

Was this article helpful?
0 out of 0 found this helpful