Excel workbook
Gig Driver Income and Mileage Tracker: Earnings Per Mile, Per Hour and Tax Set-Aside in Excel
Log each day by platform and see what you really earn per mile and per hour, which platform pays best, and how much to set aside for taxes.
$19 one time · example and blank copies · download link by email
Who it is for
Rideshare, delivery and other self-employed drivers who want clean records of income, miles and costs.
Why it is different
- The mileage rate is an input you set from irs.gov, so the workbook does not go out of date when the rate changes.
- It shows the standard mileage method and the actual-expense method side by side.
- A filled example for an invented part-time driver and a blank copy with working formulas.
What is inside
- Start Here. Purpose, which cells to fill in and what the workbook is not.
- Setup. Tax year, the mileage rate you enter from irs.gov, your set-aside percentage, your platforms and your vehicle business-use percentage.
- Daily Log. Date, platform, earnings, tips, business miles, hours online, fuel and tolls, with earnings per mile and per hour.
- Expenses. Phone, insurance share, supplies, maintenance and other costs by category.
- Monthly. Twelve months of income, miles, mileage deduction, expenses and net profit, with the actual-expense method shown beside it.
- Quarterly Set-Aside. Net profit by quarter, the amount to set aside, what you paid and what is left, with the usual estimated payment dates as reminders.
- Dashboard. Year to date totals and the best platform by earnings per hour.
- Checks. Miles that do not add up, missing dates and a blank mileage rate.
A look inside
Example data, real formulas
Get it
Gig Driver Income and Mileage Tracker
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. A tracking aid, not tax advice. Tax rules and mileage rates change, and the example rate is invented for demonstration. Check irs.gov and a tax professional. The set-aside is your own estimate, and quarters follow the calendar, which differs from the IRS payment periods. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others