How to Set Up a Monthly Budget for Church Groups

✨ Community Finance

Published: May 7, 2026

Church groups can set up a monthly budget using a free Google Sheets or Excel template with three core sheets - Summary for overview, Income for offerings, grants, and fundraisers, and Expenses for missions, events, and operations - updated monthly by a designated treasurer.

This approach helps U.S. church leaders track shared group funds without apps, using simple roll-ups and status labels for transparency. As seen in templates like those from WordLayouts, the structure separates income and expenses for clear visibility. Nonprofit examples from Smartsheet add monthly columns with quarterly roll-ups, adaptable for church use.

Assign Roles and Set Review Cadence

Volunteer-led church groups need clear roles to maintain accountability. Designate a treasurer to handle budget setup, data entry, and initial reviews. A finance committee can approve monthly updates, while the full group reviews quarterly.

Hold a short meeting to assign roles. Use a script like: "We need one treasurer for monthly entries and a committee of three for reviews. Who volunteers? Reviews happen the first Sunday monthly and quarterly after services." This prevents overload on one person.

Set a cadence: treasurer updates after each service or event, committee reviews monthly (e.g., first Sunday), full group quarterly. Common mistake: no designated approver, leading to unchecked entries. Document roles in a shared note or the spreadsheet's first sheet.

Choose Your Budget Structure

Start with three sheets: Summary, Income, and Expenses, as in the WordLayouts church budget template. The Summary sheet provides an overview of totals and variances. Income tracks offerings, grants, and fundraisers. Expenses covers utilities, events, missions, and operations.

Use monthly columns (January through December) with quarterly roll-ups (Q1-Q4) and year-end sums, following Smartsheet nonprofit templates. For Income, list line items like tithes, pledges, grants, and fundraiser proceeds. Smartsheet examples include built-in roll-ups for these sources.

In Expenses, include categories like building maintenance, youth events, mission trips, and supplies. Add status labels such as "under budget" or "over budget." Grainledger suggests formatting variance cells as percentages.

This structure supports multi-month tracking without complexity.

Set Up the Spreadsheet Step by Step

Create a new Google Sheets or Excel file. Name it "Church Monthly Budget 2026." Add three tabs: Summary, Income, Expenses.
In Income sheet: Row 1 headers - Category, Jan, Feb, ..., Dec, Q1, Q2, Q3, Q4, Year Total. List categories: Offerings, Grants, Fundraisers. Enter projected or actual amounts monthly. For Q1 under Jan-Mar for Offerings, use a SUM formula for the range per Smartsheet-style roll-ups. Repeat for quarters. Grainledger shows similar sums for totals.
In Expenses sheet: Mirror headers. Categories: Utilities, Events, Missions, Operations. Add Actual, Budget columns per month for variance. In Summary, pull totals from Income and Expenses Year Total ranges.
Calculate variance in Summary: (Income Total - Expenses Total)/Expenses Total. Format as percentage, as Grainledger notes.
Format: Bold headers, freeze row 1, add conditional colors (green under budget). Set sharing: edit for treasurer, view-only for committee/members via Google Sheets permissions.

Common mistakes: no backups (download monthly), unlocked cells (protect ranges), ignoring roll-ups. Test formulas before sharing.

Track Receipts and Reimbursements

For shared church expenses, use a lightweight workflow. Create a shared Google Drive folder "Church Receipts." Volunteers photo or scan receipts, upload with filename "Date_Purpose_Amount.jpg."

Log in Expenses sheet: columns Date, Amount, Purpose (e.g., "Youth event snacks"), Paid By (volunteer name), Approver Initials, Reimbursed (Yes/No). Treasurer reviews weekly, approves, reimburses via cash or check.

Decision tree for splits: Equal per member? For group events, divide total by attendees. Donor-funded? Log as Income if from specific giver. Usage-based for missions (e.g., per participant). Note in sheet.

U.S. groups keep receipts for transparency; churches as nonprofits consult IRS guidance or a professional for recordkeeping rules, as requirements vary.

Decide on Contribution and Split Rules

Church groups choose splits based on values and needs. Options: equal per member (simple for small groups), donor-based (tithes/offerings cover all), usage-based (event attendees pay share).

Example: Youth group event - equal split ($10/person) or donor-funded (church general fund). Discuss: "Do we split events equally, or use offerings? Vote now." Log rule in Summary sheet notes, tie to Income entries.

Tradeoffs: Equal builds unity but burdens low-givers; donor-based eases access but relies on few. Review annually after year-end. Update Income sheet to reflect (e.g., "Pledges - equal split").