Spreadsheet vs software for DOT compliance

For a carrier with one to three trucks and a roster that doesn't change much, a spreadsheet of expiry dates and a folder of scans is a legal and sensible way to keep DOT records. Nothing in the regulations asks for more. It stops being enough at a fairly predictable point: when the dated items you're watching pass about forty, when a second person needs to update it, or when a truck is sold or a driver leaves and the retention clock that follows them gets lost. This page sets out where that line is, gives you a free template for the near side of it, and says what software has to earn if you're on the far side.

What the rules actually require of your system

Nothing about format. §390.32(b) says anyone required to keep records under the safety regulations may keep them electronically, and §390.32(d) sets the test an electronic record has to pass: it must accurately reflect what the paper version would have contained, and it must be capable of being retained and accurately reproduced for anyone entitled to see it. That is the whole test. A spreadsheet that holds the dates and a folder that holds the scans passes it, and so does a filing cabinet. The rule was written for paper and then opened to everything else. It doesn't prefer either.

What the rules are strict about is content and time. §391.51(b) lists eight items a driver qualification file has to hold. §391.51(c) keeps that file for as long as the driver works for you and for three years after. §396.3(c) keeps a vehicle's inspection and maintenance records for a year where the vehicle is housed or maintained, and for six months after the vehicle leaves your control. Those clocks are the job. Any system that keeps them, on paper or on a screen, is doing what the rule asks. The full schedule is in the guide on how long to keep DOT records.

Where a spreadsheet is the right answer

That carrier looks like this. One person owns the records and also drives, or dispatches, or does the books. There are one to three power units. The drivers have been there for years, or there is only one and it's you. Nobody else needs to touch the sheet. And, this is the part that matters, that one person opens the sheet at least once a month whether or not anything is due.

Plenty of operators run for years on exactly this and never lapse: a calendar reminder for the medical certificate, a photo of the card on the phone, and a sheet with conditional formatting that turns a cell red ninety days out. The sheet is not what fails. What fails is that nobody looks at it until something has already run out, and by then the sheet is describing the past. If you're the kind of person who opens it, keep it.

A setup that works: one row per driver and one column per item in §391.51(b), holding the date each was executed. Separate columns for the medical certificate expiry, the next annual review, the next Clearinghouse query and the date employment ended. One row per unit with the last annual inspection date and your own service intervals. A folder per driver and per unit, with scans named by item and date so you can find the March medical certificate without opening five files. Conditional formatting at ninety, sixty and thirty days. A monthly reminder to open the sheet. That is the entire system. It costs nothing and it satisfies §390.32.

The four places it breaks

The line is not a truck count. It's the point where one of the following starts happening, and each one is a specific, recognisable failure rather than a general feeling of disorder.

1. A clock that starts when something leaves. The retention period in §391.51(c) begins on the day a driver's employment ends. The six months in §396.3(c) begin on the day a truck leaves your control. Both are moments when the natural thing to do with a spreadsheet is delete the row, and the folder goes with it a month later during a tidy-up. The record you are still required to hold is the one that no longer has a driver or a truck attached, and a sheet built around active drivers and active units has no place to put it.
2. The second editor. The day somebody else needs to update the sheet, there are two of it: the one on the desktop and the one in the email attachment. Neither records who changed a date or when. A cell that was overwritten by accident looks identical to one that was updated correctly, and there is nothing to check it against. The medical expiry that read 2027-03 and now reads 2028-03 is either a renewal or a typo, and the sheet can't tell you which.
3. The sample request. In a compliance review the investigator picks a handful of drivers and units and asks for the records behind them. Not the index. The records, in a form they can read, that day. The sheet is the index. The records are in the folder, and assembling a complete file for six drivers from scans named by whoever scanned them takes an afternoon you'd rather spend answering questions. §390.32(d) asks that the record be accurately reproducible for the person entitled to see it, and a folder you can't find your way around on the day doesn't meet that in any useful sense.
4. Defects that never reach the sheet. A driver finds a cracked mirror bracket, writes it on a paper inspection report in the cab, and the report goes in the door pocket. The sheet is in the office. Either the truck goes out again with the defect and no record of the decision, or the repair is done and nothing records the certification. The report itself is legal on paper; the guide on DVIR requirements goes through what it must contain. The failure is the gap between the cab and the sheet, and paper has no way to close it.

