SDSimpleDesigns

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

PTA Treasurer Spreadsheet — the workbook open in Excel

See it in action

What it looks like

PTA Treasurer Spreadsheet screenshot
PTA Treasurer Spreadsheet screenshot

Every tab in the workbook

These are the actual sheet names in the file, in order, read out of the workbook itself.

Works in

Others in PTA & Treasurer

PTA Treasurer Spreadsheet$16.99Buy on Etsy