In many UAE offices the company car keys hang in a cabinet at reception and are signed out in a notebook, when someone remembers. This free car key register turns that notebook into a proper key log: every key signed out to one named employee with a due-back time, an overdue flag, an inventory that shows who holds each key right now, an end-of-day count and a lost-key report. Download the Excel file with formulas or the printable PDF.
Free, no sign-up. Use the Excel file at the key cabinet or print the PDF register.
Pick the key tag from a drop-down list and the vehicle and plate are filled in. The status of each line is calculated: Out, OVERDUE once the due-back time has passed, or Returned. The inventory sheet shows every key that is out, who has it and since when, and counts the keys out, overdue and lost at the top. A key with an open lost-key report shows as Lost until the report is closed. No macros; example rows show how it works.
The register works a little differently for each kind of key:
When an employee leaves the company, check the register for any key still signed out to that person before the final settlement.
A key register records who took the key, not who drove the car. A colleague may drive while the key is signed out to someone else, a key may be copied, and the register says nothing about where the car went or how many kilometres it did. In the UAE, traffic fines are issued to the registered owner of the vehicle, which for a company car is the company, and they often arrive weeks later. To match them, you need trip times and the driver: that is what a vehicle log book adds.
If you are deciding between an electronic key cabinet and a phone key, read our comparison of key management systems for UAE fleets.
With CT Mobility the key disappears from the daily routine. Employees book a company car in your branded app, pass a selfie liveness check and unlock the car with the phone, so there is no key to hand over, chase or lose. Booking rules decide who may use which vehicle, on which days and at what times, and every trip is recorded with the driver, time, route and mileage.
Tracking is included and the driver is known on every trip, for AED 50 per vehicle per month, and you can start with a pilot for up to 2 vehicles with no subscription fee for 3 months; only the hardware, installation and mobile data are paid. See how the phone key compares with a key cabinet, and read about pool car management and the vehicle booking system. For the moment a car changes hands, use the free vehicle handover form.
Pilot for UAE companies: we connect up to 2 of your vehicles with no subscription fee for 3 months, so you can judge the results on your own operations before any commitment. Only the hardware, installation and mobile data are paid. Go live in about 15 days.
CT Mobility Solutions F.Z.C. · E-Commerce Hub BC-8, Ajman Free Zone C1 Building, Ajman Free Zone, Ajman, United Arab Emirates
Yes. The Excel and PDF files are free to download and use, and you do not need to sign up.
A key register, or key log, records every time a key leaves and returns: which key, which vehicle, who took it, when it is due back and when it came back.
At the end of every working day. Every key in the inventory should be either on its hook or signed out in the register; anything else is chased the same day.
Record it in the lost-key report at once, use the spare key if needed and let the fleet office decide whether the lock or immobiliser must be reprogrammed.
No. It shows who took the key. To know who drove and when, keep a vehicle log book or use trip records with the verified driver.
With CT Mobility, employees unlock company cars by phone after a selfie check, so day-to-day key handovers are no longer needed. You can test it in a pilot for up to 2 vehicles with no subscription fee for 3 months; only the hardware, installation and mobile data are paid.
We have repeatedly proven this in practice with dozens of launched projects and years of successful work. Ask our clients who have tried several IT solutions but still remain with us.
