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 create mileage-log entries and monthly summary rows on your expense tab. Review the imported dates, miles, business purpose, and any missing trips before using the log for taxes.

How to download the CSV: Log into drivers.uber.com on a desktop browser (not the mobile app) → Earnings → Statements → Download CSV. The file downloads as a .csv and can be up to 500 KB (5,000 trips). Set a mileage rate and expense category in Settings first; the import needs both.

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."
• Monthly summary rows — one per month on your main expense tab, so the deduction stays visible. The import does not create Income tab rows; add earnings with Add 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 76 cents/mile for miles driven from July 1, 2026 (Announcement 2026-11); miles driven January 1 - June 30 use 72.5 cents (Notice 2026-10). The import creates monthly expense summaries using the mileage rate saved in Settings. Use the Vehicle Deduction Optimizer to compare deductions using the standard rate in force on each trip date; review the imported log first. Note: the distance column covers only trip miles; deadhead miles (driving to pickup) require a separate GPS tracker or manual log.

Miles missing from the CSV: Keep actual records of business miles driving to pickups or between rides, with the date, distance, destination, and business purpose. Do not add an estimated percentage to your imported miles. Travel between home and your first or last work location can be personal commuting; exceptions depend on your circumstances. See IRS Publication 463.