Acquisition Data Migration

You bought the firm. Now get their clients into your Salesforce without losing a single household.

For RIAs and wealth advisories that acquire. The seller’s Redtail, Wealthbox, or spreadsheet book lands in your Salesforce org clean, de-duplicated, and advisor-ready on a fixed fee per acquisition, in weeks, not quarters.

~6 / yearAcquired firms currently migrated annually for a multi-office wealth advisory
20 yearsIn the Salesforce ecosystem, 8x certified, Financial Services Cloud specialist
Fixed feeQuoted from the source inventory before you commit. No hourly surprises mid-deal.
Redtail → FSCPurpose-built tooling for the migration most sellers bring you

What the seller’s export won’t tell you

The contact list is the easy part. Everything around it is where acquisitions bleed.

A Redtail backup looks complete until you load it. Here is what’s actually missing or broken in the typical seller handoff, and what has to be rebuilt before the acquired advisors can work in your org.

01 · HOUSEHOLDS

Households are labels, not records

Redtail links spouses with a tag. Your Salesforce needs real Household accounts, person accounts, and relationship records, or every review meeting starts with “which one is the husband?”

02 · EMAIL HISTORY

Years of client email live in a separate archive

The standard export leaves email behind in a Zimbra archive. If nobody retrieves and re-attaches it, the acquired advisors lose the paper trail your CCO will ask for.

03 · DUPLICATES

10–30% of the seller’s book overlaps or repeats

Duplicates inside the seller’s data, plus clients and COIs you already have. Loading without a match pass means two of everything and a cleanup project nobody budgeted.

04 · NOTES

Notes arrive as a wall of HTML

Decades of meeting notes come through wrapped in markup and bad line breaks. Unreadable notes get ignored, and ignored notes are lost context on day one.

05 · ACTIVITIES

Future recurrences and ownership drop out

Recurring reviews, open tasks, and who-owned-what are the first things to vanish in a flat export. They are also the first things advisors notice.

06 · DOCUMENTS

Imaging and attachments ship separately, if at all

Client documents are a separate pull with their own retrieval rules. They need to end up on the right household, not in a shared drive called “Old CRM.”

What you get, per acquisition

A fixed-scope migration your ops lead, your advisors, and your CCO can each sign off on.

Every engagement delivers the same checklist, which is exactly why the second acquisition goes faster than the first.

How it works

From signed LOI to advisors live in about four weeks.

The timeline assumes a typical single-practice acquisition on Redtail or Wealthbox. Larger books and legacy Salesforce orgs get their own schedule in the inventory report.

WEEK 0

Kickoff

You send the LOI date and the seller’s CRM. I send the seller a one-page data request so the handoff happens once, not six times.

WEEK 1

Inventory

Full source analysis, email archive retrieval, duplicate scan against your book. You get the gap report and the fixed fee.

WEEKS 2–3

Clean, map, stage

Households rebuilt, notes cleaned, fields mapped, everything loaded and reviewed in a sandbox first. Your team approves the merge file.

WEEK 4

Load and validate

Production load in strict dependency order, counts reconciled, ownership and activities assigned, reconciliation report delivered.

DAY 1

Advisors live

The acquired team opens Salesforce and finds their clients, their notes, and their next review. The 30-day fix window starts.

Your options

Why serial acquirers stop doing this with whoever is available.

Vendor “free migration” Implementation partner Your ops team SMC Migrations
Households Contacts only; households not rebuilt Rebuilt, billed hourly Manual, after hours Rebuilt with purpose-built tooling
Duplicates vs. your book Not done Scripted if scoped Spreadsheet VLOOKUP Matched, reviewed, merged
Email, notes, documents Usually excluded Extra scope Often abandoned Retrieved and attached
Timeline Fast, incomplete 8–16 weeks Whenever it fits About 4 weeks
Pricing Free, then cleanup Hourly, open-ended Hidden in salaries Fixed fee per acquisition
Next acquisition Start over Start over Start over Same playbook, faster

Industry benchmarks: scripted Redtail-to-Salesforce migrations typically run 100–200 developer hours, and partner timelines run 8–16 weeks. Destination-vendor migrations generally do not de-duplicate or carry files and workflows.

Built for firms that keep acquiring

The playbook gets faster every deal. So should your migration.

Annual acquisition program

For firms doing three or more deals a year: a standing arrangement with a per-acquisition fee, a reserved start slot when each deal closes, and one person who already knows your org.

Seller intake kit

A one-page data request and checklist you hand the seller at LOI, so the export you receive is the export you need. Fewer follow-ups, faster close-to-live.

Your org, hardened for the next one

Each migration leaves behind documented field maps, duplicate rules, and household conventions, so acquisition five takes less of your team’s time than acquisition one.

“Data migration is the scariest part of an acquisition for everyone in the room. It’s my favorite part.”

Elise Pottinger, SMC Migrations

Elise Pottinger, Salesforce data migration architect
Who does the work

One architect. Not a bench of juniors learning on your deal.

Elise Pottinger has spent 20 years in the Salesforce ecosystem as a solution architect, business analyst, and the person partners call when the data part of an implementation is going sideways. She specializes in Financial Services Cloud for wealth management firms, teaches Salesforce data migration to implementation consultants, and runs the Salesforce Masterclass YouTube channel.

She is currently the standing migration partner for a multi-office wealth advisory that acquires around six firms a year, and has run the same playbook for an Indiana advisory folding acquired practices into Salesforce. The tooling she uses for household reconstruction, note cleanup, and Redtail email retrieval was built for exactly this job.

Questions acquirers ask

The fine print, in plain English.

What CRMs can the seller be on?
Redtail and Wealthbox are the most common and have the most purpose-built tooling. Spreadsheets, Outlook-only practices, legacy Salesforce orgs, and most other advisor CRMs are also in scope; the inventory report will say exactly what can be recovered from each.
Does our Salesforce need to be Financial Services Cloud?
No. FSC gets the richest household and relationship model, and most acquirers at this stage are on it. Sales Cloud orgs with a custom household design work too; the field map is built to your org, not a template.
How do you handle client data and privacy?
Work happens in your sandbox and production under an NDA and a signed data-handling agreement. Client PII is never pasted into public AI tools; the cleanup tooling runs locally or in your environment. Your CCO gets the reconciliation report and a description of where the data traveled, which is increasingly what examiners ask for.
What if the seller is slow or uncooperative with the export?
That is why there is a seller intake kit. Most sellers are not hostile, they are busy and have never done this. A one-page request with exact steps for their CRM, sent at LOI, resolves most of it. When it doesn’t, I get on the call with them.
How soon after the deal closes can advisors be live?
About four weeks from receiving the seller’s data for a typical single-practice book. If you send the LOI date early, the inventory can be done before close so the production load lands in the first week.
How is the fee set?
Fixed, per acquisition, quoted from the inventory report before you commit. It scales with record volume and complexity (email archive, documents, legacy Salesforce org), not with how many hours it takes. Firms doing several deals a year get an annual program rate.
Can you train our ops team to do this ourselves?
Yes, and some firms do both: I run the first two or three while your admin shadows, then your team takes over with the documented playbook and I stay on call for the ugly ones.

Have a deal closing?

Send the LOI date. I’ll send the seller data request and a fixed fee.

Twenty minutes on a call is enough to tell you what the seller’s export will and won’t contain, and roughly what it will take to land it in your org.