Nonprofit Accounting
Nonprofit Management
Grant Tracking Spreadsheet: A Template for Deadlines, Awards and Reporting
Last updated: October 13, 2026 · Independent guide · We do not sell rankings or coverage.
A grant tracking spreadsheet works best as four linked tabs: a pipeline of every opportunity from prospect to decision, an awards register with amounts, periods and restrictions, a reports calendar with one row per report due, and a budget tab that compares spending against each award. Most free templates stop at the pipeline and a single “reporting deadline” column, which breaks as soon as one grant has quarterly, annual and final reports. The layout below fixes that, gives you the formulas, and shows the point where Excel or Google Sheets stops being enough.
How to use this template
Create one workbook with five tabs named exactly Pipeline, Awards, Reports, Budget and Expenses. Each table below lists one tab’s columns in order from column A. Every tab shares a Grant ID in column A, which links the formulas across tabs. Formulas assume data starts on row 2 and work in both Excel and Google Sheets, since EOMONTH, SUMIFS and COUNTIFS exist in both (Microsoft; Google).
The grant tracking spreadsheet template
Tab 1: Pipeline (one row per opportunity)
| Col | Header | What to enter | Formula or validation |
|---|---|---|---|
| A | Grant ID | Short unique code, such as FY27-014 | Never reuse an ID |
| B | Funder | Legal name of the funder or pass-through entity | Text |
| C | Funder type | Federal direct, Federal pass-through, State or local, Foundation, Corporate | Dropdown |
| D | Program | The program or project the request funds | Dropdown from your program list |
| E | Stage | Prospect, LOI, Invited, Submitted, Awarded, Declined, Withdrawn | Dropdown |
| F | LOI due | Letter of inquiry deadline, blank if none | Date |
| G | Application due | Full proposal deadline | Date |
| H | Amount requested | Total request in USD | Number |
| I | Submitted on | Date you actually submitted | Date |
| J | Decision date | Expected or actual notification date | Date |
| K | Next deadline | Calculated | =IF(E2="LOI",F2,IF(OR(E2="Prospect",E2="Invited"),G2,"")) |
| L | Owner | One named person | Dropdown of staff |
| M | Notes | Contact, portal link, last conversation | Text |
Tab 2: Awards (one row per awarded grant)
| Col | Header | What to enter | Formula or validation |
|---|---|---|---|
| A | Grant ID | Same ID as the Pipeline row | Dropdown from Pipeline!A:A |
| B | Award number | Funder’s award or agreement number (and Assistance Listing number for federal funds) | Text |
| C | Amount awarded | Total from the award letter | Number |
| D | Start date | First day of the grant or performance period | Date |
| E | End date | Last day of the period | Date |
| F | Restriction | Unrestricted, Purpose, Time, Purpose and time | Dropdown |
| G | Conditional? | Yes if there is a barrier plus a right of return; describe the condition in M | Dropdown Yes or No |
| H | Payment basis | Advance, Reimbursement, Milestone | Dropdown |
| I | Spent to date | Calculated from Expenses | =SUMIFS(Expenses!D:D,Expenses!A:A,A2) |
| J | Remaining | Calculated | =C2-I2 |
| K | % time elapsed | Calculated | =MIN(1,MAX(0,(TODAY()-D2)/(E2-D2))) |
| L | Burn gap | % spent minus % time elapsed | =I2/C2-K2 |
| M | Terms | Allowed uses, prior-approval items, match, indirect cap, condition text | Text, quoted from the award |
Tab 3: Reports (one row per report due)
| Col | Header | What to enter | Formula or validation |
|---|---|---|---|
| A | Grant ID | Award the report belongs to | Dropdown from Awards!A:A |
| B | Report type | Interim financial, Interim narrative, Annual, Final financial, Final narrative | Dropdown |
| C | Period end | Last day the report covers | Quarter n: =EOMONTH(Awards start date, 3*n-1) |
| D | Days allowed | From the award letter (for example 30, 90 or 120) | Number |
| E | Due date | Calculated, or typed if the funder gives a fixed date | =C2+D2 |
| F | Status | Not started, Drafting, In review, Submitted, Accepted | Dropdown |
| G | Days to due | Calculated | =IF(F2="Submitted","",E2-TODAY()) |
| H | Submitted on / by | Date and name, plus where the file is saved | Text |
Tab 4: Budget (one row per grant per budget line)
| Col | Header | What to enter | Formula or validation |
|---|---|---|---|
| A | Grant ID | Award | Dropdown from Awards!A:A |
| B | Budget line | Personnel, Fringe, Travel, Supplies, Contractual, Other, Indirect | Dropdown, same list on Expenses |
| C | Approved budget | Amount in the latest approved budget | Number, changed only with written approval |
| D | Actual to date | Calculated from Expenses | =SUMIFS(Expenses!D:D,Expenses!A:A,A2,Expenses!B:B,B2) |
| E | Variance | Calculated | =C2-D2 |
| F | % of line spent | Calculated | =IF(C2=0,"",D2/C2) |
Tab 5: Expenses (one row per charge, pasted from your accounting system)
| Col | Header | What to enter | Notes |
|---|---|---|---|
| A | Grant ID | Award charged | Map from your class, fund or project code |
| B | Budget line | Matching line from the Budget tab | Same dropdown list |
| C | Date and GL reference | Transaction date and journal or bill number | Lets you trace back to the ledger |
| D | Amount | Charge in USD | Negative for credits and reclasses |
Walking through each tab
Pipeline: keep stages fixed and dates separate
Set the Stage column as a dropdown so nobody types “pending” in one row and “submitted” in another. In Google Sheets you add one through Data > Data validation > Add rule or Insert > Dropdown (Google Docs Editors Help, no date shown). Keep LOI and application deadlines in separate columns, because a two-stage funder has two hard dates.
For a win rate, put this on a summary tab: =COUNTIFS(Pipeline!E:E,"Awarded")/(COUNTIFS(Pipeline!E:E,"Awarded")+COUNTIFS(Pipeline!E:E,"Declined")). It counts decided proposals only (Google COUNTIFS reference).
Awards: record restrictions and conditions separately
A restriction and a condition are different things in nonprofit accounting. FASB’s ASU 2018-08 defines a donor-imposed condition as a barrier the recipient must overcome plus a right of return or release, and says restrictions limit how a contribution is used without affecting whether you are entitled to it (FASB, June 2018). That is why the template tracks them in separate columns; your accountant needs both to record revenue in the right period.
The Burn gap column compares spending pace with time elapsed. The National Council on Aging’s grant funds tipsheet gives the example of 50% of a grant period gone with only 20% of funds spent as a warning sign, and notes that underspending is as risky as overspending (NCOA, June 23, 2026). Highlight the cell when the gap is below -0.15 or above 0.15; those thresholds are an illustration, so set your own.
Reports: one row per report, never one column per grant
A federal award with quarterly financial reports and a final report needs five or more rows, so this tab lists each report separately. To generate quarter ends, use EOMONTH: for an award starting July 1, 2026, =EOMONTH(DATE(2026,7,1),2) returns September 30, 2026, the end of the first quarter (Google EOMONTH reference).
For federal awards, the Uniform Guidance sets the default windows you can enter in the Days allowed column. Interim financial reports are due no later than 30 calendar days after the reporting period and annual reports no later than 90 days (2 CFR 200.328). Final reports are due no later than 120 calendar days after the period of performance ends for recipients, and 90 days for subrecipients unless the pass-through entity sets an earlier date (2 CFR 200.344). Foundation and corporate grants follow the award letter.
To highlight reports due within 30 days, select the Reports tab data and open Format > Conditional formatting, choose Custom formula is (Google Docs Editors Help, no date shown), and enter =AND($F2<>"Submitted",$F2<>"Accepted",$E2-TODAY()<=30).
Budget and Expenses: let the ledger drive the numbers
Paste a monthly export from your accounting system into Expenses rather than typing charges by hand. SUMIFS then totals each grant and budget line (Microsoft SUMIFS reference). NCOA recommends reconciling a grant tracker with finance at least monthly and keeping the written approval on file for any budget change the funder approves (NCOA, June 23, 2026).
For federal awards, also track cumulative moves between budget lines. Under 2 CFR 200.308(i), an agency may restrict transfers among direct cost categories when the federal share exceeds the simplified acquisition threshold and cumulative transfers exceed or are expected to exceed 10 percent of the total approved budget (2 CFR 200.308). A simple control is a transfer log on the Budget tab: record each amount moved between lines, divide the cumulative total by the award amount, and check your award terms before that figure nears 10%.
Common mistakes
- Typing actuals by hand. Keyed spending drifts from the general ledger. Paste exports and keep a GL reference on every row.
- Overwriting the approved budget. Change column C on the Budget tab only with funder approval on file.
- Defaulting to your fiscal year. Use each award’s own start and end dates for every calculation.
- Forgetting closeout. Add the final financial and final narrative reports to the Reports tab on the day you log the award, not when the period ends.
- Deleting closed grants. Federal award records must be kept for three years from the date you submit the final financial report, with longer periods if an audit or claim is pending (2 CFR 200.334). Move closed rows to an archive tab instead.
When to move from a spreadsheet to software
A spreadsheet works for a handful of foundation grants. Look at dedicated tools when:
- You manage more than one federal award, or your federal spending is approaching the Single Audit threshold, which is $1,000,000 for fiscal years starting on or after October 1, 2024 (Federal Audit Clearinghouse, November 7, 2024).
- Staff time is split across grants and needs effort records tied to payroll.
- Several people edit the file and you cannot tell who changed a figure.
- You bill funders for reimbursement or indirect costs and build each invoice by hand.
Grant-seeker platforms such as Instrumentl combine prospecting with tracking; its Full Lifecycle plan ($999 per month billed annually, up to 15 users) adds post-award tracking, budget-versus-actual reports and accounting integration, while the cheaper Discover and Pre-Award plans do not (Instrumentl pricing, no date shown, checked October 13, 2026). Euna Grants tracks requirements, deadlines and spend-down with automated reminders and audit trails, but does not publish pricing (Euna Solutions, July 28, 2026).
Other teams track grants inside the accounting system. Sage Intacct grant tracking and billing compares budget to actuals across grant periods that cross your fiscal year, tracks staff effort per grant and bills indirect costs; its grant tracking page lists no pricing (Sage, no date shown). For a fuller comparison of grant tools, see our grant management software guide, and for the accounting side, read how nonprofit accounting software simplifies grant tracking and compliance reporting. If the ledger is the bottleneck, see our nonprofit accounting software comparison.
How we researched this
We reviewed the top-ranking grant tracking templates from SpreadsheetPoint, Spreadsheet Daddy, Smartsheet and Grist; none combined multiple reports per grant, restriction tracking and budget-versus-actual spending in one workbook. We checked the federal reporting, closeout, budget revision and record retention rules in the eCFR (up to date as of October 8, 2026), FASB’s ASU 2018-08 text on conditions and restrictions, and the Microsoft and Google function references behind each formula. Product details come from vendor pages checked on October 13, 2026.
Related guides
- Grant Budget Template: Categories, Narrative and 2 CFR 200
- SF-425 Federal Financial Report: Lines, Due Dates, Ledger
- Period of Performance: Pre-Award Costs, NCEs and Closeout
Frequently asked questions
What columns should a grant tracking spreadsheet have?
At minimum you need a grant ID, funder, stage, deadlines, amount requested and awarded, award start and end dates, restriction type, report due dates and spending to date. Splitting these across pipeline, awards, reports and budget tabs keeps each tab readable and lets one grant carry many reports and budget lines.
How do I track grant report due dates in Excel?
Give every report its own row with the period end, the days allowed and a due date formula such as =C2+D2. Then highlight unsubmitted reports due within 30 days.
What is the difference between a restricted and a conditional grant?
A restricted grant limits what you can spend the money on or when. A conditional grant has a barrier you must meet, plus a right for the funder to take back or withhold the money, before you are entitled to it, as defined in FASB ASU 2018-08.
When should a nonprofit stop using a spreadsheet for grants?
Common triggers are managing federal awards, splitting staff time across several grants, billing funders for reimbursement, and having several people edit the same file. At that point, compare a grant management tool with the grant module in your accounting system.
Sources
- eCFR, 2 CFR 200.328 Financial reporting, up to date as of October 8, 2026. ecfr.gov
- eCFR, 2 CFR 200.344 Closeout, up to date as of October 8, 2026. ecfr.gov
- eCFR, 2 CFR 200.308 Revision of budget and program plans, up to date as of October 8, 2026. ecfr.gov
- eCFR, 2 CFR 200.334 Record retention requirements, up to date as of October 8, 2026. ecfr.gov
- Federal Audit Clearinghouse, Is my organization required to conduct a Single Audit?, November 7, 2024. support.fac.gov
- FASB, Accounting Standards Update No. 2018-08, June 2018. storage.fasb.org
- National Council on Aging, Grant funds tracking tipsheet, June 23, 2026. ncoa.org
- Microsoft Support, SUMIFS function, no date shown. support.microsoft.com
- Google Docs Editors Help, SUMIFS, no date shown. support.google.com
- Google Docs Editors Help, COUNTIFS, no date shown. support.google.com
- Google Docs Editors Help, EOMONTH, no date shown. support.google.com
- Google Docs Editors Help, Create an in-cell dropdown list, no date shown. support.google.com
- Google Docs Editors Help, Use conditional formatting rules in Google Sheets, no date shown. support.google.com
- Instrumentl, Pricing, no date shown, checked October 13, 2026 (vendor). instrumentl.com
- Euna Solutions, Euna Grants, July 28, 2026 (vendor). eunasolutions.com
- Sage, Sage Intacct Grant Tracking and Billing, no date shown, checked October 13, 2026 (vendor). sage.com
- Smartsheet, Free Grant Tracking and Grant Management Templates, June 26, 2024 (vendor). smartsheet.com
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
