Church Financial Report Template
Free Excel workbook for church treasurers: a monthly treasurer's report, fund balances, an income and expense statement and an annual summary, plus a printable offering count sheet and deposit log.
By MosesTab Editorial Team · Published
About This Template
A working church financial report spreadsheet for the person who keeps the books. You type each deposit, check and payment once on the Transactions tab, with the fund and category it belongs to. The workbook does the rest: a one-page Treasurer's Report for each board or finance committee meeting, each fund's balance at the end of every month, a month-by-month income and expense statement, and an Annual Summary for your January meeting that compares the year with last year and with budget. It ships with one invented example year so you can see every report working, and an orange banner on each report until you clear the example rows. Two printable PDFs, an offering count sheet and a deposit log, cover the counting room.
What's Included
Printable Forms
Free to print, with no email required.
Offering Count Sheet
One page per count: bills and coins by denomination, a list of checks with the fund each giver chose, totals by fund, and lines for two counters to sign.
Download PDF · 15 KBOffering Deposit Log
One line per deposit for the month: cash, checks, total, who counted, who took it to the bank, and a column to tick when it appears on the bank statement.
Download PDF · 9 KBPerfect For
How to Use
What each tab in the church financial report template is for
- Setup
- The one place you describe your church: the first day of your financial year, the month you're reporting on, your funds (each marked unrestricted, board-designated or restricted, with its balance on the first day of the year) and your income and expense categories. Budget and last year's actual are optional, but the reports compare against them when you fill them in.
- Transactions
- Every deposit, check and payment goes here, once. Pick a fund and a category from the dropdowns and type the amount under Money in or Money out. Gray columns work out the month of the financial year and the type of each line, so you never type a total by hand.
- Treasurer's Report
- The monthly report for your board or finance committee, on one printable page: cash at the start and end of the month, income and expenses for the month and year to date against budget, each fund's balance, a bank reconciliation, data checks and sign-off lines.
- Fund Balances
- Each fund's balance at the end of every month so far, with subtotals by fund type. It's the tab to look at when someone asks how much is left in the missions fund.
- Income & Expense
- A church income and expense statement: every category across the twelve months, the year-to-date total and each line's share of the total, plus income, spending and surplus split by fund type.
- Annual Summary
- The year on one page for your annual meeting: total income, total expenses and the surplus or deficit against last year and against budget, every category, and each fund's start and end of year, with space for notes to the congregation.
How a treasurer uses it each month
- 1After each count, enter the deposit from the offering count sheet, split by fund. Record it on the deposit log too.
- 2As bills are paid, enter each check or payment with its fund and category, using the check number as the reference.
- 3When the month's bank statement arrives, change the report month on Setup and fill in the bank reconciliation: the statement balance, deposits not yet on it and checks not yet cleared. The difference should be zero.
- 4Check the data checks at the bottom of the Treasurer's Report. Each should read 0: a non-zero line points to a date outside the year, an unknown fund or category, or a transfer that doesn't balance.
- 5Add a few plain-language notes for the board, such as a large repair or a fund that's running low, then print or share the Treasurer's Report and sign it.
Preparing the annual summary for your January meeting
Once December's bank statement is reconciled, set the report month to 12. The Annual Summary drops its draft warning and shows the whole year: what came in and went out, how that compares with last year and with the budget the church approved, and where each fund started and ended.
Use the notes box to explain the two or three things members will ask about, such as a one-off repair paid from the building fund or money the board set aside. Keep the Treasurer's Reports for each month with it, in case anyone wants the detail.
After the meeting, save a copy of the file for the year. Start the new year with a fresh copy and enter each fund's closing balance from the Annual Summary as its opening balance on Setup.
Fund accounting basics: restricted and unrestricted funds
Most of what a church receives can be used for any part of its mission. That's unrestricted money, usually kept in a general fund. When a giver says what a gift is for, such as missions, the building or helping families in need, that gift is restricted: it should only be spent on that purpose, and it stays in its own fund until it is.
Sometimes the board or the church decides to set unrestricted money aside, for example a reserve for future repairs. That's board-designated. It's tracked like a separate fund, but it is still unrestricted because the board can change its mind. A donor's restriction can't be lifted that way.
Two habits keep this straight. Record the fund the giver chose on the count sheet, next to each check or envelope. And watch the Fund Balances tab: a restricted fund below zero usually means its money was spent on something else.
These are plain-language descriptions, not accounting rules. Terms and requirements vary by country and by how your church is organized, so ask your accountant or denomination how your funds should be classified.
The printable offering count sheet and deposit log
The offering count sheet is one page per count: bills and coins by denomination (US currency), each check with the fund the giver chose, totals by fund, and lines for two counters to sign. Many churches have two people who aren't related count together and both sign. The deposit log keeps one line per deposit for the month, so the treasurer can tick each one off against the bank statement.
For a week-by-week record of tithes and offerings by fund, use the tithe and offering tracking spreadsheet. For staff and volunteer reimbursements, use the ministry expense report. To plan next year's numbers, start with the church budget template.
Related Templates
You might also find these templates useful.
Church Budget Template
Free Excel workbook to plan your church budget by fund, track budget vs. actual every month, and give your board a one-page summary.
Tithe & Offering Tracking Spreadsheet
Excel spreadsheet to record weekly tithes and offerings by fund, with automatic monthly and annual totals.
Ministry Expense Report
Track and reimburse ministry expenses with this simple form.
FAQ
FAQs: Church Financial Report Template
Common questions about the Church Financial Report Template
Yes. The Excel workbook and both PDFs download directly, with no email or signup. They're fully editable and yours to keep.
Yes, by importing it. In Google Sheets, choose File → Import, upload the .xlsx and pick “Replace spreadsheet”. The formulas only use functions Google Sheets also has, such as SUMIFS, COUNTIF, INDEX, MATCH and EDATE. There isn't a separate Google Sheets copy link. After importing, check that the cash total on the Treasurer's Report matches the Fund Balances total.
At a minimum: cash at the start and end of the month, what came in and went out, income and expenses against budget for the month and year to date, the balance of each fund, and a note that the books agree with the bank statement. The Treasurer's Report tab has all of these, plus data checks and lines for the treasurer and a reviewer to sign. Your church's bylaws or denomination may ask for more.
Add two rows on the Transactions tab with the category “Transfer between funds”: money out of the fund it leaves and money in to the fund it joins, for the same amount. Transfers change fund balances but aren't counted as income or spending, and the Treasurer's Report flags any transfer that doesn't net to zero.
No. The example year is invented for a made-up church so you can see the reports working. Every example transaction starts with “[Example]”, and every report shows an orange banner until those rows are deleted. The example opening balances, budgets and last-year figures on Setup are invented too: replace them with your own.
No. It's a reporting tool for keeping clear records and presenting them. It isn't accounting, tax or legal advice, and its reports aren't audited financial statements. Ask your accountant or denomination how your funds should be classified and what your annual report needs to show.
Keep your member records in MosesTab
This workbook covers the church's books. MosesTab keeps your members, attendance, events, groups and volunteers in one place, and in the dashboard you can record cash and check gifts and produce year-end giving statements. The Free plan includes unlimited members.