Keep every grant deadline, deliverable and report in one place.

Put every date in one list, review it weekly, and give each item an owner. Most slips happen because the application deadline lives in one inbox, the interim report in another, and the renewal in nobody's calendar. A grant tracking spreadsheet fixes that when it holds three things together: the pipeline, the deliverables you owe once funded, and the dates on both. This one does, and it adds a weighted forecast so the same list tells your board what is secured and what is still to raise.

Five sheets. Type on two of them; the rest calculate.

• Pipeline: One row per opportunity, from research to award. Stage, fit, owner, amount, LOI and application dates, decision date, award terms. Three columns calculate for you: the next deadline for each row, days left, and a flag that turns red when something is overdue.
• Deliverables: One row per thing you owe a funder after a yes: interim reports, final reports, financial reports, site visits, renewals. Linked to the pipeline by ID, so the funder name fills in and overdue reports show up on the dashboard next to overdue applications.
• Dashboard: Secured, expected and still-to-raise against your fiscal-year goal. Overdue and due in the next 7, 30 and 90 days. A 12-month view of applications due, reports due and decisions expected. Totals by initiative. Nothing to type.
• Settings: Your goal, your stage weights, your team's names and every dropdown list. Change them once and the whole workbook follows.
• Start here: A 10-minute setup and a weekly routine, inside the file.

1. On Settings, enter your fiscal-year goal and adjust the due-soon threshold (14 days by default).
2. Replace the owner names with your team.
3. On Pipeline, delete the eight sample rows and enter your open opportunities. White cells are yours; shaded cells calculate.
4. On Deliverables, add what you owe on each awarded grant. Type the pipeline ID and the funder fills in.
5. On Dashboard, type your initiative names so they match the Pipeline column.

Open the file on the same day each week. Sort by Flag, clear the red, move stages, add new dates. Twenty minutes keeps it honest.

Winning the grant starts a second calendar: the interim report, the financial report, the final report, the renewal. Deadline tracking that stops at the application is how good teams miss funder reports. The Deliverables sheet carries those dates with the same owner, status and flag logic as the pipeline, and the dashboard's 12-month view puts both calendars on one line per month.

Three habits that matter more than the template:

• Enter the report dates the day the award letter arrives, not when the first reminder lands.
• Give every row one owner. Shared ownership is how deadlines fall through.
• Record the decision date for anything submitted. It is the date your forecast is waiting on.

Each stage carries a planning weight: 5% while researching, 10% qualifying, 20% at LOI, 35% drafting, 50% submitted, 100% awarded. Weighted value is amount requested times that weight. Secured counts awards only. Expected is the weighted value of everything still open. Still to raise is the goal minus both.

The weights are planning assumptions, not award odds. After a year, replace them with your own hit rates from the Pipeline sheet. Until then, treat Expected as an estimate and say so when you present it.

A tracker like this works well for one person or a small team with a modest number of live grants. The strain shows when three or more people edit it, when the grant list passes twenty or so, or when a board asks why a number changed and nobody can trace it. At that point the work moves to software that holds the opportunity, the application, the deadlines and the forecast together.

That is the job Grants360 does inside mission360: it finds funders that fit the work you need to fund, produces funder briefings from their 990-PF filings, tracks each application through to a decision, and carries awards and expected funding into the same forecast your board sees. AI drafts application sections from your approved materials, and your team reviews everything before it goes anywhere.