PTA Treasurer Spreadsheet, Booster Club Budget, PTO Treasurer Report, Bank Reconciliation, School Fundraiser Tracker, Google Sheets Excel

A treasurer's binder in one workbook. Record deposits and checks once. The kit keeps the register, restricted funds, budget and bank reconciliation in sync and produces a one-page monthly report for your board.
WHO IT'S FOR
Volunteer treasurers of PTAs, PTOs, booster clubs, band and sports parent groups, and other small clubs — especially if you're new to the role or inheriting a messy file.
WHAT IT DOES
• Transaction register with a running book balance
• Built-in control checks on every line: second signature over your limit, the same person signing twice, a missing receipt, and an overspent restricted fund
• Restricted funds (playground, teacher grants, class funds) tracked separately from general funds
• Fundraiser profit by event
• Budget vs actual with year-to-date pace and flags
• Bank reconciliation that lists outstanding items automatically and shows the difference
• One-page printable monthly treasurer's report that ties beginning balance, activity and ending balance
• Two-person cash count sheet with variance
TABS
Start Here · Dashboard · Settings · Chart of Accounts · Restricted Funds · Fundraisers · Transactions (1,500 rows) · Budget vs Actual · Bank Reconciliation · Monthly Report · Cash Count
WHAT YOU GET
• Instant digital download — no physical item is shipped.
• Excel workbook (.xlsx) and a PDF how-to guide. The guide has step-by-step instructions for using it in Google Sheets.
• Works in Microsoft Excel 2010 or later (Windows and Mac), Excel for the web, and Google Sheets (free Google account). No macros, add-ins or subscriptions.
• Fictional sample data is included so you can see how it works. Clear it when you're ready to start.
GOOD TO KNOW
• Formula cells are protected so they can't be overwritten by accident (no password). Light-tinted cells are for your entries, and dropdowns keep entries consistent.
• Need more rows? The guide shows how to extend them.
• Your bylaws, your state or national PTA, and your auditor set the actual rules. Set your own signature limit and accounts in Settings. This isn't tax-filing software.
• Because this is a digital download, returns aren't accepted. If something doesn't work, message the shop and we'll help.
AI disclosure: This listing was made with the help of AI tools. AI helped draft the spreadsheet formulas, the how-to guide text and the layout of the preview images. Every formula was then recalculated and checked for errors before listing, and the preview images show the real workbook's sample numbers.
Please note: This is a record-keeping template. It is not financial, tax, accounting, legal or HR advice, and it does not guarantee compliance with any law, policy or funder requirement. Check important results with a qualified professional.
Original design by SystemSheets. For personal or internal business use; please don't resell or share the file.