Grant Templates: 5 Documents to Keep a Small Nonprofit’s Award File Straight


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.

Five blank nonprofit grant worksheets arranged on a table, including an award folder, budget grid, evidence cards, calendar, and closeout checklist
A few well-kept worksheets make the award, the records, and the next deadline easier to find.

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.

FieldWhat to record
Funder and award IDExact name and ID from signed award
Project periodStart and end date, plus amendment date if changed
Approved amountCurrent award amount and approved budget location
Scope and deliverablesShort description with source page or clause
Reports and due datesReport name, system, period, deadline, and instructions
Other conditionsMatch, equipment, prior approval, or partner terms
Owner and reviewerNamed staff roles and back-up contact
QuestionsQuestion, 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.

DateTransaction IDAmountBudget categorySource fileReviewer note
YYYY-MM-DDSystem reference$0.00Approved lineInvoice or receipt pathVerified, 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 IDRecord namePeriodWhat it supportsOwnerLocation
E-001Monthly attendance summaryAprilUnique participant countProgram leadApproved folder path
E-002Vendor invoice and payment recordAprilExpense entry 24-018Finance leadAccounting 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 questionSource and measure definitionReporting ownerReview status
How many unique people received service?Dedupe rule and period-specific attendance fileProgram leadNeeds count and second review
What was spent in this period?Reconciled ledger and source documentsFinance leadDraft total, check category
What changed from the plan?Approved work plan and dated program notesProject leadExplain 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 fieldExample entry
Funder questionHow many tutoring sessions took place in May?
SourceMay session log, controlled program folder
Draft answer20
Review findingTwo canceled sessions included
Verified answer18, 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.

Leave a Comment

Item added to cart.
0 items - $0.00