The grant
The grant name, the funder, and the start and end dates.
Grant budget
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.
Nothing you enter leaves your browser.
Grant budget
| Category | Budget | Spent | Remaining | Percent spent |
|---|---|---|---|---|
| Personnel | ||||
| Fringe benefits | ||||
| Equipment | ||||
| Supplies | ||||
| Travel | ||||
| Publication costs | ||||
| Other direct costs | ||||
| Total |
| Date | Category | Description | Vendor or payee | Amount |
|---|---|---|---|---|
Template from conductcommons.com/tools/grant-budget-template
Filling it in
The grant name, the funder, and the start and end dates.
The amount for each category, such as personnel, supplies, and travel.
The date, the category, what it was for, who was paid, and the amount.
Each category’s spending from the expense log, the amount left, and the percent spent.
The share of the grant period that has passed, beside the share of the budget spent.
One list of the lab’s grants, each with its budget, the amount spent so far, and its dates.
In ConductCommons
Lab managementFree for labs
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.
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
$157,500.00 left
Seed award
University seed fund
Until Jun 30, 2027
Over budget by $1,250.00
Spent so far is the total to date. Update it when the total changes.
Questions
The grant name, the funder, the dates, and a budget for each category. Then log each expense with its date, category, and amount.
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.
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.
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.
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.
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.
Grant tracking is free for research labs.