They had twelve Excel files. One for donors, one for volunteers, one for projects, two for grant applications and a handful of separate lists that nobody fully understood anymore. Every employee had their own version, and no one knew for certain which one was current. For a small foundation with big ambitions, this wasn’t just an inconvenient workflow: it was a risk.
When they called us, they had just missed a grant deadline because it was recorded in the wrong file. It was the last straw.
The challenge: growth without structure
Over ten years, the foundation had grown from a handful of volunteers into an organisation with multiple paid staff, dozens of active projects and a growing donor base. The work had grown with it: but the administration hadn’t.
The consequences were predictable: duplicate contact records, unclear reporting to funders, no overview of which donor supported which initiative and volunteer management that ran mainly on memory and goodwill. Every annual campaign started with weeks of manual data cleanup.
The brief was clear: “Give us oversight. Make it reliable. Make it scalable.”
The solution: Salesforce as the central nervous system
We chose Salesforce: not because it’s the most expensive option, but because for non-profit organisations it’s available through the Salesforce.org programme with ten free licences. For a foundation of this size, that’s decisive.
Together with the team we mapped out the core processes: how does a new donor come in, how are projects managed, which reports go to funders and how are volunteers linked to activities? Only then did we start building.
The implementation included:
- One centralised contact register for donors, volunteers and partner organisations
- Project management linked to donations and grants, with progress tracking per phase
- Automatic reminders for grant deadlines and reporting milestones
- Board dashboards: real-time insight into donations, project status and volunteer deployment
- A data migration bringing all twelve Excel files together: deduplicated and validated
The migration: more than technology
The technical migration was the straightforward part. The real challenge was behaviour. Staff who had worked in Excel for years needed to learn to trust a new system. We deliberately made time for that: not just training, but understanding why people did things the way they did: and reflecting that logic back into the Salesforce setup.
Two employees were appointed as internal “Salesforce ambassadors”. They received extra attention and became the first point of contact for colleagues with questions. It worked. Within six weeks of go-live, the Excel files were actively being phased out.
The result: in control of growth
Three months after launch, the director said something she had never been able to say before: “I now know exactly how many active donors we have, what our running grants are and when I need to submit what. I genuinely didn’t know that before.”
Concrete results:
- From twelve separate Excel files to one reliable system
- Grant applications are now automatically flagged for review two weeks before the deadline
- Onboarding new volunteers takes half the time it used to
- Annual reports are generated directly from Salesforce: no more manual compilation
The foundation is still growing. But now the system grows with it.
What this means for your organisation
Excel is an excellent tool: for individuals, small datasets, temporary analysis. But when it becomes the backbone of a growing organisation, it becomes a liability. Not because Excel is bad, but because it wasn’t built for collaboration at scale.
If you recognise the pattern: staff working in conflicting versions, overview depending on one person who “just knows”, reports assembled manually every single time: it’s time for a conversation. We’re happy to explore what the right next step is for your situation, even if that step isn’t Salesforce.