Free Excel template · Excel for personal finance and taxes

Free mileage log template for Excel

Q: What mileage rate should I put in the template?

Whichever rate applies to you: an employer's reimbursement rate, or a rate you confirm with a tax professional for the year. Rates change, so the template leaves the cell empty for you to fill in.

Q: How do I total miles by month in Excel?

Use SUMIFS with two date conditions: on or after the first of the month and before the first of the next, for example =SUMIFS(G2:G21,A2:A21,">="&DATE(2026,10,1),A2:A21,"<"&DATE(2026,11,1)).

Q: Can I use this mileage log in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; SUMIFS, EDATE and DATE work the same way there.

For freelancers, gig drivers and employees who claim mileage back and need a clean record of every trip. Log the date, purpose, start and end odometer; the sheet works out the miles, totals them by month and by purpose, and multiplies by the per-mile rate you enter. The rate cell starts empty on purpose: rates change, so type the one that applies to you.

cellwise-mileage-log-template.xlsxExcel workbook · 4.4 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	I	J
1	Date	Purpose	From	To	Start odometer	End odometer	Miles	Rate per mile (enter yours)
2	Oct 2, 2026	Client visit	Home office	Riverside clinic	48210	48236	26	Total miles logged	200
3	Oct 6, 2026	Supply run	Home office	Print shop	48251	48259	8	Amount at your rate	Enter your rate in J1
4	Oct 9, 2026	Client visit	Home office	Hillcrest office park	48302	48341	39
5	Oct 15, 2026	Bank deposit	Home office	Main St branch	48390	48396	6	Year to total	2026
6	Oct 21, 2026	Client visit	Home office	Riverside clinic	48460	48486	26	Month to total (1-12)	10
7	Oct 28, 2026	Workshop	Home office	Convention center	48533	48581	48	Miles in that month	153
8	Nov 3, 2026	Client visit	Home office	Hillcrest office park	48644	48683	39
9	Nov 6, 2026	Supply run	Home office	Print shop	48702	48710	8	Purpose to total	Client visit
10								Miles for that purpose	130
11								Trips logged	8
12
13
14
15
16
17
18
19
20

How the formulas work

Miles per trip from the odometer

G2=IF(F2="","",F2-E2)

End odometer minus start odometer. The IF keeps empty rows blank, so the spare rows at the bottom do not show zeros. Writing down the odometer at both ends is more reliable than estimating miles from a map later.

Apply the rate you enter

J3=IF(J1="","Enter your rate in J1",ROUND(J2*J1,2))

Total miles times the rate per mile in J1, rounded to cents. Until you type a rate the cell reminds you to. The rate is yours to look up: your employer's reimbursement rate or whatever rate applies to you for the year.

Miles in any month

J7=SUMIFS(G2:G21,A2:A21,">="&DATE(J5,J6,1),A2:A21,"<"&EDATE(DATE(J5,J6,1),1))

SUMIFS adds the Miles column for trips on or after the first day of the month in J5/J6 and before the first day of the next month. EDATE adds one month, so it works for 28, 30 and 31-day months and across December into January. In the sample October has 153 miles.

Miles for one purpose

J10=SUMIF(B2:B21,J9,G2:G21)

Type a purpose in J9 and SUMIF totals its miles. Use the same spelling for the same purpose every time; "Client visit" and "client visits" are different text to SUMIF.

Make it yours

Log trips the same day. A short note in Purpose (who you met, what you picked up) is easier to explain later than a bare date.
Add rows by inserting them above row 21 so every SUM and SUMIFS range grows with them, then fill the Miles formula down.
Keep one file per year and name it with the year. Copy the sheet into a new file in January and clear the trips.
If you drive the same round trip often, enter it as one row with the full round-trip odometer readings rather than two rows.

FAQ

What mileage rate should I put in the template?

Whichever rate applies to you: an employer's reimbursement rate, or a rate you confirm with a tax professional for the year. Rates change, so the template leaves the cell empty for you to fill in.

How do I total miles by month in Excel?

Use SUMIFS with two date conditions: on or after the first of the month and before the first of the next, for example =SUMIFS(G2:G21,A2:A21,">="&DATE(2026,10,1),A2:A21,"<"&DATE(2026,11,1)).

Can I use this mileage log in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; SUMIFS, EDATE and DATE work the same way there.

Functions used

Related guides

More free templates

Updated November 2, 2026