Class Treasurer Report: Class Funds, Fundraisers and Bank Match
Monthly treasurer report with a bank match, fundraiser profit and a reunion fund page, in Google Sheets or Excel, plus fillable PDF pages.
Google Sheets workbook for a class treasurer: type each deposit once, then print a monthly report with a bank match, fundraiser profit and a reunion fund page for your class officers.
Preview
The product pictures show the real sheets with sample data loaded. The download also holds a blank copy, ready for your own figures.
Tabs in the workbook
Start here, Settings, Transactions, Budget vs actual, Bank match, Treasurer Report, Fundraiser profit, Reunion fund, Lists, License.
What you get
- class-treasurer_workbook_v1.xlsx: one workbook with 10 sheets (Start here, Settings, Transactions, Budget vs actual, Bank match, Treasurer Report, Fundraiser profit, Reunion fund, Lists, License) and Sample data loaded. Transactions holds 400 lines with dropdowns. Four sheets print on one page wide.
- class-treasurer_workbook_v1_blank.xlsx: the same workbook with the Sample data cleared, ready for your own figures.
- class-treasurer_printables_Letter.pdf and class-treasurer_printables_A4.pdf: the same 6 pages in two paper sizes, with 279 fillable boxes. Page 1 instructions, page 2 monthly treasurer report, page 3 class budget worksheet (16 category lines), page 4 fundraiser profit worksheet (8 fundraisers), page 5 reunion fund page, page 6 license.
- 00_READ_ME_FIRST.pdf: 1 page with what is inside, how to open the files and how to get help.
How it works
- Instant download. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel. The Start here sheet has a five-line Quick start.
- Type each deposit and payment once on Transactions: date, Income or Expense, category, fund (Class fund or Reunion fund), amount, and Y or N for cleared on the bank statement. A Row check column names any line that does not count.
- The Treasurer Report gives opening balance, receipts, disbursements and closing balance, the balance of each fund, a table by category, notes and signature lines.
- Bank match lists the lines not yet on your statement, gives the amount your statement should show and the Difference to the statement amount you type.
- Budget vs actual compares each category with the budget to date, with a flag for lines that run close to or over the plan.
- Fundraiser profit adds up the revenue and costs of each fundraiser you tag on Transactions, then shows net, margin and rank.
- Reunion fund (this listing's own sheet) tracks a goal amount and goal date, what has been paid in and spent from the Reunion fund, what is left and the amount needed per month, with a payments list by class member that you type.
- Record-keeping template only. Your class officers and school decide your own rules, approvals and reporting.
Who it is for
The class treasurer and the class officers of a school class who must keep a clear record and show a monthly report. It records and totals what you type; it is not accounting software.
Requirements
Google Sheets (free) or Microsoft Excel (Microsoft 365, Windows) for the workbook; any PDF reader for the printables. The PDF pages are fillable on screen in a desktop PDF reader (pages 2 to 5) or can be printed and written on by hand; choose the Letter file or the A4 file for your paper. No macros, no scripts, nothing to install. The workbook is built for a computer.
License
License for one buyer: use it yourself, in your household, or for the one club, class or organization you use it for. No resale or redistribution.
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. We reply within two working days.
Refund at once, no argument: a missing file, a file that will not open, or the wrong paper size.
Free extra
A free printable checklist, Before your first treasurer report, is on our free page; signing up there is optional, and we never add Gumroad buyers to a mailing list.
Next step
About
Made with the help of AI tools and designed, tested and checked by the seller.
The Vera Standard makes plain, tested templates for volunteer treasurers, exam candidates and small makers.
Questions: [email protected]