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. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- 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
- Editable CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
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.
What's inside
- 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
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 |
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.