A small nonprofit does not need a separate spreadsheet for every grant question. Start with five working sheets: an award summary, a budget tracker, an evidence index, a reporting map, and a closeout checklist. Keep them tied to the signed award and source records.
These are internal worksheets, not official forms. Adapt the fields to the funder’s instructions and the accounting system your team already uses.

The Nonprofit Grant Compliance Prompts book pairs well with these sheets. For the surrounding process, see the AI file check guide, reporting gaps to catch, the award-to-closeout workflow, and the grant compliance Q&A.
Before you copy these sheets
- Use one folder or system as the official record location.
- Keep the signed award and amendments at the top of the file.
- Record a source for every date, amount, and report figure.
- Limit access to staff who need the information.
- Do not paste sensitive records into an unapproved AI service.
For covered federal awards, the current financial management requirements include tracking expenditures and supporting records with source documentation. The award itself explains which reports and dates your nonprofit must follow. A private foundation, state, or local grant may use different requirements.
Template 1: award summary and requirement register
Use one page to help staff find the current terms without rereading the entire application folder.
| Field | What to record |
|---|---|
| Funder and award ID | Exact name and ID from signed award |
| Project period | Start and end date, plus amendment date if changed |
| Approved amount | Current award amount and approved budget location |
| Scope and deliverables | Short description with source page or clause |
| Reports and due dates | Report name, system, period, deadline, and instructions |
| Other conditions | Match, equipment, prior approval, or partner terms |
| Owner and reviewer | Named staff roles and back-up contact |
| Questions | Question, person asked, date, and written response |
Do not rely on a summary to replace the agreement. Add a page or paragraph reference for each important requirement.
Template 2: grant budget and expense tracker
This is a working index, not a replacement for your accounting ledger. Finance should reconcile it to the system of record.
| Date | Transaction ID | Amount | Budget category | Source file | Reviewer note |
|---|---|---|---|---|---|
| YYYY-MM-DD | System reference | $0.00 | Approved line | Invoice or receipt path | Verified, question, or follow-up |
Add columns if needed for reporting period, approval date, allocation method, vendor reference, payment date, or a funder approval. Keep the support in the original records location, then point to it here.
When your team checks the current budget, note the approved version and the date it took effect. A revised request is not an approved change until the required authorization is in the file.
Template 3: evidence index
Use this sheet to connect a report answer or transaction with the document that supports it.
| Evidence ID | Record name | Period | What it supports | Owner | Location |
|---|---|---|---|---|---|
| E-001 | Monthly attendance summary | April | Unique participant count | Program lead | Approved folder path |
| E-002 | Vendor invoice and payment record | April | Expense entry 24-018 | Finance lead | Accounting record link |
Write what a record supports, but also note what it does not establish. An invoice may show an amount billed. It does not, by itself, show that the nonprofit paid it or that the cost belongs in a particular award category.
Template 4: reporting question and source map
Draft this before the report is due. It gives program and finance staff a shared list instead of one last-minute email chain.
| Funder question | Source and measure definition | Reporting owner | Review status |
|---|---|---|---|
| How many unique people received service? | Dedupe rule and period-specific attendance file | Program lead | Needs count and second review |
| What was spent in this period? | Reconciled ledger and source documents | Finance lead | Draft total, check category |
| What changed from the plan? | Approved work plan and dated program notes | Project lead | Explain variance from records |
Keep targets, actual results, cumulative totals, and forecasts in separate fields. If a measure was unavailable, ask how the funder wants it handled. Do not make up a number to fill the cell.
Template 5: closeout and record retention checklist
Start the closeout list before the final reporting period. That gives finance and program staff time to resolve open items.
- Final financial and performance reports identified.
- Reporting portal and current due dates confirmed.
- Ledger reconciled to source documentation.
- Partner or subrecipient reports received, if applicable.
- Open invoices, obligations, and questions assigned to an owner.
- Equipment or property records checked against award conditions.
- Unspent funds and return instructions confirmed with funder.
- Final reports, approvals, submission receipts, and funder responses saved.
- Retention date and any exception or extension recorded.
For covered federal awards, 2 CFR 200.344 sets general closeout duties and final report timing. Recipients generally have up to 120 calendar days after the period of performance. Subrecipients generally have 90 days to report to the pass-through entity or an earlier agreed date. Check the specific award and current instructions before you set a final deadline.
The general record retention period under 2 CFR 200.334 is three years from the submission of the final financial report, with exceptions for certain circumstances and records. Follow the applicable rule and your organization’s retention policy.
A fictional example: how the sheets work together
A local literacy group receives a federal award to run evening tutoring. Its award register lists the amended project end date and the quarterly reports. The expense tracker points to the accounting ledger and invoice folder. The evidence index connects participant totals to the attendance records. The reporting map assigns one answer to the program lead and another to finance.
At closeout, the checklist shows that one partner report is still missing. The grant manager follows up, saves the response, and records the final submission receipt. The team can see what was done and who verified it without digging through every email.
Set up the sheets so your team will use them
Before copying the layouts into a spreadsheet, decide where the official records live and how the team will name them. Then keep the worksheet fields close to your current bookkeeping and reporting terms. If staff must translate every category by hand, the sheet will drift away from the ledger.
- Choose a grant ID that matches the accounting system.
- Use one date format across reports and source lists.
- Link to a controlled folder instead of attaching a second copy of every receipt.
- Use a status that says what happens next, such as “finance check needed,” rather than “pending.”
- Set access based on role, especially for participant, personnel, and financial records.
Worked example: follow one report number to its source
Suppose the report asks for completed tutoring sessions in May. The reporting map points to the May session log and identifies the program manager as the owner. The evidence index records the file location, reporting period, and calculation note. If the log shows 18 sessions and the draft report says 20, the reviewer can spot the mismatch and ask about it before submission.
The team should not overwrite the original attendance log to make the report match. It should check whether two canceled sessions were counted by mistake, document the correction, and keep a dated note of who verified the final number.
| Worksheet field | Example entry |
|---|---|
| Funder question | How many tutoring sessions took place in May? |
| Source | May session log, controlled program folder |
| Draft answer | 20 |
| Review finding | Two canceled sessions included |
| Verified answer | 18, confirmed by program manager |
This is why each sheet needs a source and a reviewer field. A total without its calculation path is hard to correct and harder to explain later.
Use AI for a careful first pass
If your organization has an approved AI tool, ask it to check a de-identified copy of the worksheets:
“Review these grant worksheets for blank owners, missing source paths, inconsistent dates or IDs, budget rows without a record, and report claims without a supporting source. Return the worksheet name, row, issue, and a question for the responsible person. Do not fill missing fields, decide cost allowability, or create deadlines that are not stated in the award.”
Check every flag against the original records. Keep the AI output as a review note, not the official grant record. Do not include participant details, bank data, or other sensitive information in a tool your organization has not approved.
Keep the templates useful
A worksheet that staff avoid is one more file to maintain. Keep the fields that help your team answer real questions. Remove duplicates. Review the layout when the award changes, when the funder updates its reporting system, or when staff find a field nobody can explain.
The goal is simple: someone should be able to tell which award the record belongs to, where the figure came from, who checked it, and what still needs attention.
Want prompts to use alongside these worksheets?
The Nonprofit Grant Compliance Prompts book gives small nonprofit staff a practical starting set for reading award conditions, reviewing budget and transaction records, matching report answers to sources, and preparing closeout questions. Use a prompt to organize work, not to replace the signed award or an authorized decision. Have finance or program staff check the result before relying on it. To see how the pieces fit, read the AI file guide, reporting review, workflow, and Q&A.
Frequently asked questions
Are these official federal grant forms?
No. They are internal worksheets. Follow the forms and portal instructions named in your award.
Can I use these templates for private foundation grants?
You can adapt the organizing ideas, but follow the foundation agreement. Federal rules do not automatically apply to private awards.
What should a grant expense tracker include?
Useful fields include award ID, date, transaction reference, amount, budget category, source document, approval, reporting period, and reviewer status.
How long should I keep the completed worksheets?
For covered federal awards, the general rule is three years after the final financial report is submitted, subject to exceptions in 2 CFR 200.334.
Can AI fill the grant templates for us?
It can help organize a redacted copy or flag blank fields. Staff must verify every entry and make all decisions.
Last reviewed: November 16, 2026. These templates are general working aids, not legal or accounting advice. Award terms and reporting requirements vary.