Church Treasurer Tracker

Every fund accounted for, every dollar tied to the bank — that is the whole job of a church treasurer, and the part that goes wrong quietly. The building fund looks healthy until someone asks what the bank actually holds. A benevolence fund spends money it doesn't have. A generous gift sits in the account for a year because nobody wrote down which fund it belonged to. This tracker is built around the one monthly check that catches all of it. You enter each gift once on the Giving Log, and everything else reads from that log: the Designated Funds Ledger (opening balance, gifts in, spending out, current balance, per fund), Budget vs. Actual by ministry with over-budget flags, and the Bank Reconciliation & Fund Tie-Out Check, which adjusts the statement balance for outstanding checks and deposits in transit and ties bank, books and funds together to the cent.

The sample data is a fictional church, Grace Community Church — 56 gifts, 14 households and 5 funds, with $31,430 given and $28,495 held across the funds. The October statement reconciles to a $0.00 difference and the tie-out balances — while the sheet still flags $1,098.50 sitting in the bank assigned to no fund, and a Benevolence Fund at −$215 after spending $3,465 against $3,250 available. Both failures surface on the dashboard instead of at the annual meeting. This is an organization and record-keeping tool, not tax, legal or accounting advice; check with your CPA or denomination about what your giving statements must say.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished spreadsheet file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.