Setting up a church attendance tracking spreadsheet
Tab 1: service headcount
One row per service, filled in by a steward or welcome team member who counts during the service.
| Date | Service | Adults | Children | Visitors (first time) | Online | Total in person |
|---|---|---|---|---|---|---|
| Sun 6 | Morning | 84 | 21 | 3 | 17 | 105 |
| Sun 6 | Evening | 26 | 0 | 1 | 9 | 26 |
| Sun 13 | Morning | 79 | 18 | 0 | 15 | 97 |
Total in person = adults + children. Keep online viewers in their own column rather than adding them in, because an online count (views, devices, or people watching together) is measured differently from heads in seats. Visitors are already part of the adults or children count; the column just notes how many were new.
Tab 2: named register for each group
One tab per group, laid out like a school register: names down the side, meeting dates across the top, a mark in each cell (P present, A absent, E away and told us, X meeting cancelled).
| Name | Sun 6 | Sun 13 | Sun 20 | Sun 27 | This month |
|---|---|---|---|---|---|
| Grace | P | P | E | P | 3 of 3 |
| Isaac | P | A | A | A | 1 of 4 |
| Leah | P | P | P | P | 4 of 4 |
Here Isaac's three weeks in a row is the line that matters. The group total would barely move; the named register makes it visible.
Herebook keeps a named register for each group, such as Sunday school or a home group, with one tap per person and a monthly rate for each member. Get it on Google Play
What to count, and how
- Count at the same moment every week, for example after the first song or during the notices. People arrive late and leave early, so the time you count changes the number.
- Count everyone in the room, including the band, stewards and those serving in children's work, or decide to leave them out. Either works; switching between the two does not.
- Keep children's groups separate if they leave the service partway through, so they are not counted twice.
- Record special services on their own row and mark them, so a large Christmas or Easter service does not distort monthly averages.
- Write down cancelled meetings rather than leaving a blank. A blank week looks like nobody came.
Church attendance tracker vs membership list
A membership spreadsheet (names, contact details, roles, baptism or membership dates) is a different record from attendance. Mixing the two in one sheet makes both harder to use and puts more personal information in one place.
| Record | Holds | Who needs it |
|---|---|---|
| Service headcount | Numbers only, no names | Leadership, anyone reporting to a wider denomination |
| Group register | First names and marks for one group | The group leader |
| Membership list | Contact details and roles | The church office, under your data protection policy |
Some denominations collect attendance figures from their churches each year and publish guidance on how to count. If yours does, follow its definitions so your figures can be compared with other churches. Ask your diocese, district or regional office whether it provides a form or spreadsheet.
Keeping the habit going
- Give the headcount to one named person each week, with a backup on a rota.
- Fill in group registers during the meeting, not from memory on Monday.
- Copy the register tab for each new term so old terms are kept and the current one stays short.
- When someone moves away or leaves the group, move them to a "left" section instead of deleting the row, so past records still add up.
- Back up the file somewhere other than one person's laptop.
Using the numbers with care
A twelve-week rolling average shows a trend better than comparing one Sunday with the next. Weather, school holidays and illness move single weeks a lot.
Named registers are most useful as a prompt for pastoral care. Two or three missed weeks in a row from someone who usually comes is a reason for a friendly message, not a mark against them. Keep that purpose in mind when deciding who sees the registers.
A register for each group, on the leader's phone
With Herebook a group leader pastes in the names, sets the meeting day so the group shows up under "Today", and marks who came. There is no account to set up, and the rosters stay on the phone.
Get it on Google PlayiPhone version coming soon
More guides
- Attendance Percentage Calculator: Formula, Examples and ExcelHow to calculate attendance percentage: sessions attended ÷ sessions held × 100. Worked examples, how to treat late and excused, cancelled sessions, and Excel formulas.
- Attendance Sheet Template: Layout, Codes and a Printable VersionHow to set up an attendance sheet template for a class, club or team: columns to include, attendance codes, a month layout to print or use in Excel, and common mistakes.
- Excused vs Unexcused Absences: What Counts and How to Record ThemThe difference between excused and unexcused absences, who decides, how late fits in, and how to record each one fairly in a class, club or team register.
- Sports Team Attendance Tracker: How Coaches Keep Training RecordsHow to track attendance for a sports team or club: what to record at training and matches, a simple sheet, injured and excused players, and attendance in selection.
Published by Zoranta, the developer of Herebook.