You did not apply to be the church accountant. You said yes when someone asked who could count the offering. Months later you are the person who knows whether the missions envelope made it into the deposit, whether the youth reimbursement cleared, and why the finance committee thinks benevolence is “fine” while a check is still sitting in a folder.
This page is the system, not the sermon. You can build the workbooks yourself from the column lists below. If you would rather open a file that already has the formulas, each job maps to one live listing at its current price. You do not have to buy every file.
- The four jobs a giving spreadsheet must do
- Where ChatGPT and Claude belong — and where they do not
- DIY giving-log schema (standalone, no purchase)
- Job 1 — Weekly giving, budget, year-end statements
- Job 2 — Two-counter offering count
- Job 3 — Restricted aid (benevolence)
- Job 4 — One named campaign
- If you are the giver, not the treasurer
- December checklist
- Love Guarantee and custom work
- FAQ
The four jobs a giving spreadsheet must do
People mash these into one notebook. They are not the same file.
| Job | What “done” looks like | Live listing (29 Aug 2026) | Price |
|---|---|---|---|
| The books | Gifts by envelope, fund, method; expenses by check #; budget vs actual; year-end donor totals | Church Tithe Tracker 4533118846 |
$6.99 |
| The count | Two people, cash vs checks vs coin, MATCH or VARIANCE, both sign, then a fund split and a deposit bag | Offering Count Sheet 4562846570 |
$6.99 |
| Restricted aid | Request, approval, check out of benevolence, running fund balance you can defend | Benevolence Tracker 4556217675 |
$6.99 |
| One campaign | Pledged vs received vs net after venue and food, for one dinner or drive | Fundraising Tracker 4559925306 |
$6.99 |
A practical stack for a small church is the tithe tracker plus the offering count sheet. Add benevolence if a committee writes checks from a restricted fund. Add the fundraising file only when you have a named campaign. All four listings were active at $6.99 USD on the pull that updated this page.
Where ChatGPT and Claude belong — and where they do not
AI is useful on church money in three narrow ways:
- Formulas. Ask for a
SUMIFSthat totals the Giving Log by fund and month. Paste a header row and three fake sample rows — not live donor data. - Board notes. Paste fund totals only (“General $12,400, Missions $2,100, Building $800; last month General $11,900”) and ask for a 150-word finance-committee note. Tell it not to invent causes.
- Print forms. Ask it to draft a one-page check-request form: payee, ministry, amount, receipt checkbox, two signature lines, treasurer box for check number. Print that. Log the payable in the spreadsheet.
Hard rule: do not paste donor names, envelope numbers, bank account numbers, Social Security numbers, or a signed count sheet into a consumer chat. Dual control is a physical procedure. A language model is not a second counter.
If the bank statement and the sheet disagree, the bank wins until you find the row. AI does not reconcile a deposit bag.
DIY giving-log schema (standalone, no purchase)
If you are building this in a blank Google Sheet tonight, use one workbook and three tabs. Do not mix personal grocery categories with ministry funds.
Tab A — Giving Log
One row per gift. Columns, in order:
- Date
- Envelope / donor number (prefer a number over a name in the working file)
- Fund — dropdown from a Setup tab: General, Missions, Building, Benevolence, plus your church's named funds
- Amount
- Method — Cash / Check / ACH / Card / Online / Other
- Check or confirmation number (optional)
- Deposit date
- Notes
Designated gifts keep their fund tag forever. A missions gift that later “helps payroll” is how churches lose restricted-fund arguments.
Tab B — Expense Log
Date, check number, payee, ministry, fund, amount, receipt Y/N, notes. Ministry and fund are separate columns. A missions trip reimbursement is Missions (fund) and Outreach (ministry). Mixing those two is how budget-vs-actual lies to the board.
Tab C — Dashboard (formulas only)
YTD giving, YTD expenses, net, budget utilization, and a designated-fund balance for each fund on Setup. You do not type totals here. If you find yourself overwriting a dashboard cell, the formula is already broken.
That DIY file will get you through a quarter. Year-end contribution statements, a 12-month P&L, and a fundraising-events tab are the pieces people usually skip — which is why the live tithe-tracker listing exists.
Job 1 — Weekly giving, budget, year-end statements
Church Tithe Tracker Spreadsheet | Giving Log Year-End Statements Excel
Listing 4533118846 · $6.99 · state active (Etsy Open API, 29 August 2026). Instant download. Nothing ships.
This is the shop's main church-finance workbook: an 11-tab Excel and Google Sheets file plus a browser dashboard. Listing copy: Start Here, Annual Budget, Giving & Tithes Log, Dashboard, Designated Funds, Expense Log, Monthly P&L, Fundraising Events, Contribution Statements, Sample Data Guide. You log every gift (envelope/donor number, date, fund, amount, method) and every expense (check number, payee, ministry, fund). Budget vs actual, designated-fund balances, a 12-month P&L, and per-donor contribution statement totals calculate from those logs.
It is for the volunteer who has to answer “how are we doing vs budget?” and “what goes on year-end statements?” from the same file. It is an organizational template, not a CPA substitute, and not a claim that the statement layout matches every denomination's receipt rules. Your church's official records and a CPA who knows fund accounting still win if numbers disagree.
Open the live Tithe Tracker listing — $6.99
Job 2 — Two-counter offering count
Dual control is the point. Two people count cash, checks, and coin independently. The sheet flags MATCH or VARIANCE. Both sign off. Then you split that week by fund so designated gifts stay labeled, and you log the bank bag. After the count, paste fund totals only into ChatGPT or Claude for a three-sentence Monday note. Do not upload the signed sheet.
Church Offering Count Sheet | Two Counter Sign Off Deposit Log Budget vs Actual Excel Sheets
Listing 4562846570 · $6.99 · active. Instant 8-tab Excel + Google Sheets. Listing tabs: Start Here, Dashboard, Setup, Weekly Count, Fund Split, Budget vs Actual, Designated vs General, Year-End Summary. Setup holds up to 10 fund names; the Weekly Count dropdown and Fund Split follow those names. Not tested in Apple Numbers — do not use Numbers.
If the tithe tracker is the books, this is the counting-room sheet. It is not a donor contribution statement and not nonprofit accounting software.
Open the live Offering Count listing — $6.99
Job 3 — Restricted aid (benevolence)
Benevolence is not “the leftover general fund.” Gifts in, withdrawals out, a running balance, and an approver on every request. Email threads are not an audit trail.
Church Benevolence Tracker Spreadsheet | Aid Request Disbursement Log Excel Google Sheets
Listing 4556217675 · $6.99 · active. Seven tabs including Requests Log (date, requester, category, amount requested vs approved, approver, status, ref #), Disbursements (method, linked request, check/confirmation number, running fund balance), Donations Income, Fund Summary, and Monthly Rollup. It is an audit trail for compassionate aid — not pastoral-care advice, not a substitute for dual-control policy, and not tax or legal advice.
Open the live Benevolence listing — $6.99
Job 4 — One named campaign
Pledged is not received. Received is not net after the caterer. One campaign per workbook; File → Save As for the next dinner. Giving Tuesday 2026 is Tuesday, December 1 — that date is on the live listing copy, not a projection from this page.
Church Fundraising Tracker Spreadsheet | Giving Tuesday Capital Campaign Pledge Excel
Listing 4559925306 · $6.99 · active. Five tabs: Instructions, Event Setup, Pledges & Donations log (outstanding as Amount − Received), Expenses log, Dashboard of formulas (raised vs goal, net after expenses, unique donors, giving by method). Not auction bids, not a weekly tithe log, and not a full church P&L.
Open the live Fundraising listing — $6.99
If you are the giver, not the treasurer
Households in the pew have a different problem: by April they cannot say what they gave, to whom, or whether the receipt still exists. That is not the church's ledger. Do not put your personal giving file in the treasurer workbook.
Donation Tracker Printable | 29-Page Charitable Giving Kit
Listing 4536203239 · $6.99 · active. A 29-page fillable binder plus companion spreadsheet for a household giving file — cash and check logs, non-cash itemization with a blank fair-market-value column you fill in yourself, receipt log, charity mileage. It is not tax advice and not the church's books. If you need the organization side, use the tithe tracker or the offering count sheet above.
Open the household Donation Tracker — $6.99
December checklist (works on any file)
- Lock the calendar year on Setup. Do not keep logging January gifts into last year's book.
- Every designated fund has a running balance that equals gifts in minus withdrawals out. If it does not, find the row before you print statements.
- Contribution statements are totals from the giving log, not a second typed list. If you retype donor totals, you will ship a letter that disagrees with the log.
- Keep official donation receipts. This system does not replace them.
- If the church letter and your household log disagree, the church's official records win until someone finds the missing gift.
Love Guarantee and custom work
Every listing on this page carries the same 14-day Love Guarantee, copied from live listing copy: message Smart Files Shop if the file is not right — free fix, free small customization, or refund.
Free small customizations (typical examples on these listings): 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 — quoted before any extra charge; never a surprise invoice. Typical menu on the church listings: 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. Timeline is usually 1–3 business days after the brief is locked. The shop does not take full bookkeeping outsourcing, tax filing, or CPA work.
Tithe tracker for the books. Count sheet for Sunday.
ChatGPT Free for the reimbursement form and the board note — fund totals only. Do not paste donor names into a chat.
FAQ
Can a church treasurer paste offering data into ChatGPT?
No. Use ChatGPT or Claude for formulas, board-memo drafts, and policy language. Strip identifiers first. Work from fund totals.
What columns belong in a church giving log?
Date, envelope or donor number, fund, amount, method, deposit date. Keep designated gifts labeled forever. Do not mix personal budget categories into the church file.
Do small churches need QuickBooks?
Many volunteer treasurers close the month in Excel or Google Sheets. Dual-control counts still belong on a count sheet, not in a chat window.
Are these tax software?
No. They are bookkeeping templates. They will not file a 990 or generate a legally sufficient contribution receipt for every jurisdiction.
What is the live price of the tithe tracker?
$6.99 USD on listing 4533118846, state active, as of the 29 August 2026 Etsy Open API pull that updated this page. Checkout on Etsy is the source of truth if the price changes.
Related playbooks
- Home maintenance spreadsheet system — filter due dates, warranties, repair spend
- Small-landlord rent roll spreadsheet — who paid, who is late, what repairs cost
- ChatGPT vs Claude vs Gemini — which model to use for formula help
- AI automation tools for small business
Last updated 29 August 2026 against a live Etsy list-listings active pull (94 actives). AI-assisted draft; human-reviewed against listing copy. Not deployed from this edit until quality prints APPROVED.