Gig Driver Earnings, Mileage and Tax Tracker Excel for delivery and rideshare drivers — app earnings per hour, shift profit by platform, a mileage and deduction log, a monthly P and L dashboard, and a tax set-aside…
About this template
Gig Driver Earnings, Mileage and Tax Tracker Excel for delivery and rideshare drivers — app earnings per hour, shift profit by platform, a mileage and deduction log, a monthly P and L dashboard, and a tax set-aside planning estimate. Know what every hour on the road actually earns — after fuel, wear, and insurance.
$49
Excel & Google Sheets template — instant download on Etsy
Apps and Earnings — average hours per shift, fuel cost per shift, vehicle wear and fees per shift, cost per hour, earnings per hour, and margin in dollars and percent for every gig work type. Change a cost and every shift profit updates by formula. Fuel is costed here, inside the shift.
Shifts Log — date, shift note, platform, gig work type, hours, realized earnings per hour, revenue, cost per hour pulled from the earnings sheet, profit per shift, and margin. Log delivery, shopping, rideshare, and block shifts in one place.
Mileage and Tax Deduction — date, platform, miles, rate per mile, deduction by formula, and notes, with totals for total miles and total deduction. The rate per mile is a yellow planning input you set and update yourself — 0.70 in the example. It is not presented as an official rate and this sheet is not tax advice.
Monthly P and L — revenue, fuel and vehicle cost, phone and data, insurance, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and shift cost are formulas from the Shifts sheet. Fuel is inside the shift cost on sheet 1, so it is not a separate P and L line — do not enter it twice.
Dashboard — total revenue, shifts, hours, average shift value, gross and net profit and margin, best gig work type by margin per hour and by margin percent, best-selling work type, best shift and best platform, costs by category, the mileage deduction total from sheet 3, and a tax set-aside planning estimate of 20 percent of net profit.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Gig Driver Earnings, Mileage and Tax Tracker track?
The Gig Driver Earnings, Mileage and Tax Tracker tracks Apps and Earnings; Shifts Log; Mileage and Tax Deduction; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 1,868.50 from 20 shifts and 85.5 hours; average shift value 93.42.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.