The full cost of an unavailable quarterly pest stop
Build a traceable worksheet for lost contribution, paid labor, extra drive time, rebooking, and repeat dispatch costs when a customer is unavailable.
Why the invoice amount is the wrong starting total
An unavailable quarterly stop does not cost the invoice amount. It also does not cost the invoice amount plus every dollar attached to the original route and the return visit. Both shortcuts turn a useful pest control margin variance into a small accounting crime scene.
The close-day mismatch is real: the route may show an attempted stop, payroll shows paid time, dispatch shows a reschedule, and service revenue lands later, or not at all. The finance question is simpler: How did this outcome differ from one successful planned stop?
Flag the outcome before doing any math:
- Permanent loss: the service will not be completed or collected.
- Delayed completion: the service will happen later and be billed then.
- Billed as planned: the recurring charge remains, but the customer still needs service, a credit, or a make-good visit.
That flag decides whether lost contribution belongs in the worksheet at all.
Set the baseline before filling in the worksheet
Start with the economics of one completed quarterly stop. The baseline is not the whole route, and it is not a fully allocated P&L. It is the expected revenue from this stop less the variable service cost that would have happened if the stop had been completed.
Expected contribution = expected service revenue − avoidable variable service cost
This is the comparison point for pest control job costing: actual outcome versus one successful planned visit. The logic follows relevant-cost analysis: count future cash-flow changes caused by the event, not sunk cost, depreciation, or a fixed-overhead allocation that would exist either way.
Keep a source trail for every input:
- Route or GPS record for arrival, departure, and added drive time
- Payroll detail and burden schedule for loaded labor
- Dispatch history and CRM call logs for rebooking work
- Customer ledger for invoice, payment, credit, refund, or later collection
- GL account mapping for the reforecast tie-out
Set one cut-off date for the reforecast. If a stop is recovered after that date, show it as later recovery, not as a reason to rewrite the first worksheet.
Build the unavailable-stop cost line by line
Use one row for each change caused by the unavailable customer. A technician’s travel between job sites during the workday is generally compensable time under the U.S. Department of Labor’s hours-worked guidance, so route timestamps are more than a routing detail here.
| Cost line | Calculation | Source record | GL account | Owner and period | Double-count check |
|---|---|---|---|---|---|
| Lost contribution | Unrecovered revenue − variable costs truly avoided | Customer ledger, invoice status, material ticket | Service revenue and materials accounts | AP/finance; reforecast period | Do not enter missed revenue again as a separate cost |
| Failed-attempt technician time | Extra paid minutes ÷ 60 × loaded technician rate | GPS timestamps, timecard, payroll burden schedule | Direct labor | Service manager; event period | Do not add the same payroll through a labor allocation |
| Incremental drive cost | Added miles × company fleet cost per mile, or added vehicle minutes × approved rate | Telematics, odometer, fleet-cost schedule | Vehicle expense | Fleet/finance; event period | Use miles or time, not both for the same vehicle cost |
| CSR rebooking time | Handle minutes ÷ 60 × loaded CSR rate | Phone, CRM, dispatch log | Customer service labor | CSR lead; event period | Include only extra contact caused by the failed stop |
| Repeat dispatch cost | Cost of the later visit above the original successful-stop baseline | New route record, payroll, materials ticket | Direct labor, vehicle, materials | Dispatcher; later period | Do not book the full second stop by default |
| Customer credit, refund, or payment fee | Actual issued amount | Credit memo, payment record | Contra revenue or fee account | AR/AP; event period | Do not count a planned-but-never-issued credit |
Build the loaded labor rate from base wage or actual payroll cost, employer payroll taxes, workers’ compensation, and variable benefits, divided by hours under your stated policy. Leave unrelated fixed overhead out. A loaded rate should reflect paid work rather than unrelated fixed overhead.
For vehicle cost, use the company’s own fleet calculation. The IRS standard mileage rate can be an outside reasonableness check, but it is not a substitute for your fuel, repairs, insurance, lease, depreciation, and telematics records.
Unavailable-stop variance = lost contribution + failed-attempt labor + incremental drive + CSR rebooking + above-baseline repeat dispatch + credits, refunds, and fees
Run the same stop through three revenue outcomes
Here is one illustrative quarterly-stop record, not an industry benchmark. Assume expected revenue of $150, $20 of materials avoided if service never occurs, 15 extra paid minutes at a $36 loaded technician rate, eight added miles at a company fleet rate of $0.40 per mile, and a $25 credit only in the billed-as-planned case. This shared example assumes no documented repeat-dispatch cost above the planned successful-stop baseline; the full later visit is therefore not added, and the incremental amount is $0.00.
| Calculation | Permanent loss | Delayed completion | Billed as planned |
|---|---|---|---|
| Lost contribution | $150 − $20 = $130.00 | $0.00 | $0.00 |
| Failed-attempt labor | 0.25 × $36 = $9.00 | $9.00 | $9.00 |
| Incremental drive | 8 × $0.40 = $3.20 | $3.20 | $3.20 |
| Credit issued | $0.00 | $0.00 | $25.00 |
| Above-baseline repeat dispatch | $0.00 | $0.00 | $0.00 |
| Full worksheet impact | $142.20 | $12.20 | $37.20 |
The permanent-loss case counts the $130 lost contribution once. The delayed-service case does not treat revenue as gone when the same $150 service is completed and billed later. The billed-as-planned case does not call billed revenue lost, either. It shows the delivery obligation and any extra cost to meet it.
For a quick sensitivity check, change only four fields: loaded labor rate, added drive, recovery status, and customer credit. That makes the unavailable customer cost visible without pretending every reschedule has the same shape.
Tie the result to the reforecast—and the handoff
Roll worksheet totals up by branch, route, technician, customer plan, and reason code. Then tie the total to service-revenue variance and the right expense accounts. You do not need a journal entry for every missed pest control stop to see a pattern.
Bring it to the GM when frequency, dollars, repeat-dispatch rate, or recoverability moves enough to change the forecast. The response should fix failed handoffs, not assign blame.
- Require an outcome flag and reason code when dispatch closes an unavailable stop.
- Review repeat-dispatch cost and recovery within the agreed cut-off period.
- Compare route profitability analysis by plan type and notification outcome.
- Give CSRs a clean customer notification workflow for exceptions and recovery calls.
A brief Queue Up aside: queue position, revised windows, on-the-way updates, and a CSR notification log give the dispatcher and CSR a shared record of what changed. That can hand CSR time back for the work that matters after a miss: saving the relationship, not hunting for the story.