Mileage Log

Log business miles from odometer readings and work out the reimbursable or deductible amount at the standard mileage rate.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Log Sheets

Tables

Trips

Fields

14

Views

grid, calendar, form, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Trips

14 fields · 6 sample rows

  • Mileage log (Grid)
  • Calendar (Calendar)
  • Log a trip (Form)
  • Tax summary (Dashboard)
TripTextDateDateVehicleSingle selectPurposeSingle selectFromTextToTextStart OdometerNumberEnd OdometerNumberMilesFormulaRate per MileCurrencyDeductibleFormulaTolls & ParkingCurrencyReimbursedCheckboxReceiptAttachment
Client meeting – Acme HQ18 Nov 20262021 Honda AccordClient visitHome officeAcme HQ, Austin32,150.432,188.938.5$0.700$26.95$12.00
Supply run16 Nov 20262019 Ford F-150BusinessOfficeHome Depot58,020.058,034.514.5$0.700$10.15Yes
Physio appointment15 Nov 20262021 Honda AccordMedicalHomeCity Clinic32,120.032,131.211.2$0.210$2.35
Food bank volunteering13 Nov 20262021 Honda AccordCharityHomeCentral Food Bank32,090.032,104.614.6$0.140$2.04
Trade show – Dallas9 Nov 20262019 Ford F-150BusinessAustinDallas Convention Center57,610.058,005.0395$0.700$276.50$38.50Yes
Weekend at the lake11 Nov 20262021 Honda AccordPersonal31,980.032,075.095$0.00
Field details
Trip · Text
Date · Date
Vehicle · Single select
2021 Honda Accord, 2019 Ford F-150
Purpose · Single select
Business, Client visit, Medical, Charity, Personal
From · Text
To · Text
Start Odometer · Number
End Odometer · Number
Miles · Formula
IF(AND({Start Odometer}, {End Odometer}), ROUND({End Odometer} - {Start Odometer}, 1), 0)
Rate per Mile · Currency
USD
Deductible · Formula
IF({Purpose} = 'Personal', 0, ROUND({Miles} * {Rate per Mile}, 2))
Tolls & Parking · Currency
USD
Reimbursed · Checkbox
Receipt · Attachment

Form view “Log a trip” asks for: Trip, Date, Vehicle, Purpose, From, To, Start Odometer, End Odometer, Rate per Mile, Tolls & Parking, Receipt.

Mileage Log: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates