Lawn Care Business Expenses Spreadsheet: Tabs and Formulas

Quick Answer: A lawn care business expenses spreadsheet works best as five linked tabs, not one long list: an equipment register for mowers, trimmers and trucks, a fuel and repair log keyed to each machine, a supplies tab, a crew labor tab, and a route profit tab that pulls from the other four. Add a winter cash plan for the slow months, and fill the tabs from your card and bank statements each month.

A lawn care business expenses spreadsheet has to cope with three things a generic expense template ignores: costly equipment that is deducted differently from everyday spending, running costs that belong to individual machines, and a season that earns most of the year's money in eight months. Build it around those three and the tax totals come out of the same workbook.

What tabs does the workbook need?

Format each tab as an Excel table or a named range in Google Sheets so formulas can refer to column names.

A sixth tab, Statement lines, holds the raw transactions you import each month. The other tabs are filled from it, which keeps a single source for every dollar.

How should mowers, trucks and trailers be recorded?

Equipment is the biggest number in most lawn care books, and it is not handled like fuel. Give every machine a short unit ID (MOW-01 for a zero-turn, TRM-03 for a trimmer, TRK-01 for the truck) and record the purchase once in the Equipment tab.

The tax treatment column is where you note how the cost is deducted. Three routes come up often for US businesses:

• De minimis safe harbor. The IRS tangible property regulations page allows businesses without an applicable financial statement to deduct items costing up to $2,500 per invoice or item, if they attach the election statement to a timely filed return. A $420 backpack blower often fits here.
• Section 179. IRS Publication 946, in its edition for 2025 returns, puts the maximum Section 179 deduction for tax years beginning in 2025 at $2,500,000, reduced once the cost of qualifying property placed in service exceeds $4,000,000. Those limits change, so check the current edition. Most lawn businesses are far below them; the practical questions are whether the machine is used mainly for the business and whether the deduction suits the year's income.
• Depreciation. Cost recovered over several years, figured on Form 4562.

Which route you pick is a decision for you and your tax preparer. The sheet's job is to keep the cost, the date the machine went into service and the business-use percentage in one place so the decision is easy to make and to defend. Add a column for the sale price and date when you trade a mower in, since disposal has its own tax consequences.

How do you work out the running cost of each machine?

Logging fuel and repairs against a unit ID lets you see which machine is costing you money. Most commercial mowers have an hour meter; read it when you refuel and type it into the log.

For a cost per operating hour on the Running costs tab (columns: A date, B unit, C type, D amount, E meter reading), put the unit ID in H2 and use:

• Total spend: =SUMIFS(D:D,B:B,H2)
• Hours run: =MAXIFS(E:E,B:B,H2)-MINIFS(E:E,B:B,H2)
• Cost per hour: =IFERROR(I2/J2,0), where I2 and J2 hold the two results above

Worked example. MOW-01 logs $1,920 of fuel, $760 of service and repairs, and $180 of blades in a season, $2,860 in all. The meter read 1,210 hours at the first fill and 1,660 at the last, so it ran 450 hours. Running cost: $2,860 ÷ 450 = $6.36 an hour, before any share of the purchase price. When a second mower of the same model costs $11 an hour, that is your signal to look at its repair history before next spring.

Do the same for the truck using odometer readings, or keep a mileage log instead. Our mileage tracker spreadsheet covers the log itself, and the IRS publishes the standard mileage rates each year if you use that method rather than actual vehicle costs.

Which route or job is actually profitable?

The Routes tab is where the workbook pays for itself. Each row is one route or recurring contract for a week (or a month, if you invoice monthly).

Worked example. The "Tuesday North" route has 14 residential stops billed at $75 each, $1,050 a week. Two crew members work 7.5 hours each at $20 an hour, $300 of labor. The zero-turn runs 6 hours at $6.36 ($38.16) and the trimmers and blower add $12. Trimmer line and bags come to $18. Truck costs allocated to the route are $46. Profit is $1,050 − $300 − $38.16 − $12 − $18 − $46 = $635.84, a 60.6% margin before overhead such as insurance, phone and the owner's own time.

Run the same row for a route with long drives between stops and the margin falls quickly. That comparison is what tells you which neighborhoods to quote higher or drop.

How do you plan cash for the winter months?

Where mowing stops for winter, fixed costs keep coming. Add a twelve-month cash tab with expected revenue and fixed costs per month.

1. List costs that do not stop in winter: insurance, truck and equipment payments, phone and software, storage, any year-round wages.
2. Total them for the slow months. For example, $1,850 a month for December to March is $7,400.
3. Total expected revenue for the busy months, say $96,000 from April to November.
4. Reserve rate: =Winter_costs/Peak_revenue, here $7,400 ÷ $96,000 = 7.7%. Move that share of each busy-month deposit into a separate savings account.

Snow removal, leaf cleanups and winter pruning can shorten the gap; put their expected revenue in the cash tab too, but plan the reserve as if they fall short.

How do you fill the workbook from statements?

Most of your expenses already sit on a business card or checking statement: fuel stations, the dealer's parts counter, the garden supply yard, insurance drafts. Rather than saving every receipt into the sheet by hand, import the statements once a month.

1. Download the month's statements. If your bank offers a CSV export, use it. If you only have PDFs, QuickBankConvert turns them into CSV or Excel rows with date, description and signed amount, and the credit card statement to Excel page shows what a card export looks like.
2. Paste the rows into Statement lines.
3. Add a small rules table (keyword in one column, category in the next: "SHELL" to Fuel, "JOHN DEERE" to Repairs, "SITEONE" to Supplies) and categorize with =IFERROR(LOOKUP(2^15,SEARCH(Rules[Keyword],B2),Rules[Category]),"Review").
4. Add the unit ID or route by hand for fuel and repair lines; nothing on a statement knows which mower you filled.
5. Keep the receipts for big purchases with the Equipment tab entry, because a statement line does not show the model, serial number or date placed in service.

Our guide to tracking business expenses from bank statements covers the categorizing step in more depth, and the income and expenses spreadsheet guide shows a simpler single-tab layout if you are just starting out.

Crew pay: employees or contractors?

Record the classification in the Labor tab, because it changes your paperwork. Employees go through payroll with withholding. If you pay independent contractors, the IRS page on forms and associated taxes for independent contractors explains the forms involved. Keep each contractor's total paid in a pivot by name so the year-end figures are ready.