← Back to blog

Grant Budget Template: How to Build a Spreadsheet That Adds Up

A grant budget template with live formulas and check cells: the line formula, subtotals, the MTDC indirect base, four checks to add, and one master tab for every funder form.

Grant budget template spreadsheet showing cost categories and calculated totals

In this article (10)

A grant budget template is only as good as its arithmetic. Change one salary percentage two days before a deadline and every subtotal, the indirect line and the grand total have to move with it, or the budget you submit no longer adds up. This guide covers that machinery: the formulas, the check cells and the tab layout that keep a spreadsheet honest, shown cell by cell in the free workbook below and its worked example, a one-year community health screening project that totals $140,002.

What each budget category means, how to write the budget narrative and which costs funders allow are covered in the companion grant proposal budget template guide. Use this page when you are building the spreadsheet itself, or fixing one that stopped adding up.

Quick Answer: What Is a Grant Budget Template?

A grant budget template is a spreadsheet that organizes a project's costs into the categories funders expect (personnel, fringe benefits, travel, equipment, supplies, contractual, other, and indirect costs) and calculates every total with formulas. Each line is a quantity times a rate times the share charged to the project, the subtotals and the indirect charge are formulas, and check cells flag a broken formula before a reviewer does.

Free download: Grant budget spreadsheet with live formulas as Excel .xlsx. No email address required. The free grant templates page has the budget narrative template, a budget versus actual tracker and the rest of the set.

Writing your own? Start it as a draft in GrantCue, with AI help for each section. Start the proposal free

How the Workbook Is Laid Out

The workbook has a Read Me and six working tabs, each with one job.

TabWhat it doesWhat you type there
AssumptionsFringe rate (24 percent in the example), indirect rate (15 percent), indirect base, $10,000 equipment threshold, $50,000 subaward cap, budget periodEvery value
Budget MasterEvery line item, priced as quantity times rate times percent allocated, with subtotals and totalsThe shaded input cells only
SF-424A Section BThe federal object class summary, lines 6a through 6k, read from the Budget Master subtotalsProgram income only
Foundation SummaryThe same numbers grouped into seven lines for a one-page foundation budgetNothing
Post-Award TrackingApproved budget against actual spend by categoryActual spend to date
Reviewer ChecklistFourteen pre-submission checks, each marked Yes or NoThe Done column

One rule holds it together: every rate lives in one place. Budget Master reads the fringe rate, the indirect rate and the subaward cap from the Assumptions tab, so changing a rate there changes the whole budget, and no summary tab holds a typed dollar figure.

Federal applicants will recognize the category order. It follows SF-424A, the Budget Information form for non-construction programs, whose Section B runs Personnel, Fringe Benefits, Travel, Equipment, Supplies, Contractual, Construction, Other, Total Direct Charges, Indirect Charges, and Totals. Building against the longest list means the master collapses cleanly into the shorter forms states and foundations use.

Nonprofit finance staff working through a grant budget spreadsheet on a laptop

The Line Formula: Quantity x Rate x Percent Allocated

Every row in Budget Master has the same eleven columns: line item, basis, quantity, rate, percent allocated, line total, requested from funder, match or other sources, MTDC treatment, in indirect base, and notes. Four of them are formulas. Here they are on row 9, the program manager:

Line total (F9)        =IF(OR($C9="",$D9=""),"",$C9*$D9*IF($E9="",1,$E9))
Requested (G9)         =IF($F9="","",$F9)
Match / other (H9)     =IF($F9="","",$F9-N($G9))
In indirect base (J9)  =IF($F9="","",IF($I9="Subaward",MIN($F9,'Assumptions'!$B$9),IF($I9="Include",$F9,0)))

The line total stays blank until both quantity and rate are filled in, so empty rows add nothing, and a blank percent counts as 100 percent. Requested starts equal to the line total; overwrite it with a smaller number where another source pays part of the cost, and the match column fills in the difference, which is the figure a cost-share requirement asks to see. The MTDC treatment cell is a dropdown with three choices. Include passes the whole line into the indirect base, Exclude passes zero, and Subaward passes only the first $50,000.

The program manager row shows the pattern. The rate cell holds =68000/12, so a reader sees an annual salary turned into a monthly rate; the quantity is 12 months and the percent allocated is 0.4, for a line total of $27,200. The fringe row takes its quantity from the personnel subtotal (=$F$14) and its rate from the Assumptions tab (='Assumptions'!$B$5). That is how the template keeps fringe on personnel and off the rest of the budget: 24 percent of $69,200 is $16,608.

The notes column, the last one to the right of the money, is where you record why each rate is what it is. Six months later, when a program officer asks how you arrived at a per-unit cost, the answer is already in the file, and the budget narrative is mostly those notes written out as sentences.

Diagram of grant budget formulas chaining from line items to subtotals to grand total

