How to import OHIP claims into MDBilling.ca

When importing claims using our Excel template, any rows on the spreadsheet that are missing information will be listed on the Upload Claim Error window.

If you notice errors during import, but the cells in the spreadsheet are showing correctly, it may be due to "special hidden" characters in the template (likely from a carriage return or space, from when the rows were copy and pasted from your application).

In the example below, row 15, 19, 101 in the template have service codes populated. However, during the import, error message was showing with: 'No services found for claim'.

To avoid this issue, copy and paste the rows from your existing spreadsheet into a new spreadsheet template, using the Paste Special - VALUES feature from MS Excel. This will remove any special hidden characters.

Steps as follows:

1) Select all rows from original spreadsheet -> Right Click --> COPY

2) Open new spreadsheet template. Right Click --> PASTE SPECIAL --> VALUES

3) Upload new spreadsheet into MDBilling.ca