Google Sheets Church Treasurer Report Template

Report to your church board on one page: pick the month and this Google Sheets and Excel workbook shows every fund, a bank Difference and budget vs actual. Print it, sign it, hand it over.

What You Get

• Three things that change your treasurer week: a one-page Monthly Report fund by fund with a bank line and Difference, Budget vs Actual against the year-to-date budget with a Watch flag, and a weekly two-person Offering Count.
• treasurer-report-church-pack_workbook_v1.xlsx: 1 workbook, 8 sheets (Start here, Monthly Report, Transactions, Designated Funds, Budget vs Actual, Offering Count, Lists, License). Fictional sample data is marked Sample. Formulas only: no macros, no scripts.
• treasurer-report-church-pack_workbook_v1_blank.xlsx: the same workbook with no sample data, for your real records.
• treasurer-report-church-pack_printables_Letter.pdf: 8 printable pages on US Letter (instructions, monthly report, fund ledger with 24 lines, budget worksheet with 20 lines, two offering count pages with two sheets each, year at a glance, license). Pages 2 to 6 are fillable.
• treasurer-report-church-pack_printables_A4.pdf: the same 8 pages on A4.
• 00_READ_ME_FIRST.pdf: 1 page with what is inside, how to open the files and where to get support.
• Inside the workbook: Transactions with 400 rows and a Row check on every line, fund class labels with subtotals, a flag when a fund goes below zero, and a Start here sheet with a 5-line Quick start.
• No tax or donor-receipt wording is included; your treasurer or accountant decides those.

How It Works

• Instant download. Open the workbook in Excel, or open Google Sheets, then File, Import, Upload this file.
• Start with the Quick start on the Start here sheet (about two minutes). Type your church name, month and funds, enter each deposit and payment once on Transactions, type the bank statement amount, and the report, fund balances and budget sheets calculate.
• Print the Monthly Report on one page, sign it and hand it to the board. Use the PDF pages when you prefer paper.

Who It Is For

Volunteer church treasurers, finance committee members and church administrators who keep the books in a spreadsheet and want a clear monthly report, fund by fund. It records and totals what you type; it does not check your figures against anything except the bank amount you type, and it does not tell you how to keep or report your records.

Requirements

Excel 2016 or later, or Google Sheets, for the workbook. The printable PDFs are fillable on screen (Adobe Reader, Chrome or Edge) or print and write by hand. Both US Letter and A4 files are included; print at actual size.

LICENSE (also spelled LICENCE)

License for one buyer: use it yourself, in your household, or for the one club, class or organization you use it for. No resale or redistribution.

Refunds

Digital files are not returnable, but if anything is wrong with your file we will fix it or refund you within three working days. If the file will not open, or the wrong size or file arrived, we refund you at once.

About

Made with the help of AI tools and designed, tested and checked by the seller.

Designed and checked by the seller: a studio led by a PhD and former university faculty member who designs systems and spreadsheets for a living.

Questions: theverastandard@gmail.com