Free Sample Church Budget Template (Excel)
What goes into a church operating budget
The template comes with 25 categories already filled in, split between Income (tithes and offerings, designated gifts, missions giving, facility use, fundraisers, other income) and Expense (staff salaries, payroll taxes, guest speakers, mortgage or rent, utilities, maintenance, insurance, and ministry lines like worship, children's, youth, outreach, missions support, and more).
You can rename or add to any category, but starting from a list built around how churches actually budget — payroll, facilities, and ministry areas as separate lines — saves you from building the category structure from a blank sheet.
Tracking annual budget vs actual to date
Each row has an annual budget figure and an actual-to-date figure you update as the year progresses. The variance column subtracts actual from budget automatically, so you can see at a glance how much budget remains — or how far over you've gone — on every line.
A percent-used column shows actual as a percentage of the annual budget for that category, which is often a faster read than the raw dollar variance, especially when you're scanning 25 rows at a monthly finance meeting.
Reading the surplus/deficit and the over-100% flag
The summary block totals budgeted and actual income, budgeted and actual expenses, and calculates the surplus or deficit to date by subtracting actual expenses from actual income. That single number tells the finance committee whether the church is running ahead of or behind its plan for the year.
Any expense line where percent used goes over 100% is flagged in red automatically, so a category that's blown through its annual budget stands out immediately instead of getting lost in a wall of numbers.
Church budget vs a tithe and offering log
This template plans and tracks spending against a budget — it doesn't log individual donations by giver. If you need to track who gave what and keep a running year-to-date total per donor for giving statements, that's a separate file: see the free-church-tithe-and-offering-spreadsheet-excel page.
Most churches use both together: the tithe log for donor records and fund totals, and this budget template for planning and monitoring spending against that plan. Keeping them separate keeps each file focused on its own job.
How to use it
- Review the 25 pre-filled income and expense categories and adjust names to match your church.
- Enter your annual budget for each category.
- Update actual-to-date as the year progresses; variance and % used calculate automatically.
- Check the summary for the surplus or deficit to date, and watch for any category flagged over 100%.
Download the free Free Sample Church Budget Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the formulas keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Can I rename or add categories?
Yes. The 25 categories are pre-filled as a starting point that matches how most churches budget, but you can rename, delete, or add rows freely.
Does this track individual donor giving?
No. This is a budget-planning file that compares budgeted vs actual spending by category. To track what individual givers contribute, use the free-church-tithe-and-offering-spreadsheet-excel page instead.
How does the over-100% flag work?
Any expense row where actual-to-date exceeds the annual budget (percent used over 100%) is highlighted automatically, so overspent categories are easy to spot.
What's the usage license?
Personal or single-church use. It's not meant to be resold or redistributed as a template product.