sheetfolk

Published · Updated · sheetfolk guides

Uber and Lyft Driver Expenses Spreadsheet: Every Deductible Category and How to Log It Weekly

Build an Uber and Lyft driver spreadsheet with tabs for trips, expenses, mileage, payouts, weekly summaries, and a tax stash, then log every week with odometer readings, receipts, and payout reconciliations so your deductible totals are ready for month-end and quarterly review.

TL;DR: Build an Uber and Lyft driver spreadsheet with tabs for trips, expenses, mileage, payouts, weekly summaries, and a tax stash, then log every week with odometer readings, receipts, and payout reconciliations so your deductible totals are ready for month-end and quarterly review.

Overview

This spreadsheet is for Uber and Lyft drivers who want a clean weekly record of miles, income, and deductible expenses without turning tax time into a scavenger hunt. Each week, you will have updated trip totals, a mileage summary, and deductible expense totals ready for monthly or quarterly reconciliation.

Deductible categories every Uber/Lyft driver should track

Keep one bucket per category so your receipts and totals do not end up in the spreadsheet version of a junk drawer.

  • Fuel, gas and charging costs used for business driving, tracked as actual expenses if you are using that method.

  • Oil & fluids, oil changes, transmission fluid, coolant, and similar vehicle fluids used to keep the car working.

  • Maintenance & repairs, routine service and fixes tied to the business vehicle, like brakes, belts, batteries, and labor.

  • Tires, replacement tires, rotations, balancing, and related tire work.

  • Depreciation or lease payments, the vehicle cost recovery side of car use, whether you are tracking depreciation for an owned vehicle or lease payments for a leased one.

  • Insurance (auto and business), the business-use share of auto insurance and any rideshare-related coverage you pay for.

  • Registration and licensing, vehicle registration fees, permits, and licensing costs tied to operating the car for work.

  • Tolls and parking, tolls and parking fees incurred while driving for rideshare work.

  • Car washes and detailing, cleaning costs used to keep the vehicle presentable for passengers.

  • Vehicle accessories (mounts, chargers), phone mounts, charging cables, dash accessories, and other small tools that support rideshare driving.

  • Phone and data (business portion), the business-use share of your phone plan and data needed to run the apps.

  • Rideshare supplies (water, masks, branded items), consumable passenger supplies and small branded items used in your driving business.

  • Platform commissions and fees, Uber or Lyft fees and commissions taken out of your earnings, which matter for true net income tracking.

  • Bank fees, tax-prep & bookkeeping fees, fees for business banking, tax prep, and bookkeeping software or services.

  • Home-office, generally not applicable for drivers, since most rideshare work happens in the car, not at a dedicated business office.

Which vehicle deduction method to prepare for

Drivers commonly look at two approaches, the standard mileage method and the actual expenses method. They are not the same thing, and you generally do not want to casually mix them like a mystery smoothie.

A simple decision checklist for your spreadsheet:

  • Do you want the sheet to focus on odometer readings and business miles?
  • Do you want to save every vehicle receipt and sort actual costs by category?
  • Are you switching vehicles, leases, or usage patterns this year?
  • Do you want a clean record that an accountant can review later without translating your handwriting into modern English?

If you are unsure, log both mileage and actual expenses now, then review the deduction method with a tax professional later. The point is to keep the evidence clean while the facts are still fresh.

Spreadsheet structure: tabs to build and why

Build the workbook as a system, not a pile of tabs that only make sense to you at 11:47 p.m.

  • Trips / Daily Log, trip-level data for fare, tips, fees, and miles.
  • Expenses, non-mileage receipts and deductible purchases.
  • Mileage Register, odometer snapshots and weekly business miles.
  • Platform Payouts, imported CSV reconciliations from Uber, Lyft, or other platforms.
  • Weekly Summary, computed totals for the week.
  • Tax Stash / Sinking Fund, the reserve you set aside from earnings.
  • Year-to-date Report, tax-ready totals for the current year.
  • Attachments, links to receipt images, statements, and support files.

Trips / Daily Log, exact columns to use and why

  • Date, groups trips into the right week and tax period.

  • Start time, helps identify trip order and supports the daily timeline.

  • End time, useful for cross-checking trip duration.

  • Start address/zone, optional location detail for tracking where work happened.

  • End address/zone (optional), optional destination detail if you want more context.

  • Start odometer, starting mileage for the trip block.

  • End odometer, ending mileage for the trip block.

  • Platform (Uber/Lyft/Other), identifies where the trip came from.

  • Trip fare (gross), gross fare before fees.

  • Tips, passenger tips received.

  • Platform fee (commission), app commission or service fee withheld.

  • Bonuses/surges, incentive income tied to the trip.

  • Net payout, formula example =Trip fare (gross) + Tips + Bonuses/surges - Platform fee (commission).

  • Category tag, helpful if you want to group certain trip types or work patterns.

  • Notes/receipt link, a short note plus a link to supporting records.

