Grant Tracker Spreadsheet for Nonprofits, Grant Management Template, Application Deadlines and Award Spending Log

Seller's description

Instant digital download: grant tracker spreadsheet. You get 2 .xlsx files (blank and filled-in example), a printable PDF and a quick start guide. Nothing physical ships.

A grant tracker spreadsheet for a small nonprofit, school group or grant writer. Log every application, the awards you win, what you spend from each award and the reports each funder wants back, and it puts every application deadline and report due date into one list, soonest first.

WHAT YOU GET
- Grant-Tracker_Blank.xlsx: empty, ready for your own grants
- Grant-Tracker_Example.xlsx: the same workbook filled in with 6 sample funders, 11 applications, 4 awards and 7 reports
- Grant-Tracker_Printable.pdf: 2 pages on US Letter paper, a blank application log and a blank spending log to fill in by hand
- README.txt: quick start

HOW IT WORKS
1. Settings: an as of date (blank = today), how many days count as due soon, and how far spending can trail before an award shows Behind.
2. Funders: each funder once with its type. Grants, amount asked, amount awarded and win rate are worked out.
3. Pipeline: one row per application with the funder, the ask, the due date and a status picked from a list. Open applications show the days left.
4. Awarded: each grant you won with the award, start and end dates. Spent, left and pace are worked out from the Spending tab.
5. Spending: one row per expense, with the grant picked from a list.
6. Reports: each report a funder wants, with its due date. Type the date you sent it and the status changes to Sent.
7. Deadlines: applications still being written and reports not yet sent, soonest first, with days left. Late items turn red and items due soon turn gold.
8. Summary: counts and amounts by status, win rate, money waiting to hear, spent and left to spend.

WHAT MAKES IT DIFFERENT
- Application deadlines and report due dates in one list, so nothing slips.
- A pace check for each award: the share spent compared with the share of the grant period gone by.
- Win rate by funder, counting only applications that were awarded or declined.

THE FILES
9 tabs: Start Here, Settings, Funders, Pipeline, Awarded, Spending, Reports, Deadlines, Summary. Up to 50 funders, 100 applications, 50 awards, 500 spending rows and 200 reports. Cream cells are for typing and white cells calculate. Formula cells are protected with no password, so you can unprotect them in Excel with Review > Unprotect Sheet. No macros. The sample funders and grants are made up and generic.

THE PRINTABLE PDF
Two pages, US Letter: a blank application log (grant, funder, ask, due, status) and a blank spending log (date, grant, what for, amount).

WORKS IN: Microsoft Excel 2016 or newer, and Google Sheets (File > Import > Upload > Replace spreadsheet; layout may look slightly different). Apple Numbers: not tested. The tabs are laid out narrow for phone screens, but it has not been tested on a real iPhone or Android phone, so a computer is easiest for setup.

THIS IS NOT accounting software. It does not do fund accounting, payroll or bank reconciliation, and it is not legal or tax advice. It does not connect to any grant portal. The Deadlines tab shows the 40 soonest items.

PHOTOS: the listing photos are screenshots of the actual files and the actual PDF. They are not mockups.

INSTANT DOWNLOAD. Nothing physical ships. For personal use only. Please do not share or resell the files.

Designed with the help of AI tools, then reviewed and tested by me.