A recurring route has different bookkeeping needs from an occasional one-off job. You need to know when a property is due, the service frequency, the agreed price and whether that week's work was completed and paid.
Start with one dependable customer list
Include customer name, service address or route area, contact method, frequency, regular day, quoted amount, property notes, and any special access instructions. Store personal contact information in a tool with suitable access controls rather than publishing it to a shared public document.
Separate the schedule from the job log
A master list tells you the regular cadence; a visit log tells you what actually happened. Record date, completion status, extra services, amount invoiced, amount received and reschedule reason when relevant. This distinction prevents skipped visits from being mistaken for completed ones.
Example of a weekly workflow
- Review next week's recurring customers by route or neighborhood.
- Mark weather-related or customer-requested changes.
- Log actual service completion at the end of each job.
- Reconcile jobs performed with invoices and payments.
- Update the recurring schedule only after confirming a lasting change.
How to avoid route-tracker clutter
Use consistent status labels, one row per completed visit, and a separate list for open invoices. If two employees share a route, assign clear responsibility for updating the record so the same job is not logged twice.
The MintedTools digital-template collection on Etsy includes a Lawn Care Route Tracker and other service-business spreadsheets if you'd rather start with an editable template.