Grant Tracker Spreadsheet for Nonprofits: Deadlines, Pipeline and Reporting
Small nonprofits often juggle LOIs, applications and funder reports across email, sticky notes and three versions of "grants_FINAL.xlsx". A single spreadsheet with deadline flags and a weighted pipeline answers "what's open?" and "what's due this week?" without paying for grant software.
Why a grant tracker matters
Missed deadlines cost renewals. So do late interim or final reports. A tracker is not a grant-finding tool and it won't write your narrative. What it does well is:
- Put every open application in one place with the next deadline and owner
- Flag DUE SOON and OVERDUE items before they slip
- Show a realistic pipeline (weighted by stage) instead of a wishful sum of every ask
- Keep funder contacts and reporting dates next to the awards they belong to
Columns worth keeping
Start lean. You can always add fields; a sheet with 30 columns stops getting updated. A workable core:
| Column | Why it's useful |
|---|---|
| Funder · Opportunity | Who and what. Link to the RFP or portal if you have one. |
| Status | One value per row (see below). Drives your to-do list. |
| LOI due · Application due | The two dates that matter most before award. |
| Next deadline | The earlier of the open dates for that row, or the next report due after award. |
| Days left · Flag | Calculated. Amber for due soon, red for overdue. |
| Owner · Next action | Who does what, and the one next step. |
| Amount requested · Awarded | For pipeline totals and win rate. |
| Win probability | Default by stage, with an override when you know more. |
Statuses that drive next actions
Keep statuses few and mutually exclusive. One set that works for many small shops:
- Prospect — researching, not yet drafting
- LOI in progress / submitted
- Application in progress / submitted
- Under review
- Awarded — move reporting dates into a reporting log
- Declined / Withdrawn / Deferred — closed, but keep the row so win rate stays honest
Sort open rows by next deadline. The top of the list is this week's work.
Win probability and weighted pipeline
Adding every requested amount gives a fantasy number. A simple fix: assign a default win probability to each stage (for example Prospect 10%, LOI submitted 25%, Application submitted 40%, Under review 55%, Awarded 100%). Override per grant when you have a clearer read. Then:
Weighted value = Amount requested × Win probability
Sum weighted values for open grants. That is a more honest "what's in the pipeline" figure for board updates.
Don't forget reporting obligations
Awards create work: interim, final and financial reports. Missed reports are a common reason renewals fail. Keep a separate reporting log (or tab) with:
- Award / funder, report type, due date, status, owner
- The same due-soon and overdue flags as applications
When a grant is marked Awarded, add its report dates the same day.
A 15-minute weekly routine
- Sort open applications by next deadline; clear anything overdue or due in the next 7 days.
- Update statuses and next actions for anything that moved.
- Check the reporting log the same way.
- Glance at weighted pipeline and awarded this fiscal year for your board or ED update.
Free and paid templates
If you'd rather not build the sheet from scratch, we make two versions: