Church CRM

Keep your congregation, giving, small groups and events connected, so pastors and coordinators see each member’s involvement at a glance.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

CRM

Tables

Members, Contributions, Events, Communities

Fields

37

Views

grid, kanban, form, dashboard, calendar

Tables, columns and sample rows

The 4 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Members

14 fields · 6 sample rows

  • Directory (Grid)
  • Pipeline (Kanban)
  • Connect card (Form)
MemberTextEmailEmailPhonePhoneAddressAddressStatusSingle selectJoinedDateBirthdayDateMinistriesMultiple selectCommunitiesLink to another tableContributionsLink to another tableTotal givenRollupLast giftRollupYears with usFormulaPastoral notesLong text
Thomas Mathew[email protected]+91 98470 1122314 Church Road, Kochi, Kerala, IndiaMember18 Mar 20122 Jul 1978Ushering, PrayerOutreach Team, Ernakulam Home GroupR-1041, R-1044₹33,00012 Nov 202614
Grace Fernandes[email protected]+91 98200 334457 Hill View, Mumbai, Maharashtra, IndiaMember9 Sep 201824 Dec 1991Worship team, Sunday schoolWorship & MusicR-1042₹6,5005 Nov 20268
Daniel Brooks[email protected]+1 415 555 0142Regular attendee14 Jan 2024Media & techYouth FellowshipR-1045₹1,50019 Nov 20262
Priya Joseph[email protected]+91 99620 55667Visitor29 Oct 2026Youth Fellowship₹00
Samuel Okafor[email protected]+234 803 555 0199Member31 May 2015Outreach, Worship teamWorship & Music, Outreach TeamR-1043₹5,00012 Nov 202611
Ruth Abraham[email protected]Inactive1 Nov 2009₹017Moved to Chennai; keep in touch.
Field details
Member · Text
Email · Email
Phone · Phone
Address · Address
Status · Single select
Visitor, Regular attendee, Member, Inactive
Joined · Date
Birthday · Date
Ministries · Multiple select
Worship team, Sunday school, Ushering, Outreach, Prayer, Media & tech
Communities · Link to another table
Links to Communities
Contributions · Link to another table
Links to Contributions
Total given · Rollup
sum of Amount via Contributions
Last gift · Rollup
latest of Date via Contributions
Years with us · Formula
IF({Joined}, DATETIME_DIFF(TODAY(), {Joined}, 'years'), BLANK())
Pastoral notes · Long text

Form view “Connect card” asks for: Member, Email, Phone, Address, Birthday, Ministries, Pastoral notes.

Contributions

7 fields · 5 sample rows

  • Giving (Grid)
  • Giving report (Dashboard)
ReferenceTextMemberLink to another tableFundSingle selectAmountCurrencyDateDateMethodSingle selectReceipt sentCheckbox
R-1041Thomas MathewTithe₹8,0005 Nov 2026UPIYes
R-1042Grace FernandesTithe₹6,5005 Nov 2026Bank transferYes
R-1043Samuel OkaforMissions₹5,00012 Nov 2026Online
R-1044Thomas MathewBuilding fund₹25,00012 Nov 2026Cheque
R-1045Daniel BrooksOffering₹1,50019 Nov 2026Cash
Field details
Reference · Text
Member · Link to another table
Links to Members
Fund · Single select
Tithe, Offering, Building fund, Missions, Benevolence
Amount · Currency
INR
Date · Date
Method · Single select
Cash, Cheque, UPI, Bank transfer, Online
Receipt sent · Checkbox

Events

8 fields · 4 sample rows

  • Events (Grid)
  • Calendar (Calendar)
EventTextDateDateFrequencySingle selectCommunityLink to another tableLocationTextCoordinatorTextExpected attendanceNumberNotesLong text
Sunday worship service20 Nov 2026WeeklyWorship & MusicMain sanctuaryGrace Fernandes320
Youth fellowship night24 Nov 2026WeeklyYouth FellowshipFellowship hallDaniel Brooks45
Christmas carol service28 Dec 2026AnnualWorship & MusicMain sanctuaryGrace Fernandes600
Food drive — Fort Kochi1 Dec 2026MonthlyOutreach TeamParish groundsSamuel Okafor30
Field details
Event · Text
Date · Date
Frequency · Single select
One-time, Weekly, Monthly, Annual
Community · Link to another table
Links to Communities
Location · Text
Coordinator · Text
Expected attendance · Number
Notes · Long text

Communities

8 fields · 4 sample rows

  • Communities (Grid)
CommunityTextTypeSingle selectLeaderTextMeets onSingle selectMembersLink to another tableMember countCountEventsLink to another tableUpcoming eventsCount
Worship & MusicMinistryGrace FernandesThursdayGrace Fernandes, Samuel Okafor2Sunday worship service, Christmas carol service2
Youth FellowshipYouthDaniel BrooksFridayDaniel Brooks, Priya Joseph2Youth fellowship night1
Outreach TeamOutreachSamuel OkaforSaturdaySamuel Okafor, Thomas Mathew2Food drive — Fort Kochi1
Ernakulam Home GroupSmall groupThomas MathewWednesdayThomas Mathew10
Field details
Community · Text
Type · Single select
Small group, Ministry, Youth, Outreach
Leader · Text
Meets on · Single select
Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
Members · Link to another table
Links to Members
Member count · Count
Events · Link to another table
Links to Events
Upcoming events · Count

Church CRM: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates