Functional Expense Allocation
Illustrative, for a fictional community health nonprofit called Cedar Line Community Health. Fiscal year ended 30 June, total functional expenses $1,984,800, total revenue $1,914,000. The two right-hand columns are the pass no checklist asks for.
| Line | Natural expense | Total | Basis behind the split | Documented | Was | Now |
|---|---|---|---|---|---|---|
| 7 | Other salaries and wages | 892,000 | A percentage set in 2021 | no | 76% | 68% |
| 5 | Officers and key employees | 214,000 | Direct for two roles, an estimate for the ED | partial | 42% | 34% |
| 16 | Occupancy | 164,200 | Square footage, never measured | no | 80% | 61% |
| 9 | Other employee benefits | 138,400 | Follows salaries | inherits | 76% | 68% |
| 10 | Payroll taxes | 79,100 | Follows salaries | inherits | 76% | 68% |
| 22 | Depreciation | 61,300 | Square footage, never measured | no | 80% | 61% |
| 13 | Office expenses | 52,300 | Headcount, not recorded by function | no | 70% | 58% |
| 11c | Accounting | 44,800 | Direct, all management and general | yes | 0% | 0% |
| 8 | Pension plan contributions | 41,200 | Follows salaries | inherits | 76% | 68% |
| 11g | Other fees: IT support | 31,200 | A percentage set in 2021 | no | 60% | 47% |
| 23 | Insurance | 29,800 | A percentage set in 2021 | no | 70% | 58% |
| 17 | Travel | 22,700 | Direct from expense reports | yes | 88% | 88% |
| 24a | Programme supplies | 96,500 | Direct, charged to the programme | yes | 100% | 100% |
| Basis | Dollars | Share of expenses |
|---|---|---|
| Documented | 242,400 | 12.2% |
| Partial | 214,000 | 10.8% |
| Inherits an undocumented basis | 258,700 | 13.0% |
| Undocumented | 1,269,700 | 64.0% |
| Exposed | 1,742,400 | 87.8% |
| Programme services, as the system would answer | 1,395,723 | 70.3% |
| Programme services, re-based | 1,225,126 | 61.7% |
| Swing | 170,597 | 8.6 points |
The inherits rows are the ones people argue about and they should not be arguable. Pension, benefits and payroll taxes all follow salaries, salaries are split on a 2021 percentage with no memo behind it, so those dollars are exposed for exactly the same reason. Fix line 7 and 13.0% of expenses corrects itself for free. Neither re-basing is an accounting error either: the time study came out at 68% because the old percentage predates two administrative hires, and the floor plan measured 4,180 programme square feet of 6,850 because the clinic added administrative space in 2023. Both numbers were true once. The whole exercise is 26 hours for the study, 4 to measure the floor plan and 6 for the related-party join, so $1,512 at a blended rate.