Church annual report template
The financial section of an annual report shows members the year's gifts, spending and fund balances. Type in the year's totals and this workbook writes it, with every number beside last year and the budget, plus highlight sentences you can paste into the report.
Inside your free Excel download
- Income and spending this year, last year and against the budget
- Cents of every dollar spent, and next year's budget, by ministry area
- Highlight sentences written from your numbers, ready for the report
Name each line the way members know it: Children and youth, not account 6420.
Get your annual report template
Download an editable .xlsx file immediately.
A year, in numbers members can follow
A preview of the workbook. Your download includes the full editable template.
| Brookside Church, 2025 | Amount |
|---|---|
| Gifts, up 0.8% from 2024 | $481,300 |
| Spending, $300 under budget | $441,700 |
| Staff: 53¢ of every dollar spent | $236,000 |
| Average gift per household (214 households) | $2,249 |
| Next year's income budget | $507,000 |
| Next year's spending budget | $447,000 |
Keep your next step connected
Start with the spreadsheet. When you need your giving, spending, funds, and reports in one ledger, explore Grain.
Which numbers belong in front of members?
About half a dozen. Members want the shape of the year, not the ledger, and as the Lewis Center for Church Leadership puts it, "Very few persons want to see a detailed budget." Here's what we'd put in front of them:
- Gifts this year, and the change from last year
- Total income and total spending, each against the budget
- The three or four biggest ministry areas, in cents of every dollar
- How many households gave, and the average gift
- What the general fund ended the year with, beside the money given for a purpose
- Next year's income and spending budget
Where each dollar went at Brookside Church in 2025
- Staff salaries and benefits53¢
- Building, utilities and upkeep16¢
- Missions and outreach11¢
- Administration and office6¢
- Children and youth5¢
- Worship and music4¢
- Adult ministries and small groups2¢
- Benevolence2¢
Account codes and monthly detail stay in the books for anyone who asks. For the rest of the report, from the pastor's letter to the year's stories, see our guide to writing a church annual report.
Write the highlights as sentences
Members skim a grid of numbers, but they read a sentence. The Annual Report tab writes seven of them from your totals, ready to paste into the report. Change a number on the Year Totals tab and its sentence changes too, so the summary never disagrees with the tables.
The highlights the workbook writes for the sample church
- 3Highlights
- 4Gifts came to $481,300, up 0.8% from 2024.
- 5Total income was $492,800, 99% of the $497,000 budget.
- 6Spending was $441,700, $300 under budget.
- 7The biggest line was Staff salaries and benefits: 53¢ of every dollar spent.
- 8Income was $51,100 more than spending. The funds went from $195,300 to $246,400.
- 9Of that, $27,900 stayed in funds given for a purpose and $5,000 went to money the board set aside.
- 10214 households gave, 6 more than last year, an average of $2,249 per household.
If you cut any of the seven, keep the line on where the surplus went. On its own, a $51,100 surplus reads like money the church didn't need, and someone will ask about it. This line answers before they do: most of it stayed in funds given for a purpose, the building fund above all, or went to the reserve the board set aside. The balance sheet template shows how each kind of fund sits on the books.
How to present next year's budget
Members vote on the change, not the total. Find the two lines that move most and give each one sentence. The Annual Report tab sets next year beside this year for every ministry area, so they're easy to spot. At Brookside, next year's spending budget is $5,300 above this year's spending: staff goes up $10,000, and building and upkeep comes down $8,300 because this year's $12,000 parking lot repair won't happen again.
Say what a planned surplus is for, too. Brookside budgets $60,000 more income than spending next year, but $40,000 of that is building fund gifts saved toward a new roof. The general budget plans to end the year $20,000 ahead.
Before you print it
Close and reconcile December first, so the year's totals match the treasurer's year-end report. Then read the Check on the Annual Report tab. It compares the change in all your funds with income minus spending. When they match, it says Ties. When they don't, it says by how much. The usual cause is a fund left out of the table, or a transfer between funds entered as income. For the monthly version of these numbers, use the church financial report template.
In Grain, the statement of activities, fund balances and budget vs. actual all come from the same books, so the totals you copy into this workbook already agree with each other. Grain is free for churches with up to $20,000 in monthly expenses.
Frequently asked questions
Do restricted funds go in the annual report?
Yes. List every fund with its balance at the start and end of the year and its class. The report then shows how much of the total is free to spend, how much the board set aside, and how much was given for a purpose.
What if our fiscal year isn't the calendar year?
Enter your fiscal year's totals and use the year it ends in as the report year. For a year ending June 30, 2026, enter 2026, and the sentences compare it with 2025.