Skip to content

How to Migrate Your MCA CRM Off Centrex or Spreadsheets

Moving an MCA shop to a new CRM is mostly a data problem, not a software problem. The new system is usually ready in days. What takes time is getting a clean export, deciding which fields matter, and switching over without losing a deal that was halfway through underwriting.

This checklist is for broker and ISO shops leaving Centrex, another MCA platform, or a Google Sheet or Excel file. It works whichever CRM you're moving to. Centrex terms are quoted from its own billing policy, read October 24, 2026. If you're a broker shop still picking where to move, our top pick is Ferrylend, because its team imports your data for you as part of setup, and that setup fee is waived for workspaces created through December 31, 2026.

Here's the TLDR:

  1. Read your exit terms first. Centrex exports your data only after final payment and a signed cancellation form, so plan for an overlap.
  2. Move live work, archive the rest. Open deals, merchants, lenders, unpaid commissions and renewal candidates move. Closed history can stay in a read-only archive.
  3. Map fields and statuses on paper before you import anything.
  4. Test with 20 rows, then do one full import and a short delta on cutover day.
  5. Our pick for broker shops: Ferrylend. Its team imports your data as part of setup, and its own import handles CSV and XLSX with column mapping, saved presets and duplicate detection. It doesn't run ACH servicing or syndication, so funders need a servicing platform.

Step 1: Read your current vendor's exit terms

Before you tell anyone you're leaving, find out how leaving works. For Centrex, the published billing policy sets out four things that affect your timeline:

  • Export after payment. "Data will be exported to you once we have received your final payment and the signed cancellation form."
  • Final invoice. On cancellation you get a prorated final invoice, and your card is charged immediately.
  • Add-ons. Monthly "enhancement" fees aren't prorated. To cancel one, you must ask by the 5th of the billing period or owe the full month.
  • Per-user billing. You're billed in arrears for "every user that has logged into the system at least once for the prior month."

What this means in practice: you won't have Centrex's export in hand until after you've cancelled. So pull everything you can yourself while you're still a customer. Ask Centrex support which reports and exports your account can run, and note that Centrex publishes an API with endpoints for contacts, lenders, transactions, documents, loans and advances, which a developer can use while your account is active. Time any add-on cancellations for before the 5th.

Other platforms have their own catches. OrgMeter's SaaS agreement runs for a year and auto-renews unless you give notice at least 60 days before it ends. Cloudsquare's auto-renews unless either side gives 30 days' notice. Check your own contract, not just the website. Our Centrex explainer covers its modules and billing in more detail.

Step 2: Decide what moves and what stays behind

You don't need to move everything. Moving ten years of dead leads just fills the new system with duplicates. A practical split:

DataMove as live records?Why
Open deals (app in through offers)YesReps work these daily
Merchants funded in the last 12 to 18 monthsYesRenewal candidates
Lenders, contacts and their criteriaYesMatching and submissions depend on them
Commissions expected but not receivedYesMoney still owed to you
Leads worked in the last 90 daysYesStill in follow-up
Older leads and declined dealsOptional, as one importUseful for duplicate checks
Closed deal history, signed contracts, old emailsArchiveReference only

Vendors say the same. Ferrylend's homepage notes that "documents, signed contracts and servicing history usually stay in your old system for reference." If you're cancelling the old system, that means saving a full export to storage you control before access ends.

Step 3: Clean the spreadsheet (or the export)

Spreadsheet shops have an advantage: you already have the data. The work is making it consistent. Before you import:

  • One row per deal, one header row, no merged cells or color-only statuses.
  • Split the business from the owner. Legal name, DBA and EIN in one set of columns; owner name, phone and email in another.
  • One date format across the file, and plain numbers in money columns (no "$60k").
  • Pick one spelling per lender. "Kapitus", "kapitus " and "Kapitus LLC" become three lenders on import.
  • Remove exact duplicates, then sort by business name and scan for near-duplicates.

Step 4: Map your fields

Write the mapping down in a two-column sheet: old field, new field. The fields most MCA shops need to carry over:

GroupFields
BusinessLegal name, DBA, EIN, state, industry, time in business, monthly revenue
OwnerName, phone, email, ownership %, credit range
DealRequested amount, stage, rep, lead source, date created
SubmissionsLender, date sent, status, decline reason
Offer / fundingFunded amount, factor rate, payback, payment, frequency, funded date
MoneyCommission points, expected commission, received date, splits

Statuses need their own crosswalk. Your old "Sent out" might be the new system's "Submitted"; "Dead" might split into "Declined" and "Lost". Settle these before import so reports make sense from day one. Handle SSNs and bank account numbers deliberately: import them only into fields the new CRM encrypts and masks, never into a free-text notes field.

Step 5: Decide how deal history comes across

For funded deals, you need enough to track commissions and renewals: funded date, amount, payback, payment and frequency, plus any payments recorded so far. For notes and activity, most imports can't recreate a timeline. The usual workaround is a single "Migration notes" field per deal holding the last few notes, with the full history in the archive.

Step 6: Move documents for open deals only

Bank statements, applications and IDs for open deals should follow the deal. Name files consistently (business name, document type, month) so they can be attached in bulk or by hand. Everything else goes into the archive, organized in folders by merchant. These files hold sensitive data, so keep the archive somewhere with access control, not a shared personal drive.

Step 7: Run a test import

Import 20 rows that include your weirdest cases: a deal with two owners, a renewal, a declined file, a deal with three lender submissions. Then check that dates, amounts, statuses and lender names landed where you expect. Fix the mapping, delete the test records and import the full file. Good import tools help here: Ferrylend's CSV and XLSX import has column mapping, saved presets and duplicate detection, and Fundara says it imports "contacts, deals, and documents" from Centrex, HubSpot or a spreadsheet as part of its build-out.

Step 8: Cut over

  1. Pick a cutover day early in the week and tell reps the old system becomes read-only that morning.
  2. Run a delta export of anything created or changed since the full import, and import it.
  3. Repoint your inflows: website forms, lead vendor deliveries, application links and the reply-to address on submission emails.
  4. Check the counts: open deals, funded deals and expected commissions should match the old system.
  5. Rebuild the renewal list from funded deals and confirm the top ten by hand.
  6. Remove old logins for reps who no longer need them. On Centrex, anyone who logs in during a month is billed for it.
  7. Cancel only after you've saved the archive, and keep the final export with your records.

Who does the migration for you

Several vendors include migration help, which is worth asking about when you compare them (it's one of the questions in our guide to choosing an MCA CRM):

  • Ferrylend says "We import your data for you", as part of setup and onboarding. That $999 fee is waived for workspaces created through December 31, 2026. It's a newer broker CRM, and it doesn't run ACH servicing or syndication, so it isn't a full Centrex replacement for a funder. See how Ferrylend positions itself against Centrex.
  • Onyx IQ (for funders) says teams can migrate data and configure core workflows within two weeks.
  • MCA Track (for funders) says its onboarding team handles data migration.
  • NextLevel MCA offers help moving active deals from another MCA platform.
  • LendingWise says migration is "typically" an additional fee if its import tool doesn't fit; the amount isn't published.

For the full list of where Centrex customers go, see our Centrex alternatives comparison and the best MCA CRM roundup.

FAQ

How long does a CRM migration take for a small broker shop?

It depends mostly on how clean your data is, not on the software. Vendors that do it for you quote anywhere from days (MCA Track) to two weeks (Onyx IQ). Plan for a longer overlap if your old vendor only exports after cancellation.

How do I get my data out of Centrex?

Per Centrex's billing policy, data is exported after it receives your final payment and a signed cancellation form. Pull what you can yourself before cancelling, and ask support what's included.

Should I migrate closed deals?

Move funded deals recent enough to renew, plus anything with unpaid commission. Archive the rest unless you need it for duplicate checks.

Can I run the old and new CRM side by side?

For a few days, read-only. Longer than that and reps update both, and the data splits. Pick a cutover day and stick to it.

Get the export terms in writing first, and the rest of the migration is a checklist.

Disclosure: Ferrylend is made by Digital Mundo, a separate company with the same owner as Gold Penguin. We rank it first, and we've kept its drawbacks in plain view.

Some links on Gold Penguin are affiliate links. If you buy through them we may earn a commission, at no extra cost to you. How we make money

Related reviews

More like this

Get new reviews by email

One email a month: new reviews, price changes and the benchmark. Unsubscribe any time.