DoorDash Mileage Tracker: How to Log Every Mile (Spreadsheet or Printable)
Share
The simplest DoorDash mileage tracker is an odometer log: write down your start and end reading for every shift, with the date and which app you drove for. Do it at the start and end of each shift, keep it all year, and you have a record that covers every mile, including the ones the app doesn't count.
Below is what to record, how to set up a mileage log in Google Sheets or Excel, and how to handle multi-apping. If you would rather not build it yourself, our DoorDash mileage tracker spreadsheet (Google Sheets and Excel) has the mileage log, shift log and expenses already set up.
Please note: this article is about keeping good records. It isn't tax advice. Mileage and vehicle rules differ by country and change over time, so check the current rules with the IRS (US), the CRA (Canada) or a tax professional.
Do I need to track mileage for DoorDash?
If you deliver as an independent contractor, your car is usually your biggest work cost, and in most places you can only claim what you can show. In the US, the IRS expects a record of business miles with dates and purpose. In Canada, the CRA expects a logbook to support the business-use share of your vehicle costs. Either way, a mileage log written at the time is far stronger than a guess at the end of the year.
Even apart from tax, tracking mileage shows what you really earn. An order that pays well per mile can still be poor once you add the drive back to a busy zone.
Does the DoorDash app track mileage?
The Dasher app shows the distance for each offer. Any mileage total a delivery app gives you can only include the miles it records, which are mainly miles on active orders. It won't know about:
- the drive from home to your starting zone
- repositioning between orders while you wait for the next offer
- the drive home at the end of the shift
- miles driven for another app during the same shift
Which of those miles you can claim depends on your country's rules, so the safe habit is to log all of them and mark what they were. Your tax preparer can then decide what counts.
What should a DoorDash mileage log include?
Keep one row per shift with these columns:
- Date
- App: DoorDash, Uber Eats, Instacart and so on, or "multi" if you ran several.
- Start odometer and end odometer
- Miles (or km): end minus start.
- Purpose: for example "DoorDash deliveries, downtown zone".
- Earnings and hours online: optional, but this is what turns a mileage log into an earnings tracker.
Also note your odometer on 1 January (or the day you start delivering) and on 31 December. Those two numbers give you total miles for the year, which you need to work out your business-use percentage.
How do you make a DoorDash mileage tracker in Google Sheets or Excel?
- Add the headings. In row 1 type: Date, App, Start, End, Miles, Purpose, Earnings, Hours.
-
Calculate the miles. In E2 type
=D2-C2and copy it down the column. - Add an app dropdown. Select column B, choose Data, then Data validation, and list your apps. This keeps "DoorDash" and "Door Dash" from being counted separately.
-
Total by app. On a second tab,
=SUMIFS(Log!E:E,Log!B:B,"DoorDash")gives your DoorDash miles. - Work out earnings per mile. Divide total earnings by total miles. Do the same with hours to get earnings per hour.
That covers the basics. The ready-made delivery driver expense tracker adds a shift log with net earnings per hour, trip and mile, an expense tab with business-use %, a maintenance log with the next service due, and a monthly dashboard. It works in miles or km and any currency, and you enter your own mileage rate, so it isn't tied to one country's rules.
Should I track DoorDash and Uber miles separately?
You only drive one car, so keep one log and add an App column. If you run DoorDash and Uber Eats at the same time, put "multi" in that column for those shifts rather than trying to split each mile. This avoids counting the same miles twice, and the totals by app are still there if you want them.
Is a printable mileage log better than an app?
Use whichever you will actually fill in. GPS apps record trips automatically but can drain your battery and miss trips when the phone is off. A paper log in the car is hard to forget, but you will need to type it up at tax time. A spreadsheet sits in between: about 20 seconds per shift to enter two odometer readings, and it does the totals for you. Many drivers keep a small notebook in the car and copy it into the sheet once a week.
Planning to grow beyond delivery? The side hustle expense tracker kit includes the driver tracker plus versions for Etsy sellers, Airbnb hosts, cleaners and beauty pros. Our guide to a monthly budget template in Google Sheets shows how to budget around uneven gig income, and if you are paying off a car loan or cards, see how to create a debt payoff tracker.
Mileage and expense trackers for drivers
- Rideshare & Delivery Driver Expense Tracker — mileage log from odometer readings, shift log, earnings per hour and per mile, expenses and maintenance, for Google Sheets and Excel
- Side Hustle Finance Kit — the driver tracker plus four more job-specific income and expense trackers
- Small Business Bookkeeping Spreadsheet — income, expenses and profit and loss if your side hustle is turning into a business
FAQ
Does DoorDash give you a mileage total?
The Dasher app shows the distance for each offer, and a delivery app can only total the miles it records, which are mainly miles on active orders. It won't include driving to your zone, between orders or home. Keep your own odometer log so you have the full picture.
Is a spreadsheet good enough as a mileage log?
A spreadsheet filled in at the time, with the date, odometer readings, miles and purpose for each shift, is a common way to keep a mileage log. Keep it up as you go rather than writing it all in at the end of the year, and check your country's record-keeping rules.
What if I forgot to track my mileage?
Start a log today. For past months, your order history, bank statements and service records can help you rebuild an estimate, but a reconstructed log is weaker than one kept at the time. Ask a tax professional how to handle it.
Should I track mileage in miles or kilometres?
Use whatever your tax authority uses: miles for the IRS in the US and kilometres for the CRA in Canada. Our driver tracker lets you choose km or miles on the Setup tab.