You are attempting to import an electronic remittance advice file, but instead of the expected payment window, you receive an "open dental ERA import error" message or the file simply fails to process. You might see a pop-up stating "Invalid file format" or "No matching claim found," leaving you unable to post insurance payments automatically in the Account Module.
Quick Fix
Most import issues stem from a simple mismatch between the file and the software settings.
- Ensure you are downloading the correct file type (usually .835 or .txt) from your clearinghouse portal.
- Verify that the file has not been renamed or modified, as the software requires the original file structure to map the data correctly.
- Try manually selecting the file again by going to Manage Module > ERA > Import ERA and ensuring the file extension matches what your clearinghouse provides.
Step-by-Step Troubleshooting
If the quick fix does not resolve the issue, follow these steps to identify the root cause.
Verify Clearinghouse Setup
Go to Setup > Family/Insurance > Clearinghouses. Select your active clearinghouse from the list. Ensure the "ERA Format" is set correctly for your specific provider. If this is set to "None" or an incorrect format, the software will not know how to read the incoming data.Check for Duplicate Files
Open Dental tracks imported files to prevent duplicate payments. If you have already imported this specific ERA file, the system will reject it. Check the Manage Module > ERA window to see if the file is already listed in the "Processed" or "Imported" tabs.Validate Claim Matching
If the ERA imports but shows "No matching claim," the information in the ERA file (such as the Patient ID or Claim ID) does not match what is currently in your database. Go to the Account Module for the patient in question, locate the claim, and ensure the "Claim Identifier" matches the information provided by the insurance carrier.Check File Permissions
If you receive a "File Access Denied" error, ensure that the user logged into Windows has read/write permissions for the folder where the ERA files are saved. Open Dental must be able to move the file to its internal storage directory after processing.
Why This Happens
An open dental ERA import error typically occurs because the electronic file contains data that conflicts with your current practice records. This can happen if the insurance carrier changed their formatting, if a claim was manually altered in the Account Module after submission, or if the clearinghouse sent a file that is missing required identifiers like the Subscriber ID or the specific Claim Number.
How to Prevent This
- Standardize Downloads: Always download ERA files directly from your clearinghouse portal rather than relying on email attachments, which can sometimes strip necessary file metadata.
- Regular Reconciliation: Process your ERAs daily. The longer a file sits in your download folder, the higher the chance of it becoming corrupted or mismatched with your current practice data.
- Keep Software Updated: Ensure you are running the latest version (currently 25.3) by going to Help > Update > Check for Updates. Newer versions often include improved parsing logic for insurance carrier file changes.
When to Contact Open Dental Support
If you have verified that your clearinghouse settings are correct and you are still receiving a specific error code (such as a "Database Connection" error or a "Null Reference Exception"), do not attempt to modify the database yourself. Call the official support line at 503-363-5432. They can examine the raw text of the ERA file to determine if the insurance carrier is sending malformed data that requires a software patch or a change in your clearinghouse configuration.
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.