Three spreadsheets, the week before
The members list, the bank statement and last year's list, side by side, with someone counting rows and hoping the totals agree.
For the AGM
Clayside is the club report a committee used to build by hand. How many members you had, who came back, who played, what was collected and where the new members came from. Counted from your own register, so nobody types a number.
On every club plan, from £265 a year. The committee seat that reads it is free.
Counted, never typed Never a made-up chart One spreadsheet for the meeting
The club over the years
You finished 2025/26 with 241 members, up from 219 the year before.
The problem
The members list, the bank statement and last year's list, side by side, with someone counting rows and hoping the totals agree.
Nobody knows how many came back, so the answer is a feeling. The junior programme and the court hours get decided on it.
Do members who play stay longer? Everyone thinks so. Nobody has ever had the number, because the league and the membership were never on one list.
The screen
The headings on the screen are the questions a committee asks. Not one is a word off a dashboard.
Members at the end of each year, and who joined and left.
How many come back the next year, and what happened to the ones who did not.
Members who played a match in a box, on a ladder, in a tournament or at a social night.
Ages and gender, as far as the register knows them.
Subscriptions charged and collected, year by year.
Where this year’s new subscriptions came from.
What the courts have been used for.
Who stays
Do members who play come back more than members who do not? Here it is, every year, from your own club.
86%came back for 2025/26 · 189 of 219
What happened to the ones who did not
8 said no9 went quiet13 never answered
Coming back, split by whether they played in 2024/25
Played in a competition92%
142 of 155 came backPlayed nothing73%
47 of 64 came backSaid no, went quiet, never reached. You do something different about each, and the third is usually the biggest.
Below 10 people in a group the figure is not drawn, and the screen says why. An age or gender chart needs 10 members whose details are known, and says how many members it is based on. Age is worked out to the day.
A first year shows months, not years. A block that needs a second year says which month it opens. Nothing is greyed out with pretend bars behind it.
The spreadsheet
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Year | Members | Joined | Left | Counted from |
| 2 | 2021/22 | 163 | 35 | 20 | joining dates |
| 3 | 2022/23 | 179 | 38 | 22 | joining dates |
| 4 | 2023/24 | 198 | 44 | 25 | subscriptions |
| 5 | 2024/25 | 219 | 49 | 28 | subscriptions |
| 6 | 2025/26 | 241 | 52 | 30 | subscriptions |
| 7 |
The secretary, treasurer and committee all read it, and the committee seat is free. Nothing on it can be changed, and no name is in it.
A club with one membership year has a report already.
Questions
Your first year, month by month. Anything that needs a second year says which month it opens.
No. It is counted from people joining, paying, playing and booking.
No. This screen is counts. Who has paid and who has played are on the register, behind their own permissions.
Every club plan, from Club 125 at £265 a year. See what each plan holds.
Club figures
Free for fourteen days, no card. The first year draws itself from the first membership.
Your club has its own address. Open it and sign in there with your email. There's no password.
If you set the club up, tell us and we'll look it up.
Play in a box? Tap the link in your group chat, or ask whoever runs your league. Still can't get in?