Ninety seconds at the meeting
Beginning balance, money in, money out, ending balance, and one sentence against the budget. Here's what each number means, a treasurer report template you can copy into Google Sheets™, and the ninety-second version you read out at the meeting.
The template that fills itself · from Marinette
Treasurer Spreadsheet
See it on Etsy →Google Sheets™ + Excel · Pick the month, the report writes itself
Nobody wants a lecture and nobody's grading you. A monthly treasurer report answers one question: where did the money go this month? Five numbers cover it.
These are the same five numbers the free one-page guide for new treasurers teaches. This page is the report itself: what it looks like on paper and how to produce one every month without dreading it.
Here's the whole layout. Copy it into a fresh Google Sheet or a doc, swap in your organization's name, and type the numbers each month.
Lincoln Elementary PTA
Treasurer's Report · October 2026
| Beginning balance (Oct 1) | $2,078.60 |
| Money in: dues $310, fall festival $1,240, bake sale $385 | $1,935.00 |
| Money out: festival costs $612, supplies $184, reimbursements $95 | $891.00 |
| Ending balance (Oct 31), matches the bank statement | $3,122.60 |
Against the budget: fall festival came in $140 under its expense budget. On track for the year.
Six lines. That's the entire report.
If you'd rather not build and total it by hand every month, the Treasurer Spreadsheet produces this exact handout from your money log: you record money in and out as it happens, pick the month from a dropdown, and the report fills itself in, ready to print for the meeting.
"We started October with $2,078.60. We took in $1,935, most of it from the fall festival. We spent $891, including the festival costs and two reimbursements. We ended the month with $3,122.60, and that matches the bank statement. Festival came in about $140 under budget, so we're on track for the year. Happy to take questions."
That's the whole job. The sentence that matters most is "and that matches the bank statement": it means you reconciled, and reconciling is what protects you, the treasurer before you, and the one after. If something doesn't match, say what and why: a check that hasn't cleared is a normal sentence, not a confession.
Log the money as it happens. Pick the month. Print the report.
See the Treasurer Spreadsheet on Etsy →Or read about it first: the Treasurer Spreadsheet, page by page
FAQ
Five numbers: the beginning balance (where last month's report ended), money in, money out, the ending balance, and one sentence comparing the month against the budget. Money in and out can be grouped by category, but the five numbers are the report. The ending balance should match the bank statement, and saying so out loud is the part the members are listening for.
Usually no. Most parliamentary guides, including Robert's Rules, say a monthly treasurer's report is received and filed rather than voted on, because the numbers haven't been examined yet. What the board formally adopts is the annual audit or financial review. Your bylaws win if they say otherwise.
Yes, and matching it is the whole point of the exercise. Reconciling means checking your ending balance against the bank statement and explaining any difference, like a check that hasn't cleared yet. A report that matches the bank is what protects you, and the treasurer before you, and the one after.
Yes, two ways. Copy the six-line layout above into a fresh Google Sheet and type the numbers each month. Or let the Treasurer Spreadsheet build it for you: you log money in and out during the month, pick the month from a dropdown, and the printable report fills itself in.
New to the whole job, not just the report? Start with the free one-page guides: taking over as treasurer, and its siblings for secretaries and presidents. One page each, no email.
Still have a question? I'm happy to help.
Email support@getmarinette.com