How to Schedule Recurring Pest Control Routes Without Spreadsheets

A pest control technician's day is not a plumber's. A plumber runs 4-to-6 stops of 60-to-120 minutes each. A pest tech runs 15-to-25 stops of 15-to-45 minutes each, on tight quarterly or monthly cycles, with chemical usage logged on every visit and a customer base that is 80%+ recurring. The spreadsheet that worked at 80 accounts breaks at 400 — not because Excel cannot hold the data, but because manual filtering, routing, confirming, billing, and chemical logging becomes a full-time job before it becomes accurate.

This guide walks through six steps to move a pest control operation off spreadsheets onto an automated recurring-route system. Written for 1-to-10-truck operators with a mix of residential quarterly (QPC), monthly commercial, termite, and one-off emergency calls. Real cadences, real chemicals, real EPA label documentation.

The classic back office: a master spreadsheet filtered every Friday for 'due in the next 30 days,' exported to a shared calendar with routes eyeballed in Google Maps, carbon-copy service tickets stuffed in a monthly folder for the state chemical summary, and biweekly QuickBooks billing from completed tickets. Two hidden costs bleed margin: churn from missed service windows (2 weeks late and quarterly customers cancel), and month-end chemical reconciliation gaps nobody can explain. The steps below fix both.

The central concept is the service agreement. A customer does not buy one visit — they buy a year of quarterly service, a month of commercial unlimited service, or a 5-year termite bond. The agreement owns pricing, cadence, covered pests, chemical choices, and start/end dates.

A QPC agreement typically covers general pest (ants, roaches, spiders, silverfish), exterior perimeter, interior as-needed, 4 visits per year at $35-$55 per visit. A commercial monthly agreement covers named pests in the contract, all facility zones, IPM inspection and treatment, often with pheromone trap monitoring. A mosquito agreement runs 6-to-8 visits across the warm season. A termite bond covers annual inspection plus treatment if active infestation is found.

In Deelo the service agreement is a Project record with start date, end date, cadence (e.g., every 90 days), price per visit, chemical profile, covered pests, and a link to the parent property. The agreement generates visits automatically. Canceling stops future visits; renewing extends the end date and updates pricing.

Import your spreadsheet by creating one agreement per active customer. A customer with QPC plus termite bond needs two agreements on the same property.

Different service lines run on different cadences. Hard-code those into the agreement template rather than scheduling each visit one-off.

QPC: 90-day cadence, 4 visits per year, same month each quarter (Feb/May/Aug/Nov). Drift more than 2 weeks off schedule and you lose the brand trust recurring revenue depends on.

Monthly commercial: 30-day cadence, locked to a day-of-month (first Wednesday, second Tuesday) because facility managers want predictability.

Mosquito program: 21-day cadence during the 6-to-8-month warm season — late March in the Southeast, late April Midwest, early May Northeast. Pause for winter, resume in spring.

Termite bond: Annual inspection with a 12-month cadence plus triggered treatment visits. Annual inspection is a bond compliance requirement — missing it voids the bond.

Wildlife / one-off: No cadence; on-demand with a possible 30- or 90-day follow-up.

In the automation engine, each agreement type has a template with cadence, billing frequency, and visit template. Creating an agreement is one dropdown selection.

A residential QPC tech completes 15-to-25 stops per day. Commercial techs on larger facilities run 4-to-10 stops. Build the route 1-to-2 days in advance by pulling jobs due in the target window and clustering by zip code plus road network.

The non-obvious routing constraint is time windows. Some accounts are 'anytime' — leave a door tag, exterior only. Others require the homeowner home (interior treatment, dog in yard, access code needed) and have to be booked into a confirmed slot. Route builders that ignore time windows schedule interior-access stops at 8am when the homeowner said 2pm.

In Deelo's Field Service app, each stop has an 'access type' field (exterior-only, homeowner-required, keyholder-on-site, dog-in-yard) and a preferred time window. The route builder sorts by geography, then reorders within each cluster to match time windows. Customers get 30-minute arrival texts as the tech completes each prior stop.

