Membership tracking sounds like surveillance and is really arithmetic. A body needs to know three things at any moment: who is due to renew, who is overdue, and who has lapsed. Everything called a membership tracker, a tracking app or tracking software is trying to produce those three lists, and most spreadsheets can produce none of them reliably because the renewal date is missing or stale. This page is about the three lists, the difference between a tracker and a portal, and how to read a churn rate that means something.
The three lists member tracking software keeps, and what each is for
Due is a marketing list: these people need a notice. Overdue is an operations list: these people need a person. Lapsed is a governance list: these people are no longer members and should stop receiving what members receive. Bodies that keep one list called Members do all three jobs badly, and usually keep sending the journal to people who left, which is a cost nobody notices until somebody totals it.
Membership tracker, portal or dashboard: who each one is for
A membership tracker is for the administrator: the three lists, current. A membership portal is for the member: their own record, their renewal, their card. A membership dashboard is for the board: numbers over time, joiners and lapses, dues collected. Three audiences, three different pages, and a product that offers one and calls it the others is worth asking about.
What a membership churn rate actually tells you
A membership churn rate is lapses over the period divided by the members you started with. It is useful as a trend and misleading as a single number, because a body with a big joining year has a big lapse year afterwards without anything going wrong. Read it beside joiners and net change: a body losing a tenth of its list and gaining more than that is growing, and a body losing half as many but replacing none of them is shrinking politely. The free worksheet on this site computes your lapse share and your net change from your own figures rather than a benchmark, because no benchmark knows your body.
Why a member tracking system needs the dates on the record
None of this works if the renewal date is inferred from the last payment. That inference breaks on standing orders at the old rate, on double payments, on part-year joins and on anybody who pays late once. Put the date on the member, computed from the join date and your period, and the three lists become queries rather than an afternoon.
The three lists on a Tuesday in March, worked
A body of four hundred with renewals spread through the year. On a Tuesday in March the due list holds the thirty-one members whose renewal falls in April; they get the notice this week. The overdue list holds nine whose March date passed unpaid; the membership secretary rings them. The lapsed list holds six who passed their date more than the grace period ago; they stop receiving the journal, their cards are expired, and they are told, kindly, how to rejoin. Three lists, forty-six names, one morning, and none of it requires opening a spreadsheet, because each list is a query over the renewal date the record holds. The worksheet on this site computes the churn those numbers add up to over the year.
Lapsed is not deleted
A lapsed member is a record with a status, not a row to remove. The body needs the history: when they joined, what tier they held, when they last paid, and when they lapsed, both because a returning member should not be made to start again and because the board's numbers over time are built from those dates. Keep the lapsed record, stop the member benefits, and let the record say lapsed with a date. Deleting a lapsed member is how a body ends up unable to explain why this year's list is shorter than last year's, and it is the reason the free template on this site carries a status field rather than assuming everybody in the list belongs.
Questions people ask about membership tracking
What should membership tracking software show?
Who is due, who is overdue and who has lapsed, at any moment, without anybody running a report. If those three take a spreadsheet exercise, the tracking is happening in somebody's head.
What is a good membership churn rate?
There is no useful benchmark across bodies of different kinds. Read your own trend against your joiners, and treat any single year with a big joining cohort behind it with suspicion.
Is a membership portal the same as a tracker?
No. A portal serves the member their own record; a tracker serves the administrator the three lists. Bodies often buy the portal and still do the tracking by hand.
Do members need a membership dashboard?
Members need their own record and their renewal. The dashboard is for the board, and it is worth having only if somebody reads it between annual meetings.
Is a membership tracking app different from a membership tracker?
Not in what it holds. A membership tracking app usually means the same three lists on a phone, which matters for the person checking a member in at a door and not much for the person running the renewal round from a desk. Ask what the app writes back to the record, not what it shows.
Are membership management tools the same as membership tracking software?
Membership management tools is the market's catch-all for the whole record: members, tiers, dues, renewals and whatever proof of membership a body issues. Tracking is the part of it that answers who is current, who lapsed and who is about to. A body that only wants the three lists is buying a subset, and should not pay for the rest twice.