Migrate from Open Dental to Zoho CRM

Open Dental Patient records map to Zoho CRM Contacts. Demographics (name, DOB, address, phone, email) transfer directly. Original PatNum is stored as Source_PatNum__c for reconciliation. Patients with active treatment plans or recent appointments land as Contacts; archived or inquiry-only records can be mapped to Leads based on appointment history.

Open Dental patients who have never booked an appointment or have no active treatment plan are routed to Zoho CRM Leads rather than Contacts. The split rule uses appointment history: if PatNum has zero completed appointments, the record creates a Zoho Lead. This keeps the Zoho pipeline clean for practices that use Open Dental for lead capture.

Open Dental Provider records (ProvNum, FName, LName, Specialty) map to Zoho CRM Users. Matching is done by email address. If a Provider has no email in Open Dental, the migration creates a placeholder Zoho User with the provider abbreviation; your admin assigns records to a real user before go-live.

Open Dental appointments carry OpNum, ProvNum, AptStatus, Pattern (duration in 5-minute increments), and Confirmed status. Zoho CRM native Events store Subject, StartDateTime, EndDateTime, Location, and Description. We transform Open Dental appointments into Zoho Events, storing provider as the Event owner, operatory as Location, and appointment status in a custom Status field. Pattern-based duration is converted to end time in Zoho's datetime format.

Open Dental ProcedureLog records (ProcCode, ToothNumber, Surf, Fee, InsPay, Copay, ClaimProcStatus) have no Zoho native equivalent. We create a custom module named Procedure_History__c with fields for procedure code, tooth surface, provider, fee, insurance payment, patient responsibility, and claim status. The parent Contact lookup ties each procedure to the patient record.

Open Dental InsPlan stores CarrierName, SubscriberID, GroupName, GroupNum, and benefits (deductible, maximums, co-insurance percentages). Zoho CRM has no insurance module. We create a custom Insurance_Plan__c module linked to the Contact (subscriber) via a lookup relationship, storing carrier name, group number, subscriber ID, and a serialized benefits JSON or individual custom fields for key benefit limits.

Open Dental PatPlan is the per-patient insurance enrollment record linking a Patient to an InsPlan. We link the Zoho Contact to the corresponding Insurance_Plan__c record using the Zoho lookup field. Coverage percentages and effective dates stored as custom fields on the Insurance_Plan__c record.

Open Dental Claim records track ClaimStatus, ClaimType, PriInsPaid, SecInsPaid, and associated ProcNums. We create a custom Claim__c module linked to the Contact and Insurance_Plan__c. Claim status (Sent, Received, Received as Exception, ClaimPay) migrates as a custom pick-list field; total paid amounts and procedure references are stored as currency and multi-line text fields.

Open Dental PatFields use FieldName and FieldValue with types Text, PickList, Date, Checkbox, and Currency. Zoho CRM custom fields support all these data types. We audit all PatFieldDef records, create matching Zoho CRM custom fields on the Contact module (e.g., Insurance_Status__c as picklist, Last_X-Ray__c as date), and migrate FieldValue data. PickList PatFields require value-by-value mapping if the Open Dental picklist values differ from Zoho picklist options.

Open Dental Document records (images, PDFs, scanned forms) linked to patients can be exported and re-uploaded to Zoho CRM as file attachments on the Contact record. Large imaging files (panoramic X-rays) are flagged for separate handling; per Open Dental's own docs, most X-ray systems are bridged rather than stored directly.

Open Dental family grouping uses a Guarantor relationship where the family head is responsible for billing. Zoho CRM has no family or guarantor model. We create a Guarantor_Name__c custom field on Contact and a Family_ID__c field to surface family grouping, so billing responsibility is visible on each family member's contact record even without a true parent-child relationship.

Open Dental Payment records (PayNum, PayType, PayAmt, PayDate, PaySource) and associated PaySplits tie payments to procedures and providers. Zoho CRM has no native payment or accounting module. We create a Payment__c custom module linked to the Contact and Procedure_History__c, storing payment type, amount, date, and provider as custom fields.