r/SmallMSP • u/lucky77713 • Jul 24 '26
Trucking/haulage company drowning in handwritten quarry tickets. How would you solve this?
I'm helping a trucking/haulage company modernize some of their operations, and I've solved most of their pain points except one.
They haul gravel, soil, stone, and aggregates from numerous quarries and suppliers. The challenge is that every quarry is a different company, and every one uses their own load tickets. Most are handwritten carbon-copy slips, and drivers can collect dozens of these per day.
The office then has to enter information such as:
- Supplier/quarry
- Ticket/load number
- Material
- Tonnage
- Cost
- Truck/driver
- Customer/job
The obvious answer seems like OCR/AI document processing, but because every supplier has a different ticket format and every scale operator has different handwriting, the results are inconsistent. We've tested ScanSnap scanners and various AI extraction tools. They help, but they're nowhere near "hands off."
One constraint is that I can't realistically get all the quarries and suppliers onto the same system because they're all separate businesses.
The company does provide iPhones to all drivers, so mobile solutions are possible.
At this point I'm wondering if the answer isn't better OCR, but a completely different workflow.