Snow Removal Log Sheet: Snow and Ice Service Log Template

Free snow removal log sheet in Excel: one row per visit with time in and out, trigger, accumulation, temperatures, salt used, crew, photos and a witness line.

Preview a tab

The download always includes every tab. This only changes what you see below.

Rows

The sample rows are illustrations on this page only. The site, the crew, the readings and the quantities are invented to show how a row reads; none is a rate, a trigger, or a reading to copy. The downloaded workbook ships blank on every tab.

One row per visit, written at the time by the crew that did the work: times in and out, what was done, what went down and how much, and who saw it.

Service codes on the Service log tab
P Plowed
Lot, drive aisles, or driveway plowed or pushed back.
W Walks cleared
Sidewalks, steps, or entrances shoveled or snow-blown.
D De-iced
Salt, sand, brine, or other ice melt applied. Enter the product and quantity.
A Anti-iced
Surfaces pre-treated before the event. Enter the product and quantity.
I Inspected only
Site checked and no service done. Enter what you found.
X Could not service
Blocked, parked over, or locked out. Enter the fact and when you came back.

These six codes are the workbook's own convention, printed on the Read me tab so whoever reads the log reads the same key the crew wrote from. Use more than one when a visit did more than one thing, for example P W D.

Download the Excel service log 3 tabs · per-visit service log, numbered site list, read me with the code legend

XLSX · 3 tabs · blank grid Filename snow-and-ice-service-log-template.xlsx · one workbook per route per season.

A preview of one tab of the downloadable workbook. Print the Service log tab for the truck; each printed page is one landscape sheet of visit rows.

Snow and Ice Service Log Service log
Blank
Company name
Company phone
Season
Route / crew lead
Depth unit (in or cm)
Temperature unit (F or C)
Log kept by
Logs filed at (office or drive)
DateSite #Time inTime outService codeTrigger or reason for visitAccumulation on arrivalAir tempPavement tempTemp source (instrument or station)Product appliedQuantity and unitCrew on sitePhotos / notes refCustomer or witness (print and sign)

The downloaded tab has 60 blank rows.

Service record worksheet only. It is not legal advice and does not decide what you must keep. Your contract, your insurer, and the law where the site sits decide what to record and for how long.

Print or save

Service record worksheet only. It is not legal advice and does not decide what you must keep. Your contract, your insurer, and the law where the site sits decide what to record and for how long.

