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
Tables
Drivers, Trips
Fields
26
Views
grid, kanban, calendar, form, dashboard
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.
10 fields · 3 sample rows
| DriverText | PhonePhone | Licence #Text | Licence ExpiryDate | Licence StatusFormula | StatusSingle select | TripsLink to another table | Trip CountCount | Total kmRollup | Net EarningsRollup |
|---|---|---|---|---|---|---|---|---|---|
| Gurpreet Singh | +91 98140 11122 | PB10 20190012345 | 24 Dec 2027 | Valid | On duty | Airport drop – Mehta, Mysuru day trip | 2 | 332 | ₹3,280 |
| Mohammed Rafiq | +91 98450 33344 | KA01 20170054321 | 9 Dec 2026 | Renew soon | On duty | Office shuttle AM, City ride – MG Road | 2 | 40 | ₹1,610 |
| Carlos Mendes | +91 99200 55566 | MH02 20200098765 | 14 Nov 2026 | Expired | Off duty | Warehouse delivery run | 1 | 36 | ₹500 |
16 fields · 5 sample rows
| TripText | DriverLink to another table | DateDate | VehicleSingle select | Trip TypeSingle select | FromText | ToText | Start OdometerNumber | End OdometerNumber | Distance (km)Formula | FareCurrency | FuelCurrency | Tolls & ParkingCurrency | NetFormula | PaymentSingle select | ReceiptAttachment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Airport drop – Mehta | Gurpreet Singh | 19 Nov 2026 | KA01 AB 1234 · Dzire | Airport | Indiranagar | KIA Terminal 2 | 48,210 | 48,252 | 42 | ₹1,250 | ₹300 | ₹120 | ₹830 | UPI | |
| Office shuttle AM | Mohammed Rafiq | 19 Nov 2026 | KA03 MN 5678 · Innova | Corporate | HSR Layout | Whitefield | 91,020 | 91,048 | 28 | ₹1,800 | ₹420 | ₹0 | ₹1,380 | Corporate account | |
| Warehouse delivery run | Carlos Mendes | 18 Nov 2026 | KA05 XY 9012 · Ace | Delivery | Peenya | Jayanagar | 30,550 | 30,586 | 36 | ₹900 | ₹350 | ₹50 | ₹500 | Cash | |
| Mysuru day trip | Gurpreet Singh | 17 Nov 2026 | KA01 AB 1234 · Dzire | Outstation | Bengaluru | Mysuru | 47,860 | 48,150 | 290 | ₹4,800 | ₹1,900 | ₹450 | ₹2,450 | Card | |
| City ride – MG Road | Mohammed Rafiq | 17 Nov 2026 | KA03 MN 5678 · Innova | City | Koramangala | MG Road | 90,990 | 91,002 | 12 | ₹380 | ₹110 | ₹40 | ₹230 | UPI |
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.
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.
Log what you worked on, when and for how long, then see where your hours really go by category and project.
1 table · 10 fieldsAnger Management SheetA private anger journal: note what triggered it, how intense it felt, what you did to cope and how much it helped.
1 table · 12 fieldsBathroom Cleaning LogA contactless restroom cleaning log: staff scan, tick what they cleaned and restocked, and supervisors spot missed checks.
1 table · 10 fieldsCall Log TemplateA sales call log that ties every call to a contact, records direction, duration and outcome, and schedules the follow-up.
2 tables · 20 fieldsCase Management SheetTrack client cases from intake to closure, with caseworker assignments, next actions, documents and a dated log of every contact.
2 tables · 26 fieldsChange Log TemplateRecord every product or project change — what changed, why, who approved it, the release it shipped in and how to roll it back.
1 table · 15 fields