When is my grant report actually due?
Managing a handful of awards in a spreadsheet works until two reporting intervals overlap and the one that is actually overdue gets buried under whichever row is at the top. A review queue sorted by days remaining, not by award size or funder name, is what tells you which report needs attention first.
Open the free grant reporting tracker
What a plain award list does not show
The next report date is not the award date. A 6-month reporting interval on an award made in February means the next report is due in August, not on some fixed calendar date someone has to remember separately.
Overdue, due soon, and on track are different problems. Treating every award the same hides the one that already missed its date behind two that still have months to go.
A restricted balance is not a report status. An award can be fully spent and still not be due for a report for months, or barely touched and overdue right now — the two facts move independently.
Worked example
Three awards, reviewed the same day: a $24,000 community program award reporting every 6 months, a $48,000 literacy award reporting every 12 months, and a $15,000 capital award reporting every 3 months.
| Award | Reporting interval | Restricted balance | Status |
|---|---|---|---|
| Community food program | Every 6 months | $15,500 of $24,000 | Overdue — 21 days past due |
| After-school literacy | Every 12 months | $16,800 of $48,000 | Due soon — 14 days out |
| Winter shelter capital | Every 3 months | $0 of $15,000 (fully spent) | On track — 96 days out |
Sorted by days remaining rather than award size, the smallest award is the one that needs attention first — the fully-spent capital award is not due for months and would be the wrong place to start. Load the sample grants in the tracker to see this exact queue rendered live.
Common questions
How do I calculate when a grant report is due?
Add the reporting interval in months to the award date, clamped to the last day of a shorter month, to get the next report date. Compare that date to today: a report already past its date is overdue, one due within 30 days is due soon, and anything further out is on track.
What is the restricted balance on a grant award?
It is the award amount minus what has been spent so far. A $15,000 award fully spent has a $0 restricted balance and is not itself a reporting problem — spending is one input to a report, not the trigger for one.
How should I prioritize which grant to report on first when I manage several awards?
Sort by days until the next report, not by award size or funder importance. An overdue report on a small award is a live problem right now; a large award due in three months is not, and treating them as equally urgent means the actually-overdue one gets missed.