VThe Vera Standard

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.

$79
Buy on Gumroad
Secure checkout and instant download through Gumroad.

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]