Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Our Clients' Motor Fleet Schedules Up to Date Without Endless Spreadsheets?
Problems We Solve

How Do We Keep Our Clients' Motor Fleet Schedules Up to Date Without Endless Spreadsheets?

Insurance brokers juggle fleet vehicle additions and deletions from client spreadsheets. We build a fleet portal that tracks each change through to the insurer.

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

Fleet schedules drift because clients send vehicle changes in emails and their own spreadsheets, the broker keys them to the insurer, and nobody reconciles the client's list with the insurer's schedule. We build a fleet portal where clients add and remove vehicles, each change flows through a tracked queue to the insurer, and the two lists are reconciled regularly so differences are found early.

Vans in, vans out, and three versions of the list

A client runs a fleet of vans and a couple of cars. Vehicles change all the time. The transport manager emails 'two new vans this week, regs attached', or sends an updated spreadsheet with changes highlighted in yellow, or rings on a Friday afternoon. The handler adds the vehicles on the insurer's portal or by email, and files the confirmation.

At renewal the insurer's schedule, the client's spreadsheet and the broker's file all disagree. There are vehicles the client sold months ago still listed, and one van that the client thought was on cover and the insurer has never heard of.

Why fleet lists drift apart

Fleet changes are frequent, small and informal. Each one is easy, but there is no single list that all three parties treat as the truth. Clients keep their own spreadsheet for their own reasons, insurers hold their schedule, and the broker sits in between with emails. Differences only surface at renewal or at a claim.

  • Changes arrive in different formats from different people at the client.
  • Deletions are reported less reliably than additions.
  • Insurer confirmations are filed but not compared back to the client's list.
  • Some fleet policies are rated on vehicle count or type, so the premium drifts too.

When the lists disagree

The worst case is a vehicle the client believes is insured when the insurer does not have it. How cover applies in that case depends on the policy and the insurer, and is not something any system decides. The more ordinary costs are hours spent at renewal reconciling lists, adjustment premiums missed, and a client who feels the broker is not on top of their fleet.

A fleet portal with a change queue

  1. Each fleet client gets a secure portal showing their current vehicle list as the broker holds it.
  2. The client's transport or office manager adds or removes vehicles on the portal, with registration, type, use, value and date, and can upload a spreadsheet of changes instead.
  3. Registrations can be checked against public vehicle data where available, so make and model are filled in and typos are caught.
  4. Each change enters a queue for the handler with a status, and is submitted to the insurer by portal, email or API.
  5. Insurer confirmations are matched back to the change, and the portal list updates once confirmed.
  6. On a regular schedule, the insurer's schedule is read and compared with the portal list, and any difference goes on a list for the handler.
  7. Premium adjustments from the insurer are logged for accounts to invoice or refund.

One list, checked against the insurer

QuestionTodayWith the portal
What vehicles are on cover?Depends who you askPortal list, reconciled with insurer
Has the new van been added?Search emailStatus shown on the portal
Sold vehiclesOften forgottenRemoved by client, confirmed by insurer
Renewal fleet listRebuilt from scratchAlready current

Fleet renewals afterwards

The renewal list is correct before renewal starts. The client can see their fleet as the broker holds it at any time, which removes the Friday afternoon calls asking whether a van is on. Handlers deal with differences as they arise rather than all at once. For clients on fleet rating by count or type, adjustments are captured as they happen.

Recognise your fleet clients?

  • Fleet changes come in by email, spreadsheet and phone.
  • At renewal, the client's list and the insurer's schedule disagree.
  • Sold vehicles stay on schedules for months.
  • Clients ring to ask whether a new vehicle is covered yet.

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

Do clients have to use the portal?

It is easiest if they do, but spreadsheets and emails can still be accepted and loaded into the queue by the handler.

Can it read insurers' fleet schedules?

Yes, from the formats they provide, such as PDF or spreadsheet. Each insurer's layout is set up once.

Does it confirm cover to the client?

It shows the status of each change. The confirmation of cover comes from the insurer, and the portal only marks a vehicle as on cover once that is received.

What affects the cost?

The number of fleet clients and insurers, how insurers accept changes, and how the portal connects to your broking system.

Keep reading

More on Problems We Solve

Start here

Tell us where your broking admin gets stuck

Describe the task, the broking system you use and where the time goes. We will tell you what we would build and what we would leave alone, and if a smaller change inside your current system would fix it, we will say so.

  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 →