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.
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:
| Source | What 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:
| Column | What it answers |
|---|---|
| Date, Site #, Time in, Time out | Where you were and for how long, to the minute |
| Service code | What you did: plowed, walks cleared, de-iced, anti-iced, inspected, or could not service |
| Trigger or reason for visit | Why you were there: the contract trigger, a refreeze check, a customer call |
| Accumulation on arrival | What you found, in the depth unit the header names |
| Air temp, Pavement temp, Temp source | A reading you can point to, or nothing (optional) |
| Product applied, Quantity and unit | What went down and how much of it |
| Crew on site | Who was there |
| Photos / notes ref | Which photo files or app entries belong to this row |
| Customer or witness | Whoever 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?
Should I record air and pavement temperature on a snow log?
How long should I keep snow removal logs?
Does a service log replace the snow removal contract?
Sources
- 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 .
- 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 .
- Protecting People and Property from Snow and Ice. Utah Division of Risk Management. Retrieved .