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

Seller's description

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.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/ZMQXu3jx3Eg

✨ 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 offering
✓ Anyone who needs to send donor giving statements

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, add your church details and chart of accounts. Type your budget and opening fund balances.
3. Each week, record the offering count and log each gift and payment.
4. Each month, reconcile the bank and print the Treasurer Report. At year-end, print giving statements.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• This is a bookkeeping tool, not legal or tax advice. Rules for giving statements and restricted gifts vary, so check with your accountant or denomination.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.