A small church runs on the same operating disciplines as any small office, and usually on one or two volunteers who were never given a system. Attendance is in a notebook, giving is in a spreadsheet somebody started in 2019, the rota lives in a group text, and the person who knows how the pieces fit is the person who is about to move away. This document is the operating handbook for that office.
WHAT THIS COVERS
Fourteen linked record structures, each with its column list, its option values and its saved views: families, members, services and events, sermons and media, attendance, the giving ledger, volunteer rotas, pastoral care and prayer, connection and follow-up, operations checklists, the Sunday run sheet, the year plan, small groups and ministries, and the pastoral touch log.
Forty-three recurring duties from daily to annual, each one naming the evidence it should leave behind, so the person doing the task also knows what done looks like. Twenty-one timed service-day steps across six sections, and eighteen planning milestones with the lead time that makes each one usable rather than aspirational.
WHAT YOU RECEIVE
The primary document is a 97-slide PowerPoint training guide in the headline-body-bumper style: a headline per slide, the supporting detail in the body, and a one-line takeaway you can act on.
A supplemental ZIP is included with the purchase and holds the working parts:
• An Excel workbook with one tab per record structure, live formulas, dropdown validation on every choice column, a Start Here sheet that maps each saved view to the Excel steps that replace it, and a dashboard that totals giving by fund and reads rota and care gaps straight off the tabs.
• Fourteen CSV files with the same columns and the same records, importable into any tool.
• Five printable forms as PDFs: connection card, member information form, contribution statement letter, room booking request, and child pick-up authorization.
• A print-ready PDF copy of the handbook, a two-page quick-start, and the license terms.
WHAT THE INTERNAL-CONTROL SECTION GIVES YOU
The giving material is written around the controls that cost nothing and protect volunteers: two unrelated people count and both initial the sheet, a different person records the count, someone independent reconciles it to the bank deposit, designated gifts stay in the fund they were given for, and cash is deposited the same day or the next business day. The year-end statement walkthrough shows how to produce statements from the ledger without re-deriving anything in December.
WHO IT IS FOR
Office administrators, church secretaries, treasurers, volunteer coordinators, and pastors who run a congregation of roughly five to two hundred people. No software purchase is required and nothing here assumes you use any particular platform.
BOUNDARIES, STATED PLAINLY
This is an administrative record-keeping aid. It is not accounting software or a general ledger, and nothing in it reconciles to a bank by itself. It is not tax advice or a determination of deductibility; a contribution statement records what was received. It is not legal advice, a compliance guarantee, or a substitute for a child-protection policy. It is not a clinical or counseling record system. People, amounts and dates in the sample records are illustrative sample data created for demonstration. Where a number or a legal point matters, verify it with your own accountant, attorney or denomination.
HOW TO USE IT
Ten minutes to make it yours: replace the households first, because every giving and member record points at them, then set your own funds, enter the rota for the next four Sundays, and write down who may see the care and money records before you invite the next volunteer.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Records Management, Nonprofit PowerPoint Slides: Church Operations Handbook and Records Toolkit PowerPoint (PPTX) Presentation Slide Deck, WebsiteGeek