Church membership database: what to record and how to keep it up to date
A church membership database is the organised list of the church's people, with each person's contact details, family and journey in the congregation. Kept well, it helps the church office follow who arrives, who has drifted away and who needs a visit. This guide shows what to record, how to set it up and how to keep it current, year after year.
What to record for each person
Start with the essentials. Every extra field is more data to keep and protect.
- Full name and, if they prefer, the name they go by.
- Phone and e-mail, so the church can reach them.
- Address and town, if the church organises visits or home groups by area.
- Date of birth, to remember birthdays.
- Status at church: member, regular attender, visitor or inactive.
- When they joined and how: transfer from another church, baptism or acclamation.
- Date and church of baptism, which go on a transfer letter.
- Family: spouse and children, linked to each other.
- When and how the person agreed to the church keeping this data.
Members, regular attenders and visitors in one list
Separate people by status, not into different lists. That way the same record follows a person from their first visit to baptism, without copying anything from one place to another.
- Member: received by the church, as its constitution sets out.
- Regular attender: comes often but isn't a member yet.
- Visitor: came to a service and left their details.
- Inactive: moved to another church or drifted away. They leave the day-to-day lists, but their history stays.
How to set up the database from scratch
- Gather what already exists: paper cards, spreadsheets, group chat lists.
- Choose one official list and tell the leadership which it is.
- Agree the fields before you start, so everyone fills them in the same way.
- Ask each person to check their own details and agree to the record, on a signed form or by message.
- Decide who can edit the database. Usually the church office and the pastor.
How to keep it up to date
- Add visitors in the same week they came, with phone and town.
- Update the status after each baptism, reception or transfer.
- Once a year, ask members to check their own details.
- Anyone who has left becomes inactive. If they ask for their data to be erased, erase it.
- Look for duplicate records, with the same name or phone number, and merge them into one.
What changes for a church in Europe
In Europe, being on a church's register reveals a person's faith, and the GDPR treats that data with special care. Our guide to GDPR for churches explains the rules. In the church office, it comes down to four habits:
- Ask only for what the church will use. An ID number, for example, is rarely needed.
- Record when and how each person agreed. For children, the parent or guardian agrees.
- The treasurer doesn't need to open the whole register.
- Keep the postcode and the country: many families move town, and sometimes country.
How Atrium helps
In Atrium, each person's record has a photo, status, family links on both records, the dates of arrival and baptism, and any fields the church creates. Standard fields the church doesn't use can be switched off. Consent is recorded with the date and how it was given, search finds a name even without its accents, and the register exports to CSV. The treasurer doesn't open the register, and copying or erasing a person's data takes a few clicks.
Frequently asked questions
What details can a church ask for in its membership database?
The ones it will really use to care for people and follow its constitution: name, contact details, family and the dates of their life in the church. Ask for anything else only with a clear reason, and explain that reason to the person.
Should visitors go in the database too?
They can, with their permission. Record their details with the visitor status and, when the time comes, change them to regular attender or member on the same record.
What should we do with the record of someone who has left?
Change their status to inactive and keep it only as long as the church needs. If they ask for erasure, erase it, keeping only what the law requires.