# A pest control service log in SharePoint

> For the full documentation index, see https://250highstreet.com/llms.txt

> Keep one row per pest control visit: site, date, area treated, follow-up and next visit date, in two SharePoint lists with views for visits due.

Build a Service visits list with one row per visit: site, date, area treated, follow-up and next visit date. Link it to a Sites list and save a Visits due view, so you see which sites are due and have the history at hand for an audit.

A Lookup column ties each visit to its site, and a Next visit logged flag lets the due view hide finished work. The log repeats what your provider gave you. How long to keep records is not covered here, so ask your provider, insurer or attorney. Exact names may differ on your screen.

## Why visits go unlogged

A technician works a route, spends a short time at each stop and leaves a slip at the front desk. The provider's office may send a PDF to whoever is on the account. A tenant who spots activity between visits calls someone else entirely. Then a manager preparing a walk-through at Site 12 asks for its last three visits, and the answer is spread over a desk tray, an inbox and a phone note.

A list changes where that answer lives. Each visit becomes a row in one place, so the three most recent visits at a site are a single view away.

## What you are building

The finished tracker has two lists. "Sites" is a short directory, typed once. "Service visits" grows by a row per visit, and each row carries a Lookup back to its site, a visit date, a free-text area treated, a follow-up note, a next visit date and a Next visit logged flag.

If lists are new to you, start with "[Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)". A comparable log for equipment is in "[An equipment maintenance log in SharePoint for a clinic or lab](/guides/equipment-maintenance-log-clinic-lab/)". The basics are not repeated below.

## What a visit row may say

Our advice, not a Microsoft rule. Before building, settle what a visit row is allowed to say.

Treatments and products: record where the technician worked, in the words on the slip. Leave out product names, doses and strength claims unless the provider's paperwork prints them, and even then the file holds the detail, not a column.

Customer access: if a tenant or department must clear a room before a visit, put that in Follow-up so the next booking inherits it.

Re-treatment windows: copy the date the provider names into Next visit date. Do not work one out yourself from a gap between visits.

Retention and audits: this guide sets no rule on how long paperwork is kept. Ask your attorney, insurer or auditor.

Access: a view changes what is displayed, not who may open the list. Use permissions for that, and ask your admin which groups to use.

## Columns at a glance

Sites: Site name, Area or address note, Provider.

Service visits: Visit, Site (Lookup), Visit date, Area treated, Follow-up, Next visit date, Paperwork attached, Next visit logged.

## Step 1. Create the "Sites" list

Microsoft's help page on creating a list says: "select + New \> List." It then says to choose "Blank list: Choose to start a list from scratch," and to "Add a list Name, Description (optional)" and select "Create." Name the list "Sites". To add columns, Microsoft says to "select + Add column."

Set up these columns:

1.  Title (Single line of text). Rename the Title column to "Site name". Type a name people use, such as "Back warehouse".
2.  Area or address note (Single line of text). Keep it short.
3.  Provider (Single line of text). The company that services the site.

Add one row for each location.

## Step 2. Create the "Service visits" list

Make a second blank list and name it "Service visits". This is the list that grows, one row per visit. Add the columns below in this order:

1.  Title (Single line of text). Rename it "Visit" or turn off Require. A site name plus a date, such as "Site 12 2026-10-14", works as a label.
2.  Site (Lookup). Add a column, choose Lookup, then follow Microsoft's wording: "Under Select a list as a source, select the source list to get information from." Choose "Sites". Next comes: "Under Select a column from the list above, select what information you want to display from the source list." Choose "Site name". One rule from Microsoft governs placement: "Lookup columns should be created and used within the same site." Both lists therefore belong on one site.
3.  Visit date (Date and Time, date only).
4.  Area treated (Single line of text). Free text, copied from the paperwork, such as "Loading dock and east storeroom". No dropdown, because areas differ by site.
5.  Follow-up (Multiple lines of text). Whatever the paperwork asks of you, in the provider's words. Leave blank when it asks for nothing.
6.  Next visit date (Date and Time, date only). Copy it from the provider's schedule.
7.  Paperwork attached (Yes/No). Set its default value to No in the column settings. Tick it after the file is on the row.
8.  Next visit logged (Yes/No). Set its default value to No in the column settings. Tick it on the earlier row once the next visit has a row of its own. This flag is what lets the due view hide finished work.

A second test row helps: "Site 7 2026-09-02" with a Follow-up note and Next visit logged ticked. It should not show in the due view in Step 4.

## Step 3. Add a visit

