Open the board pack of most associations and the membership section is two numbers: total members, and membership revenue against budget. Sometimes there is a chart of the total over time. The board looks at it, notes that it is roughly flat, and moves on to the finance report.
The problem is that a flat total is compatible with a healthy association and with one that is quietly hollowing out. If you gained 120 members and lost 118, the total is flat. If you gained 20 and lost 18, the total is also flat. Those are very different organisations, and the board should be able to tell them apart from the page in front of them.
Here is a membership report that fits on one page, takes under an hour to produce from a decent membership system, and gives a board what it actually needs to govern.
Start with flows, not stock
The first section should show joins, lapses and net change for the quarter, alongside the same quarter last year. Three rows, two columns. This is the single most useful change you can make to a board report, because it turns a static number into a story.
A board that sees joins are up 30% while lapses are up 40% will ask a different question to one that just sees the total dropped by twelve. The first question is “why are we losing more people”. The second is “should we do a recruitment drive”. Only one of those leads somewhere useful.
Show retention by cohort
Overall renewal rate is a blunt instrument. It blends long-standing members who would renew regardless with first-year members who are still deciding, and the blend hides the thing that matters.
Split the renewal rate three ways: members in their first year, members in years two to four, and members in year five or beyond. Most associations discover that the first-year rate is dramatically lower than the others, sometimes by twenty or thirty points. That is where the retention problem lives, and the board cannot direct resources towards it if the report does not show it.
If your tiers or categories are meaningfully different, add a second split by tier. A student category that churns at 60% is expected. A full professional category doing the same is a crisis.
Report on engagement, not just membership
A member who has not opened an email, attended an event or logged into the portal in nine months is a lapse that has not been processed yet. The board should see how many of those there are.
Define a simple engagement threshold your system can actually compute, such as any event attendance, portal login or email click in the last six months. Report the percentage of members below it. Track it quarter on quarter. When that number rises, next year’s lapses are already visible, and the board has time to act rather than react.
One line on where the money comes from
Membership revenue as a single figure hides concentration risk. Add a single line showing what share of revenue comes from your largest category or largest ten organisational members. If half your income depends on eight corporate memberships, the board should know that, and it should shape the conversation about non-dues revenue and pricing.
What to leave out
The temptation with a good membership system is to report everything it can produce. Resist it. Event-by-event attendance, newsletter open rates by edition and website traffic belong in an operations report or an appendix, not on the page the board reads.
The test for each number is whether a board member could make a different decision because of it. Cohort renewal rates pass that test. Open rates on the March newsletter do not.
Add the questions, not just the answers
The most effective board reports we have seen end with two or three sentences from the executive about what the numbers mean and what the board is being asked to consider. “First-year renewal fell for the third consecutive quarter. Staff propose trialling a structured 90-day check-in and will report on results in Q2. No decision required this meeting.”
This is the difference between a report that informs and one that governs. The board is not there to discover the trend themselves. It is there to weigh the response.
Make it repeatable
None of this is valuable if it takes a full day every quarter and the definitions shift from one report to the next. Fix the definitions once, write them on the back of the page, and produce the report from the same saved queries every time. When the numbers are consistent, trends become visible, and trends are what boards are actually there to see.
My Member Buddy tracks joins, lapses, cohort renewal and member engagement in one place, so the quarterly board report is a saved view rather than a spreadsheet exercise. See how it works.