I've sat through a lot of December board meetings. The question that derails them is rarely "how many members do we have?" It's "why doesn't that number match last quarter's?"
Here's my short answer. Bring five numbers: active members, renewal rate, first-year renewal rate, new members and membership revenue. Then agree on how each one is defined, write the definitions down, and use them every quarter. The definitions matter more than the dashboard.
Usually because the same word means different things to different people. Membership counts "active" as paid through today. Finance counts anyone billed this year. Someone else includes members in their grace period. Each report is right on its own terms, and the board sees three different answers.
The fix isn't a better chart. It's a one-line definition for every number, agreed on once and printed at the bottom of the page.
Copy this table into your next board packet and fill in the definitions your team agrees on.
| Number | Agree on this definition | The common trap |
|---|---|---|
| Active members | Paid through the report date, broken out by member type | Counting members in grace without saying so |
| Renewal rate | Members who renewed, divided by members who came due in the period | Including members who weren't due yet |
| First-year renewal rate | The same calculation, for first-year members only | Burying it inside the overall rate |
| New members | First-time joins in the period, with rejoins counted separately | Counting returning members as new |
| Membership revenue | Dues for the period, shown against budget | Mixing invoiced and collected amounts |
Five is enough. If your board wants more, add one number at a time, with its definition, rather than handing over a dashboard of twenty.
It's your call, but make it once and say it out loud. I prefer to report them on their own line: active, in grace and lapsed. That way the board sees renewal momentum building before the grace period ends, instead of a sudden drop in February that nobody saw coming.
In Cannolai, grace is its own membership status, so members in grace don't have to hide inside your active count.
When we built Cannolai, we put a report designer inside the product so staff can build and adjust reports like this themselves, and it includes a Membership Revenue report. But the tool isn't the point. A board report built on clean definitions in a spreadsheet beats a beautiful dashboard built on messy ones.
Do that, and the conversation moves from "are these numbers right?" to "what do we do about them?" That's the meeting your board actually wants. Save some room on the agenda for cannoli.
The Cannolai Taste Test sets up your real membership structure in a working sandbox before you sign anything.
Book a Taste Test and bring last quarter's board report.
Five core numbers cover most boards: active members by type, renewal rate, first-year renewal rate, new members and membership revenue against budget. Each needs a written definition that stays the same every quarter.
Divide the number of members who renewed by the number of members whose memberships came due in the same period. Leave out members who weren't due yet, and report first-year members separately.
Decide once and say so on the report. Many associations show active, in grace and lapsed on separate lines, so the board can see renewals coming in before the grace period ends.
Usually different definitions or different cutoff dates. Agree on one definition per number and one cutoff date, and the numbers will line up.