How to Calculate Membership Retention Rate (Formula, Example, and What to Tell Your Board)

Short answer: Membership retention rate = (members at the end of the period − new members who joined during it) ÷ members at the start × 100. If you started the year with 200 members, added 30, and ended with 190, your retention rate is (190 − 30) ÷ 200 = 80%.

It's the end of October. Your board wants a membership number for the annual report, and someone will ask, "So are we keeping people or not?" You have a roster, a dues spreadsheet, and a list of people who joined at the spring event. That's enough to answer the question honestly.

This guide covers the formula, the one mistake that inflates the number, how retention differs from renewal rate, and how to explain it to a board in two sentences.

What is membership retention rate?

Membership retention rate is the share of the members you had at the start of a period who are still members at the end. It only counts people who were already members. New joiners belong in a different number.

That's the key point. As the analytics firm Nucleus Analytics puts it, new members acquired during the period "should not be included in the retention rate calculation because they were not members at the beginning of the period. Including them artificially inflates retention rate" (Nucleus Analytics).

What is the membership retention rate formula?

Retention rate = (End count − New members) ÷ Start count × 100

That's the formula Nucleus Analytics lays out (Nucleus Analytics). You need three numbers:

1. Start count: members on the first day of the period, for example January 1.
2. End count: members on the last day, for example December 31.
3. New members: people who joined during the period.

Worked example

(190 − 30) ÷ 200 × 100 = 80% retention

If you skip the subtraction, you get 190 ÷ 200 = 95%. That looks great, but it's wrong. Thirty new people covered for 40 who left.

Is there a simpler way to calculate it?

Yes. If your roster has join dates, you can follow the actual people instead of subtracting totals.

Meeting Professionals International (MPI) tells its chapters to take the members they had 12 months ago and count how many of those people are still members today. Its example: a chapter had 200 members on January 31, 2024, and 150 of them were still members on January 31, 2025, so retention is 150 ÷ 200 = 75% (MPI Chapter SOP).

This version is harder to fool. A returning member who left and rejoined doesn't get confused with a brand-new one. A duplicate row doesn't pad the end count. And MPI notes that the rate moves through the year because it's always measured against 12 months ago.

What's the difference between retention rate and renewal rate?

Renewal rate = Members who renewed ÷ Members who were eligible to renew × 100

Retention looks at your whole roster over a period. Renewal rate looks only at the people whose membership came due (Nucleus Analytics).

The difference matters if members renew on the anniversary of their join date, or if you sell multi-year memberships. In any given month, most of your roster isn't up for renewal. Counting them would drag the rate down, so leave them out.

If your whole chapter runs on a calendar year and everyone expires December 31, the two numbers end up close. If you use rolling renewals, track both.

What is a good membership retention rate?

Compare yourself with your own past years first. Benchmarks help, but most of them come from larger associations.

The most-cited benchmark is Marketing General Inc.'s annual Membership Marketing Benchmarking Report. In the 2026 edition, the median renewal rate stayed at 82%. MGI's Tony Rossell notes that this number has barely moved in nearly a decade (Membership Marketing Blog). Keep in mind that it's a renewal rate, not a retention rate, and it's a median across associations that answered the survey.

Rossell's bigger point is worth putting in front of your board: unless an association is fixing a major flaw in its value proposition or renewal system, "it cannot renew its way into growth" (Membership Marketing Blog). Retention keeps you steady. New members are what grow you.

For a small chapter, also remember how fast the math swings. With 40 members, two people leaving moves your rate by 5 points. One bad year isn't a trend. Three in a row is.

Why do first-year members matter so much?

New members tend to leave at a higher rate than long-time members. Member Jungle's summary of MGI's 2025 report put the median first-year renewal rate at 74%, against 84% overall (Member Jungle).

That's why it helps to track retention by when people joined. Group members by join month, then check what share are still around at 3, 6, and 12 months. If the people who joined at your spring open house are gone by fall, that's a welcome problem, not a renewal problem.

How do you calculate retention in a spreadsheet?

You can do this in Excel or Google Sheets in about 20 minutes if your roster is clean.

1. Pick your period. Usually your fiscal or membership year.
2. Make sure every row has a join date and an expiration date. Missing dates are where retention math breaks.
3. Remove duplicates. The same person entered twice under two emails will inflate your counts.
4. Count your start list. Everyone who was a member on day one.
5. Count how many of those same people are still members on the last day. A lookup on email or member ID does this.
6. Divide. Still here ÷ start list × 100.
7. Write down your rules. Decide whether someone in a grace period counts as a member and whether a rejoiner counts as retained. Use the same rules every year so the trend means something.

What is membership churn rate?

Churn is the flip side of retention: the share of members you lost. With the start-and-end method, churn is simply 100% minus your retention rate. In the example above, 80% retention means 20% churn, or 40 of 200 members.

Some tools calculate churn a little differently. Before you compare two numbers, check what each one divides by.

How should you explain retention to your board?

Give them one number, one trend, and one next step. For example:

"We kept 80% of last year's members, down from 84%. Most of the drop came from people who joined at the spring event and didn't renew, so this year we're calling every first-year member before their renewal date."

Then put net growth next to it, meaning new members minus members lost. A chapter can have strong retention and still shrink if nobody new joins.

Where VerveHQ fits

We built VerveHQ so a membership chair doesn't have to rebuild this spreadsheet every October. Here's what the dashboard shows today:

• Join-month retention. A table that groups members by the month they joined and shows the share of each group still on the roster at 3, 6, and 12 months. Above it: "Still here at 6 months," "Still here at 12 months," and how many joined and left in the last 12 months.
• Net growth. A rolling 12-month chart of new members, by join date, against members lost, by expiration date.
• Churn trend and Recently churned. See when people left and who they were.
• Churn rate (12 months). An optional card you can add to the dashboard. It divides members lost in the last 12 months by active members today plus those lost, so it won't match the hand formula above exactly. The card shows the formula right on it.
• Former members stay on file. Lapsed members don't disappear, so you can see who still comes to events.
• Board-ready export. Rearrange the dashboard and export it to PDF for the board packet.
• Ask the data. Native AI insights let you ask questions about churn, attendance, and engagement in plain English.

The numbers are only as good as the join and expiration dates on file. Imports and merges help clean that up, but check a few rows before you trust the first report.

VerveHQ is in beta, and access is invite-only for now. If your board report starts with a retention spreadsheet, get a demo and we'll walk through it with your roster. Pricing is coming soon.

FAQ

What is the formula for membership retention rate?

(Members at end of period − new members who joined during the period) ÷ members at start of period × 100. Don't count new joiners, or the rate will look higher than it is.

How is retention rate different from renewal rate?

Retention rate covers everyone who was a member at the start of a period. Renewal rate counts only the members who were up for renewal and divides how many renewed by how many were eligible.

What is a good membership retention rate?

Start by comparing with your own past years. For context, MGI's 2026 benchmarking report puts the median association renewal rate at 82%, but that's a renewal rate across mostly larger associations.

How often should we calculate retention?

Once a year for the board report, at the same point each year. A rolling 12-month view, like MPI's method, lets you check it any month.

Do lapsed members who rejoin count as retained?

Pick a rule and stick with it. Many chapters treat someone who rejoins within a grace period as retained and someone who comes back a year later as new. What matters is using the same rule every year.