Membership retention worksheet
This worksheet measures member retention the same way every year. A board or association staff enters four counts from the membership records and gets back the retention rate and the net change in membership, with every step of the arithmetic shown. It works on screen or on paper, and nothing you enter leaves your browser.
How the worksheet counts
Retention rate = members from the starting cohort who renewed within the grace period divided by members in the starting cohort who were due to renew in the period, times 100.
- Starting cohort
- Every member whose renewal came due during the period. If everyone renews on one calendar date, that is the roster on that date. If members renew on the anniversary of joining, it is every member whose expiration date fell inside the period. A member on a two-year term belongs to the cohort only in the year the term ends.
- Life and honorary members
- Leave them out of the cohort. They are never asked to renew, so they cannot lapse.
- Renewed
- A member of the starting cohort who paid by the last day of your grace period. Count each member once, however many notices it took.
- Grace period
- The time after expiration in which a payment still counts as a renewal. Write yours on the worksheet and keep it the same every year, because a longer grace period raises the rate on its own. Two to three months is the most common choice among associations surveyed by Marketing General Incorporated, and about one in five offer none (Membership Marketing Benchmarking Report, 2024 edition, page 40).
- New members
- Members who joined for the first time during the period go on line 3 and never raise the retention rate. They join the starting cohort the first time their own renewal comes due.
- Reinstatements
- A lapsed member who comes back after the grace period has ended is a reinstatement, counted on line 4 and never as retained. A member who paid late but inside the grace period counts as renewed on line 2.
- Membership categories
- If categories behave differently, for example company and individual members, or regular and associate members, run one worksheet per category. A single combined rate can hide a category that is losing members.
- When to run it
- After the grace period has closed for the last member due in the period. Run it sooner and members who are still inside their grace period show up as lapsed.
The worksheet
Fill in lines 1 to 4 for the period you are measuring. Add the prior period's counts in the second column to compare the two years. Use whole numbers only. Lines 5 to 9 fill in as you type.
The starting cohort: every member whose renewal came due in the period. Leave out life and honorary members.
Members from line 1 who paid by the end of your grace period. Cannot be more than line 1.
First-time members who joined during the period. Counted here only.
Lapsed members who came back after their grace period had ended.
Line 5: Members lapsed
Line 1 minus line 2.
Line 6: Retention rate
Line 2 divided by line 1, times 100. A percentage.
Line 7: Lapse rate
Line 5 divided by line 1, times 100. Lines 6 and 7 add up to 100.
Line 8: Net change in membership
Line 3 plus line 4, minus line 5. A minus result is a loss.
Line 9: Change in retention rate
Line 6 this period minus line 6 prior period, in percentage points.
The arithmetic, step by step
Everything you type stays in this browser tab. Nothing is sent or saved, and closing the tab clears it.
Old Plank Group membership retention worksheet, oldplankgroup.com/resources/membership-retention-worksheet/. Reviewed November 15, 2026. Printed on ____________________
What the worksheet leaves out
The worksheet works from counts, so it shows how many members left and never which ones or why. Your membership records hold the names, and the next section covers where to look.
Line 8 covers members who came due, joined or came back. A member who left before coming due, such as a company that closed or merged partway through its term, appears on no line. If you track those departures, subtract them from line 8.
What to look at when retention falls
First-year members and long-time members
Members in their first year renew less often than the membership as a whole. Marketing General Incorporated reports a median renewal rate of 72% for first-year members against 82% overall, from its 2026 Membership Marketing Benchmarking Report (Marketing General, "The First 30 Days"). Those medians come from associations reporting on themselves, each with its own definition of renewal, so the most useful comparison is your own rate against your own prior years.
Run the worksheet twice, once with only first-year members on line 1 and once with everyone who has renewed before. If the first-year rate sits well below the other, the loss is happening in the welcome and the first months of membership.
Engagement before renewal
Lack of engagement was the reason association executives most often gave for non-renewal, chosen by 47% overall and 64% at trade associations (Membership Marketing Benchmarking Report, 2024 edition, page 47).
In our experience, a lapse is usually visible months before the invoice. Take the members who lapsed and check whether anyone from each one attended an event or served on a committee during the year.
The renewal notice schedule
Associations most often start the renewal effort three months before expiration and most often stop contacting a lapsed member three months after it (Membership Marketing Benchmarking Report, 2024 edition, pages 44 and 45).
In our experience, a drop in retention sometimes traces back to a change in the schedule itself. Put the dates each notice went out this year beside last year's. A first notice that went out later, or a reminder that was skipped, shows up in line 6.
The companion read, why members leave associations, and a renewal calendar that keeps them, sets out a twelve-month calendar of member contact.
Old Plank Group manages trade and professional associations, including membership and renewals.