Snow Removal Contract Template and Seasonal Pricing Spreadsheet: Excel + Google Sheets, Per-Push and Seasonal Quote Calculator

Price the whole season from your real costs - and send a contract quote your client can sign.

One payment of $49.99.

Most snow templates price one driveway visit, or hand you a blank contract to fill in. This kit is a seasonal contract system: cost each route once (crew, time, salt, fuel, equipment), set the visit count you want to price the season on, and it recovers your overhead, applies your profit - by markup OR margin, correctly - and gives you a seasonal contract price AND a per-push price from the same costing, for every route. Your costs, overhead and profit never appear on the client page.

Who it's for
Snow removal and landscaping contractors who sell seasonal contracts - residential routes, condo and commercial properties - and price them by the season, by the route, or per push. The same file prices a summer lawn-care season: visits become cuts, salt becomes materials per visit.

What it does
- Route costing engine: up to 8 routes, each with its property count, crew size, hours per visit, salt per visit (priced per kg or per tonne, as you buy it) and fuel per visit - labour, salt, fuel and equipment costed per visit and per season
- Season pricing on YOUR visit count: you enter the number of visits you want to price the season on. The workbook does not predict weather or snowfall - it prices the season you choose, and every season figure updates if you change the count
- Two price structures from one costing: a seasonal contract price and a per-push (per-visit) price for every route, plus per-property prices both ways, and a comparison block that shows the per-push total at your visit count next to the seasonal price - arithmetic, labelled as arithmetic
- Winter scenarios: add a light-winter and a heavy-winter visit count next to the count you price the season on, and every route is priced at all three counts - a season price and a per-push price at each one, all from the same costing. The counts are the visit counts you choose to price on; the kit does not predict weather or snowfall
- Push cap for seasonal contracts: set a maximum number of billed pushes and the season is priced at that cap count, with the billed total shown at each of your counts. Visits past the cap bill at an over-cap per-push rate - one you type, or the route's own per-push price if you leave it blank. Leave the cap blank and nothing changes: the ordinary seasonal price stands
- Overhead recovery your way: a percent of direct cost, a dollar amount per labour hour, or none. Profit by MARKUP (on cost) or MARGIN (on selling price) - the sheet labels which one is active and shows your effective markup AND margin across all routes
- Branded client quote: pick the route and the structure; your business name and contact block, season dates, scope of services, the price, tax line only when the tax switch is ON (rate editable - 13% Ontario default), total, terms and a client signature line
- Payment schedule that adds up: for seasonal contracts, a deposit plus monthly instalments (the final instalment is the exact remainder, so the schedule always totals to the cent). For per-push, the quote shows the per-visit total and bills each visit as it is completed
- Season log: record every visit - date, route, work done, salt used, time spent - and see season-to-date visits, salt and time per route next to your plan
- Yellow input cells; every formula is locked so the math can't be broken by accident

How it compares
- The snow spreadsheet at the low end of this shelf estimates one visit at a time and says so itself: no seasonal contracts, no routes, no season record. CrewQuote prices the season and the route, and derives the per-visit price from the same numbers.
- Some kits leave every formula visible and editable, which also means breakable. CrewQuote locks its formula cells, and the math is QA-tested: 1,658 checks against an independent pricing model, with zero deviation.
- Blank contract documents make you do the pricing somewhere else. CrewQuote's quote page is filled by the costing engine - the price on the page is the price the engine computed.

What's included (instant download)
- Excel workbook - blank template (SETUP - ROUTE COSTING - CONTRACT PRICING - CLIENT QUOTE - SEASON LOG)
- Google Sheets version - identical workbook, Sheets-compatible formulas only
- Fully worked example (both formats): one complete fictional route priced end to end. In the example, a 12-property route costing $387.00 per visit becomes an $11,352.00 seasonal contract price at a 25% margin over a 20-visit season the buyer sets, and a $567.60 per-push price from the same costing
- Quick-Start Guide (PDF, 5 pages): setup, price a season in 5 steps, the visit-count assumption explained, and markup vs margin in plain language
- Licence: single business (see below)

How it works
1. Fill in SETUP once - business details, season dates, your visit count, your rates, overhead method, markup or margin, tax.
2. Cost each route on ROUTE COSTING - one row per route.
3. Check both prices on CONTRACT PRICING, then open CLIENT QUOTE, pick the route and the structure, write the scope, and print or PDF the quote for your client.
4. Log every visit on SEASON LOG as the season runs.

Requirements
Microsoft Excel 2016 or later, OR a free Google account (Google Sheets). No macros - nothing to enable, nothing to install. Also verified in LibreOffice.

Licence (plain version)
One purchase covers one business: your whole crew can use it, on unlimited routes and seasons, forever. Please don't share, resell or redistribute the files - the full licence is included in the download.

Tax note: the HST/tax fields are calculation helpers at the rate you enter. They are general information only, not tax advice - confirm your tax obligations with your accountant.

Production note: this kit was produced with AI assistance, working under the seller's direction. The workbook's calculations were independently checked by recalculation, and the QuickStart Guide was written and verified against the finished workbook.

QUESTIONS AND ANSWERS

Excel or Google Sheets - which do I get?
Both. The download includes the Excel workbook and a Google Sheets version with identical formulas and identical results, plus a worked example of each. Use whichever you already live in.

Is this a subscription? Do I pay again for updates?
No. One payment of US$49.99, yours forever - no subscription, no per-quote fees, no account. If a corrected version is released, it replaces the file in your Etsy Purchases & Reviews downloads at no cost.

Does it have macros? My Excel blocks them.
No macros at all. It's a plain .xlsx with formulas, so there is nothing to enable and nothing for your security settings to block.

How does the visit count work? Do you predict how many storms there will be?
No - nobody can, and this kit doesn't try. You enter the number of visits you want to price the season on, from your own records and judgement. Every season figure is built on your count, and changes when you change it. The per-push price comes from the same costing, so if you would rather charge per visit, that price is already worked out.

What if the season runs lighter or heavier than my visit count?
That is what the WINTER SCENARIOS block is for. Add a light-winter count and a heavy-winter count of your own, and CONTRACT PRICING shows the season price and the per-push price at all three counts before you quote. It is arithmetic on counts you choose - the kit does not predict how many visits a winter will need.

Can I cap the number of pushes a seasonal price covers?
Yes. Enter a push cap on CONTRACT PRICING and the seasonal price is priced at the cap count. Visits beyond the cap bill at an over-cap per-push rate - yours, if you type one, or the route's per-push price. Leave the cap blank and the block does nothing: your seasonal price covers the season as priced. If you sell a capped contract, write the cap and the over-cap rate into the quote's scope of services so your client sees the same terms.

Can it price per-push instead of seasonal?
Yes. Every route gets both prices from the one costing. On the client quote you pick the structure: SEASONAL shows the contract price with a deposit and monthly instalments; PER-PUSH shows the per-visit total, billed after each completed visit.

I also do landscaping in the summer. Can I use it then?
Yes. The engine is a seasonal-contract engine, not snow-specific math: for a lawn-care season, a visit is a cut, the visit count is the number of cuts you price on, and the salt line becomes any per-visit material. The season dates, label and rates are all yours to set.

I'm not in Ontario - does the tax work for me?
Yes. The tax line is a switch plus a rate you type. Set 13% HST, 5% GST, your provincial rate, a US sales-tax rate, or switch it OFF entirely and no tax line prints.

Markup and margin - I mix these up. Does it matter?
It matters a lot: at the same percentage, a margin prices higher than a markup (25% markup on $1,000 of cost = $1,250; 25% margin = $1,333.33). The kit implements both correctly, labels which one you're using, and the Quick-Start Guide explains the difference in plain language.

Will it show my client my costs or profit?
No. The CLIENT QUOTE sheet was specifically checked for this: it shows the route, season, scope, prices, tax and total only. Your costs, overhead, markup/margin and profit live on the internal ROUTE COSTING and CONTRACT PRICING sheets - send clients the quote sheet (or its PDF), never the whole file.

Can my crew use it too?
Yes - the licence covers your whole business. One purchase per business, unlimited routes, unlimited seasons and unlimited users inside that business.

What if I'm not a snow contractor?
The math is generic seasonal-contract costing - any service business that sells a season of repeated visits on routes (lawn care, pool service, cleaning routes) uses the same structure. The examples and wording are snow-flavoured.

Materials: Digital download: 4 workbooks (.xlsx - blank template and worked example, in Excel and Google Sheets versions), 1 Quick-Start Guide (PDF, 5 pages), licence file. No physical item ships. Requires Microsoft Excel 2016 or later or a free Google account. Instant download.