How to Schedule Recurring Maintenance Visits Without a Spreadsheet

Every maintenance plan you sell is a promise to show up. The plan is easy to sell. Showing up is what slips. It's March, spring tune-ups should have started two weeks ago, and the list of who's due lives in a spreadsheet on the office computer that only one person really understands.

Here's how to schedule recurring maintenance visits so they happen on time, every time, without depending on one person or one file.

Why the spreadsheet stops working

A spreadsheet is fine for twenty customers. It breaks for three reasons as you grow:

• It doesn't create anything. Someone has to read the sheet and book each visit by hand. When that person is out sick in April, nothing gets booked.
• It doesn't know what happened. A visit rescheduled on the board doesn't update the sheet. Two weeks later nobody's sure whether the Patels were done.
• It doesn't connect to billing. The sheet says a visit is covered. The invoice doesn't know that, and the customer gets billed for work their plan paid for.

The fix isn't a better spreadsheet. It's letting the schedule create the visits itself.

Step 1: Decide the cadence for each kind of work

Start with how often each type of visit needs to happen. Don't guess; tie it to the equipment or the contract.

• HVAC: ENERGY STAR recommends annual pre-season check-ups, with the cooling system checked in the spring and the heating system in the fall. Most residential plans sell two visits a year for that reason.
• Plumbing: usually one whole-home inspection a year, often paired with water-heater maintenance.
• Pest control: quarterly for most residential plans; monthly for many commercial and food-service accounts.
• Pool service: weekly in season.
• Commercial accounts of any trade: whatever the contract says. Read it, don't remember it.

Write the cadence down per plan, not per customer. "Gold HVAC plan: two visits a year, spring and fall" is a rule you can schedule from. "Mrs. Lee likes April" isn't.

Step 2: Pick the right home for each visit

Recurring maintenance comes in two shapes, and they're worth handling differently.

Visits that are part of a paid plan belong on the service agreement or membership itself. That way the visit schedule, what's covered and the renewal date travel together. When the plan ends, the visits stop. When it renews, they carry on.

Visits that only repeat, billed each time, like a weekly pool clean or a monthly filter change for a property manager, can be a plain recurring job: set the frequency once and let the jobs create themselves.

Keep each series simple: one frequency per series. If a commercial customer wants service on two different weekdays, set up two series rather than trying to bend one.

Step 3: Spread the visits so peak season doesn't break you

The fastest way to wreck a maintenance program is to book every tune-up in the same three weeks. Your techs are already slammed with no-cool calls in the first heat wave. That's not when every member should be due.

A few ways to spread the load:

• Stagger start dates. A customer who signs in June doesn't need a first visit in June. Set their visits around when you have room.
• Book members in the shoulder months. Cooling checks in spring, heating checks in fall, before emergency calls start.
• Batch by area. Members in one neighborhood booked in the same week cut drive time, which is where maintenance margin goes.
• Protect emergency capacity. Leave room on the board each day so a run of breakdowns doesn't push maintenance visits back by a month.

Step 4: Remind customers before the visit, not after

A visit nobody's home for is a wasted truck roll. Confirm the appointment ahead of time and remind the customer the day before. Tell them when the tech is on the way. The customer sees the plan working, and you don't burn an hour on a locked door.

Step 5: Have a rule for skips, no-answers and reschedules

Some customers will reschedule, some won't answer and some will say "skip this one." Decide in advance:

• Reschedule: move that one visit, not the whole series.
• No answer after two tries: leave a note on the job and move on, so it doesn't sit open forever.
• Customer skips a covered visit: record it on the job. If the plan promises a set number of visits, you'll want a record of who declined, not only who wasn't visited.

Write the rule down so the office handles it the same way every time.

Step 6: Treat multi-site commercial customers as several schedules

A property manager with nine buildings isn't one recurring visit. It's nine, and each site usually has its own access rules, contact and equipment. Schedule them per site, not per customer, so a locked mechanical room at one building doesn't hold up the other eight.

A few habits that help:

• One schedule per service location. Each site gets its own visits, its own notes and its own history.
• The contract's resolution time on every job. If the agreement promises a no-heat call fixed within a set number of hours, that deadline belongs on the job, not in someone's head. In FSM Navigator an agreement can record both a response time and a resolution time; the resolution time sets the SLA deadline on new jobs for that customer or location. The response time is recorded on the agreement as a reference, so keep your own process for it.
• The customer's own reference on the paperwork. Commercial accounts often won't pay an invoice without their work-order or purchase-order number on it.
• One contact for scheduling, one for access. The person who approves the visit is rarely the one with the keys.

Done this way, a multi-site account is no harder to keep on schedule than nine homeowners. It usually pays better.

Step 7: Check the schedule against the contract once a month

Once a month, compare what each plan promises with what's on the board:

• Every active plan has its next visit scheduled
• No visits are booked for plans that have ended
• Commercial contracts' resolution times match the deadlines on the jobs
• Plans renewing soon have someone assigned to call
• Equipment under warranty is checked before a paid visit goes out; the equipment warranty tracking checklist shows how

Ten minutes a month catches the members who would otherwise quietly lapse. For the program side, read how to start a maintenance membership program. For setting arrival times customers can count on, read arrival windows vs. appointment times. If you sell HVAC plans, our HVAC maintenance agreement template shows what to put on paper.

How to schedule recurring maintenance visits in FSM Navigator

FSM Navigator is one app from first call to renewals, and recurring maintenance sits at the renewals end. If you'd rather not run the steps above by hand, here's how it works. Service agreements and recurring jobs are on the Pro plan.

Service agreements and membership plans schedule their own visits. Set a visit frequency on the agreement, from daily to yearly, with an "every N" interval from the first visit date. Two visits a year works as monthly, every 6 months, starting in the first month. Each agreement location has its own visit schedule. Work the agreement covers is waived on the invoice, anything you leave unticked is billed as normal, and the invoice names the agreement that applied. Agreements the customer agreed to auto-renew renew automatically; the others send a renewal notice. See service agreements.

Recurring jobs handle everything else that repeats. Set the frequency once and each visit lands on the board as its own job. A recurring schedule can name a preferred technician and a backup; with no technician named, jobs are created unassigned and intelligent dispatch picks one. For customers who ask for a specific technician, see when to send the same tech back. You can pause and resume a schedule.

Every visit is a normal job. It shows on the technician's phone in the iOS and Android app, works without signal, and is invoiced from the job when the work is done.

See how recurring jobs work: recurring jobs.