Dispatch board or spreadsheet? A guide for chauffeur companies

Almost every chauffeur company starts on a spreadsheet, and many good ones stay there longer than they should. The sheet is free, everyone knows how to use it, and it bends to whatever the day needs. A dispatch board is what replaces it: a screen in dispatch software that lists every duty with its car, its chauffeur and its state. This guide is an honest comparison of the two, including the cases where the spreadsheet is still the right answer.

What a spreadsheet does well

Give the sheet its due. It costs nothing. A new column takes five seconds. It can be sorted, coloured and filtered in ways the owner understands completely, because the owner built it. For a company with three or four cars, one person taking bookings and clients who pay on the day, a shared sheet and a messaging group are a perfectly reasonable dispatch system. Software would add a monthly cost and a learning curve without removing a real problem.

Five signs the spreadsheet has stopped working

• Two people edit it at once. The moment bookings are taken by more than one person, rows are overwritten, and nobody knows which version the night dispatcher saw.
• A chauffeur has been given two jobs that overlap. The sheet did not stop it, because a sheet does not know that 14:00 to 17:00 and 16:30 to 18:00 clash.
• A car went out with an expired document. The expiry dates live on another tab, or in a folder, and nobody looked.
• The client asks where the car is and you phone the chauffeur. Every such call interrupts a person who is driving.
• Month-end billing takes days. Someone retypes each job from the sheet and from paper slips into invoices, and the corporate client disputes three of them.

One of these in a month is bad luck. Three of them is a system that has been outgrown. Our article on the hidden costs of spreadsheet dispatch looks at what each one costs.

What a dispatch board does that a sheet cannot

A dispatch board looks like a sheet at first glance: rows of jobs with times and names. The difference is that the board knows what the rows mean. It knows a duty has a start and an end, so it can refuse or flag a chauffeur who is already committed. It knows each car and chauffeur has documents with expiry dates, so it can warn before a lapsed limousine permit or licence goes on the road. It knows the time now, so a duty that should have started and has not is marked overdue instead of sitting quietly in row 40.

It is also the same record for everyone. The reservation a client made in the portal, the job the chauffeur sees on the phone, the position on the map and the line on the invoice are one thing looked at from four places. Nothing is copied, so nothing is copied wrongly. In MobilityDrive the board sits beside an allotment matrix, which shows duties against cars and chauffeurs, and an availability calendar. The fleet dispatch software page describes them.

The chauffeur's side: the job on the phone

With a sheet, the chauffeur gets a message with the details and replies when the job is done. With a board, the duty arrives in a driver app with the passenger's name, the pickup, the client's notes and any VIP tag. The chauffeur starts it, which tells dispatch without a call. The car appears on the live map, so the client can be sent a tracking link. At the end the chauffeur records kilometres, waiting, tolls and parking, and the passenger confirms on the phone.

That last step is where chauffeur companies recover the most time. A duty slip that exists the moment the job ends can be billed the same day. See digital duty slip software for chauffeur services for how the slip reaches the invoice.

Airport pickups: where the sheet fails first

A spreadsheet holds the scheduled arrival time. It does not know the flight is forty minutes late, or that it landed early. Somebody has to check each flight by hand, and on a busy evening somebody forgets. Dispatch software can hold the flight number, refresh the flight automatically and alert dispatch when it is late, cancelled, diverted or landed. In MobilityDrive that needs a flight data provider configured with your own key, and dispatch still decides whether to move the chauffeur. The chauffeur and limousine software page covers the airport flow.

A fair way to switch

• Do not migrate history. Load your cars, chauffeurs, clients and rates, and start with next week's bookings.
• Run one client or one service line on the board first, with the sheet still open for the rest.
• Enter the document expiry dates on day one. It is the dullest job and it pays back first.
• Agree a date when the sheet becomes read-only. Two live systems are worse than either one.
• After a month, compare: duties missed, calls to chauffeurs, and days from the end of the month to the last invoice sent.

The honest conclusion

If you run a handful of cars and bill on the day, keep the spreadsheet. If more than one person dispatches, if you have corporate or hotel accounts billed monthly, or if you do airport work in volume, the board will pay for itself in the mistakes it stops. To compare products once you have decided, use the criteria in fleet dispatch software alternatives: what to compare.