RecordKeep these fieldsAvoid
Driver
Licence class and expiry, approved vehicle types, availability, supervisor and any restriction.
Assuming a person can drive every vehicle simply because their name is in the list.
Vehicle
Vehicle, location, responsible person, availability, current driver, odometer, next service, document expiry, open note.
An enormous master table containing every trip, expense, and inspection history.
Checkout and return
Purpose, driver, dates, status, starting and ending mileage, fuel, condition, and next action.
A calendar booking that never proves custody or return condition.
Expense
Vehicle, type, date, amount, submitter, receipt, approval status, and review owner.
Receipts in email with no vehicle reference or resolution status.