You can make a copy of this mileage log template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.
Below we explain how to use our mileage log template in Google Sheets:
Enter the date of the trip in the format of year-month-day. This standardizes the dates for easy sorting and filtering.
Describe the purpose of the trip. Be specific; for example, "Client meeting at ABC Corp" or "Supply run to XYZ Supplies."
Enter the vehicle's mileage before you start your trip. This should be recorded directly from the vehicle's odometer.
Enter the vehicle's mileage immediately after the trip concludes. Again, this should be taken from the vehicle's odometer.
This cell will automatically calculate the total miles driven for the trip by subtracting the Starting Mileage from the Ending Mileage. If you're manually filling this out, subtract the Starting Mileage from the Ending Mileage.
Enter the reimbursement rate per mile. This rate can vary depending on the policy of your organization or the current standard mileage rate provided by the IRS or your country's tax authority. For example, in 2023, the IRS standard mileage rate is 62.5 cents per mile for business travel.
This cell automatically calculates the total amount to be reimbursed for the trip by multiplying the Total Miles by the Rate per Mile. Ensure to set the correct reimbursement rate per mile for accurate calculations.
Any additional information about the trip can be entered here. This could include tolls, parking fees (if you're including these in your mileage log for reimbursement), or any other relevant details about the trip.
Here we have our sample data for your reference:
We hope that this article has helped you and given you a better understanding of how to use our Google Sheets mileage log template. If you enjoyed this article, you might also want to check out our film budget template and rental property spreadsheet template in Google Sheets.
