Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Replace the Spreadsheet Our Clients Use to Book Their Pool Cars and Vans?
Problems We Solve

How Do We Replace the Spreadsheet Our Clients Use to Book Their Pool Cars and Vans?

Fleet management clients book pool cars on spreadsheets and keys go missing. We build a pool booking system with licence checks, key handover and usage data.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Pool vehicles at client sites are booked on a shared spreadsheet or calendar, keys sit in a reception drawer, and nobody knows who drove what when a fine or damage appears. We build a pool booking system where only cleared drivers can book, keys are handed over against the booking, pre-use checks and mileage are recorded, and each client can see how their pool vehicles are really used.

A calendar, a drawer and a mystery dent

A client has six pool cars at their head office. Staff book them on a shared calendar. Keys are in a drawer at reception. On Tuesday, two people turn up for the same car because one booked it in the calendar and the other just took the keys. On Thursday, someone notices a dent on the rear bumper. Nobody knows who had it last. A parking notice arrives a fortnight later for a date when three people used that car.

The client asks you, as their fleet manager, to sort it out.

Why pool vehicles become unmanaged

Pool vehicles have no single driver, so everything that normally hangs off a driver, like checks, responsibility and records, is missing.

  • Anyone can book, including staff whose licence has not been checked.
  • Bookings and actual use do not match.
  • Keys are handed out without recording who took them.
  • Nobody does a check before driving, so defects and damage are found later.
  • Mileage and fuel are not recorded per trip.

The cost of unmanaged pools

Damage and fines that cannot be traced to a driver. Staff driving without the checks the client requires. Pool vehicles that sit unused while others are overbooked, or too few vehicles because nobody can see demand. And clients who cannot answer basic questions about their own pool.

The pool booking system we build

  1. Staff book pool vehicles from a web page or phone, and only drivers cleared by the client's licence check process can book.
  2. At collection, the driver confirms the booking and takes the key, either from reception against a scan or from a key cabinet that releases it to that booking.
  3. A short pre-use check on the phone records the vehicle's condition, fuel and mileage, with photos of any damage.
  4. On return, the driver records mileage, fuel and any issues, and the key is returned against the booking.
  5. Every booking becomes an allocation record, so fines, damage and fuel card use can be traced to the driver who had the vehicle.
  6. The client sees utilisation per vehicle and site, which shows whether the pool is the right size.
QuestionBeforeAfter
Who had the car on a date?GuessworkBooking and key record
Is the driver cleared?Not checkedChecked at booking
When did the damage happen?UnknownPre-use and return records
Is the pool the right size?UnknownUtilisation per vehicle

Keys without a key cabinet

A smart key cabinet helps, but many sites do not have one. Without it, reception scans a tag on the key against the booking in a couple of seconds, or the driver does it themselves. Either way, the handover is recorded. Where a site already has a cabinet with an API, we connect it.

Pool vehicles with a clear history

On a normal morning at the client's head office, a sales executive books the estate car for a customer visit from her phone the night before. Reception scans the key to her booking at 8am. She spends a minute on the pre-use check and photographs a scuff on the rear bumper that is not on the record. The system shows it was not reported at the previous return, so the fleet contact knows exactly which booking to ask about, while it is still fresh in everyone's memory.

Double bookings stop. Only cleared drivers drive. Damage is found at the pre-use check of the next driver and traced to the previous booking. Fines go to the right person. And the client can see from real data whether they need more pool vehicles, fewer, or a different mix.

Is this your client's pool?

  • Pool vehicles are booked on a shared spreadsheet or calendar.
  • Keys are kept in a drawer with no record.
  • Damage and fines cannot be traced to a driver.
  • Anyone can book, whether their licence has been checked or not.
  • Nobody knows how often each pool vehicle is used.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this need a key cabinet?

No. Scanned key tags work on their own. Existing cabinets with an API can be connected.

Can it link to our licence check process?

Yes. Only drivers cleared under the client's rules can book.

Can client staff book from Outlook?

Bookings can be sent to their Microsoft 365 or Google calendars. The booking itself happens in the system so the checks apply.

What about vans with tools on board?

The pre-use check can include the equipment carried, so missing items are found at handover.

What drives the cost?

The number of clients, sites and vehicles, key handling and how we connect to your fleet system and licence check process.

Keep reading

More on Problems We Solve

Start here

Tell us how you run your client fleets

Describe how many clients and vehicles you manage, the fleet system you use and where your team spends time on admin. We will tell you what we would build and what we would leave alone, and if your fleet software already does it, we will show you where.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →