# Car Rental Booking Tracker Excel (Free, Fleet)

> A free Excel car rental tracker: log your fleet and bookings, see cars out today, returns due, balances owed, utilisation by class and double bookings.

Source: https://softwiro.com/templates/car-rental-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Car Rental Booking Tracker for Excel

A free car rental booking tracker for Excel for a small rental business or a few cars you rent out. You list your cars once and write one row per booking: customer, car, pick-up and return dates, status, extras and what has been paid. The workbook works out the days, the total and the balance, warns you about overdue returns and double bookings, and shows on one Dashboard which cars are out today, who is due next and how busy each car class is this month. It works in Excel, LibreOffice and Google Sheets and in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-car-rental-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-car-rental-tracker-blank.xlsx)

Excel file (.xlsx) · 149 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| As of | 46342 | Change the date, the month and the currency on the Settings sheet. Update the booking status as cars leave and come back. |  |  |  |
| --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |
| Cars rented out today | 5 | Fleet utilisation this month |  | 30.3% |  |
| Cars available today | 6 | Booked value, pick-ups this month |  | 9,195.00 |  |
| Cars in the workshop | 1 | Bookings starting this month |  | 21 |  |
| Pick-ups due today | 1 | Average rental, days |  | 4.7 |  |
| Returns due today | 0 | Balance still owed by customers |  | 5,980.00 |  |
| Overdue returns | 1 | Rows that need a fix (Check column) |  | 0 |  |
| Car class | Active cars | Booked days | Utilisation | Booked value | Average daily rate |
| Economy | 2 | 12 | 20.0% | 457.00 | 39.00 |
| Compact | 3 | 26 | 28.9% | 1,374.00 | 50.00 |
| SUV | 2 | 21 | 35.0% | 1,814.00 | 79.00 |
| Van | 2 | 23 | 38.3% | 2,565.00 | 107.50 |
| Luxury | 2 | 18 | 30.0% | 2,985.00 | 142.50 |
|  |  |  |  |  |  |
| All classes | 11 | 100 | 30.3% | 9,195.00 |  |
|  |  |  |  |  |  |
|  |  |  |  |  |  |
| Next pick-ups and returns | Action | Booking | Customer | Car | Alert |
| 46340 | Return | 1030 | Dylan Ross | C07 | Overdue return |
| 46342 | Pick-up | 1037 | Fiona Bell | C09 | Pick-up today |
| 46343 | Return | 1034 | Carlos Vega | C12 |  |
| 46344 | Return | 1032 | Peter Nolan | C10 |  |
| 46344 | Pick-up | 1038 | George Mills | C05 |  |
| 46345 | Return | 1036 | Victor Han | C03 |  |
| 46345 | Pick-up | 1039 | Hana Sato | C11 |  |
| 46346 | Pick-up | 1040 | Ian Fraser | C02 |  |
| 46347 | Return | 1035 | Rachel Green | C06 |  |
| 46347 | Pick-up | 1041 | Jenna Cruz | C07 |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Cars rented and available today, pick-ups and returns due, overdue returns, utilisation for the month, booked value, the number of bookings, the average rental length and the balances still owed. Below it, utilisation and value by car class, the next 10 pick-ups and returns with an alert for each, bookings by status, booked value by month and charts.
- Bookings: One row per booking: customer, phone, car from a dropdown, pick-up and return dates, status (Reserved, Out, Returned, Cancelled), an optional rate override, extras and amount paid. The sheet works out the car, days, rate, total and balance, flags Overdue return, Return today, Pick-up today, Late pick-up or Double booking, and counts the booked days in the month. Room for 500 bookings.
- Fleet: One row per car: car ID, plate, make and model, class, daily rate and whether it is Active, In workshop or Retired. The sheet shows whether each car is Rented or Available now, its bookings, booked days, utilisation and booked value for the month, and its total booked value. Room for 60 cars.
- Lists: Your car classes (Economy, Compact, SUV, Van, Luxury in the sample), used in the Fleet dropdown and the class table on the Dashboard.
- Settings: Your business name, the currency symbol and the As of date, which decides what is overdue and which month the Dashboard shows.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most free car rental spreadsheets are a booking calendar or a list. This one links the list to the fleet: every booking takes its daily rate from the car, so you change a price in one place, and a double booking or an overdue return is flagged for you instead of discovered at the counter. The sample is a 12-car business through October and November 2026.

## How do I track car rental bookings in Excel?

Keep one list of cars and one list of bookings. A booking needs the car, the pick-up date, the return date and a status that you move along as the booking progresses: Reserved, then Out when the customer drives away, then Returned. Everything else is calculated from those fields.

In this template the rental days are the return date minus the pick-up date, with a minimum of one day, and the total is days times the daily rate plus extras. A rate override handles a negotiated price: in the sample, booking 1007 for a Ford Escape is charged at 72 a day instead of the car's 80. A cancelled booking is worth 0.

