Your Cart
Loading

PTA and PTO Treasurer Sampler: free monthly treasurer report with a bank check

On Sale
$0.00
Free Download
Added to cart

You don't want to mess up other people's money. A free monthly treasurer report with a bank check, for PTA and PTO treasurers in Excel and Google Sheets.

Use it the evening before the monthly meeting: you type each deposit and payment once, and the report adds them up.

Every Register line checks itself and says OK or what to fix, and the report ends in a bank match that reads 0.00 on the sample.

Free: no subscription, no account and no bank login. Nothing is linked to a bank; your numbers stay in your file.

A Start here sheet gives five steps in plain words; you type only in the shaded cells.

Try it on made-up numbers first. The sheet What the full kit adds lists what the complete kit holds.

The report prints on one page: money in, money out, what the group has, and whether it matches the bank.

Free and complete. The full PTA and PTO Treasurer Kit adds Budget, Fundraiser Profit and Book Fair sheets, a 400-line Register, a blank copy and printable worksheets: https://theverastandard.gumroad.com/l/pta-pto-treasurer-kit

$0.

Gumroad asks for an email to send the file. We send one follow-up asking for an honest rating, and nothing else unless you opt in.

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.

What you get: 4 files: the workbook with 6 sheets and a 100-line Register, the sample report as a one-page PDF on US Letter and on A4, and a one-page read-me guide. Free guide to the report: https://theverastandard.pages.dev/guides/how-to-write-a-treasurer-monthly-report/

How it works

  1. Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
  2. Read the Treasurer Report and its bank match.
  3. Change a number on the Register and watch the checks.

See it first

Real screens. Sample data is fictional.

Who it is for

The unpaid volunteer treasurer of a PTA, PTO or booster club who must report to a board every month.

It is not the right fit if you need:

  • a bank feed or automatic import.
  • donor-receipt forms.
  • payroll.
  • more than 100 Register lines.

What you need

Tested in Microsoft Excel (Microsoft 365, Windows) and Google Sheets (in Google Sheets, cell protection is not kept) (free). 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, committees or fundraisers? 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

Free file. There is nothing to pay, so there is nothing to refund. If a file will not open or is not as shown, write to theverastandard@gmail.com and we send another file.

Files

  • pta-pto-treasurer-sampler.xlsx
  • pta-pto-treasurer-sampler_report_Letter.pdf
  • pta-pto-treasurer-sampler_report_A4.pdf
  • pta-pto-treasurer-sampler_READ_ME.pdf

License: for your own use. You may print it and keep copies. Please do not resell it or share it as your own.

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.

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.

You will get the following files:
  • XLSX (34KB)
  • PDF (88KB)
  • PDF (88KB)
  • PDF (25KB)