Atrium

Monthly church financial report template

A spreadsheet to show the members' meeting what came in, what went out and what was left at the end of the month. The totals calculate themselves, and the last line shows whether the cash and the bank match what was recorded.

Download in Excel (.xlsx)

Free, no sign-up. Opens in Excel, LibreOffice, Numbers and Google Sheets.

Template preview

Monthly financial report

Church

Month

Prepared by

Opening balance
Cash (notes and coins)€
Bank account€
Total opening balance€
Income
Tithes€
Sunday offerings€
Designated offerings (missions, building)€
Other income€
Total income€
Expenses
Hall rent€
Water, electricity, gas and internet€
Maintenance and supplies€
Missions and offerings sent€
Community outreach€
Bank charges€
Other expenses€
Total expenses€
Result for the month (income − expenses)€
Closing balance (opening balance + result)€
Cross-check
Cash counted on the last day of the month€
Bank statement balance on the last day€
Difference (must be zero)€

Treasurer

Finance committee

Pastor or chair

In the spreadsheet, a second tab lists each expense: date, description, category, cash or bank, amount, receipt no..

What it is for

The financial report, often called the treasurer's report, is how the treasury shows the church the month's money in and out. It protects the people who handle the money as much as it informs the people who give.

The spreadsheet has two tabs: the summary, which goes to the members' meeting, and the list of expenses, which stays with the finance committee so they can check each receipt.

How to fill it in

  1. At the top of the summary, write the church's name, the month and who prepared it.
  2. Under Opening balance, copy last month's closing balance, with cash and bank kept separate.
  3. Under Income, add up the count sheets from the month's services and whatever came in by bank transfer.
  4. In the Expenses and receipts tab, enter each expense with the date, the category and the receipt number. Then copy each category's total to the summary.
  5. Under Cross-check, enter the cash counted and the bank statement balance on the last day of the month. The difference must be zero: if it isn't, find the missing entry before the meeting.
  6. Print it, ask the finance committee to sign it and present the totals to the church.

Good practice

  • Tithes and offerings appear as totals. How much each person gave never goes on a slide, a noticeboard or a group chat.
  • Swap the expense categories for the ones your church uses, but keep them the same from month to month so you can compare.
  • Don't delete a wrong line: correct it with a new line and a note.

To learn more, read the guide Church treasurer's report: how to prepare it, month by month.

Frequently asked questions

Do the totals calculate themselves?

Yes. The totals, the result for the month, the closing balance and the cross-check difference are formulas. You only fill in the amount on each line.

Does it work in Google Sheets?

It does. Upload the file to Google Drive and open it with Google Sheets. The formulas keep working.

Can I change the categories?

Yes. Change the text on the line and, if you need more lines, insert them in the middle of the group: the total follows.