Migrate from Essential MD Software Suite to HubSpot

Patient demographics (name, date of birth, contact information) map directly to HubSpot Contact. Original patient ID preserved as Source_System_ID__c for traceability. HubSpot's contact record becomes the primary patient representation in the CRM context. This mapping ensures that all patient-facing communications, appointment reminders, and billing notifications are routed correctly within HubSpot's workflows.

Insurance carrier name, policy number, group number, subscriber ID, and eligibility status become custom contact properties on the patient Contact record. Multiple insurance plans per patient stored as multiple custom properties or as a JSON-formatted custom property for flexibility and ease of reporting.

Guarantor information (responsible party) and emergency contact details require custom contact properties since HubSpot has no native guarantor model. For family groups, we create secondary contact records linked via a custom junction object to represent household relationships. These relationships enable targeted communications and billing oversight across family members.

Appointment records split into a Task (representing the appointment task and status) and an Event (representing the scheduled time slot). Provider name maps to Task owner or a custom owner reference property. Visit type stored as a custom Task property.

Providers and physicians in Essential MD resolve to HubSpot users by email match. If the provider has no HubSpot user account, their records are flagged for admin assignment before migration. Provider specialties become custom user properties for reporting and workload distribution.

Insurance carriers map to HubSpot Companies with carrier name as Company Name and type set to 'Insurance Carrier'. This allows practices to segment reporting by payer and track patient volume per insurance carrier as company associations for revenue analysis and payer mix reporting.

Outstanding or historical billing records map to HubSpot Deals with amount representing total charges. CPT codes and billing status (paid, pending, denied) become custom Deal properties. Paid invoices may be stored as custom contact or deal properties depending on reporting needs.

Insurance claims link to the patient Contact and the insurance carrier Company. Claim status (submitted, denied, appeal, paid) maps to a custom Deal property with value mapping from Essential MD statuses to HubSpot Deal stage equivalents or custom pick-list values.

Practice service lines (general, specialty, ancillary) become custom properties on Deals and optionally on Companies. If the practice operates multiple locations, each location maps to a separate HubSpot Company for geographic segmentation. This enables revenue reporting by department and location-based performance analysis.

Any custom fields unique to the Essential MD setup (e.g., preferred pharmacy, referral source, patient notes) migrate as HubSpot custom contact properties. We flag fields that exceed HubSpot's Starter-tier property limits for potential plan upgrade discussion to ensure compliance and data integrity.

Clinical notes and appointment-specific documentation have no direct HubSpot equivalent. We preserve these as Contact notes with original timestamps and owner attribution. Practices should review whether clinical notes require PHI-safe storage outside HubSpot for HIPAA compliance and determine appropriate archiving strategies.

Patient documents and attachments stored in Essential MD re-upload to HubSpot Files and associate to the corresponding Contact record. File size limits and format compatibility checked during migration. PDF and image formats supported. We also verify that no oversized files block migration and that metadata is retained correctly.