Skip to content

Church & ministry toolkit

Your controls pass on paper.Here is what they are actually worth.

Two adults in the nursery, two counters on the offering, a benevolence log, funds that are tracked. Every one of those satisfies an audit of the policy as written, and every one has a specific way of quietly failing anyway. Six free workbooks that check the difference.

Six workbooks. No account, no email gate, no watermark.

The workbooks

Each downloads as a branded .xlsx that keeps calculating after you open it. Start with whichever job is on fire.

The gap between a policy and a control

For each of these, the upper bar is what an audit of the policy as written would score it. The lower bar is what the control is worth once the assumption underneath it has quietly stopped holding.

Two adults in the room

On paperpasses
In practiceat risk

A married couple alone in the nursery is two names. It satisfies a head-count and removes the thing the rule exists for — that two people are present who would not cover for one another. Count distinct households, not adults.

Two counters on the offering

On paperpasses
In practiceat risk

Two unrelated counters who are not the treasurer is the written control. A reliable pair who count together every week for three years satisfies it perfectly while the assumption underneath has stopped being true. Rotation is the part nobody tracks.

A benevolence fund with a log

On paperpasses
In practiceat risk

A log of payments shows money leaving. What matters for deductibility is that the CHURCH exercised discretion — so the record needs the request, the body that considered it, the date, and the declines as well as the approvals.

Restricted funds tracked

On paperpasses
In practiceat risk

Tracked in one column called “funds”, restricted and designated money are indistinguishable. Overspending the second is a planning problem; overspending the first means general money went against a promise made to donors.

The bars encode a relationship, not a measurement. Nobody has surveyed this — the point is the gap.

These do not run in order. They run on three clocks.

None of it is new work. Most of it is a habit attached to something the church already does.

Every week

Count with two, deposit fast, write down who

The most common finding in church fraud cases is not a scheme — one person stayed behind to finish up. Two unrelated counters, neither of them the treasurer, the total recorded before the money leaves the building, and a note of who counted so rotation is visible later.

Offering Count Log
Every rota, every new volunteer

Check households, and start the clock

A room short an adult is obvious on the morning. A room staffed by two people from one household is not obvious at all. And a waiting period before serving with children only works if somebody knows when the person first attended — so record it the day they offer, not the day you need them.

Children’s Ministry Rota
Every January, and every finance meeting

Run the gifts, then look for a fund in deficit

Four giving-statement mistakes recur every January and all four are checkable in an afternoon. A restricted fund below zero is almost always an accident and is far easier to explain at the meeting where it appears than at the one where somebody else finds it.

Substantiation Checker

What churches usually pay for this

Church management platforms typically price by module and by church size. Individual modules — services and scheduling, giving, check-ins — commonly run $15 to $75 a month each, and a church of around 500 using several of them can reasonably expect $100 to $200 a month, or roughly $1,200 to $2,400 a year. Several vendors have genuinely free tiers for smaller churches, which is worth knowing before anyone signs anything.

None of which is an argument against the platforms. Check-in labels, member logins, online giving and text reminders are real things a spreadsheet cannot do, and above a certain size the alternative is worse.

It is an argument that a church of ninety people should not be paying a monthly fee to find out whether two people from the same household are on the nursery rota. That is a formula.

Pricing figures are indicative ranges gathered from published vendor pricing and software directories in September 2026. Vendors change pricing frequently — check current rates before making a decision either way.

The date these workbooks cannot keep current for you

Both rotas hold a screening date, and the honest thing to say about any of them is that a check is only true on the day it ran. A children’s worker screened in 2024 and still serving in 2026 has a two-year-old check and a cell that says so in the same confident black text as one run last week. The rota computes expiry against your own policy, but it cannot re-run the check.

These files work perfectly well if you screen elsewhere and keep the dates by hand — they are registers, and you owe us nothing. If you would rather the dates maintained themselves, VolunteerBadge screens church volunteers for $5 per adult — a national criminal search across county, state and federal records, sex-offender registries in all 50 states, and photo-ID plus biometric verification, because a name-only check clears a name rather than a person. Automatic rescreening on a schedule you set, no per-seat fee, no contract.

Questions church leaders ask

Are these free, and what is the catch?

Free, no account, no email gate, no watermark. We build background-check software, so two of the six touch something we sell — the rotas hold screening dates a screening service can keep current. The other four have nothing to do with our product. The catch, such as it is, is that we would like you to remember who gave them to you.

Is the two-adult rule the law?

In general, no. Two-adult supervision, a waiting period before serving with children, and volunteer screening are widely adopted child-safety practices and are commonly expected by church insurers and denominations — but they are not, as a rule, statute, and this toolkit does not tell you what your obligations are. Your denomination, your insurer, your state and your own policy set them. Mandatory reporting is a separate matter entirely: who must report suspected abuse, to whom and how quickly is set by state law, applies to individuals regardless of church policy, and is never satisfied by recording something in a spreadsheet.

Is the giving checker tax advice?

No, and we are not affiliated with the IRS. The thresholds in it are general federal figures included so a church knows which question to ask — the written acknowledgment a donor needs for a single gift at or above $250, and the written disclosure a church must issue for a quid pro quo gift over $75. Both are cells you can change. Whether a specific gift is deductible, and what your church must issue, should be confirmed with a CPA or attorney experienced with churches. Church tax law is genuinely specialized.

Why does the benevolence log record declines?

Because a log showing only approvals evidences money leaving, not discretion being exercised — and discretion is the whole test. For contributions to a benevolence fund to be treated as gifts to the church rather than to a person, the church must have full control over the funds and their use. Recording that requests were considered, and that some were declined or referred elsewhere, is what shows the church deciding rather than passing along a donor’s instruction.

Do these work in Google Sheets?

Yes. Upload the .xlsx to Drive and open with Sheets. Every formula used here — COUNTIF, COUNTIFS, SUMIF, MAXIFS, VLOOKUP, EDATE, DATEDIF — carries over, and there are deliberately no array formulas anywhere, precisely so nothing silently returns a different answer in a different spreadsheet. Conditional formatting usually survives; if a colour rule does not, the underlying status text still does.

Our church is tiny. Is this overkill?

The controls scale down better than they look. A church of forty people can still have two unrelated counters, still record who decided a benevolence request, and still know which of its funds are restricted. What small churches genuinely cannot do is run a rota of a hundred volunteers — so use the tabs you need and ignore the rest. Nothing here requires you to fill in everything.

We build background-check software, which is why the rotas hold screening dates and why we try to be honest about what a check does and does not catch. The money workbooks have nothing to do with our product. They exist because the same four giving-statement mistakes recur every January, because church money goes missing almost never on purpose, and because a company that wants to be useful to churches should be useful before it asks for anything.

If something here is wrong, or your church does a thing these files cannot handle, tell us at support@volunteerbadge.com. Most of what these workbooks do came from someone pointing out what the previous version got wrong.