
PTA Treasurer Spreadsheet, Excel and Google Sheets, PTO Bookkeeping, School Fundraiser Tracker, Treasurer Report, Cash Count Sheet
$9.99 USD
Buy on EtsyInstant digital download for Microsoft Excel and Google Sheets. Checkout and delivery are handled securely by Etsy.
PTA Treasurer Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Keep your PTA or PTO books clean all school year: budget vs actual, every dollar in and out, fundraiser profit, two-person cash counts, bank reconciliation and a monthly treasurer report for your meetings. Perfect for PTA and PTO treasurers.
✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers).
★ WHAT'S INCLUDED ★
• 15 tabs with a clickable Start Here page and a step-by-step How To Use guide
• Dashboard: 16 KPI tiles, month-by-month table, a "needs your attention" checklist, fundraisers ranked by profit, coming-up events, budget by group and 5 charts
• Treasurer Report: pick any month for beginning and ending balance, income vs budget, expenses by group, fundraisers this month, membership, requests and controls, notes and signature lines
• Budget vs Actual: school-year budget (July to June, or your own start month) for 12 income and 25 expense categories, 12 monthly columns, variance and status
• Income log (600 rows) and Expenses log (500 rows) with approvals, a second-signature flag over your limit, receipt check and cleared dates
• Check Requests (150 rows): reimbursement requests with decision, paid amount, status and days waiting
• Deposits (120 rows): two counters, bills by denomination, coins and checks, checked against the Income log, plus a printable Count Sheet for any deposit
• Bank Reconciliation: finds outstanding checks, deposits in transit and cash not deposited yet, with a reconciliation log
• Fundraisers (40 events): money in, costs, net profit, margin, % of goal and profit per volunteer hour
• Membership (500 rows) with dues status and a classroom membership contest with chart
• Teacher Grants (60 rows): requested, approved, reimbursed and left to award, by grade
★ PERFECT FOR ★
✓ PTA and PTO treasurers
✓ Booster clubs and parent groups that run on a school year
✓ Handing clean books to the next treasurer
★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers
★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, type your group's name, school year start, officers, opening bank balance and categories, then add your budget.
3. Log income, payments and check requests, and record every cash count with two volunteers.
4. Reconcile each month and print the Treasurer Report for your meeting.
Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.
★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• This is a bookkeeping tool, not legal or tax advice. Follow your bylaws, your council or district rules and your accountant's guidance.
• Because it's a digital
Free Monthly Budget Starter Kit
5 printable pages: a monthly budget sheet, a 12-month bill checklist and 3 savings-goal trackers. Free when you join the email list.
Get the free kit