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
- At the top of the summary, write the church's name, the month and who prepared it.
- Under Opening balance, copy last month's closing balance, with cash and bank kept separate.
- Under Income, add up the count sheets from the month's services and whatever came in by bank transfer.
- 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.
- 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.
- 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.