What this log is (and isn't)

This is a blank record, not a calculator: it computes nothing, scores nothing, and validates nothing. It is the per-visit record a snow contractor keeps for the day an insurer, an adjuster, or a lawyer asks what happened on a site at a particular time. That reader is not your customer, and the snow removal contract is a different document: the contract sets the trigger and the response window, and this log is the evidence of what you did against them.

Two grid tabs, plus a Read me:

  • Service log. One row per visit, written at the time by the crew that did the work: times in and out, what was done, what went down and how much, and who saw it.
  • Site list. The numbered site register every log row points at, with the trigger and response window copied from that site's contract.

The Site # is the spine. Number every site once on the Site list tab, copy that site's trigger and response window from its contract, and put the same number on every Service log row. When a question arrives about one location on one date, filter by Site # and date and print the rows, including the visits either side of the one in question.

How the Read me tab tells the crew to write an entry:

  • Write the row at the time of the visit, not at the end of the shift or the storm.
  • Times to the minute, in and out, for every visit, including visits where nothing was done.
  • Name the product and the quantity every time material goes down, in the unit you buy it in.
  • Record what was done and what was found. Leave out opinions and guesses about the site or the customer.
  • Fill the temperature columns only with a reading you can point to, and name the instrument or weather station.
  • Note the photo file names or the app reference, so a photo can be matched to its row.
  • Customer or witness line: whoever was on site and willing to sign. Leave it blank rather than invent one.

Temperature is the one field the published advice disagrees on, so both views are shown here rather than one of them being picked for you:

SourceWhat it says
Landscape Ontario, Battle of Evidence: The side with the best records often wins a slip and fall lawsuit (Visnja Jovanovic, Moodie Mair Walker LLP, September 2019) "The time of salting, type of salt or ice-melt, amount of salt used, equipment used to spread salt, precise location of salting, snow contractors performing the salting, weather, temperature, sun/overcast/dark."
Snow and Ice Management Association (SIMA), If you didn't record it, it didn't happen (Ken Boegeman, CSP, ASM, December 2025) "Do not record weather or conditions like temperature, precipitation or ice conditions unless you have a reliable and verifiable source or measurement."

The workbook keeps both temperature columns, marks them optional, and adds a Temp source column for the instrument or the weather station the reading came from. Leave all three blank when you did not take a reading. Which approach your insurer prefers is a question for your insurer.

How long to keep it. The workbook sets no retention period, and this page does not invent one. The one figure printed here is quoted from its source: SIMA's If you didn't record it, it didn't happen (Ken Boegeman, CSP, ASM, December 2025) advises: "Keep at least three to eight years, depending on local laws and insurance requirements." Your insurer and your attorney decide what applies to you. Quantities go in as applied; to plan them before the storm, use the de-icing salt calculator. Service record worksheet only. It is not legal advice and does not decide what you must keep. Your contract, your insurer, and the law where the site sits decide what to record and for how long.

The person who reads a snow log closely is almost never the customer. It is an insurance adjuster, a defense lawyer, or a judge, months after the storm, asking what happened on one site at one time. This workbook is the record you hand them: one row per visit, written at the time, by the crew that did the work. Download it free, with no signup, keep one workbook per route per season, and fill it in Excel, Google Sheets, or LibreOffice, or print the Service log tab for the truck.

Who the log is for

SIMA’s December 2025 article on in-season documentation puts the stakes in one line: “In the eyes of the court or an insurance adjuster, what is not documented is open for debate.” A customer wants to know the lot was clear by opening time. The adjuster wants to know when you arrived, what you did, what you put down, how much of it, and when you left, for the visit in question and the visits either side of it. That is a different question, and it needs a different document from an invoice or a service report.

Writing for Ontario contractors in 2019, defense counsel Visnja Jovanovic gave the reason a log has to be made at the time rather than rebuilt afterwards: “Records that are contemporaneous and kept as part of the usual course of business can be admitted into evidence during a trial.” That is a statement about Canadian courts, and how evidence rules work where your sites are is a question for your own attorney. The habit it describes travels anywhere: write the row on site, every visit, in the same format.

One row per visit, not per storm

The same SIMA article notes that “Courts and attorneys often request a chronological record of what was done onsite, not just general storm summaries.” A storm summary that says “plowed and salted all sites overnight” answers nobody’s question. A row per visit does. Here is what each column on the Service log tab is for:

ColumnWhat it answers
Date, Site #, Time in, Time outWhere you were and for how long, to the minute
Service codeWhat you did: plowed, walks cleared, de-iced, anti-iced, inspected, or could not service
Trigger or reason for visitWhy you were there: the contract trigger, a refreeze check, a customer call
Accumulation on arrivalWhat you found, in the depth unit the header names
Air temp, Pavement temp, Temp sourceA reading you can point to, or nothing (optional)
Product applied, Quantity and unitWhat went down and how much of it
Crew on siteWho was there
Photos / notes refWhich photo files or app entries belong to this row
Customer or witnessWhoever was on site and willing to sign (optional)

The Site list tab is the spine. Number every site once, copy its trigger and response window from the contract, and put that number on every log row. When a question arrives about one location on one date, filter the Service log by Site # and date and print what comes back.

The trigger column ties the log to the contract

A log row on its own shows you were on site. It does not show you did what you agreed to. The agreement does that, and the snow removal contract template is where the trigger depth, the response window, and the areas covered are written down. The Site list copies those terms per site, and the “Trigger or reason for visit” column records, visit by visit, whether the trigger depth was met or why else you came. Visits you make below the trigger (a refreeze check, a call from the property manager) belong on the log too, with the reason written in.

Inspection-only visits matter for the same reason. A row that reads “I, trace, no service needed” at 2 a.m. is evidence that somebody looked. A blank night is not.

Product and quantity, every time

Every time material goes down, the row names the product and the quantity in the unit you buy it in. The Landscape Ontario article lists salt-log contents as “The time of salting, type of salt or ice-melt, amount of salt used, equipment used to spread salt, precise location of salting, snow contractors performing the salting, weather, temperature, sun/overcast/dark.” This workbook carries the time, the product, the quantity, the site, and the crew on every row; the equipment goes in the notes reference if you track it.

The log records what was applied. Planning what to apply is a separate job, done before the storm, with the de-icing salt calculator. Keeping the two apart is useful: when the applied quantity on a row runs well over the plan, the log is where you find out, and the notes column is where you say why.

Temperature: shown both ways

The two sources this page relies on disagree about temperature. Landscape Ontario’s list above includes “weather, temperature”. SIMA’s article says “Do not record weather or conditions like temperature, precipitation or ice conditions unless you have a reliable and verifiable source or measurement.” The “What this log is (and isn’t)” block below shows both side by side. The workbook keeps the air and pavement columns, marks them optional, and puts a Temp source column beside them, so every number has an instrument or a weather station next to it, or the cells stay blank.

What not to write

SIMA’s article is direct about this, too: “Do not write personal impressions, guesses or comments like ‘this looks unsafe’ or ‘the customer is difficult.’” The Read me tab turns that into one rule the crew can follow: record what was done and what was found, and leave opinions out. A log that sticks to facts is easier to stand behind than one that speculates.

Crew time is a different record

The crew column says who was on site. It is not payroll. Paid hours, breaks, and travel between sites belong on the crew timesheet template, which answers a different reader: your bookkeeper, not an adjuster. Time in and time out on the log are site times. They will not add up to the hours on a timesheet, and they are not meant to.

If part of a route is run by a subcontractor, the log matters twice. The Utah Division of Risk Management’s guide for state facilities notes that “Logs are a valuable record-keeping tool that helps property managers match up and verify invoices from snow removal subcontractors.” The subcontractor agreement template has a site-log clause for exactly that: the sub hands in a row per visit, in this format, before the invoice is paid.

North of the border

The header block names the units in use, so the same workbook works in centimeters and degrees Celsius. In Ontario the log does more than defend a claim. The snow contracts guide for Ontario and the Prairies covers the provincial notice regime and why Canadian contractors keep service logs as a matter of routine.

How long to keep it

This page does not invent a retention period. The one figure it prints is quoted from its source, SIMA’s article by Ken Boegeman: “Keep at least three to eight years, depending on local laws and insurance requirements.” Your insurer and your attorney decide what applies to your sites. Nothing you do on this page is saved to Fieldwynn: the workbook is a static file, and the only copy is the one you download.

Frequently asked questions

What should a snow removal log sheet include?
One row per visit with the date, the site, time in and time out to the minute, what was done (plowed, walks cleared, de-iced, inspected), the trigger or reason for the visit, the accumulation on arrival, the product applied and its quantity, the crew on site, a photo or notes reference, and a customer or witness line when someone is there to sign. SIMA's December 2025 article on in-season documentation asks for logs that are "Time-stamped with arrival and departure times to the minute" and that record the "type and amount of materials used". This workbook has a column for each, plus optional temperature columns with a source column beside them.
Should I record air and pavement temperature on a snow log?
The published advice disagrees, so this page shows both views instead of picking one. Defense counsel writing for Landscape Ontario in 2019 lists "weather, temperature" among what salt logs record. SIMA's 2025 documentation article says the opposite unless you can back it up: "Do not record weather or conditions like temperature, precipitation or ice conditions unless you have a reliable and verifiable source or measurement." The workbook keeps both temperature columns, marks them optional, and adds a Temp source column for the instrument or weather station. Ask your insurer which it prefers.
How long should I keep snow removal logs?
This page does not set a retention period of its own. The one figure it prints is quoted from SIMA's December 2025 article If you didn't record it, it didn't happen (Ken Boegeman): "Keep at least three to eight years, depending on local laws and insurance requirements." Your insurer and your attorney decide what applies to the sites you service.
Does a service log replace the snow removal contract?
No. The snow removal contract sets the trigger, the response window, and who is responsible for what. The log is the record of what you actually did against those terms, visit by visit. A log with no contract behind it shows you were on site; it cannot show you did what you agreed to do.

Sources

  1. If you didn't record it, it didn't happen: effective in-season documentation (Ken Boegeman, CSP, ASM; published 2025-12-12). Snow and Ice Management Association (SIMA). Retrieved .
  2. Battle of Evidence: The side with the best records often wins a slip and fall lawsuit (Visnja Jovanovic, Moodie Mair Walker LLP; published 2019-09-15). Landscape Ontario. Retrieved .
  3. Protecting People and Property from Snow and Ice. Utah Division of Risk Management. Retrieved .

Get early access

Fieldwynn is the field-first app we are building for small crews — simple in the truck, powerful in the back office. It is not out yet; join the early-access list and be first when it launches for your trade.