PTO Treasurer Monthly Report Kit | Excel Budget & Bank Reconciliation Template
Prepare your PTO’s monthly money report from one organized Excel transaction log. Record receipts, payments and refunds, compare actuals with the annual budget, reconcile your checking account, and print a clear meeting summary.
Made for volunteer treasurers of small independent PTOs using one checking account and cash-basis records.
YOUR DOWNLOAD INCLUDES
• A blank Excel workbook with five connected sheets: Monthly Report, Setup, Budget, Transactions and Reconciliation.
• A completed fictional example to practice with.
• A four-page illustrated quick-start guide.
• A one-page monthly close and handover checklist.
• Setup help and troubleshooting by message.
INSIDE THE WORKBOOK
Monthly and year-to-date category totals, annual budget remaining, opening and closing book cash, dated outstanding checks and deposits, and visible input checks. Choose your fiscal year and rename the preset categories. Reuse a fresh copy for a new year.
PLEASE CHECK THE FIT BEFORE BUYING
Macro-free .xlsx files, tested in Microsoft Excel for Windows 16.0, build 20326. An Excel license is not included. Google Sheets, Apple Numbers, Excel for Mac and mobile apps have not been tested. Capacity is 500 transaction rows per year, including opening items, and 16 categories: eight income and eight expense. One checking account, US dollars, cash basis. Digital download; no physical item.
INCLUDED HELP
Message the seller for setup questions or troubleshooting. Custom changes, bookkeeping and reviews of your financial records are separate services. The kit does not provide bank connections, automatic imports, restricted-fund accounting, payroll, tax filing or an audit.
USE
One organization’s internal work, including future years and handover to its next treasurer. Completed reports may be shared with members and advisors. Templates may not be resold or redistributed outside the organization.
Case & Contrast is not affiliated with or endorsed by National PTA.