Capital Thread HQ
Templates / Service businesses

What is each lawn care customer really worth?

Lawn Care CRM & Profit Tracker

See recurring revenue, who has not booked in months, season totals with deposits, and quotes checked against your hourly rate.

Made for: Solo lawn care operators and small crews with recurring customers.

$19
Buy on EtsyWatch the walkthrough
Instant download · 1 Excel workbook (.xlsx) · Opens in Google Sheets too
Lawn Care CRM & Profit Tracker dashboard with example numbers

What it does

  • A simple CRM built for solo lawn-care operators with recurring customers: every client, every visit, what they paid and what they're worth to you over time.
  • Shows your monthly recurring revenue, who hasn't booked in a while (win-back list), your top clients and who still owes you.
  • Quotes jobs, plans your route with Google Maps, gives you ready-to-send texts, and estimates the tax to set aside.

Watch the walkthrough

Jay walks through every tab with example numbers, so you know exactly how to set it up.

What's inside

14 tabs, including a Start Here guide. Example rows show the format; type over them with your own numbers.

DashboardRevenue, monthly recurring revenue, profit, unpaid balances, your win-back list and top clients.
ClientsYour client list: contact, address with a map link, service, how often, price. Visits, lifetime value and follow-ups calculate.
JobsOne row per visit. Price fills in from the client; log tips, add-ons, hours and when you were paid.
Price CalculatorQuote a new job in seconds with your own rates, then see your real hourly rate.
QuoteA printable quote that fills in from the Price Calculator: line items, deposit, terms and signature lines.
Route PlannerPick a day: every visit on it is listed with addresses and a one-click Google Maps route.
MessagesReady-to-send texts: confirmation, reminder, review ask, referral ask, win-back, payment and price-increase notes.
Client IntakeA printable new-client form with the questions to ask before the first visit.
Reviews & ReferralsTrack who you asked for a review, who left one and who sent you new clients.
ExpensesEvery business cost, already matched to its Schedule C line.
MileageBusiness miles and their deduction at the IRS rate.
Tax & ProfitProfit for the year, tax to set aside and the four estimated tax payments.
SettingsYour business details, services and prices, frequencies, tax rates and drop-down lists. Set these first.

How to set it up

  1. Settings: business name, your services and default prices, tax rates and your review link.
  2. Clients: add each client once (address, service, how often, price). Lead = not booked yet.
  3. Jobs: add a row for every visit. Pick the client and the price fills in. Type the date paid when they pay.
  4. Price Calculator for new quotes, Route Planner for your day, Messages for texts you send every week.
  5. Expenses and Mileage as you go. Check the Dashboard and Tax & Profit every week.

Questions

Does it work in Google Sheets?

Yes. It is built in Excel and opens in Google Sheets: upload the file to Google Drive and choose Open with Google Sheets. Excel (desktop or Microsoft 365) gives the smoothest experience. Apple Numbers is not supported.

Do I need to know formulas?

No. Blue text on a yellow cell is something you type. Everything else calculates for you, and the Start Here tab explains each step.

How do I get the file?

Buy it on Etsy and download it instantly from your Etsy purchases. Nothing is shipped.

Is this tax or legal advice?

No. Tax figures are planning estimates to help you set money aside. Check with a tax professional for your situation.

Something else? Message us on Etsy or tap Ask Jay at the bottom of the page.

Related templates

Cleaning Business CRM & Profit TrackerMobile Detailing CRM & Profit TrackerPhotographer CRM & Business Tracker