How Systems can Save your Butt: Grant Management edition
This month we’ll be kicking off a series of Systems-First articles focusing on specific areas of fundraising. We’ll look at familiar scenarios and see how building a system will save time, reduce risk and raise more money.
Then, subscribe to my email newsletter and you’ll get a behind the scenes peek at a system I build on Airtable that solves the problem.
First on the list is a system I know that every nonprofit, big or small needs: a grant management system.
Messy systems are expensive, time-consuming and risky. Here is why that matters for grants:
Missed deadlines, and forgetting to follow-up leaves money on the table.
Spending time on applying to the wrong grants, searching for information or duplicating work already done eats up 100s hours of staff time every year.
Unreliable tracking of restricted funding is a compliance risk and can damage funder relationships.
Problem: Gnarly Process
Here is a scenario that I’ve made up, but the details will be frustratingly familiar to many nonprofit staff:
The org: 20+ staff nonprofit, funded mainly through government service contracts and grants. Currently their program managers and other staff research and write all grants, although they would like to hire a contract grant writer this year.
The mess: No formal system, everything in people's heads. Three active pain points: missed deadlines, no funder relationship history, no budget visibility.
What the system needs to do:
Track the full grant lifecycle from prospect → application → award → reporting → close
Connect grants to specific programs with funding amounts
Track application deadlines, award dates, and report due dates (interim + final)
Support a prospect pipeline for the grant writer
Give Finance and the ED a clear view of which programs are funded by which grants
Solution: Gnarly System
Our solution is a custom four-table Airtable base that acts as a shared brain for the entire grants operation. Funders, grants, programs, and reports each get their own table — linked together so information flows automatically rather than getting re-entered or lost.
A funder record holds the relationship history, contact details, and a running total of what they've awarded over time.
A program record shows exactly how much grant funding it's carrying and where the gaps are.
Nothing lives in someone's inbox or head anymore — it belongs to the organization.
The grant lifecycle runs through a single Grants table, from the moment an opportunity is spotted to the day the file closes. The incoming grant writer gets a Kanban pipeline view — cards organized by stage, dragged forward as things move, instantly showing what's in flight and what needs attention.
Finance gets a Reports table filtered to show only what's due and not yet submitted, sorted by deadline. The ED gets a funding overview by program. Everyone sees exactly what they need, nothing more.
The real value isn't any single feature — it's that the information stops belonging to one person.
Right now, if the staff member who holds the grant knowledge in their head leaves, so does the institutional memory. With this system, a new grant writer can get up to speed in an afternoon.
A missed renewal or a late report becomes something the system flags, not something discovered after the damage is done.
Want to see this system in action?
I'm doing a full show and tell in the May Systems-First newsletter — walking through the actual Airtable base in a 5-min video. Subscribe using this link https://cedarfundraising.eo.page/subscribe I'll see you there.
Thanks for reading…
My name is Kim Peterson and I am a fundraising consultant. I help non-profits establish and scale-up individual giving programs, by building fundraising strategies and systems for growth and long-term stability.
I write about topics like this in my newsletter, “Fundraising from the Ground Up” so if you like what’s here ☝️, subscribe here
Follow me or connect on:
Learn more about my consulting services and how we can work together here.
