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, 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.
Tracker, portal, dashboard
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 the dates have to be 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.
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 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.