Excel workbook previewStatement of Functional Expenses Template (Form 990 Part IX)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A statement of functional expenses shows each type of expense, such as salaries, rent or travel, split by function: program services, management and general, and fundraising. Section 501(c)(3) and 501(c)(4) organizations must complete all four columns of Form 990, Part IX, and auditors, grantors and charity evaluators ask for the same split. It is usually needed when the return is being prepared, when the auditor asks how the allocation was done, or when a funder asks what share of spending reaches programs.
This workbook follows the line structure of Form 990, Part IX, lines 1 to 26. Each line has a total and an allocation basis, and the three functional columns are calculated by formula. Staff time, floor space and headcount bases are built on their own sheets, so the method is documented as the IRS instructions require. A checks sheet tests the shaded cells, the Schedule O, Schedule I, Schedule F and Schedule G triggers stated on the form, and ties the result to Part I. Every rule comes from the free IRS Form 990 and its instructions.
Who it is for
The nonprofit controller or accountant asked by the auditor or the Form 990 preparer for a functional expense schedule with a documented allocation method.
What is inside
- Part IX sheet with all lines 1 to 24e, line 25 total and line 26 joint costs, filled with a worked example for an invented youth charity
- Columns (B), (C) and (D) calculated by formula from a dropdown allocation basis on each line, or from custom percentages
- Grey cells where the form shades a column (lines 1 to 4 and line 11e) and a row check that flags any amount placed there
- Staff Time sheet for 10 sample positions and 14 blank rows that turns salary and time shares into the staff time basis
- Allocation Bases sheet with 7 bases, including floor space and headcount inputs that calculate their own percentages
- Checks sheet with 10 tests, including the 10 percent Schedule O rule for lines 11g and 24e, the Schedule I and F thresholds and the Part IV, line 17 test
- Form 990 Part I tie-out for lines 13 to 18, all by formula
- How to use sheet with the IRS allocation rules and the affiliation note
How to use it
Enter each expense total from your trial balance in column C of the Part IX sheet, then pick an allocation basis on every line.
Files
- XLSXstatement-of-functional-expenses-template.xlsx19 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
Which organizations must complete all columns of Form 990 Part IX?
The form states that section 501(c)(3) and 501(c)(4) organizations must complete all columns. All other organizations must complete column (A) and can complete columns (B), (C) and (D). State charity regulators can have different requirements, so check the rules of each state where the organization is registered.
How should shared costs be allocated between program, management and fundraising?
The Form 990 instructions say an organization whose accounting system does not allocate expenses can use any reasonable method of allocation, but must report accurately and document the method in its records. Common bases are staff time records for salaries, floor space for occupancy and headcount for office costs. This template keeps each basis on its own sheet so the method is visible.
Can an employee who works mostly on programs be reported as 100 percent program?
No. The Form 990 instructions give the example of an employee who spends 40 percent of the time on fundraising and 60 percent on program management. The salary must be allocated 40 percent to fundraising and 60 percent to program services, even though most of the time is spent on programs.



