We’ve got a process we need to model in Salesforce.com. It has to do with tracking of restricted funding. Basically, we do consulting projects with customers at break even or at a loss. We then fill in that loss with generous funding from Foundations and individual donors. While most individual donors don’t put any restrictions on how their donations are spent, most Foundations do. It could be geography, or issue that a group works on, etc.
So, we want to have pools of funding that we can draw down from as projects need the subsidy. We want to be able to easily monitor those pools of funding, how fast we’re drawing down on them, which projects with which customers are being subsidized, when they expire, etc. We don’t want to get in a situation where we look back and we’ve spent more subsidy than we have. That’s a no-no in the nonprofit world.
We’ve been thinking about this problem for years, but haven’t come up with a good solution because the technology thwarted us. Out old database was not fun to customize, and an Excel-based method was going to be too hard to maintain.
Now we’re in Salesforce.com. All our funder records are in Salesforce.com. All our projects are available in Salesforce.com via an integration with our project management system. So we took a look at the problem again and spent an hour talking it through in detail.
How long did it take me to create a database schema in Salesforce.com that allowed us to track restricted funding by Foundation, draw down those funds against specific projects? Wait there’s more, I also created a report that shows each fund and it’s balance. But don’t answer yet, I also created a report of each fund and which projects are pulling money from it, showing how much each is pulling. Oh, and the Foundation record has UI that lists all their funding pools and the project record lists all funding pools that are going toward it.
Now how long do you think it took me?
30 minutes
And it’s essentially ready for production. I want to do a couple cosmetic changes, and I want to add one field to the funding pool schema. And then I’ll let my users loose on it, adding historical data and tracking restricted funding moving forward.
And I didn’t write a single line of code
This is what rapid business process modeling is all about. This is why I’m so excited about Salesforce.com for nonprofits. Identify the work you want to do, spend time thinking about it, and implement it in the technology.
Turns out, it’s not about the technology, it’s about the work processes. Another example of how Salesforce.com helps get the technology out of your way, and lets you do your work.