id: migration-guide

category: onboarding

title: Migrating to ClientFlow from Another System

languages: [en]

read_time: 12

illustration: assets/illustrations/onboarding-migration.svg

demo_account:

email: demo-trainer@clientflow.center

password: DemoAccount2024!

related_docs:

- title: Quick Start Guide

url: https://clientflow.center/docs/onboarding/quick-start-guide-en.html

- title: Exporting Reports and Data

url: https://clientflow.center/docs/tutorials/export-reports-en.html

tags:

- migration

- import

- onboarding

- advanced

audience:

- beginner

- advanced

Migrating to ClientFlow from Another System

Complete guide to moving your client data, payments, and appointments from spreadsheets or other software to ClientFlow. Minimize downtime and maintain data integrity during your transition.

Introduction

Switching client management systems can feel daunting, but with the right approach, migration is smooth and painless. This guide covers migration from:

• Spreadsheets (Excel, Google Sheets)
• Generic CRMs (HubSpot, Salesforce, Zoho)
• Industry Software (Mindbody, Acuity, Pike13, WellnessLiving)
• Manual Systems (Paper records, notes apps)

Migration Timeline:

• Small Practice (< 50 clients): 2-4 hours
• Medium Practice (50-200 clients): 1-2 days
• Large Practice (200+ clients): 3-5 days

Pro Tip: Run ClientFlow in parallel with your old system for 1-2 weeks before fully switching. This validates data integrity and builds confidence.

Pre-Migration Checklist

Before starting, complete these tasks:

1. Audit Your Current Data

Review and clean up:

• [ ] Remove duplicate client records
• [ ] Standardize name formats (First Last, not FIRST LAST or first last)
• [ ] Validate email addresses (remove typos, placeholders)
• [ ] Correct phone numbers (add country codes: +1, +90, etc.)
• [ ] Archive inactive clients (not seen in 12+ months)
• [ ] Verify payment records match bank statements

Pro Tip: Clean data = clean migration. Spend 80% of migration time on data cleanup, 20% on the actual import.

2. Identify What to Migrate

Priority 1 (Essential):

• Active client contact information
• Unpaid payments and invoices
• Future appointments

Priority 2 (Important):

• Payment history (last 12 months)
• Client notes and session history
• Tags and client segments

Priority 3 (Optional):

• Old/archived clients
• Payment history beyond 12 months
• Historical appointments (completed sessions)

3. Export Data from Current System

From Spreadsheets (Excel/Google Sheets)

1. Open your spreadsheet
2. File → Download → CSV (Comma-separated values)
3. Save one file per data type (clients.csv, payments.csv, appointments.csv)

From Mindbody

1. Manager Tools → Reports → Client Reports → Client List
2. Select all fields
3. Export to CSV
4. Repeat for Sales Report (payments) and Appointments Report

From Acuity Scheduling

1. Business Settings → Import/Export
2. Export Clients (CSV)
3. Export Appointments (CSV)

From Generic CRMs (HubSpot, Salesforce)

1. Contacts → Export All Contacts
2. Choose CSV format
3. Include all properties/fields

Pro Tip: Export backups of ALL data before migration, even if you don't plan to import it all. Better safe than sorry!

4. Backup Everything

Before importing to ClientFlow:

1. Save original export files in a secure folder
2. Create a ZIP archive of all export files
3. Upload backup to cloud storage (Google Drive, Dropbox)
4. Keep backup for at least 90 days after migration

Migration Strategy: Two Approaches

Approach 1: Big Bang Migration (Recommended for < 100 clients)

Timeline: 1 day (complete switch)

Process:

1. Clean and prepare data (morning)
2. Import all data to ClientFlow (midday)
3. Verify data integrity (afternoon)
4. Turn off old system (end of day)
5. Start using ClientFlow exclusively (next day)

Pros:

• ✅ Fast switch
• ✅ No duplicate entry
• ✅ Clean break

Cons:

• ❌ Higher risk if data issues arise
• ❌ Stressful single cutover

Approach 2: Gradual Migration (Recommended for 100+ clients)

Timeline: 2-4 weeks (parallel operation)

Process:

