Grantnook / Guides

How to track grant deadlines in a small nonprofit

Most missed grant deadlines are not caused by carelessness. They happen because the dates are scattered: a funder's website, an email from March, a sticky note, a calendar entry only one person can see. This guide shows a simple way to pull those dates into one place and keep an eye on them with about fifteen minutes a week.

Start with one list for every date

Pick one home for grant dates. A spreadsheet works well for a small team, and so does a shared calendar paired with a list. What matters is that there is exactly one place, and everyone knows where it is. If you have two lists, you have an argument about which one is right.

Each row should be one ask to one funder. Give it columns for the funder, the program, the amount you plan to request, the stage, who owns it, and the dates described below.

Record the dates that actually matter

Funders do not use one timeline. Capture every date they give you, not only the final one:

• Letter of inquiry (LOI) due. Many funders ask for a short letter before they invite a full proposal.
• Full proposal due. This is the date most people remember, and often the only one they write down.
• Decision date. When the funder says you will hear back. This is not a deadline for you, but it tells you when to follow up and when to plan around a yes or a no.
• Report dates, if you win. Interim and final reports. Add them the day the award letter arrives.
• Reapply or renewal date. If a funder allows repeat applications, note when the next cycle opens.

Write the time zone and the exact time when the funder gives one. A deadline of 11:59 p.m. Pacific is a different day for a team on the East Coast.

Set an internal deadline before the real one

Treat the funder's date as the last possible moment, not the target. Choose an internal date three to five working days earlier for a short application, and longer for a large one. Online portals can be slow or ask for a document you did not know about. A buffer turns a crisis into an inconvenience.

It also helps to break a proposal into smaller dates: draft of the narrative, budget ready, attachments gathered, review by the executive director. You do not need to track each one for every grant. Do it for the big asks.

Give every deadline one owner

A deadline that belongs to the whole team belongs to no one. Put a single name on each row. That person does not have to write everything, but they are responsible for making sure it gets done or for saying early that it will not. If you are a one-person shop, the owner column still helps, because it shows which asks are yours and which belong to a volunteer or a board member.

Make the next deadline impossible to miss

A list of dates only helps if you look at it. Two habits make that reliable.

1. Show a countdown, not just a date. A cell that says "6 days" is easier to read than a date you have to compare to today. In a spreadsheet, a formula that subtracts today's date from the due date does this.
2. Add color rules. Many teams color anything under a week red and anything under three weeks amber. Pick cutoffs that fit how long your applications take to write, and use them every time.

Then add reminders somewhere you already look. A calendar alert 30, 14 and 7 days out is enough for most grants. If your tracker can email you, use that. If not, put the alerts in the shared calendar.

Review weekly, for fifteen minutes

Pick a day and a time. Open the list and ask four questions:

• What is due in the next three weeks, and who is working on it?
• Has any stage changed? Did a funder reply, invite a proposal, or decline?
• Are any reports coming due?
• Is anything stuck because we are waiting on someone?

Update the stage as you go. A tracker that is a month out of date is worse than none, because it looks trustworthy.

Dates that are not on any funder's calendar

Some deadlines come from outside your funders, and they still affect whether you can apply or get paid. Put them in the same list.

• SAM.gov registration. Organizations that apply for federal grants need an active registration in SAM.gov. According to SAM.gov, a registration must be renewed every 365 days to stay active. Note the expiration date and set an alert well ahead of it. Source: SAM.gov entity registration.
• Your annual IRS return. Form 990, 990-EZ or 990-PF is due by the 15th day of the 5th month after the end of your accounting period. For a calendar-year organization, that is May 15. Funders often ask for a recent copy. Source: IRS, annual exempt organization return due date.
• State charity registration or renewal. Requirements and dates vary by state, so check with your state's charity regulator and add the dates you find.
• Board meeting dates. If a proposal needs board approval or a signature, the board calendar is a deadline too.

Common mistakes to avoid

• Tracking only full proposal dates. LOIs, reports and follow-ups slip when they are not written down.
• Keeping dates in someone's email. When that person is away, so is the date.
• Not recording decisions. Mark awarded and declined asks, with a note about why. You will be glad of the history when you apply again.
• Making the system too elaborate. If updating the tracker takes longer than the work itself, it will be abandoned. Start with the columns above and add more only when you feel the need.

A simple setup you can copy this week

If you want to start today, set up one sheet with these columns: funder, program, ask amount, stage, LOI due, full proposal due, decision date, owner, notes. Add a "days until due" column and two color rules. Put the weekly review in everyone's calendar. That alone puts you ahead of most small teams.