Your Cart
Loading

Church Giving Statement Template, Year End Contribution Statement Spreadsheet, Bilingual Donation Receipt, Offering Count Sheet

On Sale
$18.00
$18.00
Added to cart

Year-end statements without a week of January evenings. This kit gives small-church treasurers one spreadsheet for the whole year: log every gift, count the offering with two counters, and print a clean one-page contribution statement for each household in a few clicks.


MADE FOR SMALL AND BILINGUAL CHURCHES

Choose a statement language for each household. The English statement always prints, and an optional second-language block prints under it. It's set up for Marshallese and Tagalog plus one more language you can rename, and you type the translation your church trusts.


WHAT'S INSIDE

- Gifts log (2,000 rows): date, household, fund, amount, method, check number. Noncash items are logged with a description only (no value), and gifts where goods or services were given in return get a good-faith estimate. Red cells catch missing details.

- Households (200): name as printed, address, language, statement-sent date, and automatic totals.

- One-page statement: pick a household and it fills itself, with gifts by month and by fund, the total, noncash gifts, goods or services provided, and acknowledgment wording that switches automatically. Print it or save it as PDF.

- Two-counter count sheet: both counters enter bill and coin counts and any mismatch says "Recount". Includes checks, total deposit and a deposit slip check. A printable blank PDF is included too.

- Treasurer dashboard: total given, households giving, who needs a written acknowledgment ($250+ single gift), disclosure flags (payments over $75 with goods given), funds, months, statements sent and a send-by countdown.

- Settings: church details, year, signer, and every line of statement wording, all editable. Thresholds are editable too.


WHAT YOU GET

- Church-Giving-Statement-Kit-BLANK.xlsx (ready for your records)

- Church-Giving-Statement-Kit-EXAMPLE.xlsx (made-up sample church so you can see it working)

- Giving-Statement-Word-Template.docx (a letter version with placeholders)

- Offering-Count-Sheet-Printable.pdf

- PDF quick-start guide (Google Sheets setup, weekly routine, January printing)


WORKS WITH

Google Sheets (free; upload and choose File > Save as Google Sheets) and Microsoft Excel. No macros, no add-ons, no subscription. Statements are printed one household at a time (pick a name, print, repeat).


PLEASE NOTE

- Digital download only. Nothing is mailed.

- Questions about the file? Message the shop where you bought it (Payhip or Etsy messages).


DISCLAIMER: Not tax advice. This is a record-keeping tool. Follow IRS Publication 1771 and your tax professional. Statement wording follows Pub 1771 as checked Oct 23, 2026 and is editable; check the current publication each year. Second-language text is only a starting point; have a fluent member confirm any translation. Screenshots show a made-up sample church.


AI DISCLOSURE: Made with AI assistance. The spreadsheet formulas, layout, guide text and listing images were created with an AI assistant under the direction of S9T Vibes (SupaMarioS9T). Listing images are mockups of the real spreadsheet with made-up sample data; no stock photos.

You will get a ZIP (324KB) file