Budget and cost · Free Excel and Word template

Fleet Insurance Renewal Pack

Prepare your fleet insurance renewal 90 days ahead. The Excel workbook holds the vehicle schedule, a five-year claims history (loss run), claims frequency and loss ratio by policy year, your risk controls with figures, a weighted quote comparison and a renewal timeline. The Word file is a fleet risk presentation for your insurer or broker.

Free: enter your name, email and job title and we email you the file. The workbook works in Excel, Google Sheets and LibreOffice Calc with no macros; the presentation opens in Word, Google Docs and LibreOffice.
  • Loss run and 5-year summary
  • 3-page risk presentation
  • 90-day renewal timeline
safee-fleet-insurance-renewal-pack-en.xlsx
Policy yearVehiclesPremiumClaimsPer 100 vehiclesNet incurredLoss ratio
20213461,00012.914,20023.3%
20223666,00025.611,40017.3%
20233870,50025.328,00039.7%
20244074,00012.59001.2%
20254178,50024.938,10048.5%
Example data. Policy years start on the renewal date, 1 December. Amounts in the currency you choose on Settings.
What's in the pack

Everything an insurer asks for, in one file

Renewal goes better when you send a complete, consistent file early, rather than answering questions one email at a time. This pack collects the facts once and turns them into a short presentation of your fleet risk.

  1. 01

    Vehicle schedule

    Plate, region, make, model, year, body, seats or GVW, use, sum insured, cover, agency repair, geographic extension, tracker, camera, overnight parking, added and removed dates. Age and "insured at renewal" are calculated.

  2. 02

    Claims history (loss run)

    Claim number, date of loss, vehicle, driver, type, fault, paid, outstanding, recovered, net incurred, status and the action taken. The policy year comes from the date of loss.

  3. 03

    Year summary

    Five policy years: vehicles, premium, claims, at-fault claims, frequency per 100 vehicles, net incurred, average severity, loss ratio, open claims and a chart. Plus the fleet at the renewal date.

  4. 04

    Risk controls

    Tracking, speed alarms, driver scoring, cameras, training, maintenance, journey management and accident reporting: since when, records held and a last-12-month KPI.

  5. 05

    Quote comparison and timeline

    Three quotes on nine terms with weights and scores, an estimated annual cost and a rank. Eleven renewal tasks from 90 days out, with due dates and overdue flags.

  6. 06

    Word: fleet risk presentation

    Eight sections on three pages: company and fleet, operations, drivers, safety program, telematics data, claims and actions, cover requested, contact and attachments.

What information do insurers ask for at fleet insurance renewal?

Requirements differ by insurer and country, so ask your broker or insurer for their list. As one published example, QBE's commercial motor minimum information guideline (Australia) asks for:

  • A vehicle schedule: make, model, year and registration for each vehicle, where it is based, and the sum insured.
  • Claims history: five years as the standard, with three accepted in some cases, as a dated report from the current insurer showing the incurred cost of each claim.
  • Fleet numbers and excesses for the same five years, the cover type, and the goods carried.

The pack covers these, and adds what sets your fleet apart: the risk controls you run and the figures that show they work.

How to use the fleet insurance renewal pack, step by step

  1. 90 days before renewal: enter the renewal date, update the vehicle schedule and request the five-year claims report from your current insurer.
  2. 75 days before: copy each claim into the claims history, and enter vehicles and premium per year on the Year summary.
  3. 60 days before: fill in the risk controls with a last-12-month KPI each, then the Word risk presentation, and send the file to your broker or insurers.
  4. 30 days before: enter the quotes as written on the Quote comparison sheet, score them, and ask about anything unclear.
  5. At renewal: share the certificates and update the insurance expiry date in your fleet records and your Fleet Incident and Claims Log.

How does the pack calculate frequency, loss ratio and quote scores?

Policy year = year of loss, minus 1 if the loss is before the renewal day and month Net incurred = paid + outstanding − recovered Frequency per 100 = claims ÷ average vehicles insured × 100 Average severity = net incurred ÷ claims Loss ratio = net incurred ÷ premium Premium score = 5 × lowest premium ÷ this premium (excess scored the same way) Weighted score = Σ (weight × score) ÷ Σ weights Estimated annual cost = premium + excess × average claims per year (last 3 years)

