Troubleshooting Open Dental ERA Import Errors

You click the "Import" button in the Electronic Remittance Advice window, but instead of seeing your payments, you receive an "open dental ERA import error" message or the window simply remains blank. You might see a specific error stating "Invalid file format" or "No claims found for this ERA," preventing you from automatically posting insurance payments to patient accounts.

Quick Fix

1. Check your Clearinghouse connection: Go to Setup > Family/Insurance > Clearinghouses. Ensure your primary clearinghouse is selected and the "Export Path" and "Import Path" are correctly mapped to your local or network folders.
2. Verify the file format: Ensure the file you are trying to import is an actual .835 or .era file provided by your insurance carrier or clearinghouse. If you accidentally downloaded a PDF or a text summary, Open Dental will not be able to process it.

Step-by-Step Troubleshooting

If the quick fix didn't resolve your open dental ERA import error, follow these steps to diagnose the issue.

1. Verify Clearinghouse Setup: Go to Setup > Family/Insurance > Clearinghouses. Select your clearinghouse from the list. Ensure the "ERA Receiver" is set correctly for your specific carrier. If this is blank or set to "None," Open Dental does not know how to parse the incoming data.
2. Check the Import Folder: Navigate to the folder defined in your Clearinghouse setup as the "Import Path." Open this folder in Windows File Explorer. If the file is not there, you may need to log into your clearinghouse portal manually to download the latest remittance file.
3. Validate the Payer ID: Open the ERA window by going to Manage > Electronic Remittance Advice. If you see the file listed but it fails to import, click on the file and check the "Payer ID." If the Payer ID in the file does not match the Payer ID listed in your Setup > Family/Insurance > Insurance Carriers for that specific insurance company, the system will reject the import. Update the Payer ID in the carrier setup to match the file.
4. Check for Duplicate Imports: Open Dental tracks which ERAs have already been processed. If you are trying to re-import a file that has already been marked as "Processed" in the ERA window, the system will prevent a duplicate import. Look at the "Status" column in the ERA window to see if the file has already been handled.

Why This Happens

An open dental ERA import error usually occurs because of a mismatch between the data provided by the insurance carrier and the configuration within your software. The ERA file (an 835 transaction) is a highly structured text file. If the Payer ID, the NPI, or the Tax ID in the file does not perfectly match the information stored in your Insurance Carriers or Provider setup, Open Dental cannot safely link the payment to the correct patient or claim, so it halts the import to prevent data corruption.

How to Prevent This

1. Standardize Carrier Setup: Regularly audit your Insurance Carriers list to ensure Payer IDs are accurate and consistent.
2. Use the Clearinghouse Portal: Instead of relying on email notifications, log into your clearinghouse portal weekly to ensure all ERAs are being delivered to the correct folder.
3. Keep Software Updated: Ensure you are running the latest stable version (currently 25.2 or 25.3) by going to Help > Update. Newer versions often include updated parsing logic for insurance carrier file formats.

When to Contact Open Dental Support

If you have verified that the file exists, the Payer ID matches, and you are still receiving a "Parsing Error" or a "Database Exception" when attempting to import, do not attempt to modify the database manually. Call the official support team at 503-363-5432. They can examine the raw text of the 835 file to determine if the insurance carrier has changed their file format, which may require a software patch or a change in your clearinghouse settings.

Need better visibility into your Open Dental data? DentalCanvas gives you a visual dashboard — no SQL required.

This article is provided by opendentalsupport.com, an independent community resource. We are not affiliated with Open Dental Software, Inc.