Drivers Log Sheet

A trip log for taxi, cab and delivery fleets: drivers and licences, odometer distances, fares, fuel and net earnings per trip.

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

Drivers, Trips

Fields

26

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Drivers

10 fields · 3 sample rows

  • Drivers (Grid)
  • By status (Kanban)
DriverTextPhonePhoneLicence #TextLicence ExpiryDateLicence StatusFormulaStatusSingle selectTripsLink to another tableTrip CountCountTotal kmRollupNet EarningsRollup
Gurpreet Singh+91 98140 11122PB10 2019001234524 Dec 2027ValidOn dutyAirport drop – Mehta, Mysuru day trip2332₹3,280
Mohammed Rafiq+91 98450 33344KA01 201700543219 Dec 2026Renew soonOn dutyOffice shuttle AM, City ride – MG Road240₹1,610
Carlos Mendes+91 99200 55566MH02 2020009876514 Nov 2026ExpiredOff dutyWarehouse delivery run136₹500
Field details
Driver · Text
Phone · Phone
Licence # · Text
Licence Expiry · Date
Licence Status · Formula
IF(NOT({Licence Expiry}), 'Missing', IF(IS_BEFORE({Licence Expiry}, TODAY()), 'Expired', IF(DATETIME_DIFF({Licence Expiry}, TODAY(), 'days') <= 30, 'Renew soon', 'Valid')))
Status · Single select
On duty, Off duty, On leave, Suspended
Trips · Link to another table
Links to Trips
Trip Count · Count
Total km · Rollup
sum of Distance (km) via Trips
Net Earnings · Rollup
sum of Net via Trips

Trips

16 fields · 5 sample rows

  • Trip log (Grid)
  • Calendar (Calendar)
  • Log a trip (Form)
  • Fleet summary (Dashboard)
TripTextDriverLink to another tableDateDateVehicleSingle selectTrip TypeSingle selectFromTextToTextStart OdometerNumberEnd OdometerNumberDistance (km)FormulaFareCurrencyFuelCurrencyTolls & ParkingCurrencyNetFormulaPaymentSingle selectReceiptAttachment
Airport drop – MehtaGurpreet Singh19 Nov 2026KA01 AB 1234 · DzireAirportIndiranagarKIA Terminal 248,21048,25242₹1,250₹300₹120₹830UPI
Office shuttle AMMohammed Rafiq19 Nov 2026KA03 MN 5678 · InnovaCorporateHSR LayoutWhitefield91,02091,04828₹1,800₹420₹0₹1,380Corporate account
Warehouse delivery runCarlos Mendes18 Nov 2026KA05 XY 9012 · AceDeliveryPeenyaJayanagar30,55030,58636₹900₹350₹50₹500Cash
Mysuru day tripGurpreet Singh17 Nov 2026KA01 AB 1234 · DzireOutstationBengaluruMysuru47,86048,150290₹4,800₹1,900₹450₹2,450Card
City ride – MG RoadMohammed Rafiq17 Nov 2026KA03 MN 5678 · InnovaCityKoramangalaMG Road90,99091,00212₹380₹110₹40₹230UPI
Field details
Trip · Text
Driver · Link to another table
Links to Drivers
Date · Date
Vehicle · Single select
KA01 AB 1234 · Dzire, KA03 MN 5678 · Innova, KA05 XY 9012 · Ace
Trip Type · Single select
Airport, City, Outstation, Delivery, Corporate
From · Text
To · Text
Start Odometer · Number
End Odometer · Number
Distance (km) · Formula
IF(AND({Start Odometer}, {End Odometer}), {End Odometer} - {Start Odometer}, BLANK())
Fare · Currency
INR
Fuel · Currency
INR
Tolls & Parking · Currency
INR
Net · Formula
{Fare} - {Fuel} - {Tolls & Parking}
Payment · Single select
Cash, UPI, Card, Corporate account
Receipt · Attachment

Form view “Log a trip” asks for: Trip, Driver, Date, Vehicle, Trip Type, From, To, Start Odometer, End Odometer, Fare, Fuel, Tolls & Parking, Payment, Receipt.

Drivers Log Sheet: 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