ZorantaGuides
Herebook

Herebook › Guides

Church Attendance Tracking: Spreadsheet Layout and What to Count

Church attendance tracking usually needs two separate records: a headcount for each service, and a named register for smaller groups such as Sunday school, youth group, choir or a midweek study. A headcount tells you how many came. A named register tells you who has stopped coming.

A spreadsheet with one tab per record is enough to start. Below is a layout for each, what to count, and how to keep it going week after week.

A community hall with a circle of chairs and members arriving through the doorway

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.

DateServiceAdultsChildrenVisitors (first time)OnlineTotal in person
Sun 6Morning8421317105
Sun 6Evening2601926
Sun 13Morning791801597

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).

NameSun 6Sun 13Sun 20Sun 27This month
GracePPEP3 of 3
IsaacPAAA1 of 4
LeahPPPP4 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

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

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.

RecordHoldsWho needs it
Service headcountNumbers only, no namesLeadership, anyone reporting to a wider denomination
Group registerFirst names and marks for one groupThe group leader
Membership listContact details and rolesThe 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.

Attendance registers, especially for children and young people, are personal data. Keep only what you need, limit who can see it, and follow your church's data protection and safeguarding policies.

Keeping the habit going

  1. Give the headcount to one named person each week, with a backup on a rota.
  2. Fill in group registers during the meeting, not from memory on Monday.
  3. Copy the register tab for each new term so old terms are kept and the current one stays short.
  4. 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.
  5. 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.

Herebook

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 Play

iPhone version coming soon

More guides

All guides

Published by Zoranta, the developer of Herebook.