PTO Treasurer Spreadsheet and PTA Treasurer Report
$16.99
Took over the books mid-year with a shoebox and a bank login? This school and club treasurer spreadsheet is for PTO-style parent groups, booster clubs, youth sports leagues, youth troops and packs, and school and community clubs. One workbook for the whole year: transaction ledger, bank reconciliation, two-counter cash count, fundraiser profit and loss, reimbursements, teacher and team allotments, dues and fees, budget vs actual, a one-page treasurer report, 990-N / 990-EZ prep and an audit tie-out. Excel and Google Sheets, plus a Word guide and handover checklist.
Share
What's inside
- School_Club_Treasurer_Workbook.xlsx: the blank 13-tab workbook you work in
- School_Club_Treasurer_Workbook_EXAMPLE.xlsx: a finished sample year for a parent group, so you can see every tab filled in
- School_Club_Treasurer_Guide.docx (Word): setup, the monthly routine and year end, in plain English
- Handover_Checklist.docx (Word): printable checklist for passing the books to the next treasurer: people and access, the books, bank and cash, compliance and records, with sign-off by both treasurers and a witness
- START_HERE.txt: what to open first and the recommended order
- Start Here: organization name, fiscal-year start month, bank accounts with opening balances, officers
- Categories: your income, expense and transfer categories in one list that feeds the ledger category dropdown
- Transaction Ledger: every deposit, check, payment and transfer, with a status column that flags bad rows
- Bank Reconciliation: 12 months per account; says RECONCILED only when the difference is $0.00
- Cash Count: printable two-counter sheet by denomination; flags a blank counter, the same person twice, quantities that disagree and over / short
- Fundraiser P&L: revenue, costs, net and margin by event, pulled from the ledger; flags a loss or a name with no ledger rows
- Reimbursement Register: requests before you pay them; flags missing receipt, blank requester or approver, and self-approval
- Allotments: teacher, classroom, team or committee budgets; spent pulls from the ledger; OVERSPENT flag
- Dues and Fees: member, player or family roster with balance and UNPAID / OVERPAID status, checked against ledger dues
Who it's for
- Treasurers at PTO-style parent-teacher groups, booster clubs, youth sports leagues, youth troops and packs, and school and community clubs, especially if you just inherited the books and want one place to track the money, keep two people on every cash count, report at each meeting and hand over a clean year
Before you buy
Organizational tools only for parent groups, booster clubs, leagues and clubs. Not tax, legal, or accounting advice. Not approved or endorsed by the IRS, any school district, national organization or regulator. Does not guarantee compliance or a clean audit. The 990-N / 990-EZ Prep tab is general information; filing requirements and thresholds depend on your organization's status and can change, so check the current-year IRS instructions and your parent organization's or district's rules, and have a qualified CPA or tax preparer confirm how they apply to you. Built by ReconciledBooksCo, a small shop run by an experienced accountant.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one organization per purchase.
