Church Treasurer Spreadsheet
Instant download Secure checkout Google Sheets & Excel Formula guarantee
Secure one-time checkout by Stripe — instant download. Also available on Etsy.
Tithes and offerings by fund, designated money that stays designated, the budget the board approved vs what was actually spent, a treasurer's report that prints for the meeting, and every giver's annual statement — one connected workbook.
What’s inside
- Giving — 400 rows: fund, giver (dropdown from your list), amount, method, deposited?; the Sunday plate as one Loose plate line
- Expenses — category, paid to, the fund it draws from, paid by, receipt?, reimbursed
- Funds — opening balance + received − spent = balance per fund, next to its budget; total equals cash now
- Giving Statements — each giver's annual total, number of gifts and totals by fund, ready for January letters (with the IRS Pub. 1771 wording note)
- Budget and Campaigns — budget vs actual per fund and category; Easter offering, missions trip and camp fund goals vs received
- Treasurer Report — pick a month; balance at start, giving by fund, expenses by category, net, balance at end
- Dashboard — cash now, average gift, General vs designated giving, Benevolence and Building Fund balances, by month / quarter / year
- 126 automated formula checks passed before listing; Google Sheets or Excel
Who it's for: the volunteer treasurer of a small church who counts the plate on Sunday, pays the bills on Tuesday, and reports to the board once a month.
Nine connected tabs for $19.99, one-time — versus the $30–$43 single-purpose tithe trackers, and versus church software billed monthly.
