How to Track Grant Applications

Every nonprofit has a grant tracker. Most of them are wrong in the same way: seventeen columns, half of them empty, last updated the week before a board meeting. Tracking fails not from too little structure but from too much — a tracker survives only if updating it takes less than a minute per grant. Here is the minimum that works.

The columns that matter

Seven fields do almost all the work: the funder's name, the stage it sits in, the ask amount, the deadline, the next action, the date that action is due, and who owns it. Add one wide notes column for relationship history — who you talked to, what they said, what you submitted. Everything else people add (program area, EIN, board connections, probability percentages) is fine if it earns its keep, but every extra column raises the odds the sheet goes stale.

Use stages, not statuses

Free-text status notes ("waiting to hear back??") rot fast. A fixed set of stages keeps the picture honest. Six cover nearly everything: Prospect (identified, not yet vetted), Researching (checking fit), Contacted (LOI or intro made), Applied (proposal submitted), Won, and Lost. A grant should sit in exactly one, and each stage implies its own next action — which is the whole point. A pipeline is a to-do list disguised as a table.

Track the ask, count the math

Recording the ask amount per funder turns the tracker into a forecast: the sum of asks in Applied is your money in play, and your historical win rate tells you what fraction to expect. That single calculation answers the board's favorite question — "how are grants going?" — with a number instead of a vibe. It also exposes pipeline starvation early: if the Prospect column is empty today, the Applied column is empty in three months.

The weekly review

The tracker earns its existence in a fifteen-minute weekly review: What moved? What is due in the next thirty days? What has no next action? Anything without a next action is drifting, and drift is where grants die — the funder who invited a full proposal in March and never got one, the report due date remembered in the deadline's week. Put deadlines on your working calendar too; a spreadsheet cannot interrupt you, and interruption is what deadlines require.

When the spreadsheet stops being enough

A spreadsheet handles a dozen active funders and one owner gracefully. It strains when several people touch it, when deadlines need to sync to calendars, when you want win rates computed instead of hand-tallied, and when funder research lives in one place and tracking in another. That is the point of purpose-built pipeline tools — the tracking is the same six stages, but the research, deadlines, and math maintain themselves. Until then, a disciplined sheet beats an ambitious one.