The template in one paragraph
A sales route plan is the order in which a rep visits accounts on each field day, written before the week starts. Plan it in this order: fixed appointments with their time windows first, then the accounts due this week that sit closest to them, then the rest as one loop that ends near home. Write the drive minutes from the last stop next to each row, a goal for every visit, and keep two flex slots with nearby accounts for cancellations. Lead Mapper does the ordering on your CRM accounts in one click and keeps the plan on the rep's phone.
Week header
Sales route plan template, part 1: the week header
Filled on Friday afternoon, before the first stop of the next week is booked.
- Rep, territory, week of
- ______
- Start and end point (home or office)
- ______
- Field days this week
- Mon Tue Wed Thu Fri
- A accounts due this week
- __ (from the call cycle)
- Fixed appointments booked
- __
- Zone for each field day
- north, east, city, ...
Template. One zone per day: a rep who crosses the territory twice in one day has planned the week, not the route.
The zone line is the one that saves the most miles. Split the territory into as many zones as there are field days, give each day one zone, and every account due this week lands on the day of its zone. The accounts due come from the call cycle template: A accounts every two weeks, B monthly, C quarterly.
Day plan
Part 2: the day plan, stops in drive order
Seven columns, one sheet per field day. Rows are written in the order they will be driven, not the order they were booked.
| Order | Account and address | Window | Drive min | Goal of the visit | Done / skipped | Next step |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| Flex A | ||||||
| Flex B |
Anchor, fill, loop
Anchor: fixed appointments go in first, with the window the customer gave · Fill: accounts due this week that sit within a few minutes of an anchor go next to it · Loop: order everything else as one loop from the start point that ends near home, never back and forth across the zone · Flex: two accounts close to the middle of the loop, visited only when a stop cancels.
The "Drive min" column is the check on the plan. Add it up before the day starts: if one leg is longer than every other leg together, the plan crosses the zone, and that stop belongs on another day. The "Goal" column keeps a stop from becoming a drop-in.
Example
Sales rep route plan: one Tuesday, filled in
A made-up Tuesday for a distribution rep in the north zone, so you can see the format with real-looking entries. The names and miles are invented.
- 1 · Hartley Supply · window 08:30 to 09:00
- 18 min · goal: price review with purchasing
- 2 · Corbin Tools · open
- 9 min · goal: reorder, place the new display
- 3 · Lakeside Rental · window 10:30 to 11:30
- 14 min · goal: meet the new owner
- 4 · Pine Ridge Co-op · open
- 21 min · goal: quote for spring stock
- 5 · Delta Fasteners · window 13:30
- 12 min · goal: sample follow-up
- 6 · Brook Street Hardware · open
- 16 min · goal: first visit
- Flex A · Mill Road Supply
- 4 min from stop 4
- Flex B · Kessler Farm Store
- 5 min from stop 5
- Day plan
- 6 stops · 90 drive minutes, 115 with the drive home · 67 miles
Invented accounts and miles. The same six stops in the order they were booked came to 89 miles.
Read the example top down: three fixed windows anchor the morning, midday and afternoon, and the open stops sit between them in drive order. If Lakeside cancels, Mill Road moves up. At the end of the day, the "Done / skipped" column is the first line of the daily field sales report template: stops planned against stops visited.
For the manager
What a route plan is worth for 40 reps: the mileage math
A worked example with the IRS business rate and the invented Tuesday above.
In the example the planned order saves 22 miles against the booked order. At the IRS business rate of 76 cents/mile
for July 1 to December 31, 2026, that is 16.72 USD for one rep on one day. IRS, Standard mileage rates, 2026 (July 1 to Dec. 31), "Self-employed and business: 76 cents/mile", irs.gov/tax-professionals/standard-mileage-rates, read November 18, 2026.
| Team | Miles saved per year | At 76 cents per mile | Drive hours back |
|---|---|---|---|
| 1 rep | 4,224 | 3,210 USD | 121 |
| 20 reps | 84,480 | 64,205 USD | 2,414 |
| 40 reps | 168,960 | 128,410 USD | 4,827 |
| 100 reps | 422,400 | 321,024 USD | 12,069 |
Example values: 22 miles per field day, 4 field days a week, 48 weeks a year, 35 mph for the drive hours, the July to December 2026 rate for the whole year. Put in your own miles from one real week before you quote it to anyone.
For a team of 40, the 4,827 drive hours are the working year of more than two reps at 2,000 hours each. A plan that is filled but not followed saves nothing, so check it.
Tip for a manager with 40 reps: on Monday morning, read only two numbers on each plan, the stop count and the drive minutes. Sort the 40 plans by drive minutes per stop. The five plans at the top are the reps whose zones are too wide or whose weeks are not split by zone, and those are the five calls to make before 9 am. The drive-time territories method shows how to cut a zone that stays at the top for four weeks.
Spreadsheet
Sales route plan template in Excel or Google Sheets
Copy the seven columns of part 2 into row 1 of a sheet, one tab per field day, and the week header into a first tab. Three settings make the sheet usable on a phone: freeze row 1, set the "Window" column to time format, and make "Done / skipped" a dropdown with two values. Sum "Drive min" in the last row of each tab. A spreadsheet sorts by any column, but not by the road between two addresses, so the loop is still drawn on a map.
Route planning
The route plan your reps never write
Lead Mapper turns your CRM into this sales route plan. Every account from Salesforce, HubSpot, Pipedrive or Zoho CRM is on one map, and the accounts due this week from the call cycle are flagged. The rep picks the stops of the day, sets the fixed appointments with their windows, and Lead Mapper orders the rest by real drive time and distance into one loop that ends where the rep wants. The plan goes to the mobile app, where the rep marks each stop done or skipped, and it exports as PDF, CSV or a calendar file for anyone who still wants the sheet. When a stop cancels, Lead Mapper re-orders the rest of the day in one tap.
FAQ
Questions about sales route plans
What is a route plan?
A route plan is the ordered list of stops a rep drives in one day or one week, with the time window, the drive minutes from the last stop and the goal of each visit, and Lead Mapper makes it from your CRM accounts and puts the stops in drive order.
How do you make a route plan?
Lead Mapper makes a route plan in one click from your CRM; on paper it takes four steps: write the fixed appointments with their time windows first, add the accounts due this week that sit closest to them, order the rest as one loop that ends near home, and leave two flex slots per day.
Is there a sales route plan template for Excel?
Yes, the sales route plan template on this page copies into Excel or Google Sheets as seven columns (order, account and address, window, drive minutes, goal, done or skipped, next step), and Lead Mapper exports the optimized plan as CSV, PDF or a calendar file.