1. Week 1: Import clients and payment history, but continue using old system
2. Week 2: Add new clients/payments to BOTH systems (dual entry)
3. Week 3: Import appointments, test reminders
4. Week 4: Verify everything works, turn off old system

Pros:

• ✅ Low risk (old system still available)
• ✅ Time to fix issues
• ✅ Staff can learn gradually

Cons:

• ❌ Slower transition
• ❌ Requires dual data entry

Pro Tip: Most successful migrations use Approach 2. The peace of mind is worth the extra week of dual entry.

Step-by-Step: Migrate Clients

Prepare Client CSV

Your CSV should have these columns:

Example client CSV:

full_name,email,phone,birth_date,notes,tags
John Smith,demo-therapist@clientflow.center,+15555551234,1985-06-15,Prefers morning sessions,vip,pt-client
Sarah Johnson,sarah@clientflow.center,+15555555678,1990-03-22,Injury: right knee,active,injury-recovery
Michael Brown,mike@clientflow.center,+15555559012,,Regular Monday 6pm client,recurring,evening

Import Clients to ClientFlow

1. Go to Clients → Import
2. Click "Download Template" (optional - see correct format)
3. Click "Choose File" → Select your client CSV
4. Map columns:

- Your "Name" → ClientFlow "full_name"

- Your "Email Address" → ClientFlow "email"

- Your "Cell Phone" → ClientFlow "phone"

1. Preview import (first 5 rows shown)
2. Click "Import Clients"
3. Wait for confirmation

Import Results:

• ✅ Imported: Successfully added clients
• ⚠️ Skipped: Duplicate emails (already exists)
• ❌ Failed: Invalid data (missing required fields)

Download the error report to fix failed rows, then re-import.

Pro Tip: Import in batches of 100 clients. Easier to identify and fix errors without redoing 500 rows.

Handle Duplicates

If import detects duplicates (matching email):

Option 1: Skip Duplicates

• Don't import if email already exists
• Use when updating existing clients separately

Option 2: Update Existing

• Overwrite existing client data with CSV data
• Use for data cleanup or field updates

Option 3: Create Anyway

• Import as new client even if email matches
• Use only if you're sure they're different people (e.g., parent and child with same email)

Pro Tip: Choose "Skip Duplicates" on first import. Fix errors, then re-import with "Update Existing" for corrections.

Step-by-Step: Migrate Payments

Prepare Payment CSV

Important: paid_at is required if status = paid

Example payment CSV:

client_email,amount,due_date,status,payment_method,description,paid_at
demo-therapist@clientflow.center,100.00,2024-03-01,paid,Credit Card,March PT Sessions,2024-03-01
sarah@clientflow.center,150.00,2024-03-15,unpaid,Bank Transfer,March + April Sessions,
mike@clientflow.center,75.00,2024-02-15,overdue,Cash,February Session,

Import Payments to ClientFlow

1. Go to Payments → Import
2. Upload payment CSV
3. Map columns (client lookup by email)
4. Choose duplicate handling:

- Skip: If same client + amount + date exists

- Import Anyway: Create even if duplicate

1. Click "Import Payments"

Pro Tip: Only import unpaid payments and last 3-6 months of paid payments. Old paid history isn't critical for day-to-day operations.

Step-by-Step: Migrate Appointments

Prepare Appointment CSV

Example appointment CSV:

client_email,date,time,duration,title,location,status
demo-therapist@clientflow.center,2024-04-15,14:30,60,Personal Training,Downtown Studio,scheduled
sarah@clientflow.center,2024-04-16,09:00,90,Injury Recovery Session,Online via Zoom,confirmed

Import Appointments

1. Go to Appointments → Import
2. Upload appointment CSV
3. Map columns
4. Choose timezone (critical!)
5. Click "Import Appointments"

Pro Tip: Only import future appointments. Past/completed appointments are historical data that clutters your calendar.

Special Cases

Migrating from Mindbody

Client Fields Mapping:

Payment History:

1. Export Sales Report (last 6 months)
2. Filter for "Completed" sales only
3. Map Item Name → description
4. Map Payment Type → payment_method
5. Import to ClientFlow

Appointments:

• Export only future appointments
• Mindbody time is in your local timezone - verify before import
• Map Service Name → title