The loss ratio here is your own estimate from your records; an insurer may calculate it differently, for example with its own reserves. Scores other than premium and excess are your judgment from 1 to 5, and the weights are examples you change to fit your priorities.

Worked example: a 41-vehicle fleet

A fleet with a 1 December renewal records eight claims over five policy years.

  • Over five years: 8 claims, 5 at fault, net incurred 92,600 against premiums of 350,000, a loss ratio of 26.5%.
  • The latest year, 2025: 2 claims for 41 vehicles, 4.9 per 100 vehicles. One rear-end claim of 31,000 paid plus a 4,500 reserve gives net incurred 35,500; with a 2,600 third-party property claim the year totals 38,100, a loss ratio of 48.5%. The presentation explains the action taken after the large claim.
  • Three quotes: A at 76,000 with a 1,000 excess, B at 71,500 with 2,000, C at 79,000 with 500. With 1.7 claims a year on average, the estimated annual cost is 77,667, 74,833 and 79,833.
  • With the example weights, C scores 4.66 out of 5 for agency repair, injury limits and faster claims, ahead of A (3.68) and B (2.78). The cheapest quote ranks last; the decision is yours.

Common mistakes at fleet insurance renewal

  • Starting a month before. The claims report alone can take weeks to arrive.
  • An out-of-date vehicle schedule. Sold vehicles still insured and new ones missing cost money both ways.
  • Claims without context. A large claim with no explanation of what changed afterwards reads as a risk that remains.
  • Controls without figures. "We have tracking" says less than "speeding events per 1,000 km fell from [x] to [y]".
  • Choosing on premium alone. Excess, agency repair, limits and claims service change the real cost.
  • Ignoring open claims. Reserves on open claims count in the loss ratio until they close.

What the pack does not do

It does not predict your premium, and it does not promise to lower it: insurers set prices on their own criteria. Compulsory motor insurance rules are set by the authority in your country, so check your authority's current requirement. The figures you present must match your records; write only what you can show. The pack is a working tool, not insurance advice. To estimate the cost of a single accident beyond what insurance pays, use the Road Accident Cost Calculator.

Related Safee solution

Show your insurer data, not promises

The risk controls section needs figures, and Safee reports produce them. The RAG report scores and color-codes each driver from harsh acceleration, braking, speeding and seatbelt events. The Best Drivers report ranks drivers each month. The Alarm report lists every alarm by vehicle and driver. After an accident, the Second by Second report shows speed, RPM and acceleration before the event, and the V-iVMS video add-on keeps alarm video evidence.

  • RAG report with driver scores and color thresholds you set.
  • Best Drivers report by month, by driver or vehicle.
  • Second by Second report for accident investigation.
  • V-iVMS video evidence for configured alarms.
FAQ

Questions about fleet insurance renewal

Want driver scores and alarm figures ready for your next renewal? Talk to Safee.

What is a loss run in fleet insurance?

A dated report from your insurer listing every claim in a period with its date, type, amounts paid and reserved, and status. Insurers quoting your fleet usually ask for several years of it; QBE's published guideline asks for five, with three accepted in some cases. The Claims history sheet holds the same data in your own file.

When should I start preparing a fleet insurance renewal?

About 90 days before the renewal date. The timeline in the pack starts there: schedule and claims report first, then the risk presentation at 60 days, quotes at 45 days and a decision two weeks before renewal.

How is the claims frequency calculated?

Claims in the policy year divided by the average number of vehicles insured, times 100. It lets you compare years when the fleet size changes.

Will this pack lower my premium?

It cannot promise that. Insurers set prices on their own criteria. The pack helps you present complete, accurate information and compare quotes on more than price.

What goes in a fleet risk presentation?

Company and fleet profile, operations and routes, drivers, the safety program with figures, a telematics data summary, claims analysis with the actions taken, the cover you want, and contacts. The Word file has all eight sections with guidance.

Can I compare quotes from more than three insurers?

The sheet has three columns. For more, copy the sheet, or compare the best three after a first screen on price and excess.

Does the template work in Google Sheets and Google Docs?

Yes. Upload the .xlsx and .docx files to Google Drive and open them there. They also work in Excel, Word and LibreOffice, with no macros.

Next step

Bring figures to your next renewal

Tell us your renewal date, and we will show you the Safee driver score, alarm and accident reports you can use in your risk presentation.

Related tools and templates

Manage claims and driver risk all year

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top