CRM & sales / GUIDE + WORKSHEET
Clean up a CRM without losing useful history
A practical CRM cleanup checklist with a merge-decision worksheet, sample records, and checks to protect useful customer history.
THE STARTING POINT
Start with the records your team needs to make a decision, preserve the available history, and test cleanup rules on a small sample. Agree on what makes two records the same before merging anything. Then fix the forms, imports, and integrations that created the mess.
Decide what a clean record must support
Pick one workflow, such as assigning a new enquiry or preparing a renewal. List the fields that make that work possible: an accountable owner, a reliable contact method, the current status, and the next action. A populated field is not necessarily useful. Identify the person who can resolve a disputed value before launching a cleanup exercise.
Preserve history, then review a sample
Check the CRM's export, backup, merge, and recovery behavior before editing. An export may omit attachments, relationships, or activity history, so do not assume it is a full restore point. Review a small batch with the people who use the records. Treat shared inboxes, family accounts, and people who changed companies as ambiguous cases rather than automatic duplicates.
Repair the inputs that recreate the problem
Document which forms, integrations, and staff actions create records. Assign an owner to each path and agree on the identifiers it should use. After cleanup, inspect new records from those paths and compare them with your agreed rules. Track unresolved exceptions separately so a tidy dashboard does not hide a growing queue of uncertain matches.
WORKED EXAMPLE / ILLUSTRATIVE
Three records, three different decisions
A fictional service firm finds these candidate matches. Similar-looking records need different treatment because identity, history, and relationships matter more than how tidy the list looks.
| Candidate | Missing evidence | Next step |
|---|---|---|
| Two records with the same email | Whether both contain active opportunities | Review linked history before merging |
| Two people using office@example.test | Whether the inbox is shared | Keep separate people unless identity is confirmed |
| Same name, different employer | Whether the person changed jobs | Verify identity and preserve company history |
MAKE IT USEFUL
CRM cleanup worksheet
Complete one copy for a sample batch before applying rules more widely.
Your notes stay in this page and are not sent to Smithers. Download or copy them before leaving; refreshing clears them.
Before you put it to work
- Inspect linked deals, activities, and attachments.
- Have an owner decide ambiguous matches.
- Verify the result in the actual sales workflow.
- Check new records after changing the inputs.
Do not bulk-merge on name alone. Recovery and merge behavior depend on the CRM, so verify the current product documentation before making destructive edits.
IF THIS LOOKS FAMILIAR
Your tools. Your particular mess.
The worksheet is yours to use. If the difficult part is making it work with the systems you already have, that's the kind of thing we help with.