Church Treasurer Spreadsheet, Excel and Google Sheets, Nonprofit Bookkeeping, Donation Tracker, Giving Statements, Fund Accounting

Church Treasurer Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Count the Sunday offering, record every gift by fund, print year-end giving statements and give your board a clear monthly report. Perfect for church treasurers and finance teams. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 15 tabs with a clickable Start Here page and a How To Use guide with FAQ • Treasurer Dashboard: 16 KPI tiles (total giving, General Fund vs budget, expenses, net income, cash in all funds, unrestricted vs restricted, giving units, average weekly offering, attendance, digital giving, pledge progress, capital campaign, lapsed donors and more), a month by month table, a "needs your attention" checklist, fund balances, recent counts, budget by group and 5 charts • Offering Counts (110 rows): two counters, currency, coin, checks, online giving and attendance, with a count check that compares the count to the gifts you logged, plus deposit and cleared dates • Contributions (4,000 rows): date, donor, fund, method, check number, amount and the value of any goods or services received, with the deductible amount worked out • Donors (300 households): envelope number, address, annual pledge, giving this year, pledge progress, last gift and Active / New / Lapsed status • Giving Statement: pick any donor and year for a printable contribution statement with a summary by fund, every gift (up to 80 lines) and the deductible total • Other Income (300 rows) for rentals, interest, fundraisers, grants and program fees, and Expenses (1,500 rows) by fund and expense account with approvals, receipts and cleared dates • Budget vs Actual: annual budget for every income and expense line, all 12 months, year to date vs pace, variance and Over budget / Running high / On track flags, with a chart by group • Fund Balances: up to 12 funds (unrestricted, board-designated, donor-restricted) with opening balance, gifts, income, expenses, transfers, goals, a month-end balance table and 2 charts • Treasurer Report: pick a month for a one-page board report with fund activity, income and expenses vs budget, giving and attendance, controls and notes • Bank Reconciliation: finds outstanding checks and deposits in transit for you and shows Reconciled or the exact amount you're off, plus a 12-month reconciliation log • Giving Analysis: giving by fund and by method for every month, giving levels, donor engagement, 53 weeks of offerings and attendance, top 10 households and 4 charts • Setup: your chart of accounts with 12 funds, 10 other income types and 30 expense accounts in 5 groups, all editable • Sample data from a mid-size church so you can see how it works ★ PERFECT FOR ★ ✓ Church treasurers and finance teams ✓ Small nonprofits, ministries and community organizations ✓ Bookkeepers and volunteers who count the Sunday