A spreadsheet is how most nonprofit coordinators already do this, and it
can work for one report: a column for the award date, a column for the
interval, and a formula like =EDATE(award_date, 6) that names
the first report date. The problem is not the spreadsheet — it is
that the formula names one date and never advances again on its own.
If that first report is filed on time, the next cell is usually a copy of the same formula, shifted by hand, and the sheet stays right by habit. The moment a period is missed, a coordinator changes roles, or a sheet is inherited mid-award, the formula still points at whichever period someone last computed — not the one that is actually due today.
| What a spreadsheet formula does | What this tracker does instead |
|---|---|
| Names the first due date from the award date and interval, and stays on that date until someone edits the cell by hand. | Recomputes the current — possibly overdue — period from the award date and interval every time the page runs, with no stored date to go stale. |
| Has no way to tell "on schedule" from "several periods behind"; a missed report just leaves the same formula pointing at the wrong date. | Flags an obligation overdue, due soon, or upcoming, and sorts overdue items to the top of the list. |
| Tracks the dollar amount at risk, if at all, as a separate manual figure nobody recalculates when the spent total changes. | Turns the award, spent amount, and next installment into a dollar figure at risk, and compares filing it yourself against hiring a contract writer. |
| Needs a separate calendar entry, made and maintained by hand, to get a reminder before the date arrives. | Exports every obligation as an .ics calendar file with a three-day-ahead reminder built in. |
A worked example. An award started 2025-01-01 with a 6-month reporting interval, checked on 2026-08-26. Three periods have already passed: 2025-07-01, 2026-01-01, and 2026-07-01. A spreadsheet formula anchored only to the award date reports the first of those, 2025-07-01, forever — it has no mechanism to notice that two more periods have since come and gone. This tracker walks the interval forward from the award date and reports 2026-07-01: the current period, already overdue, not the one the award started with.
It needs no account and no sign-in: it is a static page, the arithmetic runs in your browser, and nothing you type is ever sent anywhere.
Its due-date formula is set once, against the award start date, and names the first report in the series — an =EDATE(award_date, 6) style formula returns one date and never advances on its own. If that first report is filed on time the sheet stays right by luck: the next cell is usually a copy of the same formula shifted by hand. If a period is ever missed, or a whole sheet inherited mid-award, the formula still points at whichever period someone last computed, not the one that is actually due now.
An award started 2025-01-01 with a 6-month reporting interval. Checked on 2026-08-26, three periods have already passed: 2025-07-01, 2026-01-01, and 2026-07-01. A spreadsheet formula anchored to the award date alone reports the first due date, 2025-07-01, forever — it has no way to know two more periods have since come and gone. This tracker walks the interval forward from the award date and reports 2026-07-01: the current period, already overdue, not the one the award started with.
For one report cycle, yes. The risk is not writing the formula once — it is that nothing prompts anyone to advance it again after a coordinator changes roles, a sheet is inherited mid-award, or a period is simply missed. A cell reading 2025-07-01 looks exactly as authoritative the day it is a year stale as the day it was written. This tracker has no stored date to go stale: the current period is recomputed from the award date and interval every time the page runs.
For finding the current reporting period and the cash at risk if it slips, yes — that is the one job it does. It keeps no ledger of every past report, correspondence, or budget line beyond what you type in for the awards on screen. A bookkeeper who wants a full multi-year award ledger, not just the next deadline and the money behind it, still has reasons to keep a spreadsheet alongside it.
Nothing here says or implies that tracking grant deadlines in a spreadsheet is a mistake — it is the default most small nonprofits already use, and it works until a period is missed or a sheet changes hands. This page describes where that shortcut breaks down, not a fault in anyone who uses it. The 2025-01-01 / 6-month example above is this tracker's own arithmetic on the example described in this page, not a claim about any specific organization's real award.
Open the Grant Deadline Tracker to add your own awards and reporting dates.