Most small teams keep grant deadlines in their heads, in an inbox or on a sticky note. That works until two deadlines and a final report land in the same week. A grant tracking calendar in Excel puts every prospect, application and report in one place, with dates that change color as they approach. Here is how to set one up and keep it useful.
One workbook, one tab per job
| Tab | What it holds | When you use it |
|---|---|---|
| Settings | Your two alert windows (in days) and your currency | Once, then when your pace changes |
| Funder Research | Each prospect: focus, geography, typical grant size, whether it accepts unsolicited requests, how to apply, the source you checked and the date | When you look for new funders |
| Pipeline | Each application: stage, deadlines, days left, amount asked and awarded, lead person | Every week |
| Reporting | Each report owed on an awarded grant, with due date, status and owner | As soon as a grant is awarded |
| Dashboard | Counts and amounts by stage, deadlines and reports coming up | At your team meeting |
Keep drop-down lists (funder types, stages, statuses) on a separate Lists tab so you can change the vocabulary without touching formulas.
Research funders from free public sources
A good prospect funds your kind of work, in your area, at your size, and accepts applications from organizations like yours. Most of that can be checked for free:
- The funder's own website: guidelines, priorities, deadlines, grant sizes and how to apply.
- Form 990-PF for private foundations: on current forms, Part XIV (Supplementary Information) gives application information, shows whether the foundation contributes only to preselected organizations, and lists grants paid with their purpose. Read filings on ProPublica Nonprofit Explorer or through the IRS Tax Exempt Organization Search.
- US federal opportunities: according to its roadmap, Simpler.Grants.gov is now the default search for federal funding opportunities.
- Community foundations, annual reports and local news: open grant rounds, new priorities, staff changes.
- Your network: peers who have been funded, your board, local intermediaries.
Record the source and the date you checked each fact. Funders change their priorities, and an outdated fact can waste a whole application. Then give each prospect a fit score from 1 (not eligible) to 5 (clear match on focus, geography, size and eligibility) and move only the 4s and 5s to the pipeline.
Pipeline stages that match what really happens
A short, fixed list of stages makes the dashboard meaningful:
- Researching
- Qualified
- LOI or first stage drafting
- LOI or first stage submitted
- Invited to full application
- Full application drafting
- Submitted
- Awarded, Declined or Not pursuing
Some funders use two stages, so give each row two dates: the first-stage deadline (letter of inquiry or expression of interest) and the full application deadline. A "Next deadline" column can show the first one until it passes, then the second: =IF(AND(F5<>"",F5>=TODAY()),F5,G5). Days left is then =IF(H5="","",H5-TODAY()). Always copy deadlines from the funder's current guidelines, and plan to submit early.
Color alerts that tell you what is urgent
Two alert windows are enough. A workable starting point is a yellow window of 30 days and an orange window of 14 days, with red once a date has passed. In Excel, select the Days left column and add three conditional formatting rules, in this order:
| Rule | Formula (row 5) | Color |
|---|---|---|
| Passed | =AND($I5<>"",$I5<0) | Red |
| Within the short window | =AND($I5<>"",$I5<=14) | Orange |
| Within the long window | =AND($I5<>"",$I5<=30) | Yellow |
Point the 14 and 30 at cells on the Settings tab instead of typing them, so you can change your pace in one place.
Reporting deadlines belong on the same calendar
Winning a grant creates new deadlines. The day the agreement is signed, list every report it requires on the Reporting tab: interim or progress reports, the final narrative report, the final financial report, site visits and any renewal date. Use the same alert colors, and blank the days-left cell once a report is submitted. Late reports can damage your relationship with a funder, and they are the easiest deadline to forget because nobody is chasing a new application.
A rhythm for the year
- Weekly, 15 minutes: update stages, look at the orange and red cells, decide who does what.
- Monthly: add prospects, review fit scores, check reports due in the next window.
- Yearly: review awards, declines and amounts on the dashboard and decide where to focus.
Build the funding year into the calendar. The US federal fiscal year begins on October 1 (31 U.S.C. 1102), which is worth knowing when you plan around federal programs. Foundations that publish fixed annual deadlines can go straight onto the calendar for the next cycle.
The Grant Calendar & Pipeline Kit has these tabs ready in Essentials_GrantCalendar_Grant_Calendar_TRACKER.xlsx, plus seven letters and emails for each stage of the relationship in Essentials_GrantCalendar_Funder_Communications_TEMPLATE.docx.
General information: this guide is general information, not legal, tax or fundraising advice. No template can guarantee funding. Always follow each funder's own guidelines and deadlines.
The Funder File is not affiliated with, endorsed by or connected to the Internal Revenue Service, ProPublica, Grants.gov or any US government agency.
Sources
The Funder File is not affiliated with, endorsed by or connected to any funder or government agency named on this site. All trademarks belong to their owners.