Uber Driver Earnings Excel - Free Template

1. Enter each trip on the Trips & Expenses tab as you finish driving or at the end of the day. Use one row per trip so your mileage and expense detail stays accurate.
2. Fill in the date, platform, city, state, trip type, and miles driven. Add fares, tips, bonuses, tolls, parking, gas or charging, and any other trip cost you paid.
3. Review the total earnings and total expenses columns before you close the day. That gives you a fast check on whether a long shift actually paid off after costs.
4. Use the dashboard to review weekly totals and spot patterns. If one city or trip type produces more net income, you can focus your driving there.
5. Keep your receipts, app statements, and bank records in the same month as the spreadsheet. That makes your numbers easier to support if you need them for IRS records.
6. Update the sheet at least once a week, then use the instructions tab whenever you forget the order of entry or want to reset your routine.

Drivers usually need this sheet at the end of a shift, after a weekend rush, or when they sit down to estimate quarterly estimated taxes. A 1099 contractor who drives 25 to 40 trips a week can enter rows in batches instead of waiting until April, which is how mileage gets lost.

The workbook fits the way gig work is actually run: a morning airport run, a lunch delivery block, then a late-night surge period. If you drive in two cities and cover 900 miles a month, one file with trip-level detail is better than three scattered app exports.

Weekly Entry For Part-Time Drivers

A part-time driver making $450 on Friday and Saturday should record the work before the numbers blur together. Two $18 tolls and $26 in parking can change the real profit on a busy night more than most people expect.

Monthly Review For Full-Time Gig Income

At month-end, a driver with $4,200 in gross fares and $620 in fuel, tolls, and parking can see whether the week’s extra driving actually helped. That kind of review is what keeps your profit & loss from turning into guesswork.

The IRS does not reward vague totals. For your records, you want dates, trip counts, mileage, and expenses tied to each ride, because mileage is often the biggest deduction for a rideshare driver filing Schedule C with Form 1040.

Self-employment tax on Schedule SE is 15.3% before income tax, so clean records matter. If you owe $2,400 for the year and skip Form 1040-ES payments due April 15, June 15, Sept. 15, and Jan. 15, you can pick up penalties that eat into already-thin driver margins.

Why Mileage Detail Matters More Than Guesswork

In practice, a driver who logs 12,000 business miles and 1,800 personal miles can separate business use clearly. That is much stronger than a single yearly estimate scribbled from memory after 20,000 mixed miles.

Cash Basis Is Usually The Better Fit

Most drivers are better off using a cash-basis record of money actually received and paid, not a complicated accrual setup. You care about when Uber deposits arrive, when fuel leaves your account, and how that affects cash flow week by week.

The most expensive mistake is undercounting mileage or forgetting reimbursable trip costs. If you miss 2,000 business miles and use a 67¢ standard mileage benchmark, that is $1,340 in deductions you never captured.

Another common error is mixing personal and business fuel purchases without noting the trip. A driver who fills up for $58 twice a week can easily misclassify $150 to $200 a month, and that makes the monthly balance sheet or profit review useless.

Receipts Without Dates Do Not Help Much

A toll receipt with no trip date, city, or route is hard to match to a ride. If you ever need to defend a deduction, clean contemporaneous notes are worth far more than a box of random screenshots.

Bonuses And Tips Get Overlooked Too

Drivers also leave money off the sheet when they ignore in-app bonuses or cash tips. Missing $75 a week in bonuses is nearly $3,900 over a year, which is real income even before you count the tax impact.

Use the workbook at the same time every week, ideally after your last shift and before you cash out mentally. If you wait until tax season, you will spend hours reconstructing rides that should have taken 10 minutes to enter.

For a driver who works Friday through Sunday, the best routine is a Sunday night update plus a Monday morning check. That habit keeps your mileage, tolls, and parking from slipping through the cracks when you are tired.

Simple Habits That Keep It Current

• Enter trips once a day if you drive more than 6 hours.
• Match receipts to the row before the week ends.
• Use the same city and state names every time so your totals stay clean.
• Review the dashboard on the first of each month to see whether net earnings are rising or falling.

When A Spreadsheet Is No Longer Enough

If you are running multiple vehicles, helpers, or a side business with inventory and invoices, you may outgrow a simple workbook. At that point, QuickBooks or a dedicated fleet system is a better fit than forcing one sheet to do everything.