How to build a grant calendar a two-person team can keep
A grant calendar a two-person team can keep needs six columns: funder, ask amount, deadline, status, owner, and next action. Review it once a week at a standing time. That is the entire system. Most grant calendars fail from tracking too much, not too little, and die quietly within a quarter.
The six columns
- Funder. One row per funder per opportunity.
- Ask. The dollar amount, so the sheet doubles as a pipeline forecast.
- Deadline. Application deadlines and report deadlines, on the same sheet.
- Status. Keep the list short: researching, drafting, submitted, awarded, declined, reporting. More states means more rows filed wrong.
- Owner. A name, never “team.” Unowned rows are how deadlines slip.
- Next action. The single concrete step and the date it happens. This column is the difference between a calendar and a to-do list nobody reads.
If a column does not change a decision at the weekly review, cut it. Probability percentages, contact logs, and elaborate color codes are where two-person calendars go to die.
The weekly review
Fifteen minutes, same time every week, both people present. Walk the sheet top to bottom and confirm two things per row: the last next action got done, and a new one is written down. Anything due within 30 days gets said out loud. The review is what keeps the calendar true; a sheet nobody reads aloud drifts from reality in about three weeks.
Keep report deadlines on the sheet
Won grants generate deadlines too. A missed report damages a funder relationship faster than a declined proposal ever will, so reporting dates live in the same calendar with the same owner column, not in someone’s inbox. One quiet upgrade here: a free Jotform form gives program staff a single place to submit the numbers and stories your reports need, instead of scattered email threads. The free tier covers 5 forms and 100 submissions a month, and the permanent 50% nonprofit discount brings the Bronze plan to about $17 a month if you outgrow it.
When the spreadsheet stops working
Three signals. You are prospecting for new funders every month and pasting research into the sheet by hand. The same funder sits at multiple stages at once (an open application, an active grant, a report due) and one row cannot hold it. Or a deadline slips not because nobody cared but because the sheet was stale. Any one is survivable; two together mean the tool is now the bottleneck.
What replaces it
Instrumentl’s tracker is the natural upgrade because it attaches the pipeline to the research. Matched funders flow into the same board that holds your deadlines, statuses, and report dates, so the calendar maintains itself as a side effect of prospecting. Plans start at $179 a month billed annually. The 14-day free trial is enough time to rebuild your current spreadsheet inside it and see whether the weekly review gets shorter; our Instrumentl review covers the tracker in detail.
This piece is part of the guide to the $250k-$1M fundraising stack, where grants become a program that needs a system.
Common questions
What should a grant tracking spreadsheet include?
Six columns: funder, ask amount, deadline, status, owner, and next action. Include report deadlines for won grants, not just application deadlines. Anything beyond that tends to go stale and undermines trust in the sheet.
How often should a small team review the grant calendar?
Weekly, at a standing 15-minute meeting with everyone who owns a row. The review confirms each next action and calls out anything due within 30 days.
When is it time to replace the spreadsheet with software?
When monthly prospecting means pasting research in by hand, when one row cannot hold a funder at multiple stages, or when deadlines slip because the sheet went stale. Instrumentl's tracker combines research and pipeline in one place, and its 14-day trial lets you test it with your real grants.
This post is part of the guide to the growing fundraising stack ($250k – $1M raised).