Free Excel template · Fleet, maintenance & bookings

Fleet Management Spreadsheet

Enter your vehicles and get an Excel workbook with the formulas already in place: inspection, insurance, registration and service alerts, a trip log, a booking calendar and cost per vehicle. Free · sent by email as an .xlsx file · no account needed.

Updated Nov 18, 2026 · .xlsx for Excel, LibreOffice and Google Sheets

Step 1 of 3 · Settings

Settings

Shown at the top of the workbook.

Distance unit

Used to format every amount in the workbook.

Sheets in the workbook

Always included: the other sheets are built on it.

Also adds the trip log, maintenance and expenses sheets, whose amounts it adds up.

While you type, nothing leaves your browser (only requesting the workbook sends it to our server). If checked, your entries survive a page reload until you close the tab.

Your vehicles (1 / 50)

Enter what you have to hand: any empty field can be completed later in the workbook.

Vehicle 1

The interval that applies to this vehicle where you operate (1 to 120 months). Leave empty if none.

From the manufacturer's maintenance schedule for this vehicle.

Get the Excel workbook by email

By continuing, you agree to Lexio's legal notice and privacy policy.

Check your answers

Settings
Company
not filled in
Unit · currency
mi · USD
Sheets
6 of 6
Vehicles
Vehicles entered
not filled in
Plates
not filled in

The preview is free and complete. The .xlsx workbook (Excel, LibreOffice, Google Sheets) is sent to you by email: that is currently the only way to get it from this tool.

Where does my data go?

Your entries stay in your browser until you request the workbook. When you do, the list of vehicles is sent to our server, which builds the file and emails it to you; the vehicle list is not kept afterwards. See our privacy policy.

Due dates are only as good as what you enter. Inspection dates come from your last inspection and the interval you set; renewal dates are the dates you type. Check them against the rules where you operate. Template updated Nov 18, 2026.

Workbook preview

8 sheets, formulas included · 0 vehicles entered

PlateVehicleNext inspectionInsurance renewalRegistration renewalNext serviceAlert
ABC-1234—————OK

Due dates, days left and alerts recalculate every time the workbook is opened.

A workbook built around your fleet. Not an empty file to download: your vehicles are already in it, with their due dates calculated. Need a record for one vehicle at a time? See our printable vehicle maintenance log for a single vehicle (Word & PDF).

What's in this fleet management spreadsheet?

One workbook, up to eight sheets, linked by the vehicle's plate number: what you enter in one place feeds the calculations in the others.

  • Fleet — one row per vehicle: plate, VIN, make, model, ownership, monthly cost, insurance, odometer, and the due dates with days left and an alert column.
  • Trip log — one row per trip: date, driver, start and end odometer, distance, destination, business purpose, fuel.
  • Bookings and Calendar — bookings you enter mark a vehicles × days calendar; change the month in one cell.
  • Maintenance — services and repairs, vendor, cost and the next due date or odometer reading.
  • Expenses — fuel, tolls, parking, tickets, car washes, with amount before tax, sales tax or VAT, and total.
  • Cost per vehicle — total cost and cost per mile (or km) for each vehicle, calculated from the other sheets.
  • How to use — the instructions, the alert thresholds and the limits of the workbook.

Fleet maintenance spreadsheet: services, inspections and renewals

A vehicle maintenance spreadsheet is only useful if it warns you before something is due. For each vehicle, the Fleet sheet calculates:

  • the next inspection, from the date of the last one and the interval in months that you enter (EDATE adds the months to the date);
  • the days left before the insurance renewal and the registration or vehicle tax renewal, from the dates you enter;
  • the next service, from the odometer reading at the last service and the manufacturer's service interval, and the miles (or km) left before it.

The Alert column then shows the most urgent item: an inspection first, then the insurance renewal, the registration renewal and the service. It flags anything overdue, any date less than 30 days away and any service less than 1,000 miles (or km) away. Those thresholds are settings of the workbook, not legal rules, and you can change them in the formula.

Why the inspection interval is yours to enter

Inspection rules depend on where the vehicle is registered, so the workbook does not hard-code any. In Great Britain, the MOT is due by the third anniversary of the vehicle's registration, then every year, and you can test up to a month (minus a day) early and keep the same renewal date (GOV.UK). In the United States, each state sets its own safety and emissions inspection rules. Enter the interval that applies to each vehicle, or leave it empty if there is none.

Prefer a paper record kept with each vehicle? Use our printable vehicle maintenance log for a single vehicle (Word & PDF).

Mileage and trip log

The Trip log sheet takes one row per trip: date, plate, driver, start and end times, start and end odometer, destination, business purpose, fuel added and fuel cost. The distance is calculated for you, and the Cost per vehicle sheet adds it up for each plate.

If you deduct car expenses, the IRS (Publication 463) asks you to record the mileage for each business use, the date, the destination and the business purpose; the trip log has a column for each. It also asks for the total miles for the year, so note each vehicle's odometer at the start and end of the year. The workbook is a way to keep those records, not tax advice. The log also answers a practical question when a parking ticket or toll notice arrives weeks later: who was driving that day.