Expenses tab, exact columns and receipt rules

This tab is for everything deductible that is not already captured as a trip row.

  • Date, when the expense happened.
  • Vendor, who you paid.
  • Category, choose from the deductible list above.
  • Amount, the expense total.
  • Payment method, card, cash, wallet, or bank account.
  • Receipt link, photo or PDF location.
  • Related trip ID (if applicable), connects the expense to a specific driving shift or trip block.
  • Reimbursable flag, mark whether a platform or third party reimbursed it.

Contemporaneous receipts and vendor names matter because they make the record easier to substantiate later. Translation, if the receipt says “random gas place somewhere near the airport,” you will probably regret not writing the actual vendor name while you still remembered it.

Mileage Register, how to record odometer entries reliably

At minimum, record the odometer at the start of the week, at the end of the week, and any time the vehicle changes. If you change cars, lease another vehicle, or swap in a different work car, start a new trail.

Columns to use:

  • Date, when the odometer was captured.
  • Odometer, the actual reading.
  • Reason, start, end, weekend, or vehicle change.
  • Business miles that week, formula based on the weekly odometer difference and your business-use allocation.

The goal is a continuous odometer trail. Auditors, accountants, and future-you all prefer a line that goes forward in time instead of a pile of guesses with good intentions.

Platform Payouts tab, how to reconcile platform statements weekly

Import or paste the summary fields from Uber or Lyft CSV exports.

Columns to use:

  • Payout date, when the platform paid you.
  • Reported gross, platform-reported earnings before deductions.
  • Fees & adjustments, commissions, service fees, refunds, or corrections.
  • Transfers/paid amount, the amount actually transferred.
  • 1099-related identifiers, report name, year, or statement ID.

Each week, reconcile platform net payouts back to your trip-level net payouts with a SUMIFS or QUERY. That way, the spreadsheet tells you when the platform’s version and your version disagree, which they occasionally do, because spreadsheets are only mildly interested in everyone getting along.

Weekly Summary, totals you must produce every Sunday

This is the dashboard that keeps the whole workbook honest.

Worked example, one-week logging walkthrough and formulas

Here is a symbolic setup you can copy into your sheet without needing fake numbers to make it work.

Assume the Trips tab has these columns:

  • A: Date
  • B: Start time
  • C: End time
  • D: StartOdo
  • E: EndOdo
  • F: Miles
  • G: Platform
  • H: Gross
  • I: Tips
  • J: PlatformFee
  • K: Bonuses
  • L: NetPayout

Step 1, calculate miles per trip row

In F2:

=E2-D2

Copy down, or use ARRAYFORMULA if you want the sheet to fill the column automatically.

Step 2, calculate net trip payout

In L2:

=H2+I2+K2-J2

That gives you gross fare, plus tips, plus bonuses, minus platform fee.

Step 3, total weekly miles

If your week start date is in Weekly Summary!B2 and week end date is in Weekly Summary!C2, then weekly miles can be:

=SUMIFS(Trips!F:F, Trips!A:A, ">="&WeeklySummary!B2, Trips!A:A, "<="&WeeklySummary!C2)

Step 4, total weekly net income

=SUMIFS(Trips!L:L, Trips!A:A, ">="&WeeklySummary!B2, Trips!A:A, "<="&WeeklySummary!C2)

Step 5, tax stash calculation

If your tax rate is in Tax Stash!B2, then:

=WeeklySummary!NetIncomeCell * TaxStash!B2

Replace NetIncomeCell with the actual cell holding weekly net income in your summary. The formula pattern is what matters, not the label.

Key formulas and automations to add

Put the formulas where they do the least damage and the most good.

  • Trips tab, use ARRAYFORMULA to auto-fill derived columns like Miles and NetPayout.
    • Example: =ARRAYFORMULA(IF(A2:A="","",E2:E-D2:D))
  • Expenses tab, use IF to flag missing receipts.
    • Example: =IF(AND(D2<>"",F2=""),"Missing receipt","OK")
  • Weekly Summary tab, use SUMIFS for category-by-week totals.
    • Example: =SUMIFS(Expenses!D:D, Expenses!C:C, "Fuel", Expenses!A:A, ">="&B2, Expenses!A:A, "<="&C2)
  • Platform Payouts tab, use QUERY for platform rollups by date or source.
    • Example: =QUERY(A:E, "select B, sum(C) where A >= date '"&TEXT(B2,"yyyy-mm-dd")&"' group by B label sum(C) 'Gross'")
  • Year-to-date Report tab, use SUMIFS or QUERY to roll up annual totals.
    • Example: =SUMIFS(Trips!L:L, Trips!A:A, ">="&DATE(YEAR(TODAY()),1,1), Trips!A:A, "<="&TODAY())
  • Import workflow, use IMPORTRANGE if your platform exports live in another Google Sheet, or import CSV files into a staging tab before mapping fields.

