Free Excel template · Fleet, maintenance & bookings
Fleet Management Spreadsheet
Updated Nov 18, 2026 · .xlsx for Excel, LibreOffice and Google Sheets
Step 1 of 3 · Settings
Get the Excel workbook by email
Enter at least the plate, make or model of one vehicle.
By continuing, you agree to Lexio's legal notice and privacy policy.
Check your answers
- Company
- not filled in
- Unit · currency
- mi · USD
- Sheets
- 6 of 6
- 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.
Workbook preview
8 sheets, formulas included · 0 vehicles entered
| Plate | Vehicle | Next inspection | Insurance renewal | Registration renewal | Next service | Alert |
|---|---|---|---|---|---|---|
| ABC-1234 | — | — | — | — | — | OK |
Due dates, days left and alerts recalculate every time the workbook is opened.
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.
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.