Booking calendar for a rental fleet

Enter each booking in the Bookings sheet: start date, end date, plate, customer or driver, status. The Calendar sheet shows the chosen month with one vehicle per row and marks every booked day with COUNTIFS. Nothing to color by hand, and you change the month in a single cell (B1).

A spreadsheet will show two bookings on the same day, but it will not stop you from entering them. That is the first limit rental companies hit.

Cost per vehicle and cost per mile in Excel

The vehicle that costs least to buy is not always the one that costs least per mile. For each plate, the Cost per vehicle sheet calculates:

  • Fixed annual cost = monthly cost (lease payment or depreciation) × 12 + annual insurance;
  • Maintenance = SUMIFS of the Cost column in the Maintenance sheet for that plate;
  • Expenses = SUMIFS of the Total column in the Expenses sheet for that plate;
  • Total cost = fixed annual cost + maintenance + expenses;
  • Cost per mile (or per km) = total cost ÷ distance from the Trip log.

The result is only as complete as the rows you enter. Because the fixed cost is annual, keep one workbook per year (or per period) so the figures stay comparable.

When a spreadsheet is no longer enough

A spreadsheet works for a few vehicles managed by one person. The limits come with bookings that overlap, a file edited by several people, alerts nobody opens, and vehicle condition photos you cannot attach. For a rental business, that is the point to move to car rental software: Lexio's booking calendar prevents double bookings, maintenance alerts work by mileage or by date, a vehicle with an overdue service can be blocked from booking (an optional setting), and profitability is tracked per vehicle. Lexio imports your Excel file, so you start from your own data.

See how this works for a whole fleet on our rental fleet management software page. For check-out and return, use the free vehicle inspection form template.

Frequently Asked Questions

Does this fleet management spreadsheet work in Google Sheets and LibreOffice?

Yes. The file is a standard .xlsx workbook: it opens in Microsoft Excel, LibreOffice Calc and Google Sheets. The formulas it uses — IF, AND, OR, EDATE, MONTH, TODAY, SUMIFS, COUNTIFS and N — exist in all three, so the alerts, the booking calendar and the cost per vehicle recalculate when the file is opened.

Can I use miles or kilometers?

Both. Choose the distance unit in the settings before you get the workbook: every odometer, service interval, distance and cost-per-distance column is labeled with that unit (mi or km).

Which currency does the spreadsheet use?

The one you pick: US dollar, pound sterling, euro, or no currency symbol at all. The symbol is written into the number format of every amount column; you can change it later in Excel with Format Cells.

How do I calculate cost per mile in Excel?

Add up everything the vehicle cost over a period — fixed costs (lease payment or depreciation, insurance) plus maintenance and running expenses such as fuel, tolls and parking — then divide by the miles it covered over the same period. In the workbook, the Cost per vehicle sheet does this for each vehicle with SUMIFS on the plate number, reading the Maintenance, Expenses and Trip log sheets.

When is a vehicle’s MOT due in the UK?

In Great Britain, a vehicle needs its first MOT by the third anniversary of its registration, then by the anniversary of its last MOT once it is over 3 years old; some vehicles need their first test at one year old. An MOT lasts a year, and you can get it up to a month (minus a day) before it runs out and keep the same renewal date. Northern Ireland has different rules. In the workbook, enter the date of the last MOT and an interval of 12 months. For a vehicle that has not had its first MOT yet, enter its registration date and an interval of 36 months. The expiry date printed on the MOT certificate is the one that counts: check the workbook’s date against it.

How often do vehicles need an inspection in the US?

There is no single national rule: in the United States, safety and emissions inspections are set by each state. Check your state’s DMV or motor vehicle agency, then enter the interval that applies (in months) for each vehicle. If a vehicle has no periodic inspection, leave the interval empty and no inspection alert is raised.

How many vehicles can the workbook hold?

You can enter up to 50 vehicles on this page; the Fleet sheet then adds 20 blank rows with their formulas ready, and each log sheet (trip log, bookings, maintenance, expenses) has 300 rows. Rows you add below them are still counted, because the totals and the calendar read whole columns: just copy the Distance formula (Trip log) or the Total formula (Expenses) down. For more vehicles than the blank Fleet rows, copy the last Fleet row down, then do the same in the Calendar and Cost per vehicle sheets.

Is this Excel template really free?

Yes. There is no account to create and the preview on this page is complete. The .xlsx workbook is sent to the email address you enter: that is currently the only way to get it.

Methodology and limits

This generator, version 1.0.0, updated Nov 18, 2026, builds the workbook on our servers from the vehicles you enter, and nothing else.

  • inspection due dates come from the last inspection date and the interval you enter; no local rule is built in;
  • insurance and registration renewal dates are the dates you enter;
  • alert thresholds (30 days, 1,000 miles or km) are workbook settings, not legal rules;
  • cost per vehicle only adds up the rows filled in;
  • no vehicle data is kept after the file is sent.

Sources

This page is published by Lexio, maker of car rental software for professional rental businesses. See the features, check pricing or ask us a question.