Church Finance for the Volunteer Who Got the Keys to the Bank Bag
Shop disclosure: Smart Files Shop (Etsy: SmartFilesShopUS) is operated by Jaceal, LLC, which also publishes this site. Links below go to live Etsy listings we sell. We earn the listing price on those sales. This page is a buyer’s guide, not a ranking. Not tax, legal, accounting, or pastoral-care advice. AI-assisted draft; reviewed against the shop’s live Etsy catalog.
Offering counts, designated funds, benevolence, and year-end statements — live Excel and Google Sheets templates, one job per file.
What this page is
If you are building a digital-product shop, this is what a working template line looks like from the buyer’s side: one job per file, honest adjacency, and a guarantee you can actually message. Pair it with our digital products guide. If you are the volunteer treasurer, skip the shop-builder framing and start with the pile eating your Sunday night. Sibling guides: home maintenance templates · landlord and seller books.
Quick Navigation:
- What a treasurer’s week actually looks like
- The hub: weekly giving, budget, expenses
- Sunday afternoon: two-counter offering count
- Restricted compassion: benevolence
- One campaign at a time
- Adjacent: the fellowship meal
- For givers, not the church’s ledger
- How to choose
- Love Guarantee and custom work
- FAQ
Church finance for the volunteer who got the keys to the bank bag
You did not apply to be the church’s accountant. You said yes when someone asked who could count the offering, sign a check request, or “just keep a spreadsheet.” Months later you are the person who knows whether the missions envelope made it into the deposit, whether the youth leader’s reimbursement was paid, and why the finance committee thinks benevolence is “fine” while the deacons are still waiting on a check.
Sunday cash has to be counted by two people. Designated gifts cannot be spent as general fund. A campaign pledge is not money in the bank. Year-end is “what did envelope 142 give, by fund?” You do not need nonprofit ERP. You need a few workbooks that match those jobs, open in Excel or Google Sheets, and do not pretend to be tax software.
Smart Files Shop (Etsy: SmartFilesShopUS) sells digital downloads for that volunteer. Everything linked below was live and active on Etsy when this page was last updated (28 August 2026). Each listing is $6.99 USD. Instant download — nothing ships. These are bookkeeping templates, not accounting software, and not tax, legal, or pastoral-care advice. Your church’s official records and a CPA who knows fund accounting still win if numbers disagree.
Four piles people keep mashing into one notebook:
- The count — two counters, cash vs. checks vs. coin, MATCH or VARIANCE, a deposit bag.
- The books — gifts by envelope, fund, and method; expenses by check number, payee, and ministry; budget vs. actual a committee can read.
- Restricted money — building, missions, benevolence: gifts in, withdrawals out, a running balance you can defend.
- The one-offs — a dinner or Giving Tuesday; a hardship request; a potluck that is not finance but still lands on you.
Start with the pile eating your Sunday night. You do not have to buy all six files.
1. The hub: weekly giving, budget, expenses, year-end statements
Church Tithe Tracker Spreadsheet | Church Budget Spreadsheet Treasurer Giving Log Excel Sheets
Listing 4533118846 · $6.99
This is the shop’s main church-finance workbook: an 11-tab Excel and Google Sheets file plus a browser dashboard. You log every gift (envelope/donor number, date, fund, amount, method) and every expense (check number, payee, ministry, fund); annual budget by ministry, designated-fund balances, a 12-month P&L, a fundraising-events tab, and per-donor contribution statement totals calculate from those logs. It is for the volunteer treasurer who has to answer “how are we doing vs. budget?” and “what goes on year-end statements?” from the same file — an organizational template, not a CPA substitute, and not a claim that the statement layout matches every denomination’s receipt rules.
2. Sunday afternoon: two-counter offering count and the deposit
Church Offering Count Sheet | Two Counter Sign Off Deposit Log Budget vs Actual Excel Sheets
Listing 4562846570 · $6.99
If the tithe tracker is the books, this is the counting-room sheet. Two people enter cash, checks, and coin independently; status is MATCH or VARIANCE; both sign off; then you split that week’s offering by fund, and dashboard / budget-vs-actual / year-end summary are formulas you do not type. It is for ushers and treasurers who still count a physical bag and need a paper trail two people signed — not a donor contribution statement, not nonprofit accounting software, and not Apple Numbers.
3. Restricted compassion: benevolence requests and disbursements
Church Benevolence Tracker Spreadsheet | Aid Request Disbursement Log Excel Google Sheets
Listing 4556217675 · $6.99
This 7-tab workbook keeps a requests log (date, requester, category, amount requested vs. approved, approver, status, ref #), disbursements (method, linked request, check/confirmation number, running fund balance), and donations into the fund; Fund Summary and Monthly Rollup calculate from those rows. It is for treasurers, pastors, and benevolence or deacon teams currently tracking aid in email — an audit trail for compassionate aid, not pastoral-care advice, not a substitute for dual-control policy, and not tax or legal advice.
4. One campaign at a time: pledged vs. received vs. net after the caterer
Church Fundraising Tracker Spreadsheet | Giving Tuesday Capital Campaign Pledge Excel
Listing 4559925306 · $6.99
Pledged is not received, and received is not net after venue and food. This 5-tab file keeps those three numbers honest for one campaign per workbook (File → Save As for the next dinner): a pledges log with outstanding as Amount − Received, an expenses log, and a Dashboard of formulas (raised vs. goal, net after expenses, unique donors, giving by method). It is for a treasurer reporting to a finance committee or a volunteer chair running a dinner, walkathon, building drive, Giving Tuesday, or year-end drive — not auction bids, not a weekly tithe log, and not a full church P&L.
5. Adjacent, honestly: the fellowship meal is not the books
Church Potluck Signup Printable | Who Brings What Volunteer Dish Tracker PDF
Listing 4536216980 · $6.99
The same person who counts the offering often also gets the “who is bringing the green bean casserole” thread. This 29-page fillable signup kit plus a companion spreadsheet answers one question: who is bringing what — dish sheets, headcount-to-servings, dietary notes, setup/cleanup volunteers, a meal-train schedule, and a container-return tracker. It is for the volunteer coordinating a church potluck or meal train, not a budget tracker, not an event planner, and not meeting agendas.
6. For givers, not the church’s ledger
Donation Tracker Printable | 29-Page Charitable Giving Kit
Listing 4536203239 · $6.99
Households in the pew have a different problem: by April they cannot say what they gave, to whom, or whether the receipt still exists. This 29-page fillable binder plus companion spreadsheet is a donor-side record — cash and check logs, non-cash itemization with a blank fair-market-value column you fill in yourself, receipt log, charity mileage, in-kind/stock gifts, employer match, and a year-end summary. It is for a household keeping its own giving file, not the church’s ledger and not tax advice; if you need the organization side, use the tithe tracker or the offering count sheet above.
How to choose
| If your actual problem is… | Start here |
|---|---|
| Budget vs. actual, giving log, expenses, year-end donor totals | Church Tithe Tracker |
| Two people counting the bag and signing off | Offering Count Sheet |
| Aid requests, approvals, checks out of benevolence | Benevolence Tracker |
| One dinner / campaign: pledged vs. received vs. net | Fundraising Tracker |
| Who brings what this Sunday | Potluck Signup |
| Your own household giving file | Donation Tracker Printable |
A practical stack for a small church is the tithe tracker (books) plus the offering count sheet (Sunday). Add benevolence if a committee writes checks from a restricted fund. Add the fundraising file only when you have a named campaign. The potluck kit and the household donation binder are optional — useful, but they are not the general ledger.
Files open in Microsoft Excel and Google Sheets (upload in Drive). Several also open in LibreOffice Calc. The offering count sheet is not tested in Apple Numbers.
Love Guarantee and custom work
Every listing on this page carries the same 14-day Love Guarantee.
Love Guarantee (14 days): Message Smart Files Shop if the file is not right — free fix, free small customization, or refund.
Free small customizations (typical examples): rename a column, add a header, change a fund or ministry label, swap a service name, put your church’s fund list on the dropdowns.
Paid customs — shop-wide / typical menu; message for a quote before any extra charge. Individual listings may quote lower for tweaks already in scope for that file — always by quote, never a surprise invoice. For paid customs, timeline is usually 1–3 business days after we lock the brief.
- Light custom $15–$29 — church name / header on every tab; extra categories
- Standard custom $39–$79 — extra funds or campuses, a board-report tab, a deposit-slip layout that matches your bank bag
- Deep custom $89–$149 by scope — branding, data import, multi-entity
The shop says yes to requests like “add a Missions fund column to the church tithe tracker.” It does not take full bookkeeping outsourcing, tax filing, or CPA work. One free polish pass is included on paid customs after first delivery.
What these files will not do
They will not connect to your bank or giving platform. They will not file a 990, generate a legally sufficient contribution receipt for every jurisdiction, or replace dual-control policies your board already voted on. They will keep a volunteer treasurer from reconstructing December out of a shoebox of envelope numbers.
If you want the files, buy them on Etsy through the live links above. This page is a guide, not a checkout.
FAQ: Church Finance Templates
Do I need every file on this page?
No. Start with the tithe tracker plus the offering count sheet. Add benevolence if a committee writes checks from a restricted fund, and the fundraising file only when you have a named campaign. The potluck kit and the household donation binder are optional.
Are these tax software or a CPA substitute?
No. They are bookkeeping templates. Your church’s official records and a CPA who knows fund accounting still win if numbers disagree. They will not file a 990 or generate a legally sufficient contribution receipt for every jurisdiction.
What is the Love Guarantee?
Every listing on this page carries the same 14-day Love Guarantee: message Smart Files Shop if the file is not right — free fix, free small customization, or refund. Customs pricing is not uniform across listings; individual listings may quote lower. Always by quote.
Can you put our fund names on the dropdowns?
Yes. That is a typical free small customization. Larger work (extra campuses, a deposit-slip layout that matches your bank bag, multi-entity) is a paid custom, quoted before any extra charge. For paid customs, timeline is usually 1–3 business days after we lock the brief.
Building the shop, not just buying the file?
See how digital products actually get sold — then look at the live church, home, and landlord listings as a working catalog.
Read the Digital Products Guide