Church Treasurer Report Template, Budget vs Actual
$12.99
Built for part-time church treasurers who need a monthly income log, expense and bill controls, a one-page treasurer report, and budget vs actual, without a monthly software fee.
Share
What's inside
- Church_Income_Log.xlsx + EXAMPLE: post gifts by fund/account; online giving clearing for processor fees
- Church_Expense_Bill_Log.xlsx + EXAMPLE: bills with approval thresholds, vendor W-9/1099 tracking, aging
- Church_Treasurer_Report.xlsx + EXAMPLE: one-page monthly report for the finance committee
- Church_Budget_vs_Actual.xlsx + EXAMPLE: annual budget, monthly actuals, variance status
- Income Log: fund codes (GEN, DES-OPR, RES-BLD…), gross/fee/net, online-giving clearing, line QA flags
- Expense and Bill Log: approver required over threshold, unpaid aging, spending by fund and account
- Treasurer Report: month + YTD vs budget, fund balances by category, control checklist for the board
- Budget vs Actual: Revenue/Expense lines, watch/attention variance thresholds, printable dashboard
- Same fund discipline as the Controls Pack: Unrestricted (General), Board-designated, Donor-restricted
- Plain-English Start Here tabs · no macros · blank + EXAMPLE for every template
- Works in Microsoft Excel and Google Sheets
Who it's for
- Part-time treasurers at churches roughly 40 to 250 in attendance who already count offerings and reconcile the bank, and need monthly posting, bills and board reporting that keep restricted and unrestricted money apart
Before you buy
Organizational tools only for small churches and ministries. Not tax, legal, or accounting advice. Not approved or endorsed by the IRS or any denomination. Does not guarantee compliance or a clean audit. Confirm with a qualified CPA or attorney how these tools apply to your church.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one church per purchase.