Migrating from Google Sheets

Common Issues:

1. Name in one column (need to split)

- Use Excel formula: =LEFT(A2,FIND(" ",A2)-1) for first name

- Use: =RIGHT(A2,LEN(A2)-FIND(" ",A2)) for last name

- Or combine: full_name column acceptable

1. Phone without country code

- Add country code column: +1 (US/Canada), +90 (Turkey), etc.

- Combine: =CONCATENATE("+1", B2)

1. Date format issues

- Format column as "Date" in Google Sheets

- Download as CSV (auto-converts to YYYY-MM-DD)

1. Currency symbols in amount

- Remove $ or € symbols

- Use: =VALUE(SUBSTITUTE(A2,"$","")) to clean

Migrating from Paper Records

Process:

1. Digitize first: Type client info into Google Sheets template
2. Start with active clients: Don't waste time on inactive records
3. Prioritize contact info: Name, email, phone (skip birth dates, addresses if not critical)
4. Use mobile app: Scan business cards or intake forms with phone camera, then type into app
5. Import in batches: 10-20 clients at a time, verify each batch

Pro Tip: Hire a virtual assistant (Upwork, Fiverr) to type up paper records. Often costs $20-50 and saves hours of tedious work.

Post-Migration Verification

After importing, verify data integrity:

Client Verification Checklist

• [ ] Client count matches (old system vs ClientFlow)
• [ ] Random sample of 10 clients - verify all fields correct
• [ ] Check for duplicate clients (same person imported twice)
• [ ] Verify tags imported correctly
• [ ] Test client search by name, email, phone

Payment Verification Checklist

• [ ] Total unpaid balance matches old system
• [ ] Random sample of 10 payments - verify amount, date, status
• [ ] Check for orphaned payments (client not found - should be 0)
• [ ] Verify payment method mapping correct
• [ ] Compare revenue totals (old system vs ClientFlow Analytics)

Appointment Verification Checklist

• [ ] Count of future appointments matches
• [ ] Random sample of 10 appointments - verify date, time, client
• [ ] Check timezone (appointments should be in YOUR local time)
• [ ] Verify appointment statuses correct
• [ ] Test calendar sync (if using Google Calendar integration)

Pro Tip: Export data from ClientFlow and compare side-by-side with original export. Spot-check 5-10% of records for accuracy.

Common Migration Issues

Issue 1: Import Fails with "Invalid Email"

Cause: Email addresses have typos or placeholders

Fix:

1. Download error report
2. Fix emails in original CSV
3. Re-import fixed rows

Common errors:

• john@@clientflow.center (double @)
• john@examplecom (missing .)
• N/A, none, unknown (placeholder, not real email)

Issue 2: Phone Numbers Don't Import

Cause: Missing country code or invalid format

Fix:

1. Add country code: +1 for US/Canada, +90 for Turkey, +44 for UK
2. Remove spaces and dashes: 555-123-4567 → 5551234567
3. Combine: +15551234567

Issue 3: Clients Import But Payments Don't Link

Cause: Email in payment CSV doesn't match client email

Fix:

1. Download payment import error report
2. Look for "Client not found" errors
3. Verify email spelling matches exactly (case-sensitive in some systems)
4. Update payment CSV with correct email
5. Re-import

Issue 4: Dates Import as Numbers (Excel)

Cause: Excel converts dates to serial numbers (e.g., 44562)

Fix:

1. Select date column in Excel
2. Format Cells → Date → YYYY-MM-DD
3. Re-save CSV
4. Re-import

Issue 5: Appointments Import in Wrong Timezone

Cause: ClientFlow timezone setting differs from old system

Fix:

1. Check Settings → Regional → Timezone
2. If wrong, update timezone BEFORE importing appointments
3. Delete imported appointments
4. Re-import with correct timezone

Pro Tip: For timezone confusion, create ONE test appointment. Verify it shows correct time in ClientFlow and Google Calendar. Then import the rest.

Training Your Team

If you have staff using the new system:

Week Before Migration

• [ ] Share this migration guide with team
• [ ] Create demo accounts for practice (use demo-trainer@clientflow.center)
• [ ] Hold 30-minute training session covering:

