The Budget AuditorSign in

Free download — no sign-up

Treasurer's report template for monthly meetings

A spreadsheet built for lodge, church, nonprofit and association treasurers. Record the month's receipts and payments, calculate the book closing balance, and attach a bank reconciliation explaining any difference from the statement.

The file

What's inside

  • Blank report — 20 income and expense lines, each with a column for the authorizing motion, plus your organization and month at the top.
  • Worked example — a filled-in month so new treasurers can see what a complete report looks like.
  • Balance formulas — totals, closing balance (opening + receipts − payments) and a comparison with the adjusted bank balance from your reconciliation. The raw statement balance may legitimately differ.
  • Approval checklist — checks for supporting records, reconciliation, preparation, review and the meeting outcome. Record any required motion and decision in the minutes; proposing or seconding a motion is not approval.
Download template (.xlsx)

How to fill it in

  1. Enter the opening book balance from the previous report for the same account. Document any approved correction rather than silently changing the carried balance.
  2. List receipts and payments with their dates, sources or payees, supporting documents and applicable spending authority. Identify transfers separately: a transfer between your organization's own accounts is not new organization income or an expense.
  3. Reconcile the account at the same closing date. Keep the raw bank statement balance on the attached reconciliation; enter its adjusted bank balance in the report's comparison cell C31. After missing book entries and errors are corrected, the adjusted balances should agree.
  4. Attach the reconciliation and outstanding-item list for review. Present the report according to your organization's rules and record whether it was received, approved, deferred or returned for correction. Keep it with the supporting records and minutes.

The Budget Auditor carries report balances forward and offers AI bank-statement readings for human review. Budget and minutes comparison tools depend on the plan. Preparing or reviewing a report does not automatically verify every figure or authorize spending.

Explain outstanding items, not just the difference

A book balance does not have to equal the unadjusted bank statement balance. Attach a list of deposits in transit, outstanding checks and other reconciling items, showing each date, reference, amount and follow-up needed. Show the raw bank balance, the adjustments and the adjusted bank and book balances.

Fictional example: a $5,000 statement balance plus a $500 deposit in transit minus a $300 outstanding check gives an adjusted bank balance of $5,200. If corrected books also show $5,200, the reconciliation agrees even though the raw statement differs by $200. Do not post the deposit or check twice.

Use C31 for the adjusted bank balance and keep the original statement amount on the attached reconciliation. C32 is only the arithmetic comparison; zero alone does not prove that the records are complete or correct. See the bank reconciliation example and template.

Preparing, reviewing and authorizing are different

  • Preparing: The treasurer records transactions, calculates balances and gathers receipts, committee revenue reports and the reconciliation.
  • Reviewing: The reviewer checks the report against supporting records, investigates outstanding items and records questions or corrections. A review is not a certified audit.
  • Authorizing expenditures: Spending needs the authority required by your organization's rules, such as an adopted motion or valid standing authority. A budget line alone is not necessarily permission to spend. Receiving or approving a monthly report does not automatically authorize future spending or validate an earlier unauthorized payment.

The workbook is a simple account receipts-and-payments report. Its fictional $500 building-fund transfer appears in the payment column and total; identify it as a transfer, not an operating expense, and avoid counting it again as income when combining accounts.

Also free: bank reconciliation template

A check register with a running balance, journal entries for adjustments, and a match-to-statement tab that shows what's still outstanding.

Get the reconciliation template