Monday's route is built with Friday's data

Nobody builds a good route at seven on Monday morning. They build the one they remember: the usual customers, in the usual order. The information needed to build it properly…

M By Mauricio A Gomez · · 5 min read
Monday's route is built with Friday's data

Nobody builds a good route at seven on Monday morning. They build the one they remember: the usual customers, in the usual order. The information needed to build it properly existed on Friday at five in the afternoon, while it was still fresh who didn't buy, who owed money and who asked the rep to come back.

What Friday has that Monday doesn't

Friday closes the week with data Monday has already lost: the visits made, the orders taken, the calls that went nowhere and the reason for each one. Building the route from that turns a list of addresses into a list of reasons. Every stop is there because something justifies it, not out of habit.

A route built out of habit shows up in two places: in the mileage and in the customers nobody has seen for three weeks. They are the same problem, and the same piece of data fixes both: last visit date, customer by customer.

Call frequency is a decision, not a habit

Call frequency means how often a customer is due for a visit. If it isn't written down, the rep decides on the fly, and almost always in favor of whoever treats him well. The usual result is three visits a month to the one who buys little and none to the one who stopped buying.

Writing frequency per customer — weekly, biweekly, monthly — makes the route checkable. On Friday you list everyone past due, and that list is Monday's skeleton. On top of it go the week's exceptions, which are few and always have a name attached.

The customer who drops off the route unnoticed

A customer is never lost all at once. First a visit gets skipped because the rep was running late, then another because the store was at the far end of the territory, and by the third month he isn't on anybody's route. Nobody decided to drop him: he fell off quietly.

The Friday review is when that becomes visible, and it shows up in a single column: days since last visit. Sort the territory by that column, highest first, and in ten seconds you have the list of customers nobody has been to see in the longest time.

The five signals you check on Friday

SignalWhat it meansWhat happens Monday
Two visits in a row with no orderThe customer is still open, but something changed: price, a competitor or an unresolved problemGoes on the route, with the supervisor briefed
Past-due balanceCollection stopped being an office jobGoes early, while the customer still has cash
Order pending deliveryThere is a promise the rep madeGoes in with a specific time, not "in the afternoon"
Past due on frequencyNobody called within the agreed intervalGoes on the route even if it's out of the way
Failed visit, store closedThe opening hours on file are wrongGoes into a different time slot, never the same day and hour

The extra mile has an official price

Crossing town twice isn't an annoyance: it's a cost with a published rate. The IRS set the 2026 standard rate at 72.5 cents per mile for business use, 2.5 cents more than in 2025. It is the figure a company uses to reimburse a rep for running his own vehicle.

And the fuel inside that rate went up. Average regular gasoline in the United States closed the week of September 7, 2026 at $4.157 per gallon, 96.5 cents higher than a year earlier, according to the EIA's weekly update.

ItemFigureSource
Business mile, 2026 standard rate72.5 centsIRS, IR-2025-128
Increase over 2025+2.5 centsIRS
Regular gasoline, U.S. average, Sept 7, 2026$4.157 per gallonEIA
Change over twelve months+$0.965 per gallonEIA

The consequence needs no spreadsheet. Say twenty extra miles a day per rep: at the official rate that's $14.50 a day. With five reps and twenty working days, the month burns roughly $1,450 in driving nobody asked for and that brought back not a single order.

How it works in practice

Friday, fifteen minutes. Open the customer list for the territory, filter by last visit and by balance, and mark who goes in. The supervisor sees the same list and adds what only he knows: the promotion starting, the customer who called the office, the territory that needs covering while someone is on vacation.

On Monday the rep opens his phone and the route is already there. He doesn't build it: he reviews it. That difference is what shows at month end, because a reviewed route starts at eight and an improvised one starts at half past nine, after the coffee and two phone calls.

Two mistakes that ruin the method

The first is turning the route into a cage. A customer who calls at ten on Monday has to be able to get in, and the system has to record that he did and why. If exceptions are punished, the rep stops logging them, and by the following week there is no data left to look at.

The second is sorting by distance alone. The nearest stop isn't always the first one: the customer who pays cash gets visited when he has cash in the register, and the one receiving goods when he has someone to receive them. Distance orders the stops; the reason decides which ones make the list.

In short

Monday's route gets built on Friday because Friday is when the data that justifies it is there: last visit, balance, pending order and the reason a visit failed. Building it that way cuts miles — at 72.5 cents each in 2026, per the IRS — and keeps customers from dropping off the route unnoticed.

This is general information, not tax or legal advice. The mileage rates cited are from the United States and are set by the IRS each year; other countries have different rules.