Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. Our Pub Is Community Owned. How Do We Manage Shareholders, Members and Volunteer Rotas Without a Tangle of Spreadsheets?
Problems We Solve

Our Pub Is Community Owned. How Do We Manage Shareholders, Members and Volunteer Rotas Without a Tangle of Spreadsheets?

Community pubs juggle shareholder records, member communications and volunteer rotas in spreadsheets. We build one members and volunteers system for them.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

A community-owned pub has hundreds of members or shareholders, a committee, volunteers doing shifts and a manager or tenant running the bar. We build one place for member records and share holdings, meeting notices and voting, a volunteer rota people can sign up to from their phones, and newsletters to members, with access controlled by role.

The pub the village bought

The village raised the money and bought the pub when it came up for sale. Now it has several hundred members who hold shares, a committee of volunteers, a paid manager and a group of people who help on the bar, in the garden and with events. The membership list is a spreadsheet the treasurer keeps. The volunteer rota is a WhatsApp group and a paper list behind the bar. The newsletter is sent from someone's personal email.

Before the annual meeting, the secretary has to send notices to every member, collect proxy votes, and check who has moved or died. Some members have no email. Someone asks how many shares they hold and nobody can answer quickly. A volunteer shift is empty on a Saturday because the WhatsApp message was missed.

Why community pub admin grows so fast

Community pubs combine a business with a membership organisation, and the membership side is run by volunteers in their spare time. The tools they reach for, a spreadsheet, a group chat, a personal inbox, are fine for twenty people and struggle with hundreds.

Records also change hands. Treasurers and secretaries step down, and each handover risks losing history about who holds what and who was told what. Your society's rules and your adviser decide what records must be kept. The tools just need to make keeping them practical.

What the spreadsheets cost

ProblemEffect
Member list in one person's spreadsheetRisk when that person steps down
Notices sent by handEvenings of work and members missed
Share queries answered slowlyMembers feel out of touch with their pub
Volunteer rota in a group chatEmpty shifts and the same few people covering
Newsletters from personal emailMessages in spam and no record of who got what

Members who feel informed and involved are the ones who come in, volunteer and invest again when the roof needs fixing. Admin that makes them feel forgotten weakens the very thing the pub depends on.

The volunteers who do the admin pay a cost too. The secretary who spends every evening before the annual meeting on a mail merge is the one who will not stand again next year, and finding a replacement willing to take on the spreadsheets is harder each time.

One system for members and volunteers

  1. Member records hold contact details, share holdings, joining date and communication preferences, including post for members without email. Changes are logged.
  2. Members can view their own holding and update their details through a secure link.
  3. Meeting notices and papers are sent by email and prepared for post in one go, and proxy or online votes can be collected where your rules allow, with a record of who voted.
  4. Volunteers see open shifts on their phones and sign up, with reminders the day before and a warning to the organiser when a shift is still empty.
  5. Newsletters go out through a proper email service to members who want them, with unsubscribes handled.
  6. Access is by role: the treasurer sees holdings, the volunteer coordinator sees the rota, the manager sees who is on shift.

We do not advise on your society's rules, share offers or meeting procedures. We build the tools that help your committee follow the rules you already have.

The next annual meeting

The secretary prepares the notice once. Emails go to members who prefer email and a mail merge file is ready for the rest. Proxy votes come in online and are counted as they arrive. On the night, the list of members present is on a tablet at the door. The volunteer rota for the summer fete is filled in a week, and the organiser can see the gaps.

  • Member and share records that survive a change of treasurer
  • Meeting notices and votes handled in one place
  • A volunteer rota people actually fill
  • Members kept in touch with their pub

Is your community pub run like this?

  • Member and share records live in one person's spreadsheet.
  • Annual meeting notices take evenings of work.
  • Volunteer shifts are organised in a group chat.
  • Newsletters are sent from a personal email account.
  • Members cannot easily see or update their own details.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Is this suitable for a small community pub?

Yes. It can start with just member records and a volunteer rota, and add voting and newsletters later.

What about members without email?

They are marked for post, and notices are prepared as letters alongside the emails.

Who can see member data?

Only people with the right role. Access is set by the committee and every change is logged.

What affects the cost?

Mainly the number of members, whether online voting is needed and whether it connects to the pub's EPOS or accounts.

Keep reading

More on Problems We Solve

Start here

Tell us where the admin piles up at your pub

Describe how your pub, or pubs, handle glassware, cash, equipment and the people involved, and which EPOS and accounts software you use. We will tell you what we would build and what we would leave to your existing tools, and if a smaller change would do, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →