Mileage Log Template 2026 for Taxes, Mileage Tracker Spreadsheet, Gig Driver Expense and Income Log, Excel & Google Sheets

See what you really earn per hour and per mile, record trip dates, business purposes, odometer readings and mileage, and know how much to set aside for taxes. Made for DoorDash, Uber, Lyft and other gig drivers.

WHO IT'S FOR
- Rideshare and delivery drivers (DoorDash, Uber, Lyft, Instacart, Amazon Flex, Spark and more)
- Freelancers, realtors, contractors and anyone self-employed who drives for work
- 1099 workers who need quarterly estimated-tax reminders

WHAT'S INSIDE
- Mileage Log (2,000 trips): date, client/app, business purpose, from/to, start and end odometer or just miles
- IRS standard mileage rate applied BY TRIP DATE. 2026 changed mid-year (72.5¢ through June 30, 76¢ from July 1, per irs.gov) and the tracker handles it. Add future rates in Settings.
- Income Log (2,000 rows): base pay, tips, bonuses, fees and hours, with $ per hour for every shift
- Expenses (1,000 rows) with business-use %. Under Standard mileage, gas, repairs, insurance and other car costs are automatically excluded so you don't double-deduct.
- Standard mileage vs Actual expenses comparison: compare illustrative vehicle-expense estimates; eligibility and method restrictions depend on your circumstances
- Dashboard: total earned, hours, $/hour, business miles, $/mile, mileage deduction, other deductions, estimated net profit and suggested tax set-aside, plus month-by-month and per-platform results with a chart
- Quarterly Estimated Taxes: IRS payment periods and due dates, set-aside per quarter, what you paid, what's still open, with red/yellow alerts

PREVIEW (from the filled-in EXAMPLE file)
Dashboard snapshot: $8,328 total earned · $22.55 per hour · 6,201 business miles · $4,554 mileage deduction · $3,617 estimated net profit · $904 suggested tax set-aside
Sample trips:
- 01/05 DoorDash delivery — odometer 48,210 → 48,275 (65 miles) at $0.725 = $47.12 deduction
- 01/08 Uber rideshare — 48,314 → 48,423
- 01/14 DoorDash — 105 miles entered directly (no odometer)
Sample income: DoorDash 01/05 base $81.38 + tips $23.63 + bonus $25.00 for 4.4 hours
Platform split in the example: DoorDash $3,285 · Uber $1,772 · Uber Eats $1,765 · Instacart $1,506
Tabs: Start Here · Settings · Mileage Log · Income · Expenses · Dashboard · Quarterly Taxes

HOW IT WORKS
1. On Settings, choose your tax year, method (Standard mileage or Actual expenses) and set-aside %.
2. Log trips, income and expenses as you go.
3. The Dashboard and Quarterly Taxes tabs update automatically.

WHAT YOU GET
- Mileage-Income-Expense-Tracker.xlsx (blank, ready to use)
- Mileage-Income-Expense-Tracker-EXAMPLE.xlsx (filled-in example)
- Mileage-Income-Expense-Tracker-GoogleSheets.xlsx (Google Sheets-ready workbook)
The .xlsx files open in Microsoft Excel (365 / 2019 or newer, Windows or Mac). Upload the Google Sheets-ready workbook to Google Drive and open it with Google Sheets. Step-by-step instructions are on the "Start Here" tab.

FAQ
Q: Does it pull trips from Uber or DoorDash?
A: No. You type in your own data. Nothing connects to any app or bank.
Q: Which mileage rate does it use?
A: The IRS rate that was in effect on each trip's date. 2026 rates are pre-filled; add future ones in Settings.
Q: Standard vs actual — can I compare?
A: Yes. The sheet can compare illustrative vehicle-expense estimates; eligibility and method restrictions depend on your circumstances.
Q: Is this tax advice?
A: No. Tax figures are estimates to help you plan and save. Ask a tax professional.
Q: Excel and Google Sheets both work?
A: Yes. Upload the attached Google Sheets-ready .xlsx workbook to Google Drive and open it with Google Sheets.

GOOD TO KNOW
- This is a digital download. Nothing will be shipped.
- No macros, nothing locked or password-protected. Customize freely.
- For US self-employed. For personal or single-business use. Please don't resell or share the files.
- Not affiliated with DoorDash, Uber, Lyft, Instacart or any gig platform.
- Questions or a formula not doing what you expect? Message me and I'll help.

Planning estimates only, not tax preparation, filing instructions, a determination of deductibility, or financial, legal or tax advice. Calculations may omit tax brackets, credits, wage-base limits, other income and state/local rules. Check current rates and your circumstances with a qualified tax professional. No tax savings or accuracy for an individual return is promised.

Digital spreadsheet only. Enter your own data; no bank connection, automated bookkeeping service or professional advice is included. Results depend on your inputs; no income or savings are guaranteed.

AI disclosure: AI tools were used to generate formulas, layout and explanatory text in this spreadsheet product.