Spreadsheet

Church Contribution Substantiation Checker

Runs every gift against the thresholds a church actually meets: the written acknowledgment a donor needs for a single gift at or above $250, the written disclosure the church must issue for a quid pro quo gift over $75, gifts earmarked for a named individual (generally not deductible), and non-cash gifts where the church must describe the item and must NOT state its value. Thresholds are cells you can change, and the settings tab explains the intangible-religious-benefit wording that is specific to churches.

Per-gift review against acknowledgment and disclosure thresholds
Earmarked and non-cash gifts flagged
Per-donor outstanding acknowledgments

Church name (optional)

Tax year (optional)

Written acknowledgment threshold ($)

Per SINGLE gift, not per year. Leave blank for 250.

Quid pro quo disclosure threshold ($)

Leave blank for 75.

Include sample rows to show the format

Download your workbook

NOT tax advice, and we are not affiliated with the IRS. The thresholds are general federal figures included so you know which question to ask — confirm anything that matters with a CPA or attorney experienced with churches.

Keep going

Related free tools

Spreadsheet

Church Benevolence Request & Decision Log

Built around who decided, because that is the whole test.

Open tool

Spreadsheet

Church Designated & Restricted Fund Tracker

Restricted and designated are not the same word.

Open tool

Spreadsheet

Church Offering Count & Counter Rotation Log

Two counters is the control. The same two counters is not.

Open tool

Stop screening volunteers the hard way

These free tools are built by VolunteerBadge — full national criminal background checks for just $5, with FCRA compliance built in. No monthly fees.

Create Free Account