The CRM Audit Checklist I Use With Every New Client

Every engagement I take on starts in the same place, regardless of the organization's size or focus: a full audit of the CRM. It's not the most exciting part of the work, but it's the foundation everything else gets built on, and skipping it means building a fundraising strategy on data nobody's actually verified. Here's the checklist I actually run through.

Data integrity, first

Before looking at any strategy, I check for the basics that quietly undermine everything downstream: duplicate donor records, missing or outdated contact information, inconsistent naming conventions (a donor logged under a business name in one place and a personal name in another), and gifts that were never properly categorized. This step is unglamorous, but a strategy built on top of messy data will misfire in ways that are hard to diagnose later.

Giving history completeness

I check whether giving history is fully and consistently recorded — not just the gift amount, but the date, the campaign or appeal it responded to, and any notes about context. Gaps here make it much harder to spot patterns later, like a donor whose giving quietly increased over several years, or one who lapsed right after a specific campaign or interaction.

Segmentation, or the lack of it

Many small nonprofit CRMs have no real segmentation beyond "donor" and maybe "board member." I check whether the database distinguishes between major donor prospects, lapsed donors, corporate contacts, grant funders, and general supporters — and if not, that becomes one of the first things I build, because strategy without segmentation is just a mailing list.

Relationship and affinity notes

This is the field most often left blank, and it's one of the most valuable when it's filled in. I check for any record of personal connections — who introduced this donor, which board member knows them, what specifically drew them to the organization. This information usually lives in someone's memory rather than the system, and getting it documented is one of the highest-value, lowest-cost fixes available.

Capacity and wealth indicators

I check whether the organization has ever done any capacity research on its donor base, and if so, whether it's actually reflected in the CRM or just sitting in someone's head or an old spreadsheet. Capacity information that exists but isn't recorded anywhere useful might as well not exist.

Communication and touchpoint history

I check whether the system tracks not just gifts, but interactions — calls, meetings, event attendance, email opens where available. A donor's giving history tells you what happened. Their interaction history tells you how engaged they actually are right now, which is often a better predictor of readiness for a bigger ask.

Reporting capability

Finally, I check whether the CRM can actually produce the reports a development function needs — a ranked prospect list, a lapsed donor report, a pipeline-by-stage view. A CRM full of good data that can't be easily queried or reported on is still a bottleneck, just a different one.

Why this comes first, every time

Every strategic recommendation I make — who to cultivate, who to re-engage, where the biggest opportunity sits — depends on this data being accurate and complete. Skipping this step to get to strategy faster almost always costs more time later, when a plan built on bad data has to be revisited.