How do I stop missing road tax and insurance renewals on our company vehicles?

Why renewals slip through a spreadsheet

Renewals slip because a spreadsheet records a date but never tells anyone the date is coming. Catching each one depends on somebody opening the right sheet in time, and every vehicle added to the fleet is another set of dates to catch.

The 280-vehicle rental and corporate fleet I built a system for had exactly this setup before go-live: the vehicle list, road tax dates, insurance renewals, workshop bills and loan instalments lived in separate spreadsheets. A missed renewal is rarely carelessness; it is a reminder nobody sent.

Three patterns make it worse as a fleet grows:

• Dates bunch up. Vehicles bought in the same month expire in the same month, so one busy week can hide several renewals.
• Responsibility is shared. When “admin” handles renewals, everyone assumes someone else checked.
• The renewal is recorded late, or not at all. If the new expiry date is not typed in after renewal, next year’s reminder is wrong.

Road tax and insurance are one chain, not two dates

Treat insurance and road tax as one job, done in order: insurance first, then road tax. The government portal lists active vehicle insurance as a condition for renewing a motor vehicle licence (road tax), so a lapsed policy holds up the road tax as well.

In practice, a reminder that arrives the week the road tax expires is too late if the policy has not been renewed yet. The useful date is whichever of the two expires first, and the reminder for it should go out early enough to cover both steps.

The same portal page lists a Puspakom inspection as an extra renewal condition for certain vehicles, such as commercial vehicles or vehicles more than 10 years old. If that applies to yours, it is one more date to keep beside road tax and insurance, checked before the road tax step; the vehicle registry in the system I build records it too.

A renewal routine that does not rely on memory

This routine works in a spreadsheet today, and it is the same logic a system automates later.

1. One row per vehicle. Plate, model, insurer and policy number, insurance expiry, road tax expiry, and the name of the person responsible.
2. A named owner for every renewal. A person, not a department. If that person is on leave, the row says who covers.
3. One fixed review slot each week. Sort by the earliest expiry and go through everything due in the next 90 days.
4. Escalate as the date gets closer. An early heads-up, a firmer reminder, then a final warning that also reaches the manager. An item due this week should not look the same as one due next quarter.
5. Close the loop. When a renewal is done, enter the new expiry date the same day and keep a copy of the new policy with the vehicle’s record.
6. Add vehicles on day one. A new vehicle gets its row the day it joins the fleet; a sold one is marked off, not deleted.

Steps 1, 2, 5 and 6 are discipline, and any fleet can do them this week. Steps 3 and 4 are where a spreadsheet still depends on someone remembering; a system sends the graded reminders every day instead, to whoever you choose for each, and to a manager as well if you want.

What a fleet renewal system changes

A fleet renewal system makes the dates come to people. The system I delivered for that 280-vehicle fleet keeps one record per vehicle, grades expiry reminders into four levels across insurance, road tax, servicing and instalment payments, and pushes one daily digest, plus separate alerts for anything urgent, to WhatsApp, Lark or Microsoft Teams. WhatsApp goes through Meta’s official Cloud API with a verified business sender. Nobody has to log in for a reminder to arrive.

	Spreadsheet	Fleet renewal system
Where the dates live	Several sheets, often several files	One record per vehicle
Who notices an expiry	Whoever opens the sheet	The system, every day
How people hear about it	Someone forwards a message	Daily digest and urgent alerts in WhatsApp, Lark or Teams
Urgency	Every row looks the same	Four levels that escalate as the date approaches
After renewal	Someone retypes the policy details	Upload the policy; OCR reads it and files it to the vehicle after a check
Cost	Free	One-time build, first phase from RM 8,000; no per-vehicle monthly fee

The client confirmed in writing that missed renewals went from under a hundred in the year before go-live to zero since. In the words of their supervisor: “The system paid for itself within the first few months. Renewals used to slip through the cracks, and now they don’t. It’s one of the few tools we’ve invested in that our team actually uses every day.” (Supervisor, a rental and corporate fleet company.)

The same system also cut document filing from a few hours a week to minutes, because staff photograph a policy and only check what the OCR read. Neither OCR nor the finance features are needed to stop missed renewals; a first phase of registry and reminders does that on its own. The details are in the fleet management case study.

This is not GPS tracking. A tracker tells you where a vehicle is; this keeps its paperwork and costs. The two solve different problems, and they can be used together.

When you don’t need a custom system

If you run fewer than five vehicles and one person handles every renewal, you do not need a system. A spreadsheet with the six steps above, plus each expiry date in that person’s phone calendar, is enough. The renewal reminder apps built for individual car owners also work at that size.

A system starts paying for itself when renewals depend on more than one person, when the list no longer fits on one screen, when a renewal has already been missed, or when you also want repairs, instalments and the true cost of each vehicle in the same place. That is the situation the system is built for: companies running roughly 5 to 300 vehicles on spreadsheets.

Between a spreadsheet and a custom build there is another step. If the fleet system I have already built fits the way you work as it is, I deploy it for you unchanged, from RM 3,999, one fixed price confirmed in writing at quote time. Nothing is customised, so it costs less than building the same system for you; if you want changes later, they are quoted separately. Under this option the code stays mine and your data is yours; what you may do with the code is set out in the quote.

Try it on your own list first

Before you decide anything, send me your vehicle list for a free Renewal Check. A photo of the Excel is fine, and plates can be blacked out because the check works on dates. Within one business day of starting your check, I send back every road tax and insurance renewal due in the next 90 days, with no call needed. The file is deleted after the check unless you decide to go ahead.

I take only two Renewal Checks a month, first come first served. If the month is full, I will tell you the date I can start yours.

If you would rather the reminders happened by themselves, the fleet management system page explains the first phase: vehicle registry and expiry reminders, in the RM 8,000 to 20,000 bracket on the pricing page. The price is fixed per milestone, you use it on a live demo before paying the balance, defects in what I built are fixed free for 90 days after handover, and the code and database are yours.