ExpenseBot

How do I import my Uber CSV to create a mileage log?

Uber provides a downloadable trip history CSV from drivers.uber.com that includes every completed trip with date, distance, earnings, tips, surge, and a unique trip ID. ExpenseBot can import this CSV to automatically create both an IRS-compliant mileage log and Income Tab entries.

Uber provides a downloadable trip history CSV from drivers.uber.com that includes every completed trip with date, distance, earnings, tips, surge, and a unique trip ID. ExpenseBot can import this CSV to automatically create both an IRS-compliant mileage log and Income Tab entries.

How to download the CSV: Log into drivers.uber.com on a desktop browser (not the mobile app) → click your profile photo → Tax Information → download Trip/Earnings History for the relevant tax year. The file downloads as a .csv.

What the import creates:

  • Mileage Log entries — one per trip, using the distance column (actual trip route miles from pickup to dropoff) and begin_trip_time as the date. The IRS-required business purpose is pre-filled as "Uber trip."
  • Income Tab rows — earnings + tip + surge combined per trip, categorized as Rideshare Income.

Key CSV columns for taxes:

  • distance — trip route miles (pickup to dropoff only — does not include deadhead miles)
  • earnings — driver net after Uber's commission
  • tip and surge — taxable income, added to earnings total
  • id — unique trip identifier used for deduplication

Deduplication: Each imported trip is stored with record ID mileage_uber_[trip_id]. Re-importing an overlapping CSV skips trips already in your log. This means you can safely import quarterly CSVs and then a full-year CSV at year-end — no double counting.

Mileage deduction: The 2026 IRS standard mileage rate is 72.5 cents/mile (IRS Notice 2026-10). After import, ExpenseBot totals trip miles and calculates the Schedule C Line 9 deduction. Note: the distance column covers only trip miles; deadhead miles (driving to pickup) require a separate GPS tracker or manual log.

Note on deadhead miles: Deadhead miles (driving to pickup, between rides, and driving home at end of shift) are also deductible. Many active Uber drivers add 20-40% to their trip miles as an estimate for deadhead, or use a GPS tracker in parallel with the CSV import to capture both.

Share:

Try ExpenseBot Free

AI extracts every receipt into a Google Sheet you own. Gmail scan, mileage, tax reports, profit-by-client. No credit card needed.

No credit card required · Setup in 30 seconds