- How to add clients

- How to record payments

- How to schedule appointments

- How to send reminders

Day of Migration

• [ ] Import data (admin only)
• [ ] Verify data (admin + one staff member)
• [ ] Give team access to ClientFlow accounts
• [ ] 15-minute walkthrough of actual client data (not demo)

First Week After Migration

• [ ] Daily check-ins (10 min) to answer questions
• [ ] Document common questions in internal wiki/doc
• [ ] Monitor for duplicate entries (staff creating records that already exist)

Pro Tip: Assign one staff member as "ClientFlow Champion" - they get advanced training and become the go-to person for questions.

Parallel Operation Best Practices

If running both systems simultaneously:

Dual Entry Rules

Old System (Weeks 1-2):

• ✅ Continue normal operations
• ✅ Primary source of truth

ClientFlow (Weeks 1-2):

• ✅ Add new clients
• ✅ Add new payments
• ✅ Add new appointments
• ⚠️ Secondary system (learning mode)

Week 3+:

• ClientFlow becomes primary
• Old system in read-only mode
• Refer to old system only for historical lookup

Daily Checklist During Parallel Operation

• [ ] Add new clients to BOTH systems
• [ ] Record payments in BOTH systems
• [ ] Schedule appointments in BOTH systems
• [ ] Compare daily totals (new clients, revenue) between systems
• [ ] Document any discrepancies

Pro Tip: Set a hard cutoff date (e.g., "March 31 is last day of dual entry"). Stick to it. Otherwise, dual entry drags on for months.

Final Cutover

When you're ready to switch fully to ClientFlow:

Day Before Cutover

• [ ] Export final backup from old system
• [ ] Compare totals: clients, unpaid balance, appointments
• [ ] Notify team: "Tomorrow we go ClientFlow-only"
• [ ] Update email templates with ClientFlow branding

Cutover Day

• [ ] Turn off automatic reminders in old system
• [ ] Enable automatic reminders in ClientFlow
• [ ] Update website booking link (if applicable) to ClientFlow
• [ ] Change email signature to mention ClientFlow (optional)
• [ ] Celebrate! 🎉

First Week After Cutover

• [ ] Monitor for missed appointments (reminder issues)
• [ ] Check for payment collection issues
• [ ] Survey team on any confusion/questions
• [ ] Keep old system credentials handy (read-only access for 30 days)

Pro Tip: Don't delete old system data immediately. Keep read-only access for 90 days, just in case you need to verify historical data.

Migration Checklist Summary

Print this checklist and check off each item:

Pre-Migration

• [ ] Audit and clean current data
• [ ] Export data from old system
• [ ] Backup all export files
• [ ] Sign up for ClientFlow account
• [ ] Configure business settings

Migration

• [ ] Import clients
• [ ] Verify client data
• [ ] Import payments
• [ ] Verify payment data
• [ ] Import appointments
• [ ] Verify appointment data

Post-Migration

• [ ] Run comparison reports
• [ ] Train team on ClientFlow
• [ ] Parallel operation (1-2 weeks)
• [ ] Final cutover
• [ ] Monitor first week closely

30 Days After Migration

• [ ] Delete old system (optional)
• [ ] Archive old system backups
• [ ] Document lessons learned
• [ ] Optimize ClientFlow workflows

Migration complete! Welcome to ClientFlow.

Getting Help with Migration

Migration Support

Free Tier: Email support (support@clientflow.center, 24-48 hour response)

PRO/Team Tier:

• Priority email support (4-hour response)
• Live chat support
• Screen sharing session for complex migrations

Enterprise (100+ clients):

• Dedicated migration specialist
• Custom import scripts for complex data
• Team training session (1 hour)

Pro Tip: If migration feels overwhelming, upgrade to PRO for one month to get priority support. Downgrade after successful migration if needed.

Next Steps

Migration complete! Optimize your ClientFlow setup:

1. Quick Start Guide - Post-migration configuration
2. Appointment Scheduling Mastery - Set up reminders and automation
3. Creating Your First Intake Form - Collect new client info professionally
4. Organizing with Tags - Segment your imported clients

Congratulations on a successful migration!