DRIVER LICENCE CHECK TRACKER – Excel Workbook with Live RAG Dashboard

A complete driver licence check management system for transport operators and fleet managers. Log every DVLA share code check, track next due dates, and see your full fleet compliance status at a glance — automatically.

Created by a practising Transport Manager & Head of SHEQ.

WHAT YOU GET — 5 connected sheets

- Read Me & Instructions

- Live Dashboard — KPI cards, compliance rate, overdue and due-soon alerts

- Permanent Driver Licence Log — full check record per driver

- Agency & Contractor Log — separate tab with agency name field, same RAG logic

- Settings — configure check frequency and amber warning period in one place

WHAT THE DRIVER LOG TRACKS

- Driver name, employee number, licence number and categories

- Date of birth and licence expiry date

- Last DVLA share code check date and who carried it out

- Share code reference used

- Endorsements and penalty points

- Next check due date — calculates automatically

- Days until due — calculates automatically

- RAG status — calculates automatically

RAG STATUS — FULLY AUTOMATIC

🔴 RED — check overdue, licence expired, or driver never checked

🟠 AMBER — check due within your chosen warning period (default 28 days)

🟢 GREEN — compliant, no action needed

CONFIGURABLE SETTINGS

Set your own check frequency (default 6 months) and amber warning period. Change once and the whole workbook updates.

WHY THIS TRACKER

Employers have a legal duty to verify drivers hold a valid licence. The DVLA recommends checks at least every 6 months. This tracker keeps your whole fleet — permanent and agency — on top of that obligation without manual calculations.

DIGITAL PRODUCT – NO PHYSICAL ITEM SHIPPED

After purchase you will receive the editable Excel file via eBay message within 24 hours.

PLEASE NOTE: This tracker is a guide to help manage your driver licence check process. It is not legal advice. Buyers are responsible for ensuring their process meets their operator licence undertakings and DVSA requirements.