Grant tracking spreadsheet: the columns a small nonprofit needs

Most small nonprofits track grants in a spreadsheet, and for an organization with one person doing development part time, that is usually the right tool. The trouble is that most grant trackers are built as a list of funders. The questions that matter on a Monday morning are different: what is due in the next three weeks, what is waiting on someone else, and which reports are coming up for the grants you already won.

This guide gives you a layout that answers those questions: one sheet, the columns, a short list of status values, two formulas, and a twenty-minute weekly routine. It works in Excel or Google Sheets, and it doubles as a grant tracking template you can copy.

One row per opportunity, not one row per funder

This decision makes or breaks the tracker. A community foundation may run a spring youth cycle and a fall capacity-building cycle; a company may have an employee-giving program and a separate sponsorship budget. If you keep one row per funder, you end up with a notes cell that says "two cycles, check site" and no date to sort by.

Give each opportunity its own row: one funder, one program, one cycle. When the funder opens the same program next year, add a new row rather than overwriting the old one. Your history of what you applied for, and what came of it, is worth keeping.

The columns

If a funder does not publish an amount or a deadline, write "not stated" or "rolling" instead of guessing. A guessed date in a tracker looks exactly like a real one six weeks later.

Status values

Keep the list short and use a dropdown (data validation) so everyone spells them the same way:

• Prospect: found it, have not decided.
• Applying: decided to apply; work in progress.
• Submitted: sent; waiting on a decision.
• Awarded: won; reports now matter.
• Declined: the funder said no. Keep the row.
• Passed: you decided not to apply. Write why in Notes, so next year's version of you does not research it again.

The two formulas

Assuming the deadline is in column E and the sheet starts at row 2.

Days left until the deadline:

=IF(E2="","",E2-TODAY())

A "this week" flag for anything open with a deadline inside 21 days:

=IF(OR(E2="",G2="Submitted",G2="Awarded",G2="Declined",G2="Passed"),"",IF(E2-TODAY()<0,"Missed",IF(E2-TODAY()<=21,"Due soon","")))

Format the deadline column as a date and the days-left column as a plain number. If dates were pasted in as text, the formulas will return errors; re-enter them as dates. Add conditional formatting so "Due soon" is amber and "Missed" is red, then sort by Days left, smallest first. Rows with no deadline sort to the bottom, so check the rolling ones separately.

A second tab for reports

Won grants come with obligations: interim reports, final reports, sometimes site visits. Keep a small second tab with one row per report: funder, grant, report type, due date, owner and status. Missing a report can hurt your chances with that funder next cycle, and they are easy to forget because the grant already feels finished.

The weekly routine

Pick a time, such as Monday morning, and spend twenty minutes:

1. Sort by Days left. Everything due soon is at the top.
2. Check every "Applying" row has an owner and a next step for this week. If it does not, either assign one or mark it Passed.
3. Add new prospects. Whatever you found this week goes in as Prospect, with the source link and eligibility notes. Then decide: apply or pass.
4. Look at the reports tab. Anything due in the next 30 days gets an owner.
5. Update decisions. Move anything you heard back on to Awarded or Declined, with the amount and the report dates.

Mistakes that make the sheet lie

• No source link. Funders change deadlines and guidelines. Without the link, you are trusting a date you typed months ago.
• Overwriting last year's row. You lose the record of what you asked for and what happened.
• "Us" as the owner. If everyone owns it, the next step waits.
• Tracking prospects you never decide on. A list of 80 possibles is a database, not a plan. Decide within a week whether to apply, and mark the rest Passed.
• Forgetting reports. Add report dates the day you hear you won.

Where the rows come from

The spreadsheet keeps you organized once an opportunity is on it. Finding the rows is the slower job: checking Grants.gov, your state's grant listings, and the grants pages of the foundations and companies near you. Our guide to grant alerts covers that routine, and grant prospecting covers deciding which ones deserve a row at all.

Grant Weekly does the finding for you. Each Monday it emails a short ranked list of newly open grants that fit your mission, with the amount, deadline and eligibility where the funder publishes them, and why each one fits. Grants you track go on a running deadline calendar that you can subscribe to from Google Calendar or Outlook, with reminders 14 and 3 days before each deadline. You can keep this spreadsheet for the application work and let the Monday list feed it.