Home / Notes / Theft and bad data

Note

A keyed truck number is not a stolen fill.

If those two sit in the same pile, you accuse the wrong person and you keep paying for gallons that never reached a tank. A fuel audit has to keep them apart.

Zack Shields, October 7, 2026

Every fill gets one of three labels

Verified in a fleet tank. Needs review, with evidence. Cannot be verified yet. That is the whole sort. A Monday report that skips the sort will either cry theft at a typo or hide a real miss inside "data issues."

Verified means the card, the truck, the time, and the tank agree closely enough to close the line. Review means they do not agree, and the disagreement is specific enough to pull receipts or video. Unverified means a unit number, a GPS gap, or a tank sensor is too weak to decide either way.

What a review item has to include

A name on a list is not evidence. A useful line names the unit, the driver if the card has one, the pump location, the time, the gallons, the dollars, and where GPS put the truck. On a Southeast fleet, one of those lines was a driver whose truck was about 41 miles from an Ocala stop. The action was not "investigate the fleet." It was "pull receipts and video for this fill."

A second line in the same week was a driver who keyed one unit and drove another. The fuel was in a truck. Dispatch got a process note: have drivers enter their own unit at the pump. That line never shared a heading with the Ocala fill.

Sensors are a third file

A tank reading that jumps around cannot prove the fuel arrived, and it cannot prove the fuel was stolen. Those fills stay in sensor health until the reading is stable. Calling them clean understates loss. Calling them theft overstates it and trains the shop to ignore the next alert.

Why the split saves money

On that 200-truck fleet, the first week caught more than $2,000 in theft and card misuse. Fourteen later flags added $3,180 after receipts and video. The same work also cut idle hours 11 percent and took about six hours a week of reporting off the table. The dollars and the process fixes came from the same match. They were not the same finding.

Names and figures from that engagement are changed where a person could be identified. The categories are not.

What to do with the list

Managers clear the review lines. Dispatch clears the mixups. Maintenance, or the telematics vendor, clears the sensors. Finance reads the Monday totals. Nobody needs a new application to do that. They need the three piles kept separate.

If you want this sort run on the cards and GPS you already pay for, book a 15-minute call. The sample layout is on the Monday report page.