How to find and fix duplicate charts in an EHR migration
Find and fix duplicate client charts during an EHR migration by searching exports for matching name, date of birth and medical record number, choosing one surviving chart, and re-linking notes, appointments and balances to that chart before cutover.
- A duplicate chart is a second record for the same person, often created by a typo, a name change or a new intake.
- Detect candidates in the old EHR and in exports by matching name, date of birth, phone, email or medical record number.
- Merge or retire extras in the old system when you can, pick one surviving chart, and re-link notes, appointments and balances before the final export.
What is a duplicate chart?
A duplicate chart is a second client record for the same person. It is the same idea as a duplicate client record in the glossary: two charts that should be one. Duplicates raise client counts, split notes and appointments, and show up as gaps on the reconciliation report. Fix them during data cleanup before migration, before you decide which inactive and discharged clients to migrate.
How do duplicates show up in exports?
Exports often list each chart as its own row or folder. You may see:
- Two client IDs with the same legal name and date of birth
- The same phone or email on two charts with slightly different spellings
- Notes or appointments split across both charts
- One chart active and another marked inactive or discharged for the same person
Treat export rows as clues, then confirm in the live old EHR before you merge or retire a chart.
How do you detect duplicate charts?
Step 1: Pull a client roster from the old EHR
Export or report every client with client ID, legal name, preferred name, date of birth, phone, email, medical record number if you use one, and status. Keep the file your cleanup owner works from.
Step 2: Sort and match on strong keys
Sort by date of birth, then last name. Flag pairs that share date of birth plus a close name, the same phone or email, or the same medical record number. Review fuzzy name matches by hand; do not auto-merge on name alone.
Step 3: Confirm each pair in the old EHR
Open both charts. Check intake date, last visit, notes, appointments, balances and who created the second chart. Decide whether they are the same person or two different people who look alike.
Step 4: Choose the surviving chart
Keep the chart with the fuller clinical history, the correct legal name and the balance and appointments you want in the new EHR. Document the retired chart ID so staff can find it during the parallel run.
Step 5: Re-link notes, appointments and balances
Before cutover, move or merge so the surviving chart holds the notes, documents, appointments and opening balance you will migrate. Follow how to move appointments between EHRs and how to move client balances between EHRs once one chart owns the history.
Step 6: Re-count before the test export
After merges, re-run client counts by status and compare with your migrate-versus-archive list. Then request or refresh the test export so the sample migration uses the cleaned roster.
What should you re-link before cutover?
On the surviving chart, confirm:
- Clinical notes and documents from both charts
- Past and future appointments, including recurring series
- Insurance policies and referral source if those fields matter for billing
- Opening balance and any credits that belonged to the retired chart
If the old EHR cannot merge, list the duplicate pairs for the migration partner so the field mapping can say which ID survives in the new system.
What to watch for
- Two charts for the same person that both still receive appointments after cleanup.
- A merge that drops notes or documents because the wrong chart was kept.
- Preferred name or legal name mismatches that make two people look like one.
- Counts on the reconciliation report that still show both IDs.
Frequently asked questions
Should you merge duplicates in the old EHR or after import?
Merge or retire them in the old EHR whenever the system allows, so the final export has one chart per person. Only map survivor rules in the new system when the old EHR cannot merge.
What if two charts are the same person but both have recent notes?
Keep the chart with the fuller history as the survivor, move or copy the recent notes onto it before the final export, and stop staff from writing to the retired chart.
Do middle-name or hyphen differences count as duplicates?
They are candidates only. Confirm with date of birth, contact details and visit history before you merge.
Does Ferry merge duplicate charts for you?
Ferry can follow a written survivor list you provide and call out remaining duplicates on the reconciliation report. Your team still chooses the surviving chart and finishes cleanup in the old system when it can.
For the full project from inventory to archive, see the EHR data migration guide.
How Ferry helps
Ferry migrates data between behavioral health EHRs at a fixed price, with a reconciliation report for every record type. Get a migration quote.