Report this item to Etsy

Church Bookkeeping Spreadsheet, Tithe and Offering Tracker, Giving Statements, Church Treasurer Report

Price:$11.99

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 4 Files

Instant digital download: church bookkeeping spreadsheet. You get 2 .xlsx files (blank and filled-in example), a printable PDF and a quick start guide. Nothing physical ships.

A church bookkeeping spreadsheet for small church treasurers. Type each offering once, with the date, giver, fund and amount, and the same row feeds the giver's total for the year, the fund report and a year-end giving statement you can print for each giver.

WHAT YOU GET
- Church-Giving-Bookkeeping_Blank.xlsx: empty, ready for your own records
- Church-Giving-Bookkeeping_Example.xlsx: the same workbook filled in with a sample year (18 givers, 5 funds, about 500 gifts)
- Church-Giving-Bookkeeping_Printable.pdf: 2 pages on US Letter paper, an offering log and an expense log to fill in by hand
- README.txt: quick start

HOW IT WORKS
1. Setup: type your church name, the year and up to 10 funds (General, Building, Missions and so on) with a yearly budget for each.
2. Givers: one row per giver or family, with an envelope number if you use them. Each row shows what they gave this year, how many gifts and the date of the last one.
3. Offerings: one row per gift. Pick the giver and fund from lists, then the method (cash, check, card or online), check number and amount.
4. Expenses: one row per bill or payment, with the fund it came from.
5. Fund Report: budget, given, spent and what is left in each fund, the percent of budget given, and a month-by-month table. A fund that spent more than it took in turns red.
6. Statement: pick a giver. It shows your church name, the year, the total, a total by fund and each gift in date order, with your own note and a signature line. Print it or save it as a PDF.

WHAT MAKES IT DIFFERENT
- No retyping at year end. The statements come straight from the offering log.
- The year on the Setup tab decides which gifts count, so late December gifts from last year can stay in the list.
- Use the "Loose offering" giver for cash in the plate with no name, so the fund totals still add up.

THE FILES
7 tabs: Start Here, Setup, Givers, Offerings, Expenses, Fund Report, Statement. Up to 150 givers, 1,000 gifts, 400 expenses and 10 funds. A statement lists up to 60 gifts per giver (the totals include every gift). Cream cells are for typing and white cells calculate. Formula cells are protected with no password, so you can unprotect them in Excel with Review > Unprotect Sheet. No macros. The sample names are made up.

THE PRINTABLE PDF
Two pages, US Letter: a blank offering log (date, giver, fund, method, check number, amount) and a blank expense log for counting on Sunday.

WORKS IN: Microsoft Excel 2016 or newer, and Google Sheets (File > Import > Upload > Replace spreadsheet; layout may look slightly different). Apple Numbers: not tested. The tabs are laid out narrow for phone screens, but it has not been tested on a real iPhone or Android phone, so a computer is easiest for setup and printing.

THIS IS NOT tax advice or a full accounting program. It does not connect to a bank, run payroll or take online gifts. The statement note is yours to write. Ask a tax pro what your statements must say.

PHOTOS: the listing photos are screenshots of the actual files and the actual PDF. They are not mockups.

INSTANT DOWNLOAD. Nothing physical ships. For use by your own church or ministry. Please do not share or resell the files.

Designed with the help of AI tools, then reviewed and tested by me.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

View shop registration details

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Church Report

Church Dashboard

Church Tithe Tracker

Tithe Tracker

Church Donation Tracker

Church Treasurer Template

Listed on Oct 30, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Planner Templates