Charity Treasurer Template | Simple Accounts for Non-Accountants (Excel, Google Sheets)

Simple charity accounts for people who are not accountants. If you've just become the treasurer of a church group, village hall, sports club, PTA or local charity — and you're staring at a shoebox of receipts wondering where to start — this is for you. One clear dashboard answers the only question that really matters: "What money do we actually have available to use right now?" No jargon, no macros, no accounting degree required. 3. WHAT'S INCLUDED ⭐ The Treasurer Workbook — a 12-sheet system that does the maths for you 📊 Live Dashboard — your money at a glance, updates automatically 💷 Money In & Money Out logs — simple, dropdown-driven entry 🔒 Restricted Funds tracker — keeps ring-fenced money safe and separate 🎯 Grants & Donations tracker — with traffic-light reporting reminders 🎪 Fundraising Events — see which events actually make money 🏦 Bank Reconciliation — two numbers, one clear answer 📋 Monthly Treasurer Report — committee-ready, printable 📅 Annual Summary — your whole year on one page 🗂️ Charity Details & Compliance sheet — registration and trustee record ❓ Help Centre — plain-English answers built right in Works in Microsoft Excel (365 / Online / desktop) and Google Sheets. Comes pre-filled with realistic sample data so you can see exactly how it works — then clear it and add your own. 4. WHO IT'S FOR Built for volunteer and first-time treasurers at: small churches and church clubs, village halls, community groups, Age Concern and similar local charities, sports and social clubs, PTAs, and fundraising committees. If you're responsible for other people's money and want to do it properly — without it taking over your life — this was made for you. 5. KEY BENEFITS Know what you can actually afford. The dashboard separates ring-fenced restricted funds from money you're free to spend, so you never accidentally spend a grant on the wrong thing. Walk into committee meetings prepared. Print a clean, professional Monthly Treasurer Report in seconds — no more scribbling figures the night before. Stop dreading year-end. The Annual Summary builds itself as you go. No learning curve. Dropdown menus, plain-English labels, and a built-in Help Centre mean you're up and running in an afternoon. Reassuringly simple, properly thorough. Calm design, no intimidating finance-speak — but it still tracks everything a small charity needs. 6. HOW IT WORKS 1️⃣ Open the workbook in Excel or upload to Google Sheets. 2️⃣ Enter your opening balances (one number each for bank, general fund and any restricted funds). 3️⃣ Add money coming in and going out as it happens — pick categories from dropdowns. 4️⃣ Everything else updates by itself: dashboard, reports, fund balances, charts. 5️⃣ Print your Monthly Report before each committee meeting. 7. FILE TYPES INCLUDED 📁 Simple_Charity_Treasurer_OS.xlsx — opens in Excel and Google Sheets (This listing is for the workbook. Treasurer Guide PDF, Quick Start Guide and Printable Forms Pack available — add as bundle / upsell when ready.)