Subtotals, the Indirect Base and the Grand Total

Subtotal, personnel (F14)      =SUM(F9:F13)
Total direct charges (F54)     =F14+F19+F25+F30+F36+F42+F46+F52
Indirect base, MTDC (F55)      =J54
Indirect charges (F56)         =ROUND(F55*E56,0)
Total project cost (F57)       =F54+F56

Total direct charges adds the eight category subtotals one by one rather than summing the whole column, because one SUM down the column would count every line twice: once on its own row and once inside its subtotal. Cell J54 builds the indirect base the same way from the In Indirect Base column, so excluded lines drop out before the rate touches them. The rate sits in E56, read from the Assumptions tab, and the indirect charge is rounded to whole dollars in that one cell and nowhere else.

Two federal rules decide how the MTDC dropdown is set, and both come from the Uniform Guidance (2 CFR 200). Under 2 CFR 200.1, equipment means tangible personal property with a useful life over one year and a per-unit acquisition cost at or above the lesser of your own capitalization level or $10,000; anything below that is a supply, and equipment leaves the base. The threshold was $5,000 before the April 2024 revision of the Uniform Guidance (89 FR 30046, April 22, 2024), so older form instructions and internal policies may still quote the old figure.

Modified total direct cost, defined in the same section, means direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and the first $50,000 of each subaward. It excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward above $50,000. Recipients without a current federally negotiated rate may elect a de minimis rate of up to 15 percent of that base under 2 CFR 200.414(f), raised from 10 percent by the same revision. Once elected, the de minimis rate applies to all your federal awards until you choose to negotiate a rate, and each cost must be charged consistently as either direct or indirect, never both.

Illustration of costs excluded from the indirect cost base before the rate is applied

Here is the worked example in the workbook: a one-year community health screening project at a small nonprofit with no negotiated rate, electing the de minimis rate.

CategoryCalculationMTDC treatmentAmount
PersonnelProgram manager $68,000 at 40%, outreach worker $42,000 at 100%Include$69,200
Fringe benefits24% of personnelInclude$16,608
Travel12 outreach trips at $185Include$2,220
Equipment1 portable screening unit at $12,400Exclude$12,400
Supplies600 screening kits at $18Include$10,800
ContractualExternal evaluator, fixed-price agreementInclude$9,000
Other240 participant transit stipends at $15Exclude$3,600
Total direct chargesSum of the category subtotals$123,828
Indirect base (MTDC)Total direct less equipment and participant support$107,828
Indirect charges15% of MTDC, rounded$16,174
Total project costDirect plus indirect$140,002

Illustrative figures, not data from a real organization.

Two lines come out of the base. The screening unit is equipment. The transit stipends are paid to or on behalf of participants, which makes them participant support costs under 2 CFR 200.1; stipends and allowances paid to your own employees do not qualify, and they stay in the base. The $9,000 evaluator contract stays in too: services count in full, and only subawards are capped at $50,000. Its price should trace to the design in your evaluation plan.

The Two Check Cells Already in the Workbook

Balanced (F59)          =IF(ROUND(G57+H57-F57,2)=0,"Balanced","CHECK - the splits do not tie")
Indirect check (F60)    =ROUND(F54*E56,0)-F56

The first confirms that the requested column plus the match column still equals the total project cost. It stops saying Balanced when someone types over a formula in the match column or over a subtotal row. Overwriting the Requested column is expected and does not trip it.

The second shows what the exclusions are worth. In the example, 15 percent of total direct charges would be $18,574, so the cell reads $2,400, the amount by which skipping the MTDC base would overstate the request. That is the kind of error a federal reviewer catches.

Four Checks Worth Adding Before You Submit

These are not in the downloaded file. Each takes one cell, and each catches a failure the two built-in checks miss. We tested all four in Excel on a copy of the workbook.

The most common break is a row added inside a category block without widening the subtotal's SUM range. The new line drops out of every total, and the Balanced check still says Balanced, because the requested and match columns drop the same amount. This cell compares the sum of every line total with total direct charges:

=IF(ROUND(SUMIF(A9:A52,"<>Subtotal*",F9:F52)-F54,2)=0,"OK","CHECK - a line sits outside its subtotal")

On the example it reads OK. With a $1,000 line typed into the blank row under the personnel subtotal, it reads CHECK while F59 still reads Balanced.

A supply priced at or above the equipment threshold belongs on the equipment line and out of the base. A spare column beside each supply row can flag it:

=IF(N(D33)>='Assumptions'!$B$8,"Unit cost is at or above the equipment threshold","")

The request has to match the amount on the cover form and in the request paragraph, and a late edit to one of them is how they drift apart. Type the cover-form amount into a spare cell, F61 for example, and compare:

=IF(F61=F57,"OK","CHECK - the cover form says "&TEXT(F61,"$#,##0"))

