The problem
When the schedule is on paper, customers get booked with someone who is off.
The rota is pinned in the staff room, commission lives in a separate spreadsheet and everyone shares one login. Month end takes hours and ends in arguments.
- Bookings for a doctor who is off
- Commission added by hand, missed orders upset staff
- Shared logins, no idea who changed what
The usual way
- 1Export orders from the cashier software
- 2Work out who did each order
- 3Type commission % into Excel
- 4Check against the paper schedule
- 5Send each person their figure
5 steps, 3 files, orders get missed
