When Your Grantmaking Outgrows Your Spreadsheet
For many private foundations, tracking grants is as simple as keeping a spreadsheet up to date with grantee names, amounts, and payment dates. Most of the institutional knowledge about the organizations, including relationships, live solely in someone’s mind.
And for many foundations, that’s fine. Until it’s not.
You know the saying, - “bigger kids, bigger problems.” The same goes for foundations. As a foundation grows or as time passes and more giving history accumulates, so too does the historical record. Spreadsheets get lost, are accidentally saved over, or data is lost or duplicated when two people work from different versions. The message here isn’t that spreadsheets are bad. It’s that foundations often outgrow or outlive the systems that once served them well.
Seeing the Signs.
1. It’s taking too long to find grantee information.
Can you quickly figure out how much your foundation has given to an organization over the past five or ten years? Can you easily locate previous grant applications, reports, or correspondence?
A well-organized grant history provides more than convenience. It helps staff and board members quickly understand long-term grantee relationships, see the patterns, and make more informed decisions. Rather than having to rely on a nonprofit’s records and memory, you have your own detailed account of the relationship to rely upon.
2. When your grant manager or administrative help goes on vacation, and grants come to a halt.
For many foundations, the grant process lives with one person and one person only. He or she knows where the spreadsheets are kept, when payments are due, who has received what, and how the files are organized. Institutional knowledge is valuable, perhaps irreplaceable, especially at foundations. But when staff roles shift or PTO is taken, family members or volunteers can’t participate, or board members depart, so too does that knowledge if it is not properly captured.
3. You have outgrown informal grantmaking.
As your foundation activity grows, more things may be falling through the cracks. Informal and flexible grantmaking is sporadic and often occurs at the very end of the year, overwhelming you in paperwork. If grant applications and nonprofit communication are coming through different channels (e.g., email, texts, mail), information can get lost in the shuffle.
4. You need to provide grants information for an audit.
Whether an audit is conducted independently, or whether the IRS is involved, there may come a time when there is an immediate need for prompt, reliable, and complete grantee records - even grants that date back several years. It may be critical to your legal or reputational standing to maintain accurate, easy-to-find grant records.
You saw the signs. Now what?
If these challenges sound a bit familiar to you, it may be time to consider grant software to help organize your information. Online grant platforms can capture grant history, relationships, payments, applications, reports and more. While infrastructure can be costly, the challenges above can as well. A grant platform can better prepare a foundation if it decides to hire or add staff, grow the Board, or if the foundation suddenly grows significantly, an organized system is needed to make sure dollars are stewarded appropriately.
Establishing a standardized process doesn't mean adding unnecessary bureaucracy. Instead, it creates repeatable, scalable steps that make philanthropy easier to manage.
Better Systems Means Better Philanthropy
Making sure the trains run on time may not be the most exciting part about operating a foundation, but it is certainly an important one. Good data supports good relationships and the proper stewardship of philanthropic dollars. Continuity creates institutional memory for a foundation, including why decisions were made, what commitments are outstanding, and what the board expects, offering a seamless transition if/when needed.
At Hoplin Jackson, we've spent years helping clients organize their records, streamline operations, and build more efficient back-office systems to provide an unshakable foundation to the legacies being built.