If none of these is happening to you, you don't have a problem a spreadsheet can't handle. If two of them are, you've crossed the line whether or not you have bought anything.

A free template that does the job

Below is a spreadsheet template for the driver side of the job. One row per driver, one column for each of the eight items in §391.51(b), with the paragraph letter in the column heading so you can check it against eCFR yourself. Alongside those are the columns the (b) list doesn't include but a review will ask about: the previous employer inquiries under §391.23 and their responses, the Clearinghouse pre-employment and annual query dates under §382.701, the medical certificate expiry, and a retention column that holds the date the file may be destroyed, which is employment end plus three years under §391.51(c).

Download the driver qualification file tracker (CSV)

It's a plain CSV. It opens in Excel, Numbers, Google Sheets and LibreOffice and needs no account. Two example rows show a current driver and one who has left, with fictional names; delete them once you've seen the shape. The last row carries the review date and the reminder that every citation is to 49 CFR and should be read there before you rely on it.

Three things to do once it's open. Add conditional formatting to the medical expiry column so a date inside ninety days changes colour. Put the annual review and annual query due dates in your calendar, because a sheet that isn't open can't warn you. And when a driver leaves, fill in the employment end date and the retention date before you do anything else, then leave the row exactly where it is.

What the template doesn't cover: units. Annual inspections under §396.17 and maintenance records under §396.3 need a row per unit, including trailers and dollies, and their own retention dates. Adding a second sheet with those columns is a ten-minute job and the retention guide linked above gives every period.

What software has to earn

Software doesn't earn its price by holding files. A folder holds files. It earns it by doing the four things the spreadsheet couldn't, and you should check each of them before paying anyone, in this order.

• It knows the retention periods and keeps counting after a driver or a truck is gone, without you remembering to.
• It can hand an investigator the records behind a sample of drivers and units as something they can open on their own machine with no login and no portal.
• It keeps one inspection clock per unit, including trailers, because §396.17 counts each component of a combination and not the rig.
• It lets you leave with everything, in a format you can read without it.

Those four, and seven more, are worked through as questions to ask any vendor in the guide on what to look for in DOT compliance software. Since this page is on a vendor's site, this is where Ledger Road sits so you can judge the comparison. It keeps driver qualification files, daily inspection reports, annual inspections, maintenance schedules, roadside corrections and Clearinghouse query records. It is not an ELD, it doesn't record hours of service, and it doesn't do dispatch, loads or invoicing. If those are the problems you're trying to solve, a spreadsheet was never the alternative and this comparison isn't the one you need.

The cost comparison, in hours

Vendors like to put a penalty figure on this page. We won't, because the comparison a carrier actually makes is between the hours the spreadsheet costs and the price of not spending them. Below are the recurring tasks, with a rough monthly estimate for a twelve-truck carrier with fifteen drivers who keeps everything in a sheet and a folder. Your numbers will differ. Write yours in the third column and add them up.

For a three-truck carrier, halve everything and drop the reconciling row, and the total is an hour or two a month. That is not worth a subscription, and nobody should tell you it is. For twelve trucks the total runs to a working day a month before anyone asks for a file, and the person spending it is usually the same person dispatching. Whether a day a month is worth a published price is a question with your name on it, not ours.

The one cost that doesn't fit in a table is the date nobody saw. The document was there. It ran out, and the sheet was closed. That is the failure every system is built against, and it's the reason to decide which side of the line you're on before it decides for you.

If you're on the near side, take the template and go. It's the right tool and you'll lose nothing by using it. If you're on the far side, the next guide gives you eleven questions to ask before you pay anybody, including us.