Audit & Recordkeeping · Excel template
Free DOT Medical Card Expiry Tracker
A roster tracking each driver's medical examiner's certificate — issue and expiry dates, any restrictions, and the reminder dates that stop a card lapsing mid-dispatch.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- A row per driver with licence number, certificate issue and expiry dates, and days remaining
- The examiner's name and national registry number, so the certificate can be traced
- A certificate-length column, since not every driver is issued the maximum period
- Restriction and variance flags — corrective lenses, hearing aid, exemption held
- Staged reminder dates at 90, 60, and 30 days, plus a self-certification status column
How to use it
- 1
Enter every driver who operates a vehicle requiring a medical certificate, including occasional and yard drivers people forget.
- 2
Record the issue date, the expiry date, and the certificate length — a driver managing a monitored condition may hold a shorter card than the standard maximum.
- 3
Log the examiner's name and registry number from the certificate itself, so you can verify the examiner was listed when it was issued.
- 4
Set the 90, 60, and 30 day reminders from the expiry date and give each one an owner, not just a date.
- 5
Keep the certificate copy in the driver qualification file and track the self-certification status alongside it, because the two are separate obligations that expire independently.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
DOT Medical Card Expiry Tracker
Certificate validity periods and self-certification requirements are set by regulation and change. Verify current requirements — and how your state licensing agency handles the certificate — rather than relying on the intervals shown here.
| Driver | Licence No. | Exam Date | Expiry Date | Card Length | Restrictions | 90-Day Notice | Status |
|---|---|---|---|---|---|---|---|
| R. Alvarez | TX-4471982 | 2026-02-11 | 2028-02-11 | 24 months | Corrective lenses | 2027-11-13 | Current |
| D. Okafor | TX-3318870 | 2026-08-02 | 2027-02-02 | 6 months | Monitored condition | 2026-11-04 | Recert due |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
A maximum period applies, but plenty of drivers are issued a shorter certificate — an examiner can certify for a reduced term when a condition needs monitoring. Never assume the maximum: read the expiry printed on the certificate and track that date. Verify the current maximum against the regulations rather than working from a remembered figure.
The driver is no longer medically qualified and must come off safety-sensitive duty until recertified. Letting one lapse is a recordkeeping failure as much as a safety one: it is a routine audit finding, it can invalidate the driver's licence status in states that link the two, and it is entirely preventable with a reminder that fires early enough to book an exam.
Certifying examinations for interstate drivers must be performed by an examiner listed on the national registry. Record the examiner's name and registry number when you file the certificate, because a certificate from an unlisted examiner may not be valid — and that is far easier to catch at filing than during an audit two years later.
No, and conflating them is a common gap. The medical certificate is issued by the examiner. Self-certification is the driver's declaration to the state licensing agency of the category of operation they drive in, which determines whether a certificate must be on file with that agency at all. They have separate triggers and separate consequences, so track both.
Keep a copy in the driver qualification file, and follow whatever your state agency requires for submission. Track the expiry here and file the document there — a tracker with no underlying certificate fails an audit just as surely as a certificate nobody diaried.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.