Every fleet starts on a spreadsheet. Vehicle list in Google Sheets, renewal dates in a phone calendar, scanned PDFs in a shared drive. It works, until it doesn't (usually around 10 to 20 trucks).
Most fleets that end up running on a 30-truck Google Sheet did not plan to land there. It just happens. You buy your first truck, open a fresh tab, type the VIN, plate number, and registration expiration. You buy a second. You add a third. You open another tab for insurance, one more for CDL expirations, and now you have a workbook.
For a while this is fine. You know every truck by name and you remember every renewal because you just signed the checks. Then the fleet grows and the spreadsheet doesn't grow with it. Around 10 to 20 vehicles the cracks start showing.
I've watched this break in real time. Here are the 6 reasons the spreadsheet fails (with the receipts), and what actually replaces it.
A cell holds a date. It does not look at that date 30 days out and email the owner. It does not ping the dispatcher when a medical card lapses. It does not text the driver when their MVR is due. It sits there.
At 5 trucks you can keep the dates in your head. At 50 vehicles you have a deadline expiring every other day (registrations, insurance policies, IFTA decals, medical cards, drug-and-alcohol random pulls, annual DOT inspections). At 100 vehicles a deadline hits every single day. Something is going to slip.
The slip happens at a weigh station in New Mexico, on a Thursday, with a load on the trailer.
Which workbook is the current one? The shared Drive copy, the dispatcher's download from last week, or the version the owner emailed himself before vacation? Did the master file get updated after the March renewals, or is it still showing 2025 expiration dates?
The moment two people touch the same fleet sheet, version control becomes a real problem. Google Sheets and Office 365 shared workbooks help, but they introduce their own failure modes: someone sorts a column without selecting the full range (rows scrambled), overwrites a formula with a hard-coded value (math broken), or deletes a row of a sold truck instead of archiving it (history gone).
Ray Panko at the University of Hawaii has spent 20 years measuring this. His finding (the one Microsoft quietly cites in its own training): on average, 88% of Excel spreadsheets contain errors, with about 1% of formula cells wrong even when a single developer works alone.
A 2024 study put the number at 94% of business-decision spreadsheets containing critical errors. Two people sharing edit access does not improve that math.
The spreadsheet says truck 47's registration expires June 15. Great. Where is the actual cab card? The Form 2290 stamped Schedule 1? The IRP cab card? The Heavy Weight Permit? Last year's annual inspection report? The MCS-150 confirmation?
In a spreadsheet world: a folder in Drive, a thread in Gmail, a manila folder in the filing cabinet, a screenshot on someone's phone, and (the classic) a glove box. When the DOT officer wants proof of insurance during a roadside inspection, you're calling the office to dig through folders while the clock runs.
The disconnect between data and documents is the single biggest daily frustration I hear from fleet managers still on spreadsheets. They know the truck is current. They just can't prove it fast enough.
The roadside stop is the obvious version. The quieter version is the insurance renewal audit, where the underwriter asks for proof of annual inspection on 18 vehicles and you've got 90 minutes to email back PDFs that live in 6 different places. The fleet is compliant. The proof is scattered. The underwriter sees disorganization and prices accordingly.
Can your sheet tell you right now how many registrations expire in the next 30 days? How many drivers have a medical card lapsing this quarter? Which vehicles are past due for their annual DOT inspection? Which IFTA-licensed units haven't logged miles this quarter?
Technically, yes. If you build the COUNTIFs, layer in conditional formatting, hook up the IMPORTRANGE, and keep every row perfectly updated. In practice, the build slips by week two. You end up squinting at sorted columns and hoping the eye catches the red cell.
There's no dashboard. No compliance score. No red-yellow-green status that tells you where the fleet stands at a glance. Fleet management software gives you that view automatically: 3 registrations expiring this month flagged in red, 1 driver cert expired last week pinned to the top, 2 insurance policies renewing in 45 days on your radar.
That kind of visibility changes how the office runs.
Even when you catch the expiring registration in the sheet, what happens next? You close the workbook, open a browser, navigate to the tag agency portal or call your Licensed Operator, and start the renewal in a different tool. The spreadsheet told you about the problem and then watched you fix it somewhere else.
The handoff is where the data goes stale. Renewal gets filed, new cab card lands in email, and the workbook waits forever for the update (or worse, somebody types 2026 when they meant 2027).
Real fleet software closes the gap. Identify the expiring plate, initiate the renewal from the same record, watch the new cab card upload back to the vehicle, see the expiration date update without a human typing it. One surface. One source of truth. Zero retyping.
On November 1, 2024, Oklahoma launched the Commercial Fleet Registration program. Owners of 10 or more commercially registered vehicles can consolidate the whole fleet into one registration unit with a single uniform December expiration. First time a vehicle joins, a prorated fee adjusts the expiration so everything lines up.
For carriers running staggered renewals across the calendar, this is a real operational win. Renewals collapse from 14 scattered dates to one December push.
The catch: the December-expiration program only solves state registration. The rest of the calendar (IRP renewals through the OCC, IFTA quarterly returns, Form 2290 due August 31, UCR by December 31, MCS-150 biennial, DQ file renewals, medical card expirations, drug-and-alcohol random pulls, Clearinghouse queries) still runs on its own clocks. A spreadsheet can list all those clocks. It cannot ring any of them.
I wrote a full breakdown of the program in the Oklahoma commercial registration guide.
Here's the math people skip. A standard Oklahoma commercial registration on an 80,000-lb tractor runs around $972 per year. Renewing it on time is a calendar event. The bill is the same every year and the truck keeps rolling.
Missing it is a different number entirely.
The $972 you didn't pay on time turns into a 4-figure roadside event and a 12-month insurance and brokerage tail. The spreadsheet saved zero dollars and cost real ones.
Good fleet management software earns its keep by stripping work out of the day. It does 5 things a spreadsheet fundamentally cannot:
Vehicle compliance is at least static. The plate expires on a date. The annual inspection is due 12 months from the last one. Driver compliance moves.
A medical card expires on its own clock (typically 24 months, but cardiac, diabetic, and vision exceptions cut that to 12, 6, or 3 months). MVRs come due annually. Drug-and-alcohol random pulls happen on a federal pool rotation you don't control. DQ files want a refreshed PSP and Clearinghouse query at hire and every 12 months after.
Try modeling a 3-month medical card recheck in a Google Sheet for 22 drivers. Now do it after one driver moves from the 24- month card to the 12-month card mid-quarter and the cell formula still calculates off the old expiration. The spreadsheet doesn't flag the mismatch. The driver shows up at a roadside inspection 4 months later with an expired medical card and the truck goes out of service.
FMCSA logged 20,166 out-of-service orders for expired medical card violations from 2019 to 2023 across 97,586 driver citations. The category exists because the tracking failure is that consistent.
The spreadsheet got you started. It was the right tool when you had 3 trucks, 1 driver, and your wife answered the phone. It kept the fleet running and it cost nothing.
The exit signal is simple: when you spend more time maintaining the spreadsheet than managing the fleet, the tool is the bottleneck. When you find an expiration cell in red and you're not sure if it's actually expired or if somebody forgot to update it, the tool is the risk.
DOCKEX is what I built for the second half of that arc. Centralized registration, automated alerts, document storage attached to every vehicle, audit trail on every change, and filing services for Oklahoma-based carriers. The trial is free for 14 days and the dashboard surfaces every gap in your fleet inside the first hour.
DOCKEX
Centralized fleet dashboard, automated expiration alerts, document storage on every vehicle and driver record, and Oklahoma filing services in one place. Starts at $79/mo with a 14-day free trial.
Start your free trialKeep reading
Fleet Management
The fact-verified 2026 playbook for small Oklahoma fleets: registration calendar math, FMCSA insurance minimums, DQ files under 49 CFR 391.51, the random testing pool, IFTA cycle through the OCC, and the 10-vehicle Commercial Fleet program.
11 min read
Registration
Six commercial registration mistakes that cost Oklahoma carriers money: wrong combined laden weight, the $0.25/day commercial late-registration penalty under 47 O.S. § 1115, USDOT marking gaps under 49 CFR 390.21, sloppy IRP mileage records, tag-agency phone-tag, and skipping the November 2024 Commercial Fleet program. Fact-verified against Service Oklahoma, the OCC, and FMCSA.
11 min read
Insurance
The fact-verified guide to commercial vehicle insurance in Oklahoma: exact 49 CFR Part 387 minimums by cargo type, the 35-day cancellation rule, BMC-91 vs MCS-90, OCC Form E for intrastate, and the gaps that get carriers shut down.
11 min read