SheetSmart Template Co.
Lawn Care Business Spreadsheet

Lawn Care Business Spreadsheet, Landscaping Tracker for Excel and Google Sheets, Mowing Route Schedule, Job Log, Quotes, Invoice Tracker

$7.49 USD
Buy on Etsy

Instant digital download for Microsoft Excel and Google Sheets. Checkout and delivery are handled securely by Etsy.

Lawn Care Business Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Plan your weekly mowing route, quote new jobs in seconds, track every invoice and see your real profit after crew, materials, fuel and equipment. Perfect for lawn mowing and lawn care businesses. ✨ NOW INCLUDES 4 FILES: a SAMPLE version filled with example data so you can see how it works, plus a BLANK version ready for your own info, each for Excel and Google Sheets. ★ WHAT'S INCLUDED ★ • 11 tabs with a clickable Start Here cover page and a How To Use guide with FAQ • Dashboard: 8 KPI tiles (revenue, profit, active properties, this week's stops, unpaid invoices, quote win rate, revenue per crew hour, fuel and equipment), profit by month, revenue by service with $ per hour, quotes to follow up, unpaid and overdue invoices, top properties, plus a revenue vs. profit chart and a where-the-money-goes chart • Clients & Properties (200 rows): lot size, plan (weekly, biweekly, monthly or as needed), service day, price per visit, crew hours, season start and end, gate notes, next visit, visits, revenue, balance and monthly value • Weekly Route Sheet: type any Monday and every recurring stop due that week lists itself in day order (up to 80 stops) with address, zone, price, crew hours and notes, ready to print • Job Log (2,500 rows): crew lead, crew hours, price, materials, status (including skipped for weather) and invoice #, with revenue, crew cost, job profit and $ per crew hour • Quotes (300 rows): crew hours x your billable rate plus materials with your markup, status, decision date, follow-up date and days open • Invoice Tracker (800 rows): amounts add up from the Job Log, with due date, payments, balance and status • Equipment & Fuel: 30 pieces of equipment with service reminders and money spent this year, plus an 800-row fuel, repairs and parts log • Expenses (500 rows) with totals by category • Setup: rates, crew cost, markup, terms, services, plans, crew leads, zones and lists • Sample data from a lawn care company's season so you can see how it works ★ PERFECT FOR ★ ✓ Lawn mowing and lawn care businesses ✓ Landscapers and yard maintenance crews ✓ Snow removal and seasonal services ✓ Students and side hustlers starting a mowing business ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: Excel (sample) + Excel (blank) + Google Sheets edition (sample) + Google Sheets edition (blank) • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download and open the file in Excel, or upload it to Google Drive and open with Google Sheets. 2. On Setup, add your rates, crew cost, markup, services and crew. 3. Add each property with its plan and service day. The Weekly Route builds itself. 4. Log jobs, quotes, invoices, fuel and expenses. The Dashboard shows profit by month. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NO
Free Monthly Budget Starter Kit

5 printable pages: a monthly budget sheet, a 12-month bill checklist and 3 savings-goal trackers. Free when you join the email list.

Get the free kit