You're pulling together a grant report. You go to your CRM for program numbers. Then you check your program tracking spreadsheet. Then you look at what you submitted in last year's report.
Three different numbers. Same metric. Same time period.
This is one of the most common and most stressful experiences in nonprofit operations. And it almost always has the same causes.
Why the numbers don't match
Different systems count differently
Your CRM might count program participants by contact record. Your program spreadsheet might count by session enrollment. Your grant report from last year might have counted by household.
None of these is wrong. They're just different. But if no one decided which method to use for this grant, and documented that decision, everyone is calculating independently and arriving at different answers.
The time period isn't defined the same way
"Q1 participants" sounds unambiguous. But does Q1 start January 1 or your fiscal year start? Does it include people who enrolled in Q4 and are still active? Does it count someone who dropped out after one session?
When these definitions live in people's heads rather than in writing, reports diverge.
Data was entered after the fact
Program staff often don't enter participation data in real time. They log it at the end of the month, or before a report is due, working from memory or paper notes. When two people are doing this independently, they'll capture different information.
The source was updated after the report was filed
Sometimes the numbers matched when you submitted, but someone cleaned up the data afterward. Duplicate records got merged. A program entry got corrected. A gift was reclassified. The live system no longer matches the snapshot you reported.
This is particularly painful during audits or multi-year grant renewals, when funders compare current numbers to what you previously reported.
Someone made a manual adjustment they didn't document
A number looked wrong, so someone changed it. The change made sense at the time. But it wasn't logged anywhere, and now the number in the system doesn't match anything else.
What to do about it
Define your metrics in writing
For every metric you report externally, document exactly how it's calculated. "Unduplicated clients served" means one thing at your organization and something different at another. Write it down: who counts, what time period, which data source, how duplicates are handled.
This document doesn't need to be long. One page covering your five or six key metrics is enough. Review it annually and when grant requirements change.
Pick one source of truth per metric
Don't let the same metric live in two places. Decide: program participation comes from the CRM, not the spreadsheet. Donor retention comes from the donor database report, not the development director's tracking sheet.
When there's only one authoritative source for each number, the question "which number is right?" has a clear answer.
Lock the data before you report
Before submitting a grant report, take a screenshot or export of the underlying data. Store it with the report. If questions come up later, you have a record of what the system showed at the time you reported.
Build a reconciliation step into your process
Before finalizing any external report, compare your numbers across sources and investigate discrepancies. Budget time for this. A 30-minute reconciliation before submission is far less painful than explaining a discrepancy to a funder after.
The bigger picture
Mismatched numbers are a symptom, not the root problem. The root problem is usually one of three things: inconsistent data entry, undefined metrics, or too many places where the same data lives.
Fixing all three takes time. But you can start with the metric that causes you the most pain, define it clearly, pick a single source, and document what you reported. That alone will reduce the stress of the next report cycle significantly.
If you want to see where your organization's data practices stand across the board, our free Nonprofit Data Health Checklist covers the areas where these problems originate most often.
If you work through it and want to talk through what you find, I'm happy to do a free 30-minute discovery call.
Joshua Barillas is the founder of Prismatic Consulting, a data services firm built exclusively for nonprofits. Learn more about our services or get in touch at hello@prismaticconsulting.us.