Annual Church Budget Builder: A Worksheet for Church Boards

Building an annual church budget shouldn't take a finance degree or a week you don't have. This worksheet gives you a clean, ready-to-use Excel file that walks through every major area of church life and rolls it all up into one number you can actually present to your board.

I built this based on what I use myself, then expanded it to cover the whole church, not just the pastoral side. Every church budget looks a little different, but the bones are usually the same: staff wages, pastoral care, missions, discipleship, kids and youth ministries, worship, facilities, and administration. This worksheet organizes all of it into one place, does the math for you, and works whether you're leading a church of forty or four hundred, in any country, in any currency.

What's Inside

Nineteen expense categories covering the full life of a church: Payroll & Benefits, Pastoral & Leadership, Missions & Outreach, Discipleship & Christian Education, Children's Ministry, Junior and Senior Youth, Young Adults, Worship & Music, Welcome & Hospitality, Care & Visitation, Special Events & Conferences, Facilities & Operations, Administration & Office, Technology & Media, Audio/Podcast/Broadcast Ministry, Training & Professional Development, and Advertising & Promotion. Every line item rolls up into a category subtotal, and every subtotal rolls up into one Grand Total at the bottom, ready to drop into a board report or print as-is for a meeting.

A built-in Cost-of-Living Adjustment toggle lets you mark which salary or wage lines should automatically increase with inflation, so you're not doing that math by hand every budget season.

Missions and Advertising are calculated as a percentage of your Core Ministry Subtotal, with both percentages easy to adjust on a separate Settings tab. Change a number once, and every formula downstream updates with it.

Not Just a Spreadsheet

Nothing in this workbook is locked. Add a category, remove one, rename a line item, restructure the whole thing. It's built to bend to how your church actually budgets, not the other way around. The Instructions tab walks through exactly how the COLA toggle and percentage-based categories work, so you're not left guessing.

There's no currency symbol locked into the math. Whether you're budgeting in dollars, pounds, or any other currency, the worksheet works exactly the same.

Who This Is For

Pastors, church administrators, treasurers, and board members who need a clear, presentable annual budget covering the whole church, not just one ministry. If your board is asking for the full picture, staff costs, ministries, facilities, and everything in between, this gives you a faster, cleaner starting point than building it from scratch.

What You'll Receive

One Excel (.xlsx) file with four tabs: Instructions, Settings, Wages, and Budget. Compatible with Excel and most modern spreadsheet software. Instant download after purchase.

A product of LeadBiblically.com