Mileage Log and Car Expense Tracker Spreadsheet
Business miles and car costs all year, with monthly and yearly totals. Excel and Google Sheets.
$5 on its own, or get it with 8 more business tools in the Self-Employed & Small Business Bundle for $29.
Works in Google Sheets and Excel · Instant download · Nothing shipped
What you get
Real screenshots of the actual tabs, taken from the same .xlsx file you download. All numbers are example data.
Who this is for
- You drive for gig work or your business and need a record of business miles.
- You want car costs like gas, repairs and insurance in the same file.
- You're fine typing in each trip or odometer reading.
Who it's not for
- Not for you if you want GPS or automatic trip tracking.
- Not for you if you want the IRS rate filled in for you. You look it up and enter it.
- Not for you if you want tax advice on what you can deduct.
Need more than one?
This sheet is one of the 9 in the Self-Employed & Small Business Bundle. Get all 9 business tools for $29 (about $80 if bought one by one).
Get the bundle on Payhip – $29 See what's in the bundle
Need the home and the business sets? The Everything Bundle (what's inside) has all 22 (21 spreadsheets + the website template) for $39, about $149 if bought one by one.
Instant download. Works in Google Sheets and Excel (the website template is plain HTML/CSS).
Instant digital download, sold through Gumroad. Good for: mileage log,mileage tracker,car expense tracker,business mileage,gig driver,rideshare driver,delivery driver,self employed,excel template,google sheets.
2 separate spreadsheets (.xlsx files) in one zip: Car Expense Mileage Log v2, Car Expense Mileage Log. Each works in Excel and Google Sheets (import the .xlsx) and opens on a Start Here tab with a short how-to.
How it works
- Download the zip after checkout and unzip it.
- Open each .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Delete the example rows and type in your own numbers.
Previews and the files use example data only.
What's inside
- Trip log (400 rows): date, odometer start/end or just miles, from/to, purpose, Business or Personal.
- Car expenses (300 rows): gas, charging, maintenance, insurance, parking, tolls and more by category.
- Summary: business vs personal miles by month, business %, a mileage total at the per-mile rate you enter, actual costs, cost per mile, and a chart.
Good to know
- You type in trips and expenses; there's no GPS or automatic tracking.
- The per-mile rate is a cell you fill in. Look up the current IRS standard rate yourself.
- A record-keeping tool, not tax advice. Ask a tax pro what you can deduct.
Previews
Works in Google Sheets and Excel · Instant download · Nothing shipped
Try the free mileage deduction calculator →
Frequently asked questions
Which apps does it open in?
Excel 2016 or newer (including Microsoft 365 and Excel for the web) and Google Sheets: upload the .xlsx to Google Drive, then open it with Google Sheets. You get one .xlsx file (Excel 2016+/Microsoft 365/Excel for the web, imports into Google Sheets) and a short how-to. Instant digital download.
What happens after checkout?
Gumroad emails you a receipt right after checkout; click View content in it to open your download page. You download a .zip with the .xlsx file(s) and a short how-to. It's an instant digital download; nothing physical ships.
Can I edit it?
Yes. Nothing is locked: rename categories, add rows, change colors and type over the example data.
Does it connect to my bank or send reminders?
No. It's a spreadsheet, not an app: you type in your own numbers and nothing is synced or sent.
Can I get a refund?
It's a digital download, so if something doesn't open or work, reply to your Gumroad receipt and I'll help fix it. Refund requests are handled under Gumroad's refund policy. If you bought it on Payhip, message the shop there.
Is this financial advice?
No. It's an organizing and planning tool with example numbers, not financial, tax, legal or medical advice.
Works in Google Sheets and Excel · Instant download · Nothing shipped
Free guides that use this sheet
Pairs well with
Side Hustle Income & Expense Tracker ($7)
Pair miles with your gig income.
Not ready to buy? Start with the free Starter Budget Sheet.