Excel workbook previewGrant Budget Template (Federal Award, SF-424A Categories)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A grant budget for a federal application has two parts: the detail that shows how every figure was built, and the summary in the object class categories of the SF-424A budget information form. Reviewers compare the two, and an auditor later compares spending with the approved budget. A template that keeps the detail and the summary linked avoids the most common problem: a summary that no longer matches the justification after a late change.
The workbook has a Budget Detail sheet where each line has a category, a basis of estimate, units, unit cost, a factor such as months or effort, a federal share and a budget year. The SF-424A Summary sheet adds it all up by category and year with live formulas, applies the indirect rate to the federal base, and checks the award ceiling, cost share and the USD 10,000 equipment threshold from 2 CFR 200.1. Everything rests on 2 CFR 200 and the public SF-424A instructions.
Who it is for
The grants manager or finance lead who has to submit a federal application budget, with its justification, and was given a blank SF-424A and a deadline.
What is inside
- Budget Detail sheet with 12 worked line items for a two-year Town of Maple Fork application and 18 blank rows
- Each line built from units, unit cost and a factor, with a federal share percentage that splits it into federal and non-federal amounts
- SF-424A Summary sheet with object class lines 6a to 6k for each budget year, federal and non-federal, all by live formula
- Indirect charges calculated on the federal MTDC base per year from the Included or Excluded flag on each line
- Budget checks: headroom under the award ceiling, cost share achieved against the required share, and equipment and supplies lines on the wrong side of the USD 10,000 threshold
- Forecasted federal cash needs by quarter for the first year, with a check that the quarters add to 100 percent
- Dropdowns for category, budget year and MTDC treatment, frozen headers, filters and print fit
- How to use sheet with the source of every threshold
How to use it
Replace the worked lines on the Budget Detail sheet with your own, then read the SF-424A Summary sheet.
Files
- XLSXgrant-budget-template.xlsx14 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What are the SF-424A budget categories?
Section B of the SF-424A lists the object class categories Personnel, Fringe Benefits, Travel, Equipment, Supplies, Contractual, Construction and Other, then Total Direct Charges, Indirect Charges and Totals, with Program Income on a separate line. Section D asks for the forecasted cash needs by quarter for the first year.
When is an item equipment rather than supplies in a federal budget?
Under 2 CFR 200.1 as revised in 2024, equipment is tangible personal property with a useful life of more than one year and a per-unit acquisition cost at or above the lower of your capitalization level or USD 10,000. Anything else is a supply. The workbook flags supplies lines with a unit cost at or above your threshold.
Do I need prior approval to move money between budget categories after the award?
Section 200.308 lists the changes that always need prior written approval, such as a change in scope or moving participant support funds. An agency may also restrict transfers between direct cost categories when the federal share is above the simplified acquisition threshold and cumulative transfers exceed 10 percent of the total approved budget. Read the award terms for the exact rule.



