How to use the Lawn Care Mileage & Expense Tracker

Every mile and receipt, organized for tax time. Built for lawn businesses. Here's every step, with screenshots from the real spreadsheet.

Get this tool · $9Start the guide

Version 1.5 · 7 tabs · Excel and Google Sheets · Free Lifetime Updates

Guide at a Glance
StepHow long
1Before you start1 min 2Set it up5 min, once 3Log a day of drivingSee step 4Log a receiptSee step 5Log a paymentSee step 6Check your numbers and get ready for tax timeSee step
Messages explainedSee them →

Before you start

The one rule: yellow cells with blue text are yours to fill in. Gray cells calculate on their own and are locked, so you can't erase a formula by accident.
  1. Your download is a zip with two files. Double-click it to open it. Start with the one marked with examples to see how everything works, then use the blank one for your business.
  2. Open the file in Microsoft Excel. Using Google Sheets? Upload it to Google Drive, then open it with Google Sheets.
  3. Start on the Start Here tab. It has the same steps, right inside the file.
  4. The sample data is there so you can see how everything works. Type over it with your own when you're ready.

Here's how to set it up once and then keep clean records in a minute a day. At tax time, everything is already organized for your tax pro.

1Set it up (one time, about 5 minutes)

  1. Open the Settings tab. Pick your tax year and set how much of your profit to set aside for taxes. Many owners use 25% to 30% as a starting point. Your tax pro can tell you what fits you.
  2. Check the IRS mileage rates table. 2026 is already in there, including the July 1 change to 76 cents, and each trip gets the right rate for its date.
  3. Add your vehicles, your regular routes under Saved Trips, and anyone you pay as a contractor.
  4. Write down each vehicle's odometer on January 1, and add the ending number at year end. That gives you your business use percentage.

2Log a day of driving (30 seconds)

Lawn Care Mileage & Expense Tracker Mileage tab in Excel and Google Sheets. The mileage log applies the right IRS rate for each trip's date.
The mileage log applies the right IRS rate for each trip's date.
  1. Open Mileage and add one line: the date, the vehicle, and the purpose or client. The IRS wants the purpose, so the tool reminds you if it's blank.
  2. Type the odometer start and end. That's the strongest record. No odometer reading? Type the miles in the Miles column instead.
  3. Driving a usual route, like your Tuesday route? Pick it from the Purpose list and the miles fill in for you. Mark Round trip if you drove there and back.

3Log a receipt (30 seconds)

  1. Open Expenses and add one line: date, store, category, what it was for, and the amount.
  2. Pick the category from the list. Fuel for mowers and trimmers is its own category, separate from truck fuel, so it counts no matter which mileage method you use.
  3. Use Business use % for things you also use personally, like your phone. The deductible part figures itself out.
  4. Snap a photo of the receipt and set Receipt saved? to Yes. The Dashboard reminds you about any receipts you haven't saved.

4Log a payment (20 seconds)

  1. Open Income and add one line for every payment: date, client, what for, amount, and how they paid.

5Check your numbers and get ready for tax time

Lawn Care Mileage & Expense Tracker Tax Summary tab in Excel and Google Sheets. The Tax Summary, organized by Schedule C line and ready for your tax pro.
The Tax Summary, organized by Schedule C line and ready for your tax pro.
  1. Look at the Dashboard once a month. It shows income, deductions, miles, estimated profit, and what to set aside for the next quarterly tax payment.
  2. The Dashboard also compares the standard mileage rate with your actual truck costs, so you can see which method looks better so far.
  3. At tax time, open Tax Summary and print it or save it as a PDF for your tax pro. It's organized by Schedule C line.
  4. This is a record-keeping tool, not tax advice. The set-aside is a planning estimate. Always check your totals with a tax professional before you file.

What the messages mean

The tool watches your numbers and tells you in plain words when something needs a look. Here's every message you might see.

