Speech Rehabilitation Clinic — Custom Management System

Speech Rehabilitation Clinic in Central Israel — A Tailored Management System

When a speech rehabilitation clinic in central Israel approached us, it was already a successful business. More than 400 active patients, a team of 12 therapists, and one office manager who somehow held it all together. The problem wasn't a lack of success — the problem was that the success itself had become unmanageable.

This is the story of a project that replaced four separate systems with a single one, saved 60% of management time, and reduced the no-show rate by 40%.

The Challenge

Here's what we found: a huge Excel file with 400+ rows — one row per patient. The columns included name, phone, responsible therapist, last treatment date, payment status, and free-form notes. That file was "the system." It sat on the office manager's desktop, and sometimes — when she was sick or on vacation — no one knew where things stood.

Treatment scheduling was done by phone only. A patient who wanted to book an appointment had to call, wait for someone to answer, check with the therapist, and get confirmation back. During peak hours, the office manager juggled 3-4 calls at once while manually updating the Excel file.

Reminders were sent manually via WhatsApp — one message, one patient, every single time. The office manager spent about an hour and a half each day just on reminders. On holiday eves or busy days, some reminders simply weren't sent, and the no-show rate spiked.

The monthly reports were a story of their own. At the end of every month, the office manager would sit for two full days — counting treatments per therapist, calculating payments, producing a summary. All manual, all in Excel, and all prone to errors.

In addition, each patient's treatment history was scattered across Excel notes, old WhatsApp messages, and physical notes. A therapist who wanted to know what happened in the previous session had to ask the patient themselves.

All in all, the clinic used four separate "systems":

1. Excel — patient management and reports
2. Phone — appointment scheduling
3. Manual WhatsApp — reminders
4. Notes and documents — treatment history

None of them talked to the others.

The Solution

We built a tailored clinic management system that replaces all four. The process took about three months from requirements document to launch.

Patient Dashboard

The system's central screen is a dashboard displaying all 400+ patients with advanced filtering and search options. Each patient receives a digital card with all the information: personal details, complete treatment history, payment status, the responsible therapist, and notes. The move from Excel to a dashboard means any team member can access the information from anywhere — not just from one specific computer.

We imported all the data from the existing Excel file, including cleaning and completing missing information. The data migration took a week, including checks that every patient was transferred in full.

Self-Service Appointment Scheduling

We built an appointment scheduling system that lets patients book appointments themselves via a personal link. The patient sees their therapist's available slots, chooses a time, and receives automatic confirmation. The system manages availability for each therapist individually, blocks off hours, and displays only what is relevant.

The result: 70% of appointments are now booked without human intervention. The phone still exists for those who prefer it, but it is no longer the bottleneck.

Automatic WhatsApp Reminders

We connected the system to the WhatsApp Business API. Each patient receives an automatic reminder 24 hours before the treatment, with the option to confirm or cancel with a click. If a patient cancels, the slot opens up automatically and is offered to other patients on the waiting list.

The office manager went from an hour and a half a day of manual sending — to zero. The reminders go out on their own, and the system records who confirmed, who canceled, and who did not respond.

One-Click Reports

We built a report engine that automatically generates everything that used to take two manual days:

• Monthly report per therapist: how many treatments, on which days, total hours
• Financial report: payments received, open debts, pending charges
• No-shows report: cancellation rates by therapist, by patient, and by day of the week
• Activity report: new patients, patients who completed treatment, patients who have not come in for two months

Each report is available with a click and can be exported to PDF.

Treatment History

Every treatment is documented in the patient's card — date, therapist, treatment type, notes, and progress tracking. A therapist opening the card sees the entire history on a visual timeline. No more notes getting lost.

The Results

After three months of working with the system, the numbers speak for themselves:

The office manager, who used to work two extra hours almost every day, now finishes on time. The therapists arrive at each session with all the information ready. And the patients get a service experience that feels like a large clinic, even though this is an independent practice.

One surprising finding: the reduction in no-shows saved the clinic far more money than we expected. With 400 patients averaging 4 treatments per month, a 10% drop in no-shows represents dozens of treatments per month that were no longer lost.

The Technology

The system was built with the following stack:

• Next.js — a fast UI with SSR, including full RTL support for Hebrew
• Supabase — a PostgreSQL database with Row Level Security, user authentication, and Realtime for live updates
• WhatsApp Business API — sending automatic reminders, receiving confirmations, and managing conversations
• Full RTL interface — the entire system is in Hebrew, fully adapted for right-to-left direction

We chose Supabase because of Row Level Security — each therapist sees only their own patients, the office manager sees everything, and the medical director gets report-only access. Permissions at the database level, not the code level.

The WhatsApp Business API required an approval process with Meta, which took about two weeks. But once the connection was up, it has worked reliably with send times of under one second.

What We Learned

1. Don't underestimate Excel. That file worked for years. It worked because the office manager knew every row. When building a new system, you need to respect the accumulated knowledge and make sure the system doesn't lose what Excel provided.

2. Data migration is a project in itself. A full week was spent just on cleaning, fixing, and transferring the data. Names with typos, phone numbers in different formats, dates in different formats — everything required attention.

3. WhatsApp is the natural communication channel in Israel. We also tried offering SMS and email. 95% of patients chose WhatsApp. It's the channel they check, it's the channel they trust.

4. Let the office manager lead the requirements document. She knows the processes best. In our case, she identified 12 edge cases we hadn't thought of — a patient switching therapists mid-treatment, couples' sessions, a last-minute cancellation that opens a waiting list.

5. Zero Excel is possible, but it takes time. There was a transition month where the new system and Excel ran in parallel. Only after the office manager felt confident did we shut down Excel entirely.

This project proved that even a relatively small business — 12 therapists, one manager — can benefit enormously from a tailored business system. Not because generic tools are bad, but because they don't talk to each other. One system that does everything — that's the solution.