I Used to Think We Could Manage Events with Just a Spreadsheet
For years, I thought a simple spreadsheet and a free email service were all we needed to run community events. After all, we were a small team with limited resources. Why complicate things with fancy software? I used to say, "Why spend money on tools when we can just DIY?" I wasn’t alone in this thinking; most community organisations I worked with felt the same. Spreadsheets and clipboards had served us for decades. Why change?
But then came the chaos.
It wasn’t one big dramatic moment that changed my mind. It was the slow, grinding frustration of realising that nothing was working as smoothly as it should. Attendance numbers didn’t match our ticket sales. Emails went to the wrong people. Volunteers didn’t get proper instructions. And let’s not even talk about reconciling cash sales and online payments after an event.
Then, AEV released their 2026 eGuide. That was my wake-up call.
What the AEV 2026 eGuide Highlights
The Association of Event Venues (AEV) has been publishing their eGuide for two decades now, but this year’s edition felt different. It wasn’t just about safety regulations or venue compliance anymore. It was a blueprint for modern event management—designed to tackle the complexities of hosting events in 2026, including:
- New standards for event safety and emergency medical planning: AEV breaks down exactly what event organisers should account for, including risk assessments, evacuation plans, and medical response protocols to ensure attendee safety.
- Guidelines for managing hybrid event formats: With the rise of hybrid events, there’s a growing need for seamless integration between in-person and virtual experiences. The eGuide covers everything from tech requirements to attendee engagement strategies.
- Best practices for handling ticketing and attendee data securely: Data breaches are becoming more common, and attendee trust is hard to rebuild once lost. The eGuide outlines steps to safeguard sensitive information, including encryption, access controls, and compliance with GDPR.
Reading the eGuide, it became painfully obvious that our old-school DIY approach didn’t just make our lives harder—it put us at risk. Risk of breaking compliance rules. Risk of losing ticket revenue. Risk of frustrating our attendees and volunteers.
Why the Spreadsheet Era Lasted So Long
It’s easy to see now why I clung to my spreadsheets for so long. They were free, they were familiar, and they gave us a sense of control. When you’re running a small organisation with tight budgets, every dollar matters. Spending money on software felt like a luxury we couldn’t afford.
And honestly, most event tools out there didn’t seem designed for people like us. They were either:
- Too expensive: Many platforms charge per ticket sold, sometimes upwards of 10% per ticket, which can quickly eat into your revenue.
- Too complicated: Enterprise-level solutions often come with features we didn’t need, and figuring out how to use them felt overwhelming.
- Not flexible enough: Community events come with quirks—like accommodating walk-in attendees or managing cash payments—that many tools fail to account for.
But what I didn’t realise at the time is that the cost of inefficiency was much higher. Every hour spent fixing mistakes or chasing down RSVPs was an hour we couldn’t spend on our actual mission. Every volunteer who got frustrated with our disorganised systems was one less set of hands we could count on for the next event.
The Turning Point: Centralised Tools
After reading the eGuide, I started looking into centralised tools. That’s when I found CommunityTix, and I’ll be honest—it felt like it was built specifically for people like me.
Here’s what changed:
RSVP Chaos Turned Into Clarity
The AEV eGuide emphasises the importance of accurate attendance tracking for safety planning. With CommunityTix’s RSVP management feature, we could finally see exactly who was coming to our events in real time. No more guessing. No more sifting through email threads.
Actionable Steps:
- Create a streamlined RSVP form for attendees.
- Integrate the form with your event management platform.
- Monitor attendance numbers in real time to adjust event logistics accordingly.
Cash and Card Sales Simplified
One of the eGuide’s updated sections focuses on handling on-site sales securely. CommunityTix lets us track both cash collections and card-at-door payments in one place. Reconciling sales after events went from a multi-day headache to a 30-minute task.
Actionable Steps:
- Set up a secure payment processor that handles both online and offline transactions.
- Train volunteers on how to use the system for cash and card payments.
- Use built-in reporting tools to reconcile sales immediately after the event.
Member Data Centralised
The eGuide stresses the importance of data security and centralisation. CommunityTix combines ticketing, member management, and event blogs into a single platform. No more updating three different spreadsheets or sending duplicate emails to members.
Actionable Steps:
- Migrate member data to a secure, GDPR-compliant platform.
- Use tagging or segmentation to personalise communications.
- Regularly audit your data for duplicates or outdated information.
What I Do Differently Now
I don’t use spreadsheets for event planning anymore. At all. Everything goes into one centralised system. It sounds simple, but it’s been life-changing.
We’ve also started using Pay What You Can (PWYC) pricing for some of our events. The eGuide highlights the need for greater accessibility in community events, and PWYC has been a game-changer for us. We set suggested price points, but people can pay what they’re comfortable with. It’s fair, it’s inclusive, and it’s easy to set up with tools like CommunityTix.
Steps to Implement PWYC Pricing:
- Identify events where accessibility is a priority.
- Set suggested price ranges for tickets based on your budget.
- Communicate clearly about why you’re using PWYC.
- Track revenue trends to ensure sustainability.
Comparison: Spreadsheets vs Centralised Tools
| Feature | Spreadsheets | Centralised Tools |
|---|---|---|
| Cost | Free | Varies (can be affordable) |
| Ease of Use | Familiar but manual | Intuitive interfaces, automated processes |
| Attendance Tracking | Manual data entry | Real-time updates |
| Payment Management | Separate tools needed | Integrated cash/card tracking |
| Data Security | High risk of breaches | GDPR-compliant, encrypted |
| Volunteer Management | Manual communication | Centralised instructions |
If you’re juggling spreadsheets and email chains to manage your events, it’s time to rethink your approach. CommunityTix offers an affordable, all-in-one solution that aligns with the AEV’s 2026 standards. Get started free →
