, ,

Church Event Budget Planner Spreadsheet | Mannatally Ministry Budget, Registration & Receipt Tracker for Excel + Google Sheets

$17.99

This church event budget planner spreadsheet plans and tracks every ministry event in one file: VBS, retreats, mission trips, conferences, holiday services, potlucks and youth camps.

  • Budget vs actual by 10 categories, with per-attendee costs and contingency
  • Registrations with scholarships, deposits and balances, plus a break-even fee calculator
  • Treasurer receipt log, purchase approvals and an annual ministry dashboard with charts
  • One-page printable event report. Works in Excel and Google Sheets

A church event budget planner built for real ministry finances

Mannatally is a church event budget planner spreadsheet for churches and ministries that run more than one event a year. List your events once, plan each one item by item, and log registrations, receipts, approvals and income as they happen. The workbook does the math: budget vs actual by category, cost per attendee, the fee you need to break even, what families still owe, which receipts need attention, and a fiscal-year roll-up across every ministry.

It works for Vacation Bible School, women’s and men’s retreats, mission trips, conferences, Christmas and Easter services, potlucks and fellowship meals, youth camps, outreach events and concerts.

Who it is for

  • Church administrators and ministry leaders who plan several events a year
  • Treasurers and finance teams who need receipts, approvals and clean reports
  • Children’s, youth, women’s, men’s and missions ministries
  • Pastors and church councils who want one view of the ministry year
  • Small churches without accounting software, and larger churches that want an event layer next to their books

Main benefits

  • Know the real cost of every event before you set the fee, including contingency.
  • Price fairly with a break-even calculator that accounts for scholarships, gifts and budget allocations.
  • Keep the treasurer happy with a receipt log that flags missing receipts, purchases over your approval limit and unpaid reimbursements.
  • Report with confidence using a one-page event budget report and an annual ministry dashboard.

Features of the church event budget spreadsheet

Plan

  • Settings: church name, ministry, treasurer, fiscal year (any start month), currency symbol, purchase approval limit, default contingency % and a gift acknowledgment reminder amount.
  • Events: up to 40 events with type, ministry, dates, location, coordinator, expected attendees, status and an optional contingency % per event. Budget, spent, left to spend, income, net, people registered and cost per attendee fill in automatically.
  • Budget Lines: 600 line items across 10 categories: venue and facilities, food and drinks, supplies, transportation, lodging, speakers and honoraria, marketing and printing, decor, insurance and permits, and contingency. Mark a line Fixed or Per attendee so meals, shirts and lodging grow with your headcount.
  • Income Plan: fee per person, planned full scholarships, designated gifts, fundraisers, ministry budget allocation and other income, planned vs received.
  • Break-Even calculator: fixed costs, per-attendee costs, total cost, cost per attendee, break-even fee, break-even attendance and subsidy needed, with what-if inputs, an attendance table and a cost vs income chart.

Track

  • Registrations: 600 rows for people or families with fee override, scholarship amount, deposit, final payment, balance, automatic status (Paid in full, Partial, Unpaid, Full scholarship, Overpaid) and forms received.
  • Receipt Log: 800 purchases with vendor, payment method, receipt on file, approval ID, reimbursement date and treasurer sign-off, plus an automatic flag.
  • Approvals: 200 purchase requests with automatic IDs, decisions, approved limits and spending tracked against each approval.
  • Income Log: 400 entries for gifts, fundraisers and budget transfers with deposit and acknowledgment tracking.

Report

  • Ministry Dashboard: 12 live tiles, every event this fiscal year sorted by date with progress bars, spending by category, income by source, results by ministry and by month (4 charts), and a treasurer to-do list.
  • Budget vs Actual: every event across all 10 categories in one grid.
  • Event Report: pick an event and print a one-page portrait report with signature lines for the preparer, treasurer and approver.

What is included

  • Mannatally Church Event Budget Planner (.xlsx, 14 tabs, blank and ready to fill)
  • Filled-in example workbook with a fictional church year of 9 events
  • Word user guide with screenshots, troubleshooting and FAQ

How it works

  1. Set your church name, fiscal year, currency and approval limit.
  2. List your events and add budget lines for each one.
  3. Set fees, scholarships and planned income.
  4. Log registrations, receipts, approvals and income as they come in.
  5. Check the dashboard and print an event report for your treasurer or council.

File format and software requirements

One Excel workbook (.xlsx) that works in Microsoft Excel 2016 or later, Microsoft 365 (Windows and Mac) and Google Sheets (free). No macros, add-ons or internet connection needed. Formula cells are protected without a password, so beginners cannot break them by accident but you can still unlock them.

Customization

Rename event types, ministries, expense categories, income sources and payment methods on the Lists tab. Choose any currency symbol and fiscal year start. Set your own approval limit and contingency. Colors and fonts can be changed like any spreadsheet.

Digital download

This is a digital product. You will receive the files right after checkout. Nothing is shipped.

Use cases

  • Budgeting VBS with per-child curriculum, snacks and T-shirts, and scholarships for families who need help
  • Pricing a youth camp or women’s retreat so fees, gifts and the ministry budget cover the full cost
  • Tracking mission trip deposits, fundraisers and airfare in one place
  • Giving the treasurer clean receipts with approvals for Christmas Eve, Easter or outreach events
  • Presenting a year-end ministry budget review to elders or the church council

FAQ

Does this church budget template work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and save it as a Google Sheet. It uses only functions that work in both Excel and Google Sheets.

Is this a full church accounting system?

No. It is an event budgeting and tracking workbook. Your treasurer still records transactions in the church books; Mannatally gives them organized event records.

How many events can I track?

Up to 40 events per file, with 600 budget lines, 600 registrations, 800 receipts, 200 approvals and 400 income entries.

Can I handle scholarships?

Yes. Plan full scholarship places on the Income Plan and record partial or full scholarships for each registration.

Can I use a different currency or fiscal year?

Yes. Change the currency symbol and fiscal year start month on the Settings tab.

Is it tax advice?

No. The gift acknowledgment reminder is a prompt only. US churches can see IRS Publication 1771 and should confirm rules with a tax professional.

Can I print reports?

Yes. Every tab fits the page width, and the Event Report prints on one portrait page.

Personal use only (or use within your own church or ministry). You may not resell, share, or redistribute the files. © 2026 Taskdale. All rights reserved.

Reviews

There are no reviews yet.

Be the first to review “Church Event Budget Planner Spreadsheet | Mannatally Ministry Budget, Registration & Receipt Tracker for Excel + Google Sheets”

Your email address will not be published. Required fields are marked *

Scroll to Top