LiteRoute Planner
  • How it works
  • Features
  • Industries
  • Compare
  • Guides
  • Pricing
Log inGet Started
  1. Home
  2. Guides
  3. Overdue customers

Find the customers you haven't visited lately, on a map

A spreadsheet can sort by date, but it can't show you that the overdue accounts are all on the east side. A map colored by last visit can.

Start planning freeSee pricing
  • Free for up to 50 addresses
  • No credit card
  • No app to install
5643121234576
Monday · West6 stops · 9.0 miOptimized

The short answer

Updated October 19, 2026

Lite Route Planner colors every customer on the map by when you last visited: within a week, 1 to 2 weeks, 2 to 4 weeks, 1 to 2 months, over 2 months, or never. Filter to the overdue groups, lasso them into a catch-up route and press Optimize. The colors come from stops marked Visited or Attempted in Lite Route Planner, and dates from an old spreadsheet can come in as a date field you filter by range.

Plan a catch-up route for overdue customers

  1. 1

    Color the map by last visit

    Open Color By and choose Last visit. Green pins were visited within the last week, orange 1 to 2 months ago, red over 2 months ago, and gray never.

  2. 2

    Filter to the ones that are due

    In Filters, tick 1 to 2 months ago and Over 2 months ago, plus Never visited if new accounts count. Everyone else leaves the map.

  3. 3

    Look for the clusters

    Overdue customers bunch up in the parts of town you drive least. Pick the cluster that's worth a day.

  4. 4

    Lasso and optimize

    Make a route, draw a loop around the cluster, set where you start, and press Optimize.

  5. 5

    Visit and mark

    Mark each stop Visited or Attempted as you go. Its pin turns green on your map, and the visit goes into the stop's history.

What each color tells you

Six groups, based on the most recent visit marked on each stop.

  • Within a week (green)

    Up to date. Leave them off this week's catch-up.

  • 1 to 2 weeks ago (light green)

    Fine for monthly customers. Due now if they're weekly.

  • 2 to 4 weeks ago (yellow)

    Due for anyone on a two- or three-week cycle.

  • 1 to 2 months ago (orange)

    Monthly customers are overdue. Plan them this week.

  • Over 2 months ago (red)

    The accounts most likely to drift away. For a sales rep, the first calls to make.

  • Never visited (gray)

    New leads, or customers added before you started marking visits.

Where the last-visit date comes from

The colors come from visits marked in Lite. When you or a driver marks a stop Visited or Attempted, that becomes its latest visit. An Attempted visit counts too, so color by Last outcome when you want the stops where nobody was home.

If you've tracked visits in a spreadsheet, bring that history with you. Import the date column as a date field, then filter it by range (everything before September 1, say) or color by it from oldest to newest. Once you're marking visits in Lite, the Last visit colors take over.

Times visited is the third view. It groups stops by how many visits they've had (once, 2 to 5, 6 to 10, more than 10), which shows your most and least served customers at a glance.

Bringing last-visit dates from a spreadsheet

A sales rep's account list. Last call comes in as a date field and Tier as text.

Bringing last-visit dates from a spreadsheet
ABCDE
1AccountAddressCityTierLast call
2Greenway Pharmacy1220 Fieldstone PkwyFranklin, TNA2026-10-08
3Main Street Hardware418 Cedar Bluff RdBrentwood, TNB2026-09-02
4Corner Market Deli77 Old Mill CtMurfreesboro, TNB2026-07-21
5Lakeshore Vet Clinic3305 Harbor View DrHendersonville, TNA2026-08-14
6Riverbend Feed Co.960 Quarry RdLebanon, TNC

Filter Last call to dates up to September 19 to see every account not called in a month, then filter Tier to A to start with the ones that matter most.

Lite or Badger Maps for overdue accounts?

Choose Lite if

  • You want last-visit colors without a per-user bill: free for up to 50 addresses, and Business has unlimited users
  • Your customers live in a spreadsheet, not a CRM
  • Drivers or techs need routes on their phones with nothing to install
  • You want up to 500 stops on a route

