Driver Management & HR · Excel template
Free DOT Drug & Alcohol Testing Log
A program log for tracking DOT drug and alcohol testing under 49 CFR 382 — recording pre-employment, random, post-accident, reasonable-suspicion, and return-to-duty tests by driver and result.
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
- One row per test with driver, date, and test reason (the 382 categories)
- Columns for test type (drug / alcohol), specimen/collection ID, and result
- A reasonable-suspicion / post-accident trigger note field
- A Clearinghouse query/reporting reference column
- Running counts to support random-selection-rate monitoring
- An Excel layout kept separate from the DQF for privacy
How to use it
- 1
Log every test as it occurs, selecting the reason from the 382 categories (pre-employment, random, post-accident, reasonable suspicion, return-to-duty, follow-up).
- 2
Record the test type, collection/specimen identifier, and the result from the MRO or BAT.
- 3
For post-accident and reasonable-suspicion tests, note what triggered the test.
- 4
Track the related FMCSA Clearinghouse queries and any required reporting.
- 5
Use the running counts to monitor your random-testing rate against the program minimum, and store the log securely.
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 Drug & Alcohol Testing Log
Drug & alcohol testing records are confidential and kept separate from the driver qualification file. Random rates, post-accident triggers, and Clearinghouse obligations are set by 49 CFR 382 and change periodically — verify against the current rule.
| Driver name | Test date | Reason (382 category) | Type (drug/alcohol) | Collection / specimen ID | Result | Clearinghouse ref |
|---|---|---|---|---|---|---|
| J. Alvarez | 2026-01-05 | Pre-employment | Drug | C-88412 | Negative | Q-2026-0041 |
| R. Boone | 2026-03-14 | Random | Drug | C-90233 | Negative | Q-2026-0188 |
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.
49 CFR 382 establishes testing categories: pre-employment, random, post-accident, reasonable suspicion, return-to-duty, and follow-up. Which apply and when is defined by the rule — verify the current requirements and your random-testing rate against 49 CFR 382.
The Drug and Alcohol Clearinghouse is a federal database of CDL driver drug and alcohol program violations. Carriers must run pre-employment and annual queries and report certain violations. This log includes a Clearinghouse reference column — confirm your query and reporting duties.
Testing records are confidential and must be kept secure and separate from the general driver qualification file, with access limited. This log is designed to live in a restricted location, not in the DQF.
FMCSA sets specific post-accident testing triggers (e.g., fatalities, certain injuries with a citation, certain disabling-damage situations with a citation). The exact triggers and timing are in 49 CFR 382.303 — confirm them before testing.
Related guides & tools
- What goes in a driver qualification file
- CDL requirements explained
- Driver Qualification File Checklist
- Driver safety resources
Looking for more? Browse all fleet templates or run a fleet calculator.