Menu

Import Claims - Upload Errors

Follow

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 were showing with: 'No services found for claim'.

Screen_Shot_2018-03-05_at_12.14.20_PM.png

To avoid this issue, copy and paste the rows from your existing spreadsheet into a new spreadsheet, 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 image.png

 

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

 image-2.png

image-3.png

 

3) Upload new spreadsheet into MDBilling.ca

 

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

0 Comments

Please sign in to leave a comment.
Powered by Zendesk