Choose Badger Maps if

  • Your reps work from a CRM and need it synced (Badger's CRM integration needs 2 or more licenses)
  • You want check-ins with photos
  • You want native iPhone and Android apps
  • Per-user pricing ($58 to $69 a user a month, checked October 2026) fits your team

FAQ

Questions, answered.

Short answers to the questions that come up most.

Try it free

How do I see which customers I haven't visited?

Put them on a map and color each one by last visit. In Lite Route Planner, open Color By and choose Last visit: stops show as within a week, 1 to 2 weeks, 2 to 4 weeks, 1 to 2 months, over 2 months, or never visited. Filter to the older groups to see only who's overdue.

Can I find customers I haven't visited in 30 days?

Yes. In Lite Route Planner, filter Last visit to 1 to 2 months ago and over 2 months ago, which together cover everyone last visited more than 30 days ago. Add Never visited if you want new accounts too.

Does it use the dates in my spreadsheet?

The last-visit colors use visits marked in Lite Route Planner. Dates from a spreadsheet import as a date field, which you can color by and filter by range until your own visit history builds up.

Does an attempted visit count as a visit?

Yes, for the last-visit colors in Lite Route Planner. To find stops where nobody was home, color or filter by Last outcome, which separates Visited from Attempted.

Is this useful for outside sales reps?

Yes. Reps covering a territory use it to spot accounts that have gone quiet and plan a day around them. Badger Maps has similar days-since-last-check-in coloring at $58 to $69 per user a month (checked October 2026); Lite Route Planner is free for up to 50 addresses and has no per-user fees.

Can I see a customer's full visit history?

Yes. Open the stop in Lite Route Planner to see every visit with its date, whether it was Visited or Attempted, and any note. Visits stay in the history after the route is completed.

Keep reading

  • Customer visit trackingSee every customer you haven't visited lately.Color customers by last visit, filter the overdue ones and route them, with a visit history for each.Read more
  • Sales repsPlan sales calls around the accounts you haven't seen lately.Map your accounts, color them by last visit and plan a day of calls, with one flat price for the whole team.Read more
  • Weekly service routesHow to plan recurring weekly, biweekly and monthly routesKeep one master customer list, tag each customer by day or week, and pull a fresh, optimized route out of it each day.Read more
  • Badger Maps alternativeSee who's overdue for a visit, without paying per rep.The last-visit map sales reps rely on, at one flat price instead of $58 to $69 per user a month.Read more
  • MerchandisersPlan the store cycle, with time in each store counted in.Store lists, time in store and last-visit colors for merchandisers and route reps on a weekly or biweekly cycle.Read more
5643121234576

Your next route is two minutes away.

Make a free account, add a few stops and press Optimize. That's the whole lesson.

Start planning freeLog in

Free for up to 50 addresses · No credit card · Nothing to install

Lite

Lite Route Planner is an easy route planner for multiple stops. Add addresses by typing, pasting or importing a spreadsheet, optimize the order in one click, and send each route to a driver's phone, with turn-by-turn directions in Google Maps, Apple Maps or Waze.

  • Create a free account
  • Log in
  • Contact support

Product

  • How it works
  • Features
  • Driver app
  • Pricing
  • FAQ
  • Free route planner
  • Route optimizer
  • Route planner app
  • Map multiple addresses
  • Excel route planning
  • Delivery route planner
  • Customer visit tracking
  • Small business route planning

Route planners for

  • Lawn care
  • Cleaning
  • Window cleaning
  • Pest control
  • Pool service
  • HVAC
  • Plumbing
  • Field service
  • Snow removal
  • Home health
  • Mobile grooming
  • Pet sitting
  • All industries

Compare

  • Routific alternative
  • OptimoRoute alternative
  • Upper alternative
  • Spoke (Circuit) alternative
  • Route4Me alternative
  • Zeo alternative
  • Routing24 alternative
  • Google Maps alternative
  • MapQuest alternative
  • Badger Maps alternative
  • RouteXL alternative
  • MyRouteOnline alternative
  • Compare all

Guides

  • Google Maps multiple stops
  • Google Maps 10-stop limit
  • Google Maps optimization
  • MapQuest multiple stops
  • Apple Maps multiple stops
  • Waze multiple stops
  • Plan a multi-stop route
  • Best free route planners
  • Mapping Excel addresses
  • Plan delivery routes
  • Route planning template
  • Sending routes to drivers
  • All guides

For AI and search

  • llms.txt
  • llms-full.txt
  • Sitemap

© 2026 Lite Route Planner. Free for up to 50 addresses. No credit card.

  • Privacy
  • Terms
  • Refunds
Log inGet Started