Grant tracking spreadsheet
Most grant trackers fail the same way: too many columns to maintain, and no column for the dates that actually cause problems. This layout is deliberately narrow. Every column earns its place by answering a question someone asks out loud during a staff meeting.
Copy the CSV block below into any spreadsheet tool. The status list underneath it matters more than the columns do, because a tracker where two people use different words for the same stage stops being trustworthy within a month.
Copy this layout
Download CSVFunder,Program or fund,Amount requested,Stage,LOI due,Proposal due,Decision expected,Award start,Report due,Owner,Contact,Notes
Riverbend Community Foundation,Youth Services,25000,Invited,2026-08-01,2026-09-12,2026-11-15,2027-01-01,2027-07-15,A. Chen,[email protected],Asked for outcome data from last cycle
[Funder name],[Fund],[Amount],[Stage],[YYYY-MM-DD],[YYYY-MM-DD],[YYYY-MM-DD],[YYYY-MM-DD],[YYYY-MM-DD],[Staff],[Email],[Notes]Status vocabulary
- Researching
- You have identified the funder but have not confirmed fit or eligibility.
- Eligible
- You meet the stated requirements and the funder is open to new requests.
- LOI submitted
- A letter of inquiry is in. Nothing else is due until they respond.
- Invited
- The funder asked for a full proposal. This is now your highest priority.
- Proposal submitted
- The full application is in and you are waiting on a decision.
- Awarded
- Funded. Reporting obligations start now, not at year end.
- Declined
- Log the reason if you have it. Most funders will reconsider a stronger ask later.
The two dates almost every tracker forgets
Nearly every homemade tracker records the proposal deadline. Two other dates cause more damage when they go missing.
The first is the report due date. Reporting obligations begin when the money arrives, not when the grant year ends, and a late report is the single most reliable way to lose a renewal from a funder who was otherwise happy with you. Put the report date in the row the day the award is confirmed, not later.
The second is the decision expected date. Without it, you have no way to tell the difference between a funder who is still deliberating and one who quietly declined without notifying you, and you cannot forecast cash. When that date passes with no word, a short follow-up email is appropriate and is not a nuisance.
Why the status vocabulary matters more than the columns
A tracker is only useful if everyone reads a row the same way. When one person writes 'submitted' for a letter of inquiry and another writes it for a full proposal, the sheet stops answering the question it exists to answer, which is what needs attention this week.
Fix the stage list to a closed set, put it in a dropdown so free text cannot creep in, and keep it visible at the top of the sheet. Seven stages is enough for organizations managing fewer than forty applications a year.
When a spreadsheet stops being enough
A spreadsheet handles this well up to roughly fifteen active applications, or one person managing the calendar. Past that the failure mode is consistent: the sheet is accurate but nobody opens it, so deadlines are missed even though the information was right there.
The practical signals that you have outgrown it are needing reminders rather than a list, more than one person editing the same rows, or wanting the history of what you asked a funder for three years ago without opening an archived file.
Common questions
What columns should a grant tracking spreadsheet have?
At minimum: funder, program or fund, amount requested, current stage, letter of inquiry due date, proposal due date, decision expected date, award start date, report due date, internal owner, funder contact, and notes. Additional columns tend to go unmaintained.
What stages should I use to track grant applications?
A closed list of seven works for most small organizations: researching, eligible, letter of inquiry submitted, invited, proposal submitted, awarded, and declined. Use a dropdown so free text cannot creep in.
How do I track grant reporting deadlines?
Add the report due date to the row on the day the award is confirmed, not at the end of the grant year. Reporting obligations start when the money arrives, and a late report is a common reason an otherwise satisfied funder declines a renewal.
Should I track declined applications?
Yes. Keep the row and record the reason if the funder gave one. Many funders will consider a revised request in a later cycle, and the history tells you whether you are being declined on eligibility, which is fixable, or on fit, which is not.
How many grants can one spreadsheet realistically handle?
Roughly fifteen active applications, or any number if a single person owns the calendar. The usual failure past that point is not inaccuracy but disuse: the sheet stays correct and nobody opens it.
Should the amount column hold the request or the award?
Track the amount requested, and record the awarded amount in the notes or a separate column when it differs. Overwriting the request with the award destroys the history you need to see whether you are consistently asking for too much or too little.
What date format should I use?
Use ISO format, meaning year, month, day as 2026-09-12. It sorts correctly as text in every spreadsheet tool and removes the ambiguity between day-first and month-first conventions.
Do I need a separate tracker for federal and foundation grants?
No. One sheet with a column noting the funder type is easier to maintain. Federal awards carry more reporting requirements, so the notes field on those rows tends to be longer, but splitting the tracker means checking two places for this week's deadlines.