Church Bookkeeping & Members Template for Excel and Google Sheets
Keep your church finances and member records organized with this Church Bookkeeping & Members Template for Excel and Google Sheets. Designed for churches, ministries, congregations, and small faith-based organizations, this spreadsheet helps you track monthly contributions, offerings, donations, tithes, member giving, and church member information in one organized system.
Instead of managing donations, member lists, and contribution reports across different files, this template brings everything together with monthly contribution tabs, automatic summaries, member reports, editable categories, and visual charts.
Track Monthly Church Contributions
The template includes 12 monthly contribution tabs where you can record every church contribution in a clear and organized format. Each monthly tab allows you to enter the date, member name, contribution type, amount, payment method, and notes.
Use it to track tithes, offerings, donations, building funds, missions giving, special gifts, cash donations, check payments, card payments, bank transfers, and other church contributions.
Manage Church Members in One Place
This church spreadsheet also includes a dedicated Church Members tab where you can keep your member information organized. Track member names, join dates, active or inactive status, phone numbers, emails, addresses, and notes.
The member list helps you maintain cleaner records and makes it easier to connect contributions with the right people throughout the year.
Automatic Contribution Summary
The Contributions Summary tab gives you a clear overview of monthly and annual giving totals. The template automatically summarizes contributions by type and payment method, helping you understand how much was received through tithes, offerings, donations, building funds, and other categories.
You can also review giving by payment method, including cash, card, bank transfer, checks, and other methods depending on how your church collects contributions.
Member Contribution Summary
The Member Summary tab automatically calculates each member’s monthly and annual contribution totals across all 12 months. This makes it easier to review giving history, compare contribution totals, and maintain accurate member records.
This section is especially useful for churches that need a simple way to organize member giving information throughout the year.
Printable Member Contribution Reports
The template includes detailed member report sections that allow you to select a member and generate a contribution report with monthly totals, category totals, payment method summaries, and visual charts.
These reports can be useful for year-end contribution statements, internal records, or saving as a PDF to share with individual members when needed.
Editable Categories and Payment Methods
Every church has different giving categories, so this template includes editable contribution categories and payment methods. Customize the spreadsheet to match your church’s needs, whether you track tithes, offerings, donations, missions, youth ministry, building funds, benevolence, events, or other giving categories.
What’s Included
- Church bookkeeping spreadsheet template
- 12 monthly contribution tracking tabs
- Church members list
- Member contact and status tracking
- Contributions summary by type and payment method
- Member contribution summary
- Detailed member contribution report
- Printable member report layout
- Automatic monthly and annual totals
- Visual charts and contribution breakdowns
- Editable contribution categories
- Editable payment methods
- Notes section for each contribution
- Compatible with Microsoft Excel and Google Sheets
Perfect For
- Churches
- Ministries
- Small congregations
- Faith-based organizations
- Church treasurers
- Church administrators
- Pastors and ministry leaders
- Nonprofits that track member donations
Why Use This Church Bookkeeping Spreadsheet?
Managing church contributions requires clear records, accurate totals, and organized member information. This template gives you a simple way to track giving throughout the year without complicated accounting software.
You can record monthly contributions, review annual totals, organize member records, analyze giving by category, and generate member contribution reports from one spreadsheet.
Excel and Google Sheets Compatible
This Church Bookkeeping & Members Template is compatible with both Microsoft Excel and Google Sheets, giving your church the flexibility to manage records using the platform that works best for your team.
Reviews
There are no reviews yet.