Free Church Budget Template (Excel/Google Sheets) + How to Use It

Why Every Church Needs a Real Budget (Not a Wish List)

Most small and mid-size churches don't have a budget. They have a wish list that the treasurer glances at twice a year. That's not stewardship — it's hoping.

A real church budget does three things: it makes spending decisions faster, it protects the pastor from board drama, and it keeps you IRS-compliant as a 501(c)(3). This post gives you a free template you can start using today, plus the pattern for using it that actually sticks.

Download the Free Template

We built a simple, pastor-friendly budget template that works in both Excel and Google Sheets. It covers:

You can request the template by creating a free admin account at [the Nehemias AI portal](/admin/login) — we'll drop the template in your inbox along with a short setup video.

The 5 Categories Every Church Budget Needs

Forget the 40-row accounting school version. At its core, a church budget only has five buckets:

**1. Personnel (40-55%).** Salaries, payroll taxes, benefits, housing allowances for qualifying ministers. This is almost always your biggest line and the one boards are least comfortable discussing. Budget it first.

**2. Facilities (15-25%).** Mortgage or rent, utilities, insurance, maintenance, cleaning. If you own your building, include a sinking fund for major repairs (roof, HVAC).

**3. Ministry and programs (15-25%).** Kids, youth, worship, small groups, discipleship materials, guest speakers. This is where most of your spiritual impact per dollar happens.

**4. Missions and outreach (10-15%).** Supported missionaries, local benevolence, evangelism. Churches that tithe on their own income to missions tend to be healthier, not poorer.

**5. Operations and admin (5-10%).** Software (including your [church management platform](/blog/what-is-a-church-management-system)), office supplies, accounting, legal, website, payment processing.

If your numbers are wildly off these ranges — say, facilities is 40% — that's a signal to rethink, not a sign the ranges are wrong.

How to Build Your Budget in 6 Steps

**Step 1: Gather 24 months of giving data.** Two years is enough to spot seasonality. Ignore the last three months if they were abnormal (holidays, building campaigns, crises).

**Step 2: Project next year's income conservatively.** Take the 24-month average, not the peak. Factor in ~2-3% growth if you're healthy, flat if you're stable, a 5-10% haircut if attendance is declining. Do not budget based on miracles.

**Step 3: Lock in your fixed costs first.** Personnel, mortgage, insurance, software subscriptions. These don't flex month to month.

**Step 4: Allocate variable costs to ministries by priority.** Kids and youth before adult programs. Local outreach before conferences. Fund what produces disciples, starve what produces hype.

**Step 5: Set aside reserves.** Target 3 months of operating expenses in a separate reserve account. If you don't have that yet, build toward it — $500/month adds up.

**Step 6: Track monthly variance.** Every month, compare budget vs. actual. If a category is off by more than 10%, fix it immediately, don't wait for the year-end review.

When Excel Stops Working

This template will carry you until your church is about 150-200 regular attendees. After that, you'll start hitting walls:

When that happens, it's time to graduate to real accounting. We wrote a full [guide to tithe and offering tracking in Excel](/blog/tithes-offerings-excel-tracking-template) that covers the next step up, and a [step-by-step migration guide](/blog/migrate-excel-to-church-crm-step-by-step) for moving to a ChMS.

Common Church Budgeting Mistakes

Do You Still Need Accounting Software?

Yes — even with a budget template. The template is for planning and high-level tracking. You still need actual bookkeeping for:

Most small churches use QuickBooks + a ChMS. A growing number are moving to platforms like Nehemias AI that have double-entry accounting built into the church management system, so giving automatically flows into the ledger without a second data entry step.

Ready to Stop Running Your Church on a Wish List?

Grab the free template, fill in your real numbers, and present it at your next board meeting. If you want to skip straight to a system where the budget, giving, attendance, and accounting all live in one place, [create your Nehemias AI account](/admin/login) or check [pricing](/pricing). A real budget is the first step to real stewardship — and a calmer treasurer is the first sign it's working.