Skip to content
ConductCommonsStart free

Grant budget

Grant budget template

Set a budget for each category, then log each expense. The Excel workbook adds up what is spent in each category and shows what remains. A Grants sheet keeps all of your lab’s grants on one list.

Build your budget

Nothing you enter leaves your browser.

Budget for each category

Budgets are in whole dollars. Leave any blank to fill in later.

Grant budget

Grant
Funder
Start date
End date

Budget by category

CategoryBudgetSpentRemainingPercent spent
Personnel
Fringe benefits
Equipment
Supplies
Travel
Publication costs
Other direct costs
Total

Expenses

DateCategoryDescriptionVendor or payeeAmount

Template from conductcommons.com/tools/grant-budget-template

Filling it in

What to track

The grant

The grant name, the funder, and the start and end dates.

Budget by category

The amount for each category, such as personnel, supplies, and travel.

Each expense

The date, the category, what it was for, who was paid, and the amount.

Spent and remaining

Each category’s spending from the expense log, the amount left, and the percent spent.

Time elapsed

The share of the grant period that has passed, beside the share of the budget spent.

All your grants

One list of the lab’s grants, each with its budget, the amount spent so far, and its dates.

In ConductCommons

Keep grant budgets with your lab records

Lab managementFree for labs

Every grant’s budget on one page

The Budgets page in ConductCommons lists each grant with its funder, dates, budget, and the amount spent so far. It keeps one total for each grant, so the expense detail stays in this workbook.

  • The amount left on each grant
  • How far a grant has gone over budget
  • Archive a finished grant, or restore it later

See lab management software

Budgets

The grants in Chen Lab, with each budget and what is spent so far.

R01 MH123456

NIH

Jan 1, 2026 to Dec 31, 2027

$92,500.00 spentof $250,000.00

$157,500.00 left

Seed award

University seed fund

Until Jun 30, 2027

$21,250.00 spentof $20,000.00

Over budget by $1,250.00

Spent so far is the total to date. Update it when the total changes.

Example data.

Questions

Grant budget questions

What should a grant budget include?

The grant name, the funder, the dates, and a budget for each category. Then log each expense with its date, category, and amount.

How do I track grant spending in Excel?

Enter each expense on the Expenses sheet and pick its category from the list. The Budget sheet adds up the spending in each category. It shows the amount remaining and the percent spent.

How can I tell if spending is on track?

Compare Time elapsed with Percent spent, below the table on the Budget sheet. Time elapsed is the share of the grant period that has passed. When Percent spent runs well ahead of it, the budget may run out before the grant ends.

Which budget categories should I use?

Use the categories in your funder’s budget. The template starts with personnel, fringe benefits, equipment, supplies, travel, publication costs, and other direct costs. It leaves out indirect costs, which are worked out as a rate on direct costs. Rename them or add your own before you download.

Can I track several grants in one spreadsheet?

Yes. The Grants sheet has lines for 20 grants. Enter each one’s budget, amount spent so far, and dates. It works out what remains on each one.

Can ConductCommons track grant budgets?

Yes. The Budgets page in ConductCommons lists each grant with its funder, dates, budget, and the amount spent so far. It keeps one total for each grant, not each expense. Copy the amount spent from this workbook when it changes. It is free for research labs.

Keep every grant budget in your lab workspace.

Grant tracking is free for research labs.