Pastor housing allowance worksheet
Set the housing allowance too low and the pastor pays income tax on the costs above it, with no way to fix it after the money is paid. Set it too high and the unused part goes on one line of the pastor's tax return. This worksheet turns this year's housing costs into next year's number and the board's resolution.
Inside your free Excel download
- An expense log by category that totals the year's housing costs
- Designated, spent and fair rental value side by side, with the amount excluded and any excess allowance
- Next year's expected costs, the ceiling, and a resolution for the minutes
Write the designation into the minutes before the first paycheck of the year.
Get your housing allowance worksheet
Download an editable .xlsx file immediately.
One year, and the number for the next
A preview of the workbook. Your download includes the full editable template.
| Pastor Dan Ruiz, Cedar Hill Church, 2026 | Amount |
|---|---|
| Designated by the board | $24,000.00 |
| Spent on the home | $25,300.00 |
| Fair rental value, furnished, plus utilities | $26,520.00 |
| Excluded from income tax: the smallest | $24,000.00 |
| Housing costs above the designation | $1,300.00: taxed |
| Designated for 2027, at the ceiling | $26,700.00 |
Keep your next step connected
Start with the spreadsheet. When you need your giving, spending, funds, and reports in one ledger, explore Grain.
Why a low designation costs the pastor money
A pastor can exclude from income tax the smallest of three numbers: the amount the board designated, the amount spent on the home, and the home's fair rental value, furnished, plus utilities. It also can't be more than reasonable pay for the pastor's work.
In the sample, Cedar Hill Church designated $24,000 for 2026. Pastor Ruiz's water heater failed in August, and his housing costs came to $25,300. The designation was the smallest number, so $1,300 of real housing costs got no exclusion. Had the board designated $26,000, he would have reported the unused $700 as income on his return, the same as salary.
2026's designation came in under the costs. 2027's doesn't.
- Designated $24,000
- Spent $25,300
- Ceiling $26,520
- Expected costs $24,850
- Designated = ceiling $26,700
Setting next year's number
Start from this year's log. On the Next Year tab every category carries over, so type a new amount only where something will change: a new mortgage payment, a rent increase, higher utilities. The tab adds up the expected costs and works out the ceiling from the home's rental value and next year's utilities.
Designate at the ceiling, not at the expected costs, and not past it: nothing above the ceiling can be excluded. Cedar Hill expects $24,850 in 2027 and designates $26,700, the ceiling, which leaves room for another water heater. The Next Year tab tells you when the amount you type is below the expected costs or above the ceiling.
Getting it into the minutes
The IRS says the church "must designate a definite amount. It can't determine the amount of the housing allowance at a later date." The designation can be in an employment contract, the minutes, a budget, or any official action taken before the allowance is paid. A conversation with the pastor doesn't count. With no designation, the whole salary is taxable income.
The Resolution tab fills in the pastor's name, the year and next year's amount. Print it, have the board or congregation adopt it, and keep it with the minutes.
If the church provides a parsonage, choose Church parsonage on the This Year tab. The parsonage's rental value is excluded on its own, and an allowance for utilities is excluded up to what the pastor spends on them.
At year end
For the treasurer: leave the housing allowance out of W-2 box 1. You can show it in box 14 or on a separate statement. Don't withhold Social Security or Medicare tax from a minister's pay, and don't withhold income tax unless you and the pastor agree to voluntary withholding. And, in Publication 15-A's words, "Don't show on Form W-2, Form 941, or Form 944 any amount as social security or Medicare wages."
For the pastor: any excess allowance goes on Form 1040, line 1h, marked "Excess allowance." The allowance still counts toward self-employment tax unless the pastor has an approved exemption. The This Year tab gives both amounts.
Keeping the allowance next to payroll
Generic small-business payroll doesn't handle clergy pay well. Grain's payroll keeps housing allowance tracking beside clergy and staff pay, in the same books that hold your funds, and handles W-2s and 941s. Payroll is $50 a month plus $10 per employee, on any plan. See church payroll in Grain.
Frequently asked questions
What housing costs count toward the allowance?
The cost of providing or renting the home counts, with furnishings, utilities and a garage (IRS Publication 517). Denominational worksheets also list mortgage principal and interest, rent, a down payment, property insurance, real estate taxes, HOA dues, repairs, maintenance and remodeling. The Expense Log uses those categories.
Can the pastor still deduct mortgage interest and property tax?
Yes. The pastor can deduct home mortgage interest and real estate taxes as itemized deductions on Schedule A, even when the housing allowance paid them.
Can the denomination designate the allowance for the pastor?
Not for a pastor the local congregation employs and pays. The local congregation has to designate it, and a resolution by a national church agency doesn't count.