Route planning mistakes that cost small businesses money

The costliest mistakes send a vehicle to the wrong place or build the whole day around the wrong start, because every stop after them pays for it. Here are all ten, with the fix for each.

1. ZIP codes that lost their leading zero

Excel treats a ZIP like 02139 as a number and saves it as 2139. Every ZIP code that starts with zero is affected, which covers much of New England, New Jersey and Puerto Rico. A four-digit ZIP can put a pin in the wrong place or fail to match at all.

Fix: format the ZIP column as Text before you type or paste, or rebuild it with =TEXT(E2,"00000"). To find the damage, sort the column: four-digit ZIPs sort to the top.

2. Trusting every pin

Geocoding turns an address into a point on the map, and it's usually right. It's least reliable where a mistake hurts most: rural roads, new subdivisions, business parks, and addresses missing a city. A pin on the wrong side of a highway turns a short hop into a long detour.

Fix: look at the map before you optimize. Any pin far from the others, or in the middle of a field, deserves a second look. EZRoutePlanner flags uncertain matches at the top of an import so you can fix them first, and you can drag a misplaced pin onto the right building. See how to fix addresses that won't geocode.

3. Optimizing from the wrong start

An optimizer keeps the start where you put it and builds the whole order from there. If the start is whatever happened to be the first row of the spreadsheet, every stop is ordered around a place you aren't leaving from.

Fix: set the real start first: the shop, the depot or home. Save it as a base so it's one click every time, then optimize.

4. Forgetting how the day ends

A route that should end back at the shop, optimized as one-way, can finish at the far edge of town with a long drive home the plan never counted. The reverse happens too: a round trip forced on a driver who ends the day at home.

Fix: decide before you optimize. Turn on Round Trip to come back to the start, pin a final stop to finish there, or leave both off to end wherever is shortest. More in how to plan a round trip route.

5. Planning the whole week as one route

Optimizing 120 stops as one route gives a beautiful line nobody can drive in a day. Chop it into five pieces afterward and each day zigzags across the whole map.

Fix: split first, optimize second. Give each day one area of the map, make a route for each day, then optimize each one.

6. Ignoring the time spent at each stop

A route's distance and drive time cover the road, not the job. Twelve stops at 40 minutes each is eight hours of work before the first mile is driven.

Fix: estimate the time on site for each kind of stop, add the driving, and see whether the day fits. The stops per day calculator does the math.

7. Ordering by hand and crossing your own path

Ordering by hand usually means following the list or a hunch, and the result crosses itself: east, back west, then east again. Every crossing is distance you didn't need to drive.

Fix: optimize the order. If you must order by hand, sweep around the area in one direction and never let two legs cross. Across our 48 example routes of 7–12 stops on real roads in 24 cities, stops in a random order drove a median 65% farther than the same stops optimized.

8. Not re-optimizing after changes

A new stop added to the end of an optimized route is in the wrong place if it's really in the middle of the route's area. Cancellations matter too: the old order may no longer be the best one.

Fix: optimize again after every change. It takes a second, and a shared route shows the new order to the driver.

9. Sending Google Maps links that open in a phone browser

Google's own Maps URLs documentation says a directions link opened in a mobile browser takes only 3 waypoints between the start and the end. Text a 10-stop link to a driver, it opens in Safari or Chrome instead of the app, and the extra stops are quietly gone.

Fix: tell drivers to open links in the Google Maps app, make 5-place links with the Google Maps link builder, or share a route page instead, where every stop has its own Navigate button.

10. Copy-pasting a route for each driver

Retyping each route into texts or separate links takes time every morning, invites typos, and leaves drivers with an old copy as soon as anything changes.

Fix: share one link per route. In EZRoutePlanner each route has a link and a QR code that opens in any phone browser with no app or login. Edit the route and the page shows the change; revoke the link any time.

Run the same five-minute check on every route before it reaches a driver. It catches most of the mistakes above while they're still cheap to fix.