PTA and PTO Treasurer Kit: Monthly Report, Budget and Fundraiser Profit
You don't want to mess up other people's money. A monthly treasurer report with a bank check, for PTA treasurers and PTO treasurers in Google Sheets and Excel.
Every Register line checks itself and says OK or what to fix, and the bank match ends in a Difference: 0.00 means the Register and the statement agree.
One payment and the file is yours; fixes to the same file are free. Nothing links to your bank; your numbers stay in your file.
A Start here sheet gives five steps in plain words; you type only in the shaded cells.
Not sure it fits? Write within 30 days and we refund you in full. We reply within two working days.
Print the one-page Treasurer Report for the meeting: money in, money out, what the group has, and whether it matches the bank.
What it does
- Register: one line per deposit or payment, each with a Row check.
- Treasurer Report: opening balance, receipts, disbursements, closing balance and the bank match.
- Budget: budgeted against actual by committee.
- Fundraiser Profit: revenue, costs and net profit for each fundraiser.
- Book Fair: cash counted against cash expected, checked against the Register.
What you get: 5 files: the workbook with 8 sheets (Start here, Treasurer Report, Register, Budget, Fundraiser Profit, Book Fair, Lists, License) and Sample data loaded, the same workbook blank, the 6 printable pages on US Letter and on A4, and a one-page read-me guide. The Register holds 400 lines.
How it works
- Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Type each deposit and payment on the Register.
- Read the Treasurer Report and print it.
See it first
The free treasurer sampler has one month of the Register and the monthly Treasurer Report, with the bank match, so you can try it on your own figures before you decide: https://payhip.com/b/XJbly
Real screens. Sample data is fictional.
Who it is for
Volunteer treasurers of a PTA, PTO or similar parent group who must give a clear monthly report to the general meeting.
It is not the right fit if you need:
- a bank feed or automatic import.
- donor-receipt or tax forms.
- payroll.
- double-entry accounting.
What you need
Built for Microsoft Excel and Google Sheets (free). The printables need any PDF reader. Built for a computer.
FAQ
Where is my download? Press View content, then Download all. The link is in your receipt email too.
How do I open it in Google Sheets? Upload the .xlsx to Google Drive and open it with Google Sheets. No copy link is needed.
Can I change the categories, funds or committees? Yes, on the Lists sheet. The dropdowns and totals follow.
Does it connect to my bank? No. You type or paste your numbers; nothing is linked.
Is anything shipped? No. It is a digital download.
Help and refunds
If anything is wrong, we fix it or refund you. Changed your mind? Write within 30 days and we refund you in full. Buyers in the EU and UK keep any withdrawal right the law gives them.
Files
- pta-pto-treasurer-kit_workbook_v1.xlsx
- pta-pto-treasurer-kit_workbook_v1_blank.xlsx
- pta-pto-treasurer-kit_printables_Letter.pdf
- pta-pto-treasurer-kit_printables_A4.pdf
- 00_READ_ME_FIRST.pdf
License: one purchase covers you and the one organization, club or class you use it for. If you hand over the role, the next treasurer may keep using it. Please do not resell or share the files outside that organization.
About
The Vera Standard is a small independent studio in Hyderabad, India. We make plain, tested templates for volunteer treasurers. Write to theverastandard@gmail.com. We reply within two working days.
We design these templates with the help of AI tools. Every formula and total is then tested by us with sample data before release.
This file has no tax or donor-receipt wording. Arithmetic on the numbers you type. Not advice of any kind.
Google Sheets is a trademark of Google LLC. Excel is a trademark of the Microsoft group of companies. The Vera Standard is independent and is not affiliated with or endorsed by them.
PTA is a registered service mark of National PTA. This template is independent and suits any parent group.
Next step
More from The Vera Standard are on the same profile.