Add the purpose. The IRS wants it.
What it means: A mileage line has no purpose or client.
What to do: Type where you went and why. The IRS expects it for every business trip.
End is lower than start. Typo?
What it means: The ending odometer number is smaller than the starting one.
What to do: Check the two odometer numbers. Usually two digits got swapped.
No IRS rate for this date. Check Settings.
What it means: The trip's date is outside the years in the mileage rate table.
What to do: Check the date, or add that year's rate on Settings.
Save the receipt. Snap a photo now.
What it means: This expense is marked as not saved.
What to do: Take a photo of the receipt and set Receipt saved? to Yes.
Category isn't on the list in Settings.
What it means: The category was typed in and doesn't match the list.
What to do: Pick the category from the dropdown instead of typing it.
⚠ Some lines need a look.
What it means: At least one line on Mileage, Expenses, or Income has a note in its Check column.
What to do: Look down the Check column on each tab and fix what it points out.
Actual costs look bigger this year. Worth asking your tax pro.
What it means: Your logged truck costs are adding up to more than the standard mileage deduction.
What to do: Ask your tax pro which method to use. You can usually use one or the other, not both.

Using Google Sheets or your phone

  • To use Google Sheets, upload the file to Google Drive, then right-click it and choose Open with, then Google Sheets.
  • Dropdowns, colors, and every calculation work the same in Google Sheets.
  • On a phone, the Google Sheets and Excel apps work for quick changes. For setup and printing, a computer is easier.
  • Want to start fresh? Type over the yellow example cells. Don't delete rows, since other tabs may be reading them.

Common questions

Can I use it for more than one truck?

Yes. Add each vehicle on Settings and pick the vehicle on each mileage line.

Should I use standard mileage or actual costs?

You can usually use one or the other, not both. The Dashboard shows which looks better so far, but ask your tax pro before you choose.

Quick reference from the Start Here tab

Welcome

Every business mile and every receipt you don't track is money you overpay in taxes. Log them here as you go, and at tax time you'll have clean totals by category, your mileage deduction, and a running estimate of what to set aside, all in one place.

Setup (About 5 Minutes)

1

Open 'Settings'. Pick your tax year, check the IRS mileage rates, and set how much of your profit you want to set aside for taxes.

2

Add your vehicles, your regular routes under Saved Trips, and anyone you pay as a contractor.

3

At the start of the year, write down each vehicle's odometer. At year end, add the ending number. That gives you your business use %.

As You Go

Every work day: one line on 'Mileage'. Odometer start and end is best, or just type the miles.

Every receipt: one line on 'Expenses'. Snap a photo of the receipt and mark it saved.

Every payment from a client: one line on 'Income'.

Driving your usual Tuesday route? Pick it from the Purpose list and the miles fill in for you.

At tax time, print 'Tax Summary' or save it as a PDF and hand it to your tax pro.

Check 'Dashboard' monthly. It shows your profit, deductions, and what to set aside for the next quarterly tax payment.

Good To Know

Mileage: you can usually use the IRS standard mileage rate OR your actual vehicle costs (gas, repairs, insurance on the truck), not both. This tracker warns you if it looks like you're doing both.

Fuel for mowers and trimmers is an equipment expense, not a vehicle expense, so it counts either way. That's why there are two fuel categories.

The IRS sometimes changes the mileage rate mid-year, like it did on July 1, 2026. The Settings tab handles that, so each trip gets the right rate for its date.

The tax set-aside is a rough planning number, not a tax calculation. This tracker isn't tax advice. Share your totals with a tax professional before you file.

Using Google Sheets? Upload this file to Google Drive and open it with Google Sheets. Everything works the same.

Your License

This file is licensed to one business, including everyone who works there. Please don't share, resell or post it online.

© 2026 EasyWorkTools. All rights reserved. easyworktools.com

Every tab

This file has 7 tabs, in this order:

  1. Start Here
  2. Dashboard
  3. Tax Summary
  4. Mileage
  5. Expenses
  6. Income
  7. Settings
Still stuck on something? Ask us. We answer within one business day, and we'll add the answer here for everyone.