Home & Local Services Profit Pack — Free Spreadsheets for Contractors, HVAC, Painters & Landscapers

The problem

Jobs that look profitable on the surface, bids that lose money on paper, and customers who cost more to serve than they're worth

🔧

Most contractors quote from gut feel, not actual cost — and the margin disappears in the field

When you estimate a job without accounting for every hour of drive time, materials waste, crew downtime between tasks, and overhead allocation, you're guessing at profit. A landscaping job that invoices for $1,200 but takes 9 crew-hours including transit, burns $80 in fuel and materials, and gets billed through your overhead at $180 isn't a profitable job — it's a break-even job. The Job Estimate & Profit Calculator builds the true cost bottom-up before the first hour is worked, so your bid price reflects reality, not optimism.

☔

Seasonal revenue swings blindside home service businesses that don't plan around them

HVAC revenue peaks in July and January. Landscaping collapses in November. Painting slows in December. If you're not projecting seasonal revenue by month and adjusting crew size, equipment financing, and marketing spend to match, you're either scrambling for cash in slow months or turning away work in peak months because you didn't staff up early enough. The Seasonal Revenue Planner builds the full annual picture so you can make decisions with a 12-month view instead of surviving month to month.

📈

Customer acquisition cost looks fine until you calculate how much it costs to actually serve the customer you acquired

A $400 HVAC maintenance job might have cost $120 in advertising to land, $180 in labor to complete, $40 in parts, and $25 in overhead — leaving $35 in profit. That's an 8.75% margin on a job you worked hard to get. But if that customer books maintenance twice a year and refers one neighbor per year, their 5-year value is $3,200 with a 22% blended margin. The difference between an 8.75% and 22% margin business is usually the CLV tracker, because it changes which jobs you take, which customers you market to, and how much you spend acquiring the right ones.

What's inside

Six templates that tell you the real numbers before you commit to a job, a crew size, or a customer

Each template is a CSV file that opens in Google Sheets, Excel, Numbers, or any spreadsheet app. Pre-built formulas, realistic benchmarks, and clear column labels included.

01

Job Estimate & Profit Calculator

Materials cost (with waste factor), labor hours × crew rate, overhead allocation (percentage of revenue or fixed per job), subcontractor costs, equipment rental, fuel and disposal, target margin percentage, and calculated bid price. The output is a single bid number with a profit breakdown showing gross margin in dollars and percentage. Includes a scenario column to run the same job at three different crew sizes or material choices so you can see where margin improves. Home service contractors who start using this find that 15–30% of their recurring jobs have been running at margins below their threshold — not because the jobs are bad, but because the bidding math was wrong.

Pairs with Home Service Job Cost Calculator & Roofing Cost Estimator

02

Seasonal Revenue Planner

Month-by-month revenue forecast across up to four service lines, crew headcount by month (full-time vs. part-time split), fixed overhead by month (insurance, equipment payments, lease), variable costs as a percentage of revenue, projected profit per month, and a 12-month cash flow summary. Includes a seasonality index column — enter your historical percentage of annual revenue each month represents, and the planner scales automatically when you update your annual target. The cash surplus/deficit row tells you exactly which months need a credit line and which months you should be pre-paying equipment or reinvesting. Seasonal businesses that don't plan this lose the good-month profits to bad-month survival costs.

Pairs with Small Business Cash Flow Calculator & Break-Even Calculator

03

Crew Labor Cost Tracker

