Free Church Tithe and Offering Spreadsheet (Excel)
What a church tithe and offering spreadsheet should track
Every gift needs to be tied to who gave it, when, how much, and which fund it belongs to — general tithe, offering, building fund, missions, benevolence, or another designated fund. Recording those four things on every row is what makes year-end giving statements and fund reporting possible later.
This is a donation log, not a budget. It answers 'who gave what, and how much has each person given this year,' which is a different question from 'how much did we spend on missions versus facilities' — that's what the sample-church-budget-template-excel page covers.
How the giving log and year-to-date rollup calculate
The Giving Log has 300 rows, one per gift, with date, giver name, an envelope number, fund, amount, and payment method. A Giver YTD column runs a SUMIFS on every row, adding up everything that giver has given so far in the log — so the running total updates automatically as new gifts come in, with no manual re-adding.
The summary block totals giving by fund — tithes, offerings, building fund, missions, benevolence — plus a grand total, giving your treasurer or finance team the fund-level numbers for a monthly report without a separate calculation.
Producing a year-end giving statement, honestly
This spreadsheet does not generate printable giving-statement documents automatically — it's a log with a running YTD total, and that's the honest way to describe it. To produce a year-end statement for a specific donor, filter the Giving Log by that giver's name and read off their Giver YTD total from the last row of their entries for the year.
That's a manual filter-and-read step, not a one-click export, but it means every number on the statement traces directly back to a row in the log, which is exactly what you want when a giver asks about their record.
Church tithe log vs a full church budget
This page tracks individual donations coming in. It doesn't allocate a budget, compare planned versus actual spending, or track ministry expense categories — that's a separate workflow covered by the sample-church-budget-template-excel page. Most churches end up using both: this log for giving records, the budget template for planning and spending.
Keeping them as two separate files also keeps each one simpler — the giving log stays focused on donor-level detail, and the budget stays focused on income-versus-expense planning, without either file trying to do both jobs.
How to use it
- Log each gift as it comes in: date, giver name, envelope number, fund, amount, and method.
- Watch the Giver YTD column update automatically with each giver's running total for the year.
- Check the summary block for fund totals and the overall total giving figure.
- For a year-end statement, filter the log by giver name and read their final Giver YTD total.
Download the free Free Church Tithe and Offering Spreadsheet (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the totals keep working.
Is this spreadsheet really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Does this generate printable giving statements automatically?
No. It logs gifts and tracks a running year-to-date total per giver. To produce a statement, filter the log by giver name and use the Giver YTD figure — there's no automatic PDF or letter generation.
How is this different from the church budget template?
This spreadsheet is a donation log tracking what individual givers contribute. The sample-church-budget-template-excel page is a separate file for planning and tracking income versus expenses across ministry categories. They're built to be used together, not merged into one file.
Can it handle more than one fund?
Yes. The Fund column has six built-in options (Tithe, Offering, Building fund, Missions, Benevolence, Other designated) and the summary totals each one separately.
What's the usage license?
Personal or single-church use. It's not meant to be resold or redistributed as a template product.