For multi-truck territories, split the area into persistent technician zones. A QPC customer should see the same tech every visit for a year or more — that relationship is worth more than 5% better routing math. Cross-zone coverage only for vacation weeks or seasonal spikes.

Chemical usage tracking is the step most spreadsheet-based operations half-do — and it is the compliance exposure most likely to bite. EPA and every state department of agriculture require a record of every pesticide application: product with EPA registration number, active ingredient, target pest, application site, amount applied, applicator license number, and date and time.

On the mobile app this is a 30-second form at each stop. Tap the product from a pre-loaded truck inventory dropdown, enter the amount in ounces or gallons, select target pest, confirm application sites. The app pre-fills applicator name, license number, and date. Customer signature field if they are home.

In Deelo the chemical log is a custom field set on the service visit. End of day, usage rolls up to a dispatcher view — totals per product, flagged discrepancies if truck inventory drops faster than logged applications would predict. End of month, the state-required summary (monthly Pesticide Use Report or quarterly summary, varies by state) generates from the logged data.

This also enables EPA label compliance. Every product has label-specified maximum rates, restricted-use conditions, re-entry intervals, and prohibited uses. Log against the label and flag over-applications before the tech leaves.

With service agreements as the primary object, billing runs off the agreement, not completed service tickets. That single change shifts you from 2 hours of post-service invoicing every other Friday to 15 minutes of exception review on the first of the month.

Monthly autopay for QPC: The modern standard. A quarterly program priced at $140 billed as $35/month on autopay, regardless of whether a visit fell in that month. Smooths revenue, reduces billing friction. Deelo's Invoicing app fires the charge on the same day each month.

Per-visit billing: For commercial accounts with per-service purchase orders. Service ticket closes, invoice auto-generates, Net 15 or Net 30 applies.

Annual or semi-annual prepay: Often offered at 5-10% discount. One upfront charge, visits scheduled on cadence.

Termite bond renewal: Annual charge on the bond anniversary.

Payment method stays on file against the property. Card updater services handle expired cards. Failed payments trigger a dunning workflow — automated retry at day 3 and day 7, dispatcher call task at day 10. Zero routine declines without the customer knowing.

The biggest driver of pest control margin is retention. A QPC customer who stays 3 years is worth 8x acquisition cost. A customer who cancels after one year is a loss. Retention is driven by technician quality — not price, not marketing — so measuring technician quality directly is the foundation for retention management.

Track four metrics per technician per month: (1) completion rate of scheduled stops (target >98%), (2) on-time arrival rate within the committed 2-hour window (target >95%), (3) customer callback rate within 14 days (pest breakthrough requiring re-treat, target <5%), and (4) cancellation rate within 60 days of a tech's visit (target <2% monthly).

In Deelo these metrics pull from service tickets, timestamped Field Service arrivals, return-visit records, and agreement cancellation events. A dashboard surfaces per-tech trends. A climbing callback rate gets paired with a senior tech for a ride-along. A climbing on-time miss gets route load rebalanced.

Add a 2-question feedback text 24 hours after service ('On a scale of 1-10, how did we do?' plus open comment). Scores of 1-6 trigger a callback task. Catching one unhappy customer before cancellation is the whole retention program.

Deelo's Projects, Field Service, Automation, Docs, and Invoicing work together. Service agreements live in Projects with cadence, covered pests, chemical profile, and pricing. Automation fires visit creation on cadence. Field Service routes the day, captures chemical logs and signatures, and feeds metrics back. Docs generates state pesticide use summaries. Invoicing runs monthly autopay, per-visit, or prepay against the agreement.

At $19/seat/month a 6-person operation (3 techs, 1 dispatcher, 1 office manager, 1 owner) runs the back office for $114/month — no separate chemical tracker, compliance spreadsheet, or billing integration. Retention metrics roll up automatically. EPA label maxima flag over-applications. Failed autopays trigger dunning.