Mileage Tracker for Freelancers in Google Sheets: Log & Deduct Business Miles (2026)

The 2026 IRS standard mileage rate is 70 cents per mile. If you drive to client meetings, job sites, pick up supplies, or attend business events — and you're self-employed — every mile you fail to log is money you're giving away. This guide shows you how to build a free, IRS-compliant mileage tracker in Google Sheets that takes two minutes per week and automatically calculates your tax deduction.

Who Can Deduct Business Mileage

If you're self-employed and use your personal vehicle for business purposes, you can deduct those miles on Schedule C. This includes:

• Freelancers — driving to client offices, meetings, coworking spaces
• Consultants — site visits, presentations, training
• Contractors — driving to job sites (not your home base to a fixed office)
• Real estate investors — driving to rental properties, inspections, hardware stores
• Gig workers — Uber/Lyft, DoorDash, TaskRabbit (platform may provide mileage data, but verify)
• Small business owners — deliveries, supply runs, client visits

Standard Mileage Rate vs. Actual Expense Method

The IRS gives you two ways to deduct vehicle costs. You need to pick the right one — and once you start the actual expense method in a vehicle's first year, you may lose the ability to switch to standard mileage later.

The standard mileage rate is simpler and usually wins for most freelancers — especially those driving fuel-efficient vehicles or with moderate annual mileage. This guide focuses on the standard mileage method. For the actual expense method, you'll need a different tracking approach and a CPA involved.

What the IRS Requires in a Mileage Log

If audited, the IRS wants to see a contemporaneous mileage log — meaning you recorded each trip at or near the time it happened, not reconstructed months later. A retroactively created log is the #1 reason mileage deductions get disallowed in audits.

IRS Publication 463 specifies exactly what your log must contain for each trip:

You do not need to log personal trips — but you must maintain a record of total annual mileage (odometer reading at start and end of year) so you can calculate what percentage of your driving was business-related.

How to Build Your Mileage Tracker in Google Sheets

Start with a fresh Google Sheet. Name it "Mileage Log 2026." Here's the exact setup:

Step 1: Create a Settings Tab

Put your constants here so you can update them in one place:

Step 2: Build the Mileage Log Tab

This is where you enter every trip. One row per trip:

To create the dropdown in Column H: select the H column cells → Data → Data Validation → Dropdown → add options: Business, Medical, Charitable.

3-Tab Tracker Structure

The Summary Tab

The Summary tab is what you hand your accountant. It shows annual and monthly breakdowns of business miles and the resulting deduction.

Build a table with months as rows and these columns: Month | Business Miles | Business Deduction | Medical Miles | Medical Deduction | Charitable Miles | Charitable Deduction.

At the bottom, add annual totals — the Business Deduction total is your Schedule C, Line 9 entry.

5 Copy-Paste Formulas

1. Monthly Business Miles

2. Monthly Deduction

3. Annual Total Business Miles

4. Business-Use Percentage

5. Annual Deduction (Schedule C Line 9)

What Trips Qualify (and Which Don't)

This is where freelancers commonly make mistakes — both ways. You might be leaving money on the table by not claiming trips that qualify, or creating audit risk by claiming trips that don't.

How to Calculate Your Real Deduction

Let's look at three realistic freelancer scenarios to show how quickly mileage adds up:

The tax savings column assumes a combined federal + self-employment effective rate of ~25%. The actual benefit is higher if you're in a higher bracket, and lower if you have significant losses elsewhere. But for a mid-income freelancer driving 6,000 business miles, this is a real $1,000+ in their pocket.

How to Make Your Log Audit-Proof

The IRS audits mileage deductions at a higher rate than most other Schedule C items. The reason: mileage logs are easy to fabricate and hard to verify. Here's how to build a log that holds up:

Record Trips Within 24 Hours

The IRS requires "contemporaneous" records. While they have some flexibility, the safest standard is to log each trip the same day. A 30-second phone note after a client meeting, synced to your Google Sheet that evening, is the gold standard.

Use Specific Business Purposes

"Business" is not a business purpose. "Client meeting — ABC Design Co. re: Q2 website project" is. The more specific your purpose, the harder it is to challenge.

Record Odometer Readings Annually

Take a photo of your odometer on January 1 and December 31. Store it in your Google Drive mileage folder. This establishes your total annual mileage without dispute — which is the denominator in your business-use percentage calculation.

Cross-Reference With Calendar

If you're audited, the IRS will ask to see your calendar. Make sure your mileage log trips correspond to calendar entries. If you drove to a client meeting on March 12, there should be a calendar event for that meeting.

Keep the Log Year-Round, Not at Tax Time

The #1 audit failure is a "reconstructed" log — one that was created from memory after the fact. A spreadsheet with entries on different days, logged throughout the year, is the most defensible evidence.

5 Mileage Tracking Mistakes That Cost You Money

1. Not Tracking at All

The most expensive mistake. Most freelancers underestimate how many business miles they drive annually. Start logging everything — you can always choose not to claim marginal trips, but you can't claim what you never logged.

2. Claiming Commuting Miles

If you have a regular place of business outside your home, driving there is not deductible. This is the #1 reason mileage deductions get disallowed. If you work from home but your home office doesn't qualify as your principal place of business, your mileage to client sites is also not deductible. Consult a CPA if you're unsure whether your home office qualifies.

3. Using Vague Business Purposes

Audit-proof entries are specific: who, what, where. "Business trip" is not specific. "Drove to First Street Hardware for supplies for rental property repair — 1234 Oak Ave" is. Take 15 extra seconds to be specific when logging.

4. Missing the Odometer Reading at Year Start

Without an annual odometer reading, you can't calculate your business-use percentage, which appears on Form 4562 and determines if you can use standard mileage at all in certain vehicle situations. Take the photo on January 1 — calendar reminder, every year.

5. Forgetting Personal-to-Business Trip Conversions

You can't deduct an entire trip if only part of it was for business. If you ran a personal errand before driving to a client meeting, only the miles from your last personal stop to the client's location are deductible. Your mileage log should capture start and end points for each leg.

The 2-Minute Weekly Mileage Workflow

The best mileage tracking system is one you'll actually use. Here's a sustainable weekly routine:

If you want to simplify even further, keep your Google Sheet bookmarked on your phone's home screen and log each trip immediately after it happens. 30 seconds per trip, no catch-up required.

The Bottom Line

The 2026 IRS mileage rate of 70 cents per mile is generous. For a freelancer driving 5,000 business miles per year — a realistic number for anyone with regular client meetings — that's a $3,500 deduction. At a 25% effective tax rate, you save $875 in taxes. That's money sitting on the table right now, and all it takes to claim it is a Google Sheet and two minutes a week.

Build the tracker this weekend. Start logging on Monday. Your future April self will thank you.

For more deductions you might be missing, see the Freelance Tax Deductions Checklist 2026. And if you're not yet tracking your quarterly estimated tax payments alongside your deductions, the quarterly estimated tax guide explains exactly how to calculate what you owe and when.