Success Story: a transformative journey
with fund 360
vancouver foundation
For more than 80 years, Vancouver Foundation has connected donors, charities, and community partners to drive meaningful change across British Columbia. As one of Canada’s largest community foundations, they juggle a complex mix of fund management, grantmaking, donor engagement, and financial operations, all while continuing to grow their impact across the province.
But as the organization grew, the systems supporting that work were starting to hold them back.
The challenge
For 25 years Vancouver Foundation ran its core finance and fund accounting on Foundation Power. The platform had been reliable, but it was increasingly struggling to keep pace with the Foundation's growing needs.
Finance teams were buried in spreadsheets, manual reconciliations, and exported reports just to get through everyday tasks. Data was scattered across systems, pulling a report often meant looping in IT, and staff spent significant time cleaning up information outside the system. “We had to do a lot of manual entry, a lot of extracting data, not trusting what’s in the system. So just a lot of extra steps” said Laura Wren, Senior Manager of Finance.
Meanwhile, the Foundation had been building out Salesforce in other parts of the organization. Donor services and grants management were already moving onto the platform, but finance remained the missing piece. That gap created silos between teams and made it hard to get a complete picture of the organization's data. “Finance was really the backbone that still needed to be addressed before we could move forward with other strategic projects” said Balraj Kalkat, Director of Financial Planning & Analysis.
The situation on the IT side wasn't much easier. The environment ran on on-premise servers, Citrix virtual desktops, and fragile integrations, and staff had to remote into virtual environments just to access the tools they needed to do their jobs. “Foundation Power was really the last major piece preventing us from modernizing the broader environment” said Luigi Di Sessa, Director of Information Technology.
As donation and granting volumes grew throughout and after the pandemic, one thing became clear: the Foundation needed a finance system that was more scalable, more connected, and built for the future.
The solution
Vancouver Foundation launched the Propel Project to solve this problem. The Foundation would replace its over 30-year-old financial system with a modern, scalable platform, designed to reduce manual work and errors, strengthen internal controls, minimize future customization, and flex with the organization's growing operational needs.
After reviewing several possible products, Vancouver Foundation selected Foundation Partners’ Fund 360 solution. There were two things that made Fund 360 the best choice for the organization. First, by bringing finance fully into Salesforce, the Foundation could unite finance, donor services, grants management, donor portal, and reporting in one system with no integrations needed. This would allow its IT team to simplify infrastructure and move decisively toward the cloud.
Second, just as important was the partner behind the platform. Foundation Partners brought deep, first-hand knowledge of how community foundations operate. Project leader Shannon Van Essen alone had spent nearly 30 years working with finance teams at community foundations, expertise that proved invaluable throughout the implementation. “What really stood out was that Foundation Partners understood community foundations deeply. We didn’t have to explain our business model or why our processes were unique,” said Wren.
a partnernship-driven implementation
Finance transformations touch multiple departments, which can feel overwhelming. What made it work for Vancouver Foundation was having an experienced partner to guide them through it. Everyone at Vancouver Foundation described their working relationship with Foundation Partners the same way: collaborative and supportive. The Foundation Partners team worked closely with stakeholders across departments through weekly working sessions, collaborative testing, and hands-on troubleshooting. “I felt very supported by the Foundation Partners team. There was no problem they couldn’t help us solve”, said Wren.
What also set Foundation Partners apart was their willingness to push back on legacy processes rather than just rebuild them. The team used the implementation as a chance to rethink how things worked and find better ways forward. “We didn’t want someone who would just do exactly what we asked. We wanted a partner who would challenge us when there was a better way forward,” said Kalkat.
“shannon really understood our business. he cared deeply about getting it right. it never felt like we were handed a system and told to deal with it. it truly felt like a partnership”
-balraj kalkat, director, financial planning & Analysis
the results
It is one thing to have a good vision; however it’s another for that vision to become a reality. The good news is the Propel Project has accomplished what it set out to do. Here are some of the results so far:
1. Simplified Grant and AP Processing
Before, grant approvals and AP workflows meant PDF markups, exported spreadsheets, and manual checks at every step. Now everything moves through Salesforce directly. “The system validates so much automatically now that people are almost uncomfortable with how little manual work is required,” said Kalkat.
2. Faster Reporting and Better Access to Data
Reporting used to mean IT tickets, spreadsheets, and long wait times. Now teams build reports directly in Salesforce. “We can finally answer questions quickly instead of saying, ‘Give us a week to pull the data together. We built a report in a matter of a day that previously took us a month,” said Kalkat.
3. Reimagining Spending Policy and Grant Budgeting
The spending policy process was one of the biggest wins. It used to run quarterly through spreadsheets and manual calculations. Now it’s been rebuilt as an annual grant budgeting model inside Fund 360. “That process used to take us weeks. Now we can do it in a couple of days,” said Wren.
This shift allows the organization to:
Give fund advisors earlier visibility into available balances
Schedule grants more proactively throughout the year
Improve communication with grantees
Eliminate repetitive quarterly administrative work
Better target available funds toward community initiatives
4. Automated Investment Reconciliation and Rebalancing
Quarterly investment reconciliation used to be a heavily manual process. Now custodian reports upload directly into the system, get reconciled automatically, and convert into journal entries. Transfer rebalancing also replaced Excel-based estimates with automated, real-time calculations. “We’re now verifying work the system has already done automatically instead of creating everything manually ourselves”, said Wren.
5. Automating Fund Statements
For most foundations, producing fund statements is a manual, labor-intensive process. With Fund 360, Vancouver Foundation now manages the entire workflow within Salesforce, from preparation and review to document generation and portal publishing. Fund Statement queries let the Foundation segment and present data the way donors need to see it, with GL balances and transaction details extracted and summarized automatically. Batch processing handles any segment of the fund portfolio together at one time.
6. Modernizing the Technology Environment
For the IT team, Propel turned into something much bigger than a finance project. It was the catalyst for modernizing the organization’s entire technology environment. “Propel really enabled our entire IT modernization strategy”, said Di Sessa.
By retiring Foundation Power, Vancouver Foundation significantly reduced cybersecurity risk by modernizing and simplifying its security architecture. This enabled the organization to:
Decommission legacy on-premise servers
Eliminate Citrix as the organization’s primary work environment
Reduce infrastructure complexity
Transition more fully into Microsoft 365 and cloud-based applications
Strengthen its long-term security posture
The day-to-day experience for users improved significantly too. One example is that staff no longer need to log in to virtual desktops just to access their tools. “This really improved the experience not just for finance, but for everybody”, said Nick Diaz, Senior Manager, Business Solutions.
7. Replacing a “Black Box” Integration
The new SmartSimple integration with Salesforce was another major win. Before Propel, it ran on a tangle of SQL transformations and undocumented processes with almost no visibility into how data moved. Troubleshooting could drag on for weeks.
Foundation Partners worked closely with Vancouver Foundation’s IT team to rebuild the integration using modern APIs and native Salesforce architecture. The new integration gives the IT team full visibility and far less reliance on outside vendors for upkeep. “We now have full visibility and full control on both sides of the integration. There’s been very little issues. It’s been up for months, and we’ve barely had support tickets,” said Diaz.
building a foundation for the future
Today, Salesforce isn’t just a CRM for Vancouver Foundation. It’s become the organization’s long-term enterprise platform. “When a department needs a new solution, we now first look within the Salesforce ecosystem”, said Kalkat.
With finance now successfully integrated into Salesforce, the organization is already evaluating future opportunities across:
Engagement management
Community programs
Grantmaking modernization
Additional enterprise applications
The implementation created the foundation for what comes next…better alignment across teams, systems, and data, and a real platform for future innovation. “Propel was the catalyst for our modernization work. It positioned us for future growth and gave us a clear path forward”, said Di Sessa.
conclusion
What began as a finance project became something far more significant. Vancouver Foundation didn't just replace a system, it shed years of infrastructure debt, unified its tools, and gave every team a better foundation to work from. With Salesforce now connecting the organization end to end, the focus can shift to what's always mattered most: growing impact and serving communities across British Columbia.