When a private funder caps indirect costs below your rate, keep both numbers visible instead of overwriting the rate. Put the cap on the Assumptions tab and have the rate cell take the lower of the two, for example =MIN('Assumptions'!$B$6,'Assumptions'!$B$14) with the cap in B14, so the narrative can state your rate and the capped rate side by side.

One check belongs outside the budget file. The same person can be budgeted at 0.5 FTE on three different applications, and after the awards start, an effective-dated payroll allocation template checks that each person's shares total 100 percent every pay period.

From the Master Tab to the Funder's Form

Your budget template is the working file. The funder's form is the output.

The SF-424A tab is built entirely from references. Line 6a, Personnel, reads 'Budget Master'!G14 in the federal column, H14 in the non-federal column and F14 in the total, and every line down to 6k works the same way. Transcribe from that tab onto the form; never type into it. The Foundation Summary groups the same subtotals into seven lines, from staff and benefits to administrative and indirect costs, and adds one ratio foundations read: the requested share of total project cost, =B12/D12.

Build every number in the spreadsheet, then transcribe the totals onto the portal form or the PDF the funder requires. Typing figures straight into a portal loses the arithmetic behind them, and most portals will not show you two categories at once, so an error in one field is hard to see from any other.

Funder typeTypical budget formatWhat the template needs to produce
Federal agencySF-424A object class categories, plus a detailed budget and narrativeCategory subtotals, a stated indirect rate and base, and a federal versus non-federal split
State portalAn online form with a fixed category list, often fewer rowsMapped subtotals, since two of your categories may merge into one field
Private foundationA one-page project budget, sometimes with an organizational budget attachedA simplified view that still ties to the same line items

One tab per funder format, each pulling from the master line-item tab, keeps every version in sync. Rebuilding the budget separately for each funder is how the narrative and the spreadsheet drift apart, one of the failure modes covered in the guide to how to write a grant proposal.

The Reviewer Checklist tab holds the checks a formula cannot run for you: every personnel line appears in the narrative with the same title and role, no line exists that the narrative never mentions, every line states a unit cost a reviewer can price-check, and the grand total equals the amount on the cover form and in the request paragraph. Its last row counts the Yes answers, so the file shows at a glance how many checks are done.

Grant management software can be one more destination for the same numbers, and a budget moves into it most cleanly as one plain table on the first tab, as this guide to Excel integration in grant management software explains.

Using the Budget After the Award

Once the award lands, the budget template is your financial reporting baseline. Keep the working file instead of archiving it with the proposal. The Post-Award Tracking tab carries the approved amount for each category straight from Budget Master, takes actual spend to date, and calculates what remains and the percent expended. The workbook's own rule of thumb: a category more than 10 percent off its pro-rated pace is worth explaining before the funder asks.

The awarded budget belongs next to the deadlines and deliverables it pays for. Budget variance is a program signal as much as a finance one, which puts it inside grants lifecycle management rather than off in an accounting folder: a category running hot usually means the program is running differently than proposed.

The personnel lines in that comparison come from payroll, and how job costing moves salary and fringe to each award explains the records behind them.

FAQ

What is a grant budget template?

A grant budget template is a spreadsheet that organizes project costs into funder-recognized categories with formulas that calculate the line totals, subtotals, indirect costs, and a grand total. It lets one master file feed several application formats without rebuilding the numbers each time.

What formula calculates indirect costs in a grant budget?

Indirect charges equal the indirect base times the rate, rounded to whole dollars. With the de minimis election under 2 CFR 200.414(f), the base is modified total direct cost: total direct charges minus equipment, participant support costs, the portion of each subaward above $50,000 and the other exclusions in 2 CFR 200.1. In the worked example that is $107,828 times 15 percent, or $16,174.

How do I stop a grant budget spreadsheet from breaking when I add rows?

Add rows inside a category block, never below its subtotal row, then widen the subtotal's SUM range to cover them. A check cell that compares the sum of all line totals with total direct charges catches a row that was missed, which a requested-plus-match check alone does not.

Can I use the same grant budget template for every funder?

Yes, if you keep the line-item detail in one master tab and add a separate output tab per funder format. Funders differ in how they group categories and how much detail they want, but the underlying cost calculations rarely change.

What is the equipment threshold on a federal grant budget?

Under 2 CFR 200.1, equipment means tangible personal property with a useful life over one year and a per-unit acquisition cost at or above the lesser of your organization's own capitalization level or $10,000. Items below that threshold are supplies.

Next Steps

The budget usually changes what the project can promise, so build it before the narrative is final. Then compare your structure with the three worked budget proposal examples to see the same shape at different award sizes.

When the template is ready, the constraint moves to finding the right funders. GrantCue searches federal and state grant portals together and tracks each opportunity's deadline and stage, so the budget you just built goes to applications worth the effort. Search open grants to see what is currently accepting applications in your area of work.