Key takeaways
- Give every contract a visit count and a fee.
- Mark visits Completed so the balance stays true.
- Record the chemical and quantity on every visit.
- Let the warranty dates decide free or chargeable.
A pest control contract is a promise of a number of visits over a period, and the money is collected in advance. If nobody counts the visits already delivered, the business either short-changes the client or gives away free work. PestDesk PH counts visits against the contract, costs each treatment from the chemical used and the technician paid, and shows which sites are overdue before a client has to call.
Make the contract a visit balance
A contract records the visits included, the fee, and the next scheduled visit. Every visit marked Completed increases visits completed, and visits remaining is what the business still owes.
When visits remaining hits zero, the status shows Contract used up, which is the signal to renew rather than to keep servicing for free.
Cost the treatment, not just the visit
A visit records the technician, treatment type, areas treated, chemical, and quantity used. Chemical cost is the quantity times the chemical unit cost, and technician pay is looked up from the technician list.
Visit cost is the two added together, which is the number to compare against the contract fee divided by the visits included.
Keep the chemicals honest
Chemical stock starts from an opening quantity, rises with purchases, and falls with the quantity used on completed visits. On hand and stock value are computed per chemical.
A reorder level per chemical means the sheet says which drum to buy before the route goes out short, instead of after a technician arrives with an empty tank.
Handle re-treatments by date
A re-treatment request points at the original visit and carries a warranty period in days. The sheet computes the warranty end date from the visit date and marks the request Free re-treatment or Chargeable.
That single column ends most arguments about whether a callback was covered, because the dates decide it rather than the conversation.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
PestDesk PH Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.
No FPA licensing, pesticide handling or dosage advice, safety certification, chemical label compliance, treatment effectiveness guarantees, official receipts, or tax filing.
Frequently asked questions
What if a client needs more visits than the contract includes?
Visits remaining goes to zero and the status reads Contract used up. Open a new contract or add the extra visits to the current one.
Can two chemicals be used on one visit?
Record the main chemical on the visit row and log a second visit row for the second treatment, or adjust stock with a purchase correction.
Does it tell me how much chemical to mix?
No. It records what you used and what remains. Mixing, dosage, and handling follow the product label and your own training.
Does this replace official records?
No. No FPA licensing, pesticide handling or dosage advice, safety certification, chemical label compliance, treatment effectiveness guarantees, official receipts, or tax filing.
