Snow & Ice Service Log + Pricing Calculator (Excel / Spreadsheet Template)

Track every snow plowing and salting visit and price your snow work from your own costs, all in one spreadsheet. Built for lawn care and landscaping businesses that add snow removal in winter.

What it does:

• Service log for up to 500 visits: date, start/end time (handles visits past midnight), site, conditions, inches, services, salt used, crew, notes and a photo reference number
• Each visit's charge is calculated from the site's pricing method: per push, per inch or seasonal
• Sites list for up to 100 properties, each with a size tier and pricing method
• Pricing calculator that compares per-push, per-inch and seasonal pricing for one site side by side, with a margin check against your target
• Season summary per site, with a check that totals match the log
• Printable blank field log (1 US Letter page, landscape) with space for your business name (no FieldReady branding)

Included:

• Workbook with fictional example data, so you can see how it works
• Blank workbook, ready for your own rates and sites
• README with setup notes

Good to know:

• All rates are your inputs (labor, equipment, salt, minimums, overhead, margin, tier and per-inch prices). It doesn't include or suggest market rates.
• Results are estimates. Always review prices and invoices yourself.
• Not a contract and not legal, insurance or liability advice. No contract template is included.
• Plain formulas, no macros. Some sheets are protected without a password so formulas aren't overwritten by accident.
• Tested in LibreOffice. It should open in Excel and Google Sheets, but it hasn't been verified there yet.
• No automatic alerts or notifications. Totals update when the file is opened or recalculated.
• Site names must be unique. Inches are counted per visit, so two visits in one storm count that snowfall twice.
• Digital download. Nothing is shipped. Refund policy: replacement files if there's a problem with your download.

Made by FieldReady Digital, who also makes the Equipment Maintenance Log and the Lawn Care Pricing & Bid Calculator.