Take Site 12 as the example. The technician's slip is dated 2026-10-14 and reads "Loading dock and east storeroom, bait stations checked, seal gap by dock door, return 2026-11-11". The row for it has Visit "Site 12 2026-10-14", Site "Site 12", Visit date 2026-10-14, Area treated "Loading dock and east storeroom", Follow-up "Seal gap by dock door", Next visit date 2026-11-11, Paperwork attached ticked once the slip is scanned onto the row, and Next visit logged left at No.

When the 2026-11-11 visit gets its own row, go back to the 2026-10-14 row and tick "Next visit logged". A slip that has not arrived yet leaves "Paperwork attached" at No, which makes it easy to find. Enter every visit from the slip in front of you, not from memory.

## Step 4. Build the "Visits due" view

This is the view you open every week. It lists visits whose successor is not yet recorded.

1.  In "Service visits", open the view menu and pick "Edit current view" to reach the classic view editor, or make a new view called "Visits due".
2.  In the Filter section, choose "Show items only when the following is true".
3.  First condition: Next visit date, "is less than", \[Today\]+14. Add a second condition joined by And: Next visit logged, "is equal to", No.
4.  Sort by Next visit date, ascending, and save.

Microsoft's help page on filtering a view says: "There are two keywords that you can use to filter based on the current day \[Today\], or the current user \[Me\]." It also says: "It is not possible to use the \[Today\] or \[Me\] filters when filtering using a column header," and "You must use the classic view editor to filter columns using these keywords." Its own example uses arithmetic with \[Today\]: "Modified is greater than \[Today\]-7."

Read the result like this: a row stays visible until its Next visit logged box is ticked. A row with a past date that is still unticked means the next visit is not on file. Call the provider's office or the site contact to find out whether it happened, and enter it or the new date.

## Step 5. Build the "By site" view

Create a view named "By site". Sort by Site, then by Visit date, newest first. Microsoft says you can click a column heading and choose "Filter by" to filter from a header. That works for a quick check of one site. For a saved view that you share, use the classic view editor.

## Step 6. Weekly pass over "Visits due"

Open "Visits due" at the start of each week. Past-due rows go to the provider's office for a date. Then filter "Service visits" by Paperwork attached at No from the column header, and ask the provider for each missing slip. Then open "By site" and scan the Follow-up notes for a site that keeps asking for the same repair, such as a door gap, and raise it with the site contact or the provider. Our advice, not a Microsoft rule.

## What to avoid

- Adding columns for bait or spray product names. The slip names the product; the file keeps it.
- Logging a tenant's sighting report as a visit. No technician came, so it belongs in Follow-up on the next real visit.
- Working out a Next visit date yourself from the gap between visits. Copy the date the provider gives.
- Building the two lists on separate sites, which breaks the Lookup column's same-site rule.
- Pasting a whole report into Follow-up. A line or two keeps rows readable.

## Honest limits

A row is typed text. It does not prove a technician came, and it does not check the slip; the slip is the record. No reminder goes out either: the due view only helps whoever opens it. For an email before a date, see "[Send a reminder before a due date in a SharePoint list](/guides/send-reminder-before-due-date/)".

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### Does this log meet an audit or inspection requirement?

This guide cannot say. Rules differ by place and by business. Ask your auditor, insurer or attorney which records you must keep and how. This list only records what you type and attach.

### Is there a pest control service log template?

Not as a file. "Columns at a glance" lists both lists, and Step 3 shows one filled-in visit to copy.

### Is there a printable pest control log sheet or log book?

This guide builds the log as a SharePoint list that staff fill in on screen, not a printable sheet. Attach the provider's paperwork to each row for the file.

### What does a pest control service report entry look like?

One row per visit, copied from the slip: Site 12, visit date 2026-10-14, "Loading dock and east storeroom" as the area treated, "Seal gap by dock door" as the follow-up, and the return date the provider named, 2026-11-11.

### How do I show visits due in the next two weeks?

In the classic view editor, filter Next visit date to "is less than" \[Today\]+14. Microsoft says the \[Today\] filter needs the classic view editor. It does not work from a column header.

## Sources

- [Microsoft Support, Use filtering to modify a SharePoint view](https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4)
- [Microsoft Support, Create a list](https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-a-list)
- [Microsoft Support, Create list relationships by using lookup columns](https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-list-relationships-by-using-lookup-columns)

## Related guides

- [Home care visit log in SharePoint, with missed-visit view](/guides/home-health-visit-log-sharepoint/)
- [A calibration log in SharePoint](/guides/calibration-log-sharepoint/)
- [Vet clinic case log, drug log and vaccine reminders in SharePoint](/guides/veterinary-clinic-case-log-sharepoint/)
- [Lawn care customers and crew schedule in SharePoint](/guides/lawn-care-customer-schedule-sharepoint/)

Source: https://250highstreet.com/guides/pest-control-service-log-sharepoint/