Membership Expiry Without the Spreadsheet Panic

Every club has a version of this story. It is a bright Saturday in April, the first good weekend of the season, and the treasurer is working through the membership spreadsheet with a cup of tea. Somewhere around row forty they stop. A member whose subscription expired in November has been booking boats all winter. Nobody noticed, nobody chased, and now someone has to write a horribly awkward email about four months of back payment the member believes they have already made.

The opposite failure is just as common. A loyal member who paid in January gets a curt reminder in March because the register lived on two laptops and only one was up to date. Either way the damage is the same. Renewal time is the one moment in the year when every member quietly judges how well the club is run, and a muddle at that exact moment gets remembered.

A rolling expiry view beats an annual crisis

The root problem is treating club membership renewals as an event rather than a process. If every membership turns over on the same date, the office faces a cliff: eighty renewals to invoice, chase and reconcile inside a fortnight, usually in the very weeks the season is starting.

A rolling view changes the shape of the work. Instead of asking once a year who has renewed, you ask a smaller question every month: who expires in the next sixty days? That list is rarely more than a handful of names. It fits in an evening, and because it is short, each name gets genuine attention instead of a mail merge.

The mechanics matter less than the habit. Whether the list comes from software or a well-kept register, somebody should look at forthcoming expiries on a fixed monthly rhythm, so the question of who lapses next always has a current answer.

Chase on a cadence, not in a panic

One reminder is not a chase; it is a lottery ticket. People are busy, emails land at bad moments, and a renewal that just needs doing can sit in someone's mental drawer for weeks. Three contacts, spaced out and each written differently, catch far more people than the same message fired off three times.

• Sixty days out: a light touch. State the expiry date, the price and how to renew. Nothing urgent, because nothing is urgent yet. Some people renew straight away just to cross it off.
• Thirty days out: more direct. Lead with what carries on if they renew: booking access, their place in the season, the boats they already use. Then give the date plainly. This is the message most people act on.
• Expiry week: short and matter-of-fact. Membership ends on Friday; booking access ends with it; here is the link, and here is a human to ring if something has gone wrong. No guilt and no exclamation marks.

The change of wording matters as much as the timing. Send the identical paragraph three times and by the third arrival it is invisible.

Booking rights should follow membership status

Now the uncomfortable question: what actually happens at your club when a membership runs out? At plenty of clubs the honest answer is nothing. The booking sheet still accepts the member's name, the gate code still works, and enforcement depends on a volunteer remembering to act, which is to say it depends on luck.

Booking rights are a benefit of membership and should end with it, not as punishment but as clarity. When a lapsed member gets suspended and hits a polite notice the next time they try to book, they usually renew the same day, because the question arrived at the exact moment the benefit mattered to them. The winter-long lapser in the opening paragraph was not dishonest. The club simply never told them, in any way that registered, that anything had changed.

This is where decent software earns its keep. A system that holds the membership record and the booking diary in one place, as Nauticore does with its membership expiry report and per-member suspension, lets whoever runs the chase see who is due, who has gone over, and who is still merrily booking, and act on it long before April. The report tells you who to suspend; suspending them turns off the booking access without anyone deleting a record they might need back next week.

The win-back note worth writing

Some lapses are real decisions. People move away, take up golf, have children. Let them go gracefully and keep the door open. For everyone else, the best win-back tool is specificity. A generic note saying the club misses them is wallpaper. A note that says they took the launch out fourteen times last season, mostly on Saturday mornings, and the club would like to see them back aboard reads like it was written by someone who noticed. Your booking records make that a two-minute job: trips taken, favourite boat, the last date they were out.

Renewals are a committee health metric

Renewal rate is the most honest number a club produces. Surveys collect the opinions of people who enjoy filling in surveys; the renewal rate collects everyone's, expressed in money. A club keeping nine members in ten is doing the fundamentals right whatever the grumbling at the bar. A club losing a quarter of its list every year has a problem no open day will paper over.

So put the figure in the committee papers each month: memberships due, renewed, lapsed, and, where anyone knows it, why. Patterns show up quickly. If leavers cluster among second-year members, the welcome is working and the ongoing offer is not. If they cluster among people who hardly booked, the fleet or the booking rules deserve a look. None of that insight is available in April, in a panic, at row forty of a spreadsheet.