What is a car rental fleet workbook?
A car rental fleet workbook keeps the three things a rental office needs to know about every car: where its documents stand, what each rental earned and cost, and how many of its available days it was actually rented. Many small and mid-size rental fleets keep this in separate lists, so a fine arrives months later with no easy way to tell who had the car, and a car that sits idle at one branch goes unnoticed.
This car rental fleet management Excel template links the lists. An agreement knows the car's category, rate and tank size; utilization knows the agreements and the downtime; a fine knows which agreement covered that minute.
How the workbook calculates charges and utilization
Every result is a visible formula in the gray cells. Rates, allowances, fuel price, grace hours and targets are inputs on Settings.
Rent counts in the month in which the car was on rent, day by day. Excess km, fuel and damage count in the month of return. For an agreement still open, days run to the as-of date.
Worked example: a 12-car fleet in September 2026
The example fleet has four categories at two branches, with 63 agreements from late August to the end of September. The as-of date is 30 September at 18:00. These are figures from the file:
- Agreement RA-2602: an economy car out for 5 days at 40 USD a day. It drove 1,550 km against an allowance of 5 × 250 = 1,250 km, so 300 excess km × 0.12 = 36.00. It came back at 6/8 of a tank: 2/8 × 42 litres = 10.5 litres × (0.60 + 0.20) = 8.40. Total 200 + 36.00 + 8.40 = 244.40, and the balance on a 400 deposit is 155.60.
- Agreement RA-2607 came back 5 hours after the planned return. With a 1-hour grace period (example), it is charged 6 days instead of 5.
- Fleet utilization in September: 237.0 rented days out of 338.3 available days = 70%. Four cars are below the 70% target. CAR-10 has been waiting for parts since 21 September, which takes 9.75 days out of its available days.
- A 100 USD traffic fine on CAR-05 at 07:40 on 12 September matches no agreement: the car was at the body shop. The file marks it as a company cost. Four other fines and tolls, 296 USD with admin fees, are waiting to be recharged.
- CAR-09 is 6 years old against a 5-year limit (example), and CAR-05 is on rent with a periodic inspection that expired on 20 September. Both are flagged on the Fleet sheet.
Saudi car rental rules: what the file records and what you check
The workbook does not decide what the law requires. Each rule is a value on Settings with the source we found and a cell for the date you checked it:
- Electronic contract. The Transport General Authority required rental facilities to issue contracts through its Tajeer portal as a unified electronic contract, in phases from 25 July 2021 (SPA via Al-Madina, 7 June 2021; Argaam reported the third phase through the Naql platform in November 2021). The Agreements sheet has a column for the e-contract number.
- Maximum car age. Sabq reported in August 2018 that the rental regulation then published set 5 years from the year of manufacture. Okaz reported in August 2025 a TGA draft proposing 5 years, and 8 for clean-energy cars. The file uses 5 as an example only.
- Late return. Grace hours come from your contract. Sabq's 2018 report said a full day's rent was added after four hours late; the file's default is a 1-hour company example.
- Fines during the rental. How you recharge fines and tolls, and any admin fee, comes from your contract with the customer.
Check the Transport General Authority's current requirement for each of these, or your own authority outside Saudi Arabia.
How to use the car rental workbook
- Settings first: currency, as-of date, report month, category rates and km allowances, fuel price and the rules table.
- Register each car with its category, branch, model year, tank size and document dates.
- Open an agreement at check-out with time, odometer, fuel and planned return, and close it at return with the same readings and any damage.
- Record every downtime period, including cleaning and preparation days, so utilization reflects the days a car could really be rented.
- Enter fines with their exact time. The file finds the agreement; recharge it and update the status.
- Review utilization each month. A car below target for several months is a candidate to move to another branch or to sell; the fleet vehicle replacement calculator helps with that decision.
Where tracking data replaces manual readings
Odometer and time readings at check-out and return are the inputs most often disputed. With a tracking device in each car, they come from the vehicle's history instead of a hand-written note. In Safee, geofence entry and exit alarms show when a car leaves or reaches a branch or a permitted area, the Vehicle out of work zone report lists cars driven outside approved areas outside working hours, and immobilization commands are a separate permission you give only to named administrators.
Common mistakes in rental fleet records
- Fuel recorded as "full" or "not full". Eighths of a tank turn into litres and a charge you can explain to the customer.
- Utilization against calendar days. A car in the workshop was not available; take downtime out first.
- Fines matched by date only. A car can change hands on the same day. Match by time.
- Documents tracked per branch. One register for the whole fleet shows every expiry in one place.
- Old cars kept on rent. Check each car's age against the current limit, not the year it joined.
What the workbook does not cover
This is a generic Excel template, not rental management software or an accounting system. It does not issue contracts, take payments or replace the authority's e-contract platform. Revenue here is day rent plus return charges, not accounting revenue. The figures are examples for a 12-car fleet in USD; replace them with your own. For every regulated item, check your authority's current requirement.