Per-job log of crew members assigned, hours worked per person, hourly rates (base + burden: FICA, workers' comp, liability insurance, benefits — typically 25–40% on top of base wage), drive time included in or excluded from billable hours, actual labor cost for the job, and labor as a percentage of invoice. Includes a variance column that compares estimated vs. actual labor hours — if that variance is consistently positive (actual > estimated), your bidding is underestimating crew time. Over 20–30 jobs this tracker identifies which job types are running over on labor (and why) so you can fix the estimate, adjust the bid, or change the crew size. Most home service businesses lose their margin to labor overruns they never measure.

Pairs with Employee Labor Cost Calculator & Job Profitability Calculator

04

Materials Markup Worksheet

Material line items, supplier cost, markup percentage, sell price, gross profit per line item, and totals by job or by supplier. Includes a markup-to-margin conversion column (markup and margin are not the same number — a 40% markup is a 28.6% margin) so your pricing is consistent regardless of which metric your accountant uses. A supplier comparison column lets you enter quotes from two vendors for the same material; the worksheet calculates the profit impact of switching. Also tracks materials used vs. materials purchased per job — waste percentage directly affects your realized margin in ways that never show up in the invoice. Home service businesses frequently underprice materials because they confuse their cost markup with their actual margin.

Pairs with Job Cost Calculator & Profit Margin Calculator

05

Service Area Route Planner

Job addresses, estimated drive time between jobs, miles per leg, fuel cost per mile (vehicle MPG × local gas price), total daily drive time, total daily fuel cost, number of billable jobs per day, revenue per day, and true cost-per-job including drive time and fuel. The route efficiency column shows how much revenue you generate per hour of total working day (billable + drive) — and that number changes dramatically based on how well you cluster geographically. Driving 45 minutes between jobs in a 6-job day can reduce your effective hourly rate by 20–30% compared to a clustered route with 12-minute gaps. This template also calculates the fuel break-even on adding a second van vs. routing the second crew to the same area.

Pairs with Gas Cost Per Mile Calculator & Business Mileage Tracker

06

Customer Lifetime Value Tracker

Per-customer log of total jobs completed, average ticket, visit frequency per year, years as a customer, referrals generated (and their estimated revenue), total revenue from customer + referral chain, and CLV calculation (average ticket × frequency × retention years + referral value). Segments customers by CLV tier (platinum >$5K, gold $2K–$5K, silver $500–$2K, bronze <$500) so you can see which segment is driving disproportionate revenue. Includes a customer acquisition cost column to calculate return on ad spend per customer tier — showing you that marketing to high-frequency repeat customers costs far less per dollar of lifetime revenue than chasing one-time jobs. For most home service businesses, 20% of customers represent 60–70% of revenue — this tracker identifies who they are.

Pairs with Customer Lifetime Value Calculator & Revenue Per Customer Calculator

How to use it

Know your numbers before you bid the job, before you hire the crew, before you run the route

1

Start with the Job Estimate Calculator on your next bid

Before you quote the customer, open the Job Estimate & Profit Calculator and build the cost from the bottom up: materials with waste factor, crew hours including setup and cleanup, drive time if unbillable, overhead allocation (if your overhead is $8,000/month and you complete 40 jobs, that's $200 per job), and your target margin. The calculator outputs a bid price. If your gut number is lower, you either have room to compete or you're undercharging — the template tells you which. Run 10 jobs through it and your bidding accuracy will improve more than any amount of experience alone.

2

Track actual labor and materials for 30 days and compare to estimates

The Crew Labor Cost Tracker and Materials Markup Worksheet become your variance reports. Each week, compare estimated hours to actual hours and estimated materials cost to actual materials cost. After a month you'll have clear data on which job types you're consistently over or under on. Roofing jobs running 15% over on labor means your labor estimate needs adjustment or your crew efficiency needs attention — and now you know it's roofing specifically, not painting or HVAC. Precision in tracking produces precision in bidding. Most contractors who do this for 60 days find they can raise prices on some jobs and reduce cost on others — both improving margin without losing customers.

3

Build the Seasonal Revenue Planner before next season starts

In October, before your slow season hits, open the Seasonal Revenue Planner and build next year's 12-month forecast. Enter last year's monthly revenue as your baseline, apply any growth rate you're targeting, and set headcount by month. The cash surplus/deficit row tells you how much cash you need to carry through February. If the answer is $14,000 and you don't have it, you need to either line up a credit facility now or figure out a slow-season revenue stream before you need it. The contractors who don't get blindsided by slow months are the ones who planned in October, not the ones who scrambled in February.

Home & Local Services Profit Pack

Download all 6 templates — free, no email required

CSV files that work in Google Sheets, Excel, Numbers, or LibreOffice. Open, fill in your numbers, and know your real job costs and margins before you commit.

🔧 Job Estimate & Profit Calculator CSV — materials + labor + overhead + margin → bid price 📅 Seasonal Revenue Planner CSV — month-by-month forecast, crew headcount, cash surplus/deficit 👥 Crew Labor Cost Tracker CSV — hours × burdened rate, actual vs. estimated variance 📦 Materials Markup Worksheet CSV — supplier cost, markup, margin, waste factor, vendor comparison 🚌 Service Area Route Planner CSV — drive time, fuel cost, jobs per day, revenue per total hour 📌 Customer Lifetime Value Tracker CSV — repeat visits, referral chain, CLV by tier, ROAS per segment

Got the templates? Now get a second set of eyes.

Book a free 15-minute job cost and margin audit using your real numbers

Fill in the Job Estimate Calculator or Crew Labor Tracker with actual jobs from last month, then bring it to a 15-minute call. We'll review your real margins, flag where costs are leaking, check whether your bid pricing covers overhead, and tell you which job types are actually profitable — no pitch, just the numbers.

Name Email What type of service business do you run? Biggest profitability challenge right now

✓ No cost, no obligation ✓ Bring your actual job numbers ✓ We find the leak, you keep the spreadsheet

Stay sharp

New contractor templates, pricing benchmarks, and home service business guides — monthly

We ship new calculators, spreadsheets, and industry breakdowns every month. Join the list and get them before anyone else. No spam, unsubscribe anytime.

Use these with the pack

Home service calculators that pair with these templates

Run your numbers live in the calculator, then log the results in the spreadsheets.

View all home & local service calculators

Related packs

Other profit packs built for business owners

Small Business Profit Pack

Cash flow forecasting, breakeven analysis, profit & loss tracker, payroll cost worksheet, pricing calculator, and startup cost planner for small businesses at any stage.

View pack

Automotive Profit Pack

Lease vs. buy comparison, auto loan payoff tracker, EV vs. gas savings calculator, depreciation log, true cost of driving, and car buying negotiation worksheet.

View pack

Freelancer & Agency Profit Pack

Hourly rate calculator, project profitability tracker, client revenue scorecard, proposal pricing worksheet, capacity planner, and contractor vs. employee cost comparison.

View pack

From the team at CareerKit Digital

Running a home service business is a career — track it like one

CareerKit Digital builds job-search and career-acceleration tools — income negotiation guides, skills assessment kits, professional resume templates, and business pitch frameworks — for people growing their professional income whether that's in a trade, a service business, or a corporate role. Free and premium resources available.

Browse CareerKit Digital on Etsy