Spreadsheets vs a real booking system: what it costs you

An Excel sheet or a paper diary is a perfectly good way to start. It's free, everyone understands it, and it works when one person takes every booking. Plenty of good clinics, salons and gyms in Lebanon run on one.

The trouble shows up later, and it shows up quietly. Here's where a sheet or diary starts to cost you, and what you can fix before you pay for anything.

Where it breaks

Two people, one slot. The secretary takes a call and writes 4pm in the diary. The owner confirms the same 4pm with a regular on WhatsApp. Nobody did anything wrong. They just didn't see each other's entry. Now you have two people at the door and one very awkward conversation.

The file lives in one place. The sheet is on the reception laptop, or the diary is on the desk. When the power cuts, the laptop dies, or you're out and a client messages you, you can't check. So you say "I'll confirm later", and later is when they book elsewhere.

Nothing happens at night. A client who messages at 11pm to book a haircut or a consultation can't see free slots. Somebody has to read the message the next day, check the sheet, reply, wait for an answer and type the booking in. That's a string of steps, and each one is a chance for the person to give up.

Nobody reminds them. A diary doesn't send anything. If the day-before reminder depends on someone remembering to write to every client, it will get skipped on the busy days, which are exactly the days you can least afford an empty chair.

Typos and stale rows. Raymond Panko, at the University of Hawaii, has reviewed field audits of spreadsheets for years, and most of the spreadsheets examined contained errors. A scheduling sheet is no different. A wrong date, a row pasted over, a cancelled client who was never deleted. Small mistakes, found at the worst moment.

What the research says about reminders

A Cochrane systematic review (Gurol-Urganci and colleagues, 2013) looked at mobile phone text message reminders for healthcare appointments. Reminders increased attendance compared with no reminder. The review is about health appointments, but the logic is plain enough for a salon or a gym: people forget, and a short message the day before gets some of them back.

What to fix for free first

You can get a long way without buying anything.

• Move to one shared calendar, such as Google Calendar, that everyone who takes bookings can see on their phone. One calendar, one truth. Retire the paper diary and the second sheet.
• Fix your slot lengths. If a haircut takes 45 minutes, block 45 minutes. Calendars with real durations make clashes obvious.
• Use colours or labels for the type of appointment, or for each person or chair.
• Write a standard confirmation message and use a WhatsApp Business quick reply: date, time, address, "reply to confirm or to change". Send it as soon as you book.
• Send a reminder the day before. It's a handful of short messages. Put it in someone's morning routine.
• Keep a simple no-show note on each client. It tells you who needs a confirmation call and who doesn't.
• Back it up. If you stay on a sheet, keep it in the cloud, not on a single laptop.

If you do just these, double bookings should become rare and some of the no-shows should come back. For a small place with one booking person, that might be all you need.

When a real booking system earns its place

The free routine depends on people doing the same thing every day. It starts to crack when several people take bookings, when clients mostly write on WhatsApp, when you have more than one chair, room or doctor, or when evenings and Sundays matter.

A booking system holds the slot the moment it's taken, so it can't be offered twice. It shows only free times. It sends the reminder by itself. Nothing depends on someone's memory at 5pm on a Friday.

Where the assistant fits

Many clients here don't want to open a booking app. They want to message on WhatsApp, the way they do with everyone else. An assistant on your own WhatsApp can take that chat, ask what the secretary would ask (what service, which day, morning or afternoon), offer the free slots from your calendar, and book. It confirms, reminds, and follows up with people who go quiet. If a client asks something it shouldn't answer, or wants something unusual, it hands the chat to a person.

Some honest limits. It works from your real calendar and the information you approved, so if your calendar is a mess, tidy that first. It never invents a time, a price or a booking reference, and if a slot isn't free it won't offer it. And it doesn't replace you or your reception. It takes the repetitive back and forth so your team can look after the person standing in front of them.

If you already use a system or sheet, tell us what it is. We'll build around what you have where we can, and say plainly where we can't.

Read more: how Bader takes salon bookings and what Bader does on WhatsApp.

Want to see it on your own business?

Book a quick call and tell us about your business. After the call, we'll tell you what we'd suggest next.