Free Template for Nonprofits and Local Governments

Free Grant Budget Tracking Template (Excel and Google Sheets)

Download a free grant budget template for Excel and Google Sheets: budget versus actual by line, an expense log that adds itself up, required match, and flags at 90% used and over budget.

Free, no email required. Download for Excel or Numbers, or make your own copy in Google Sheets (you'll need a Google account). Example rows are marked EX- so you can delete them.

Tabs

Grants, Budget lines, Expenses, Match, and How to use

Built in

Spent and committed add up from the expense log; flags at 90% used and over budget

Best for

A few grants where one person keeps the expense log current

Why track the grant budget outside your accounting system

Your accounting system knows what was spent. It rarely knows the grant's approved budget lines, what's been ordered but not paid, or how much match is still owed. This template puts those next to each other, so you can see before a report is due whether a line is about to run over or money is going unspent.

1

Grants: the totals, one row per award

Enter the award amount and any required match. Everything else on this tab adds itself up.

  • Award amount, and the total of your budget lines beside it, flagged if they don't agree
  • Spent, committed and available for the whole grant
  • Percent used, turning red if the grant goes over
  • Required match, match documented so far, and match still to document

Quick check: Does Budgeted equal Award amount for every grant? If not, a budget line is missing or a number is wrong.

2

Budget lines: approved versus spent

One row per budget line, named exactly as the agreement or approved budget names it.

  • Approved budget for each line
  • Spent and committed, added up for you from the Expenses tab
  • Available and percent used
  • A flag at 90% used and another when a line goes over budget
  • Notes, for rules such as how much you can move between lines without approval

Red flag: A line passes 100% and nobody asked the funder whether the change needs approval.

3

Expenses: one row per invoice, payroll run or purchase order

This is the only tab you update week to week.

  • Date, grant, budget line, who was paid and what for
  • Amount, and the invoice or check number
  • Paid, or Committed for money you've ordered but not yet paid
  • Where the invoice and proof of payment are filed; rows without proof turn amber

Tip: Type the budget line exactly as it appears on the Budget lines tab, or pick it from the list, so the totals find it.

4

Match: what you've contributed, and the proof

If the agreement requires match, auditors will ask how each dollar was valued and documented.

  • Each contribution, cash or in-kind, with its date and source
  • How in-kind contributions were valued
  • Where the proof is filed

Quick check: Could you show the documentation for every match entry today?

Signs you've outgrown the spreadsheet

A budget spreadsheet works while one person keeps it current. If several of these are true, it may be time for software.

  • More than one person enters expenses, in more than one copy
  • Budget numbers are typed in from the agreement by hand for every grant
  • Invoices and proof of payment live in email, not beside the expense
  • You've been surprised by an over-budget line or unspent funds at closeout
  • Reimbursement requests take days to assemble
  • An audit or monitoring visit is coming up

Self-score

Give yourself 1 point for every statement you can honestly say is true.

  • Budget lines add up to the award amount for every grant
  • Every expense names a grant and a budget line
  • Every paid expense shows where its invoice and proof of payment are filed
  • No line is over budget without funder approval
  • Committed amounts are reviewed monthly and cleared when paid
  • Every match entry has documentation
  • Totals agree with the accounting system
  • Example rows have been deleted

7 to 8: Strong foundation

4 to 6: Some gaps, manageable if addressed now

0 to 3: High risk of preventable problems

What the Budget lines tab looks like

Example rows from the template. Spent and Committed come from the Expenses tab.

Grant IDBudget lineApproved budgetSpentCommittedAvailable% usedFlag
EX-CDBGConstruction$380,000$210,000$120,000$50,00087%
EX-CDBGAdministration$45,000$18,000$0$27,00040%
EX-FDNPersonnel$52,000$44,500$0$7,50086%
EX-FDNBooks and supplies$23,000$21,400$0$1,60093%90% or more used
Next step

Want the budget to fill itself in?

GrantGuard reads the budget lines from your grant agreement, tracks each expense against them with the invoice and proof of payment attached, and warns you at 90% used. Start a free 30-day trial with one of your own agreements.

Start Free 30-Day Trial Book a Demo
Print this page to save as PDF

More free templates and guides

Grant budget template questions

Does the template work in Google Sheets?

Yes. Use the Make a copy in Google Sheets button at the top of this page to get your own copy, or download the file and import it. The formulas use only functions that Excel, Google Sheets and Numbers share.

How is budget versus actual calculated?

Each budget line's Spent is the total of its Paid rows on the Expenses tab, and Committed is the total of its Committed rows. Available is the approved budget minus both.

Can it track more than one grant?

Yes. Add a row per grant on the Grants tab and use its Grant ID on the other tabs. Totals are kept separately for each grant.

How do I track cost share or match?

Enter the required match on the Grants tab and log each contribution on the Match tab. The Grants tab shows how much is still to document.

Still have a question? Book a 45-minute demo, send us a message, or start your free trial.