Excel workbook
Church Contribution Statement Maker: Gift Log and Year-End Donor Statements in Excel
Log the offering all year, then print every donor's statement in January.
$25 one time · example and blank copies · download link by email
Who it is for
Volunteer treasurers and financial secretaries at churches and small faith communities.
Why it is different
- Includes the acknowledgment wording from IRS Publication 1771.
- Property gifts are described, not valued, as the IRS expects.
- No software or subscription; works in Excel.
What is inside
- Settings. Church name, address, year and signer.
- Donors. Each donor with an ID and mailing address.
- Gifts. One row per gift: date, donor, amount, type, fund.
- Statement. Type a donor ID and print their year-end statement.
- Year Totals. Every donor's cash total and number of gifts at a glance.
Get it
Church Contribution Statement Maker
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. Not tax advice. Ask your accountant about quid pro quo gifts over $75, non-cash gifts and special cases. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Also from MCC Solutions
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19
Sales-Channel Profit Tracker
Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month.
$24