Home/Spreadsheets/Treasurer & Nonprofit/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 you get
- 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
- Opens in Excel and in Google Sheets
$16.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
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
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Register
- Monthly Report
- Bank Reconciliation
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
Honest scope
This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.
