How do I track grant expenses in a spreadsheet? Twelve columns and one monthly check
A grant expense tracker needs twelve columns on one tab, a budget tab that compares spending to each line, and one monthly check against your books. Here is the layout, with what 2 CFR 200.302 says a recipient's records must show for each federal award.
Build it in seven steps
- Make one workbook per award, with an award header. Section 200.302(b)(1) calls for identifying each federal award received and expended. As applicable, that means the Assistance Listing title and number, the federal award identification number, the year the award was issued and the name of the federal agency or pass-through entity. Put those on the first tab so every report can quote them.
- Create the budget tab from the approved budget. One row per approved budget line, with columns for approved amount, spent to date, committed but unpaid, and balance left. Section 200.302(b)(5) calls for a comparison of expenditures with budget amounts for each award, and 200.302(b)(3) lists unobligated balances among what records must identify.
- Create the expense tab with twelve columns. Date incurred, date paid, vendor or payee, description, budget line, amount, invoice or receipt number, payment reference, link to the source document, who approved it, share charged to this award (percent or amount), and the request or report it was claimed on. Section 200.302(b)(3) says records must sufficiently identify the amount, source and expenditure of funds and be supported by source documentation. The link column is the support.
- Enter each cost when it is incurred, not when the report is due. Do the entry weekly. A late entry costs more than a missing column, because the person who remembers why a purchase was made has moved on. Pair each row with the allowability decision, as in the seven allowable cost tests.
- Split shared costs with a written method. If an invoice benefits several projects, put the method in a notes cell (by headcount, by hours, by square feet) and use it the same way each month. Under 200.405(d) as read, a cost benefiting two or more projects in determinable proportions is allocated on proportional benefit. Staff pay needs its own records, covered in time and effort reporting.
- Reconcile to your books on a fixed day each month. Total the expense tab by budget line and compare to the grant's class, project or fund in your accounting system. The two totals should match to the cent. If they do not, find the difference before anything is submitted. Section 200.302(a) says financial records must be sufficient to permit preparing the required reports and tracking expenditures.
- Flag any line that is trending over. Add a column on the budget tab that shows percent spent. When a line is close to its approved amount, or you expect to move money between lines, read your award's rules and see the budget modification request guide before spending.
This page describes a spreadsheet method built on 2 CFR 200.302 as read on 2026-11-09, which applies to federal awards. Your funder may require specific formats, and a spreadsheet is not a substitute for accounting software or an accountant. It is a working method, not legal, audit, tax or accounting advice.
What the layout looks like (made-up numbers)
This is a made-up budget tab for a $90,000 award, as it might look after the third month. The expense tab feeds the Spent column.
| Budget line | Approved | Spent | Committed | Balance | % spent |
|---|---|---|---|---|---|
| Personnel | $60,000 | $14,500 | $0 | $45,500 | 24% |
| Supplies | $12,000 | $3,100 | $900 | $8,000 | 26% |
| Training | $18,000 | $4,200 | $0 | $13,800 | 23% |
| Total | $90,000 | $21,800 | $900 | $67,300 | 24% |
Balance is approved minus spent minus committed. The made-up total balance of $67,300 is $90,000 minus $21,800 minus $900. If the sum of the three lines does not equal the total row, the formula is wrong somewhere, which is the point of having the total.
Formulas that save the most time
- SUMIFS on the expense tab by budget line and award, so the budget tab updates itself.
- A dropdown for budget line and for approver, so the names match exactly and the totals do not split.
- A check cell that subtracts the sum of the lines from the expense tab total and shows zero or a red flag.
- A lock on the budget tab's approved column, so a stray edit does not change the approved amounts.
If you use accounting software
Most accounting systems can tag each transaction to a project, class or fund. If yours can, tag every grant transaction when it is entered and make the spreadsheet the narrative layer on top: the link to the source, the approver, the allocation method and the request it was claimed on. Check your own software's help pages for how its tags work, since this page does not cover any one product. The spreadsheet and the books must agree, and a monthly reconciliation proves they do.
Common mistakes
- One sheet for all awards. A cost allocable to one award may not be moved to another to cover a shortfall (200.405(c)). Separate workbooks make that mistake hard to make.
- No link to the source document. A row with an amount and no support is a claim, not a record.
- Tracking only paid costs. Section 200.302(b)(3) includes obligations and unobligated balances, so keep a committed column.
- Reconciling only when a report is due. Monthly is the cheapest the check will ever be.
- Editing history. Fix an error with a new correcting row and a note, not by overwriting.
When a report or payment request is due, copy totals from the tracker rather than recompute them, then follow the reimbursement request checklist. At the end of the award, the same sheet feeds the closeout checklist.
The faster path, and what it does not do
GrantClose does not track dollars and is not accounting software, so it will not replace this spreadsheet. It handles the dates and evidence around it: make the monthly reconciliation a recurring deliverable with one owner, make each reimbursement request or financial report its own deliverable with a due date, and attach the exported tracker or the funder's confirmation as evidence so it is in the closeout ZIP when the award ends.
- It does not record expenses, amounts, budgets or balances, and it does not reconcile to your books.
- It does not tell you whether a cost is allowable or whether a budget change needs approval.
- It holds only what you upload, up to 15 MB per file. Do not upload health records, Social Security numbers, payment card data or client case files. The terms prohibit them.
GrantClose keeps evidence with each deadline and exports a closeout ZIP when the award ends. GrantClose never submits anything to a funder, writes your reports or gives legal, audit or compliance advice. Extracted dates are suggestions you confirm. Free for 1 active award. Create a free account
Questions
What columns should a grant expense tracker have?
At minimum: date incurred, date paid, vendor, description, budget line, amount, invoice or receipt number, payment reference, a link to the source document, approver, share charged to the award and the report or request it was claimed on. Section 200.302(b)(3) says records must be supported by source documentation.
What do the federal rules say grant financial records must show?
As read on 2026-11-09, 2 CFR 200.302(b) calls for identifying each award, accurate and complete financial results, records that identify the amount, source and expenditure of funds, effective control over funds and assets, a comparison of expenditures with budget amounts, and written procedures for payment and for allowability.
Is a spreadsheet good enough to track a grant?
For a few awards and one careful owner, often yes, if it has source links and is reconciled to the books monthly. Funder terms can require more, so check your award.
How often should I reconcile grant spending?
Monthly on a fixed day is a practical rule. The regulation does not set a frequency, but it does require records sufficient to prepare required reports and track expenditures.
Can I track several grants on one sheet?
It is risky. A cost allocable to one federal award may not be charged to another to overcome a shortfall under 200.405(c), so keep one workbook or one clearly separated tab set per award.
Sources read
- 2 CFR 200.302, financial management, read on 2026-11-09.
- 2 CFR 200.403, factors affecting allowability of costs, read on 2026-11-09.
- 2 CFR 200.405, allocable costs, read on 2026-11-09.