## How do I avoid double booking a rental car?

The Check column on Bookings flags two bookings of the same car whose dates overlap, ignoring cancelled ones. A return and a new pick-up on the same day are allowed, so a car can go out again the day it comes back. The sample has none, so no row is flagged.

Before you confirm a booking, pick the car and look at the Check column and at the Fleet sheet: a car that shows In workshop or Retired is not counted as available. The sample fleet has 12 cars, one of them (the Kia Sorento) in the workshop, so 11 cars are active.

## How do I know how busy my rental cars are?

Utilisation is booked days in the month divided by active cars times days in the month. As of 16 November 2026, 5 cars are out and 6 are available. November has 21 bookings worth 9,195 with an average length of 4.7 days, and the fleet is booked 100 days out of 330 possible, which is 30.3%. Vans are the busiest class at 38.3% and economy cars the quietest at 20.0%.

Reserved bookings count, so a month in progress shows what is booked, not only what has run. The Dashboard also shows what customers still owe: 5,980 across the sample, and one overdue return (Dylan Ross, due on 14 November). If you also keep service records, see [fleet fuel and maintenance](https://softwiro.com/templates/fleet-maintenance-log) and the [car maintenance log](https://softwiro.com/templates/car-maintenance-log).

## How to use it

1. On Settings type your business name, your currency symbol and the As of date (today). The month on the Dashboard is the month of that date.
2. On Lists edit your car classes (Economy, SUV and so on).
3. On Fleet add one row per car: car ID, plate, make and model, class, daily rate and whether it is Active, In workshop or Retired.
4. On Bookings add one row per booking: customer, phone, car ID from the dropdown, pick-up and return dates, status, any extras, and what the customer has paid. Leave the rate override empty to use the car's daily rate.
5. Change the status as the booking moves: Reserved, then Out when the customer drives away, then Returned. Use Cancelled for a booking that falls through.
6. Read the Dashboard for cars rented and available today, pick-ups and returns due, overdue returns, utilisation by class, balances owed and the next ten pick-ups and returns. The Check column on Bookings flags a double booking.

**Before you start:**

- Capacity: 60 cars and 500 bookings, 6 car classes. The Dashboard lists the next 10 pick-ups and returns.
- Rental days = return date minus pick-up date, with a minimum of 1 day. Total = days x daily rate + extras. A cancelled booking has a total of 0.
- A car shows as Rented today when it has a booking with the status Out. Change the status when the car leaves and when it comes back.
- Utilisation = booked days in the month / (active cars x days in the month). Reserved bookings count, so a month in progress shows what is booked, not only what has run.
- Booked value is shown by pick-up month: the whole booking is counted in the month the car leaves.
- Double booking: two bookings of the same car whose dates overlap (not counting Cancelled). A return and a new pick-up on the same day are allowed.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-car-rental-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-car-rental-tracker-blank.xlsx)

Excel file (.xlsx) · 149 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You check the Check column for overlaps | The system refuses a booking when the car is not free |
| One person updates the status | Staff mark pick-ups and returns on their phones with a photo |
| A daily rate per car | Seasonal prices, discounts and packages for extras |
| Customers are a name and a phone | A customer record with licence, history and deposits |
| Balances are a number on the sheet | Online payments and receipts sent to the customer |

### Extra features in the app

- Customers book online and see which cars are free for their dates
- A contract and a photo check-in and check-out for damage
- Reminders by SMS or email before pick-up and on the return day
- Prices that change by season, length of rental and car class
- Fines, fuel, mileage and deposits tracked per rental
- A phone view for the counter and the people handing over the keys

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this car rental tracker free?

Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

### How many cars and bookings can it hold?

60 cars, 500 bookings and 6 car classes. The Dashboard lists the next 10 pick-ups and returns. When the log is full, save a copy and start a new file.

### How does it decide a car is rented today?

A car shows as Rented when it has a booking with the status Out. Change the status to Out when the car leaves and to Returned when it comes back.

### Can I set a different price for one booking?

Yes. Type a daily rate in the rate override column and that booking uses it instead of the car's rate. Leave it empty to use the car's daily rate.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Free Excel templates for cars: showroom, rental, workshop and maintenance](https://softwiro.com/templates/for-cars)

More free templates for: Transport and cars

## More free templates

- Fleet Fuel and Maintenance Log Template for Excel
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Employee Leave Tracker Template for Excel
- Monthly Habit Tracker Template for Excel (With Streaks)
- General Journal and Trial Balance Template for Excel
- Delivery Tracking Spreadsheet for Excel (Dispatch Tracker)
- Real Estate Lead Tracking Spreadsheet (Excel)
- Production Tracking Spreadsheet for Excel
- Piece Rate Payroll Calculator for Excel
- Garment Costing Sheet for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
