Anyone searching for an Excel template for company vehicle deadlines already knows what they want: a working sheet to use straight away. Here is the structure — columns, calculation rules, a useful order. Then the four situations in which the sheet stops being enough on its own.
The rules below are the Italian ones: the roadworthiness inspection (revisione), motor insurance (RC auto), the regional car tax (bollo) and scheduled servicing (tagliando).
The columns that matter
You do not need a sheet with fifty columns. You need one you can keep up to date. These are the ones that make the sheet work.
| Column | What goes in it |
|---|---|
| Plate | Vehicle identifier |
| Make and model | To know what it is without looking it up |
| Assigned driver | Who usually drives that vehicle |
| Inspection — next deadline | Date in YYYY-MM-DD format |
| Insurance — next deadline | Date |
| Car tax — next deadline | Date |
| Servicing — planned km | The mileage at which it is due |
| Current km | Updated at each refuel or check |
| Notes | Free text for things that do not fit the columns above |
Three optional columns that help in fleets with mixed contracts:
| Column | When it helps |
|---|---|
| Registration date | To work out the first inspection if there is no history |
| Contract type | Owned, long-term rental, leasing |
| Contract end | If the vehicle is not owned — the decision must be made months earlier |
The three calculation rules not to get wrong
Dates do not all update the same way. Using the wrong rule means putting a wrong deadline in the sheet.
Inspection: the next date is +2 years from the date the inspection was carried out, not from the previous deadline. Doing it late pushes all later ones forward too.
Car tax and insurance: the next date is +12 months from the previous expiry, not from the payment date. If the deadline was in March and you pay in August, the next one stays in March. Paying late does not move the anniversary — how Italian car tax is calculated explains it in detail.
Servicing: it depends on the manufacturer. The interval is in km or months, whichever comes first. On a vehicle doing 40,000 km a year, the kilometre deadline arrives twice before the time one.
The guide to company vehicle deadlines in Italy has every rule in detail, including tyres and end of lease.
Where it works well
An Excel sheet handles deadlines without trouble when:
- there are 3–5 vehicles and the deadlines are spread over a few months,
- one person keeps it up to date,
- that person is in the company and checks the sheet regularly,
- dates rarely change and exceptions are rare.
In those conditions a well-structured sheet does the job. It is not the wrong solution: it is the right one for that context.
Where it stops working
Sharing. If the file is on a PC, it only exists on that PC. If it is on OneDrive or a shared network folder, two people opening it at the same time risk overwriting each other. It is not the person’s fault — it is a limit of the format.
Automatic reminders. Excel does not warn you when the insurance is a month from expiring. You only see the deadline if you open the sheet and look for it. With ten vehicles whose inspections, car tax and policies expire in different months, waiting until you remember to check is the surest way to miss something.
The vehicle’s history. The sheet holds the next inspection date, not when you went, how much you spent, or that in September the mechanic found the rear brakes needed replacing. That memory is not in the sheet — or it is in a cell comment, which in practice is like not having it.
Continuity when someone changes. The person who managed the fleet for three years changes job. If the sheet was on their desktop, in their head, or in their own way of updating it, the fleet is left without memory. The company does not inherit the knowledge of whoever leaves: it inherits a file with some dates.
What to do with this
If you are starting now, use the structure above and get going. A sheet with these columns is already much better than a paper list or dates scattered in a calendar.
If the sheet works for your situation, keep it. There is no reason to change a tool that solves the problem.
If you realise one of the four situations above is already your reality — or that you spend more time checking deadlines than actually keeping them under control — the problem is not the sheet. It is that the fleet needs something that remembers on its own, is visible to whoever needs it and does not disappear with whoever managed it.
First, though, it is worth being clear on the rules the sheet has to apply: company vehicle deadlines are each calculated their own way, and two — the inspection and the car tax — follow rules that are the opposite of each other. A well-built sheet applying the wrong formula produces wrong dates with great precision.
Fleetly has a free plan that never expires, for up to 3 vehicles. Nothing to install, it runs in the browser — with the deadlines in your own calendar as well. The app interface is in Italian. The most direct way to know if it suits you is to try it on one vehicle.
Frequently asked questions
Which columns does a company vehicle deadlines spreadsheet need?
The vehicle record (plate, model, registration date), a last-done date and a next-deadline date for each obligation — inspection, insurance, car tax, servicing, tyres — plus the person responsible for checking each vehicle. The responsibility column is the one almost always missing, and without it the sheet produces no action.
Up to how many vehicles is an Excel sheet enough?
As long as one person updates it, opens it regularly and stays with the company. The number matters less than the structure: the sheet gives way on simultaneous sharing, lack of reminders, missing vehicle history and continuity when the person managing it leaves.
Why is an Excel sheet not enough for fleet deadlines?
Because it holds the data but does not communicate it: nobody opens a file to be reminded. A sheet can only tell you when the inspection expires if you go looking, and on the day nobody looks, the correct date in the sheet has prevented nothing.
Written and fact-checked by The Busy People. How we check our sources