Home/Spreadsheets/PTA & Treasurer/PTA Treasurer Spreadsheet
PTA Treasurer Spreadsheet
A PTA treasurer spreadsheet for PTOs and booster clubs: enter every transaction once on the register and the budget, fundraiser tracker, monthly treasurer report and year-end audit packet build themselves. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What it does
- 500-row transaction register with running balance, categories, events, check numbers and cleared status
- Budget against actual with ON BUDGET, WATCH and OVER BUDGET flags
- Dues roster for 200 families: PAID, PARTIAL, PAID AHEAD and OWED
- Fundraisers ranked by net against goal, plus reimbursements from Submitted to Paid
- Monthly treasurer report you pick and print, and a bank reconciliation that turns green when it agrees
- Year-end summary, 12-item audit and handoff checklist, and printable deposit and reimbursement forms
- Opens in Excel and in Google Sheets
$16.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
Secure checkout on Etsy · ★★★★★ 5.0-star shop

See it in action
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, in order, read out of the workbook itself.
- START HERE
- Dashboard
- Budget
- Register
- Fundraisers
- Dues & Fees
- Reimbursements
- Monthly Report
- Reconciliation
- Year-End
- Forms
- Settings
- Calc
Works in
- Microsoft Excel 2016 or newer, Windows or Mac
- Google Sheets: a checked Google Sheets copy is included (open the PDF in your download and make your copy)
- No macros, no add-ins, nothing to install
Others in PTA & Treasurer
- ExcelAll-in-One Event PlannerOne event, eight linked views — budget, timeline, vendors and a day-of run sheet that…$24.99View →

- Excel + Google SheetsLeague TreasurerA treasurer's ledger for any group that pools money - bowling and golf leagues, poker…$13.99View →

- Excel + Google SheetsChurch Event CalendarA full-year church event planner: one workbook for every service, study and outreach…$14.99View →

- Excel + Google SheetsNonprofit and Sports Task TrackerMost task templates give you a list. This one names who is behind and by how much, with…$13.99View →
