Reconciling donations ate up our whole month

This is one of the cases that taught us the most. A children's nonprofit that depends on tens of thousands of people and receives gifts through many channels: bank transfers, online payments, credit cards and automatic monthly deductions. Each channel delivered its own file, in its own format.

What it was like before

Every month, someone on the team downloaded the files from each bank and each payment method and matched them by hand in spreadsheets. A good part of the fundraising work was just that: copying, searching, comparing, correcting. Most of the process was manual.

The hardest part wasn't the time. It was the questions nobody could answer. Who gave this month? How much? Through which channel? And the question that matters most in an organization that lives on its donors: who stopped giving?

When a donor stops giving, every week counts. If you find out in time, you can call them, understand what happened, maybe win them back. If you find out three months later, when you finally reconcile the spreadsheets, it's too late.

The organization had tried to fix this before. It was paying for a very complete donor management system, the kind built for much larger organizations. But there was so much to set up and learn that the team ended up going back to its spreadsheets. The system was there, paid for and nearly empty.

What we did

We didn't start by choosing a tool. We started by sitting down with the people who did the reconciliation every month and looking, file by file, at how they did it. That's almost always where the answer is.

The fourth step looks like a detail, but it was key. A sudden change is scary, and rightly so: if something fails in fundraising, the organization feels it right away. Keeping the bridge gave the team time to trust the new system before letting go of the old one.

What changed

Closing the month stopped being a job that took days. And since the team no longer spends its time chasing files, it uses that time to talk with donors. The organization made its fundraising 70% faster.

But if you ask us what mattered most, it isn't any of those numbers. It's that today the team knows, every month, who stopped giving. And it can do something about it while there's still time.

What we took away

Many organizations believe their donation problem will be solved by a bigger system. Sometimes it's the opposite: what's missing is something smaller, the right size, that the team actually uses. A tool nobody opens doesn't organize anything, no matter how good it is.

We also learned that history matters. Bringing in ten years of donations was the longest part of the project, and the most valuable. Without that history, the dashboard would have shown only the present. With it, it shows trends: who has given for years, who started to slip, which channel is growing.

If closing the month on donations takes days at your organization, it's not for lack of effort from your team. It's that the data is scattered, and that can be fixed.