Sinking funds / Tax Stash tab, how to set aside and show the reserve

This tab works like a simple sinking-fund tracker inside the workbook. You set a user-defined percentage or flat amount cell, then track a running reserve balance as you move money aside each week.

A simple setup:

  • TaxRate, a user-input cell.
  • WeeklyNetIncome, pulled from the Weekly Summary.
  • Weekly Deposit, formula =WeeklyNetIncome * TaxRate or a flat user amount if you prefer.
  • Running Balance, prior balance plus current deposit minus any tax payment.

That is the same general sinking-fund logic used in the SheetFolk guide, where the monthly target pattern helps you map a recurring saving goal into a formula-driven reserve. It fits quarterly tax planning nicely because the reserve gets updated on a predictable cadence instead of becoming a “we’ll figure it out later” situation, which is usually code for “future me is in trouble.” See the mechanics in Sinking Funds and Savings Goals: A Practical Guide for the Aspire Spreadsheet.

Weekly routine checklist

Do this at the same time every week so the sheet stays useful.

  1. Enter trip rows or import the platform CSV.
  2. Add receipts to the Expenses tab.
  3. Update odometer readings in the Mileage Register.
  4. Reconcile platform statements to Platform Payouts.
  5. Update the Tax Stash deposit.
  6. Snapshot the Weekly Summary for recordkeeping.

How to prepare your spreadsheet for handing to an accountant or for tax filing

Export the clean stuff, not the chaos.

Provide:

  • CSV of Trips
  • Expenses summary
  • Mileage Register with odometer entries
  • Year-to-date totals

Add a short narrative for anything odd, like platform disputes, reimbursements, vehicle changes, or months where you changed how you logged miles. If you made a manual override, annotate it so the accountant can see your logic instead of reverse-engineering it like a crime scene.

Common pitfalls and how to avoid them

  • Mixing personal and business miles, keep a strict business-only mileage log.
  • Not recording odometer readings contemporaneously, capture them when they happen, not from memory later.
  • Failing to reconcile platform adjustments, compare platform statements to your trip log weekly.
  • Double-claiming mileage and actual vehicle expenses, pick the method you are preparing for and keep the records consistent.
  • Missing receipts, attach them the same week you spend the money.
  • Overwriting formulas, lock or protect formula cells so totals do not get “helped” into nonsense.

When to use a reusable workbook versus a one-time template

Use a reusable workbook if you are logging rideshare work all year, want weekly updates, and need the same structure for each tax period. That is the Aspire-style approach, a living workbook that keeps accumulating data and reports over time. A contextual comparison is in Aspire Budgeting Spreadsheet: How to Set It Up, What It Does Well, and When a One-Time Template Fits Better, which is helpful if you are deciding between a maintained system and a one-off file.

Use a one-time template if you only need a single-year snapshot, want minimal upkeep, or are testing whether weekly logging is even your thing before committing to a bigger setup.

Record retention and audit safety

Keep receipts, platform statements, and odometer logs in durable formats such as PDFs, photos, and exported CSVs so they stay readable and auditable. The safest move is to store the workbook plus the supporting files in a place you can actually find later without summoning the gods of missing downloads.

Next steps and quick starter checklist for building the sheet

Get the workbook live this weekend.

  • Make the tabs.
  • Paste the column headers.
  • Add three example trip rows.
  • Set up the Weekly Summary formulas.
  • Create a TaxRate input cell.
  • Link receipt images in Attachments.
  • Save a copy, then test one full weekly reconciliation before real money hits the sheet.

Optional further reading and templates

If you want a head start on structure and formulas, Google Sheets budget templates are useful because they show how a clean workbook layout and pre-built formulas can save you from building every tab from scratch.

Template for this guide

Rideshare Driver Tax & Mileage Tracker

Mileage log, per-platform income, deductible expenses and a quarterly tax estimate built for Uber, Lyft and delivery drivers. Browse every tab before you buy. One-time price, no subscription, free updates to the current-year edition.

Buy for $11 See what's inside

Written with AI-assisted research and drafting under our direction, based on sheetfolk's own templates and pricing. Not financial advice.