Most small-church financial reports fail for the same reason: they are rebuilt from scratch every month. The treasurer opens a blank sheet, tries to remember what the board asked about last time, and produces something that looks a little different from January to February to March. By June, nobody can tell whether giving is actually down or the report just changed shape again.
The fix is not more detail. It is a fixed layout — the same five sections, in the same order, every month, whether the news is good or not. Build it once in a spreadsheet and the monthly job becomes filling in numbers, not designing a report. Here is a layout that works for a church of 60 to 250 people, and how to build it so it survives a change of treasurer.
Why the shape matters more than the software
A financial report is read by people who are not accountants and do not want to be. A board member who volunteers to oversee finances alongside a day job needs to glance at a page and know, in under a minute, whether the church is on track. That only works if the page looks the same every month. Consistency is what lets someone compare April to last April without doing math in their head first.
It also protects the next treasurer. Volunteer treasurers turn over — someone’s term ends, a job changes, a family moves. A fixed template is the thing that survives that handoff. The new treasurer inherits a shape to fill in, not a blank page and a vague memory of what the last person used to do.
Section one: the one-line summary
At the very top, before any tables, put three numbers: total income this month, total expenses this month, and the ending balance. That is it. A board member who reads nothing else should still walk away knowing the three facts that matter most. Put the prior month’s ending balance next to it so the change is visible without a calculator — a church that ended March at $18,400 and April at $17,100 has a different conversation ahead of it than one that ended April at $19,900.
Section two: income by category
Break income into a handful of categories that match how your church actually receives money: general giving, designated giving, a building fund if you have one, and anything else that recurs, like facility rental income. Five to eight categories is usually enough. More than that and the report stops being readable at a glance, and a board that wants more detail can always ask for the backup.
If your church tracks giving by household or individual, that detail belongs in a separate, restricted record, not on the report the whole board sees. The monthly report needs totals, not names. Our guide on tracking giving in a way that respects the giver goes into how to keep that boundary in place while still producing the summary the board needs.
Section three: expenses by category
Mirror the income section’s structure on the expense side: payroll, facilities, ministry programs, missions or benevolence, and administration is a common starting set for a congregation this size. Keep the categories stable year over year even if a line item is small some months — a $0 line in a quiet month is more useful than a category that disappears and reappears depending on what happened.
Resist the urge to bury an uncomfortable expense inside a vague “miscellaneous” line. If a category is genuinely unusual — a roof repair, a one-time legal fee — give it its own line for that month and note it, rather than folding it into a bucket that quietly grows.
Section four: budget versus actual
Next to each category, add two more columns: the annual budget for that line, divided by twelve for a monthly target, and the running year-to-date total against that target. This is the section that turns a list of numbers into a decision-making tool. A ministry line that is running 40 percent over its year-to-date budget by month five is a conversation worth having in month five, not a surprise discovered in month eleven.
If your board sets a giving goal for the year, this is also where it belongs: giving to date against the annual goal, so the board can see early whether the year is on pace before it is too late to adjust.
Section five: a short plain-language note
Below the tables, add three or four sentences in plain English: what changed this month, why, and whether it needs board attention. “April expenses were higher than usual because of a $1,200 furnace repair; giving was in line with the prior three months” tells a board member more in one sentence than a page of numbers alone. This is the section people actually remember afterward.
SundayBridge’s giving trends and pivot-table reports can supply the totals that feed sections two through four, so a treasurer is copying numbers into the template rather than re-deriving them from a bank statement each month.
Building it so it survives a change of treasurer
Put the whole template on one spreadsheet tab, print-formatted to a single page. Lock the category labels and formulas so a future treasurer can only type into the number cells, not accidentally rename a line or delete a formula. Keep one file per fiscal year with a tab per month, in the same order, so scrolling sideways shows the whole year at a glance. Save a copy the moment each month closes, before any further edits, so there is always an unaltered record of what the board actually saw.
Finally, write down, in one sentence at the top of the file, who is allowed to change the template itself. The numbers should change every month. The shape should not, except by a decision the board actually made.
What this looks like over a year
The payoff of a fixed template does not show up in month one. It shows up in month eight, when a new board member asks how giving this year compares to last year at the same point, and the treasurer can pull up twelve identical one-pagers and answer in thirty seconds. It shows up again at year-end, when the annual summary is really just the twelve monthly reports added together, because they were built the same way all along. Our guide on reading giving trends without over-reacting to a single month is a useful companion once you have a few months of consistent reports to compare.
None of this requires new software or a finance background. It requires picking a shape, writing it down, and refusing to redesign it every time a month looks a little different from the last one. That discipline, more than any particular category list, is what makes a monthly financial report something a board actually trusts.