Church treasurer report template
A ready-to-use monthly treasurer's report worksheet — opening balance, income by fund, expenses by category, and closing fund balances, on one page a board can read in two minutes. Download it, drop in your numbers, and you have a report ready for the next meeting.
Opens in Excel, Google Sheets, or Numbers.
What's in the report
Each month it shows
- Reporting period & opening balance
- Income received, grouped by fund
- Expenses paid, grouped by category
- Net change for the month
- Closing balance (all funds)
- Budget-vs-actual and notes
Funds it tracks separately
- General / operating
- Building / capital
- Missions
- Benevolence
- Other designated / restricted
- Reserves / savings
How to use it
- 1. Start with the opening balance — last month's closing balance for each fund.
- 2. Enter income grouped by fund, so restricted gifts stay separated from general giving.
- 3. Enter expenses by category, and reconcile the total against the bank statement.
- 4. Let the closing balance flow from opening + income − expenses, fund by fund.
- 5. Add a short note on anything unusual or off-budget, and bring it to the board monthly.
For what each section means and how to present it, see the guide on how to write a treasurer's report. The report is one duty of the church treasurer, and it rolls up into the church's formal financial statements at year-end. Keeping money separated by fund is the core of church fund accounting.
This template is a starting point, not legal or tax advice. Want the treasurer's report generated from your books automatically, every month? Start free in Vestrybooks.