TToolWise Digital This on Etsy →

Catalog

PTA / PTO Treasurer Spreadsheet

Instant download Secure checkout Google Sheets & Excel Formula guarantee

Secure one-time checkout by Stripe — instant download. Also available on Etsy.

The PTO's money in one connected workbook: membership dues, committee budgets, every fundraiser's real net, reimbursements owed to chairs, a treasurer's report that prints for the board, and the year-end numbers the 990 asks for.

What’s inside

  • Membership — Family / Individual / Staff rates you set; dues and paid calculate (paid pulls from Income by name); counts by type
  • Committees — chair and budget per committee; spent, remaining and raised come from the logs where you tagged the committee
  • Income and Expenses — 400 rows each; paid by, receipt? and reimbursed on every expense
  • Budget and Fundraisers — budgeted vs actual; goal vs raised minus costs per event
  • Treasurer Report — pick a month; balance at start, income and expenses by category, net, balance at end
  • Year-End & 990 — gross receipts, dues, contributions and grants, fundraising gross and direct costs, program vs management spend, cash at start and end, and which form applies (990-N ≤ $50,000 normally; 990-EZ under $200,000 receipts and $500,000 assets — IRS thresholds verified September 2026)
  • Sample copy (an elementary-school PTO, filled in) plus a Blank copy; free phone log; printable Quick-Start
  • 140 automated formula checks passed before listing; Google Sheets or Excel

Who it's for: the incoming PTA or PTO treasurer who inherited a spreadsheet nobody understands and has an audit committee to satisfy in June.

Ten connected tabs for $17.99, one-time — the budget sheet, the committee tracker, the monthly report and the 990 prep in one file.

Sheets + Excel

Works in free Google Sheets or Microsoft Excel — your choice.

Free phone tool

Includes a browser version so you can use it on the go.

Instant download

Delivered the moment you buy. Nothing shipped.

Formula guarantee

If a formula doesn't work as described, we fix it or refund you.

Questions

Does it replace filing the 990?

No. It gives you the numbers — gross receipts, fundraising net, program vs management spending, cash at start and end — and tells you which form the thresholds point to. File with your state PTA's guidance or a CPA.

Our fiscal year runs July to June. Does it work?

Yes. The workbook runs on calendar months; start a new copy each July with that opening balance and the report and year-end tabs cover your fiscal year.

How do committee budgets fill in?

Every income and expense row has a Committee / event dropdown. Tag it, and the Committees tab shows that chair's spent, remaining and raised.

More from the shop

Browse the full catalog

See all 328 tools →