← Precedent Nonprofit Advisory

Nonprofit CRM Data Cleanup Checklist: Before You Migrate or Switch

By Adam Johns, Founder & Principal Advisor, Precedent Nonprofit Advisory · Published and last updated November 12, 2026

Short answer: Before moving to a new nonprofit CRM, back up your data, merge duplicate constituents, standardize addresses, fix households and relationships, make gift, fund and campaign coding consistent, verify recurring gift schedules, and record consent preferences. Fix these in your current system, test a sample migration, and only then load everything.

Why clean first?

A migration moves whatever is in your old database, including duplicates, inconsistent coding and broken records. Fixing problems before the move is cheaper than fixing them in the new system, and it means your first reports in the new CRM can be trusted.

The checklist

1. Back up and document

2. Duplicates

3. Addresses and contact data

4. Households and relationships

5. Gift, fund, campaign and appeal coding

6. Recurring gifts and payment data

7. Notes, attachments and history

8. Consent and communication preferences

9. Inactive and deceased records

10. Test, then migrate

Common mistakes

Common questions

Why clean donor data before migrating to a new CRM?

Migration moves whatever is in your old system, including duplicates, inconsistent coding and broken records. Cleaning first is cheaper than fixing problems after they are loaded into the new system, and it makes the new system's reports trustworthy from day one.

What should be cleaned first in a nonprofit database?

Start with duplicate constituents, then standardize addresses, households and relationships, and gift, fund and campaign coding. These affect reporting and mailings the most and are the hardest to untangle after a migration.

How long does donor data cleanup take?

It depends on record count, how many sources feed the database and how much history is inconsistent. Plan separate time for review, a test migration and corrections, and start well before your contract end date.

Should old records be deleted or archived?

Archive or flag inactive and deceased records rather than deleting them, unless policy or law requires deletion. Keep a backup of the original data before any bulk change.

Need help?

Precedent Nonprofit Advisory provides data hygiene, deduplication and backend configuration across major nonprofit CRMs, and independent CRM evaluation with no vendor commissions. See also our guide to running a nonprofit CRM RFP and Raiser’s Edge NXT alternatives. Request a discovery call or email adam@precedentnonprofit.com.