Vehicle Maintenance Log

A workshop job log for an auto repair shop: customer vehicles, job cards with parts, labour and GST, and the next service reminder.

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

Vehicles, Service Jobs

Fields

29

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.

Vehicles

11 fields · 4 sample rows

  • Vehicles (Grid)
VehicleTextRegistrationTextMake & ModelTextYearNumberFuelSingle selectOwnerTextOwner PhonePhoneJobsLink to another tableVisitsCountLast VisitRollupLifetime SpendRollup
Honda City – KulkarniMH12 AB 4521Honda City VX2,019PetrolPrakash Kulkarni+91 98220 4455140k km periodic service, Battery replacement217 Nov 2026₹14,042
Creta – ThomasMH14 CD 7788Hyundai Creta SX2,021DieselAnnie Thomas+91 98220 44552Brake pads + disc skimming119 Nov 2026₹10,266
Nexon EV – ShahMH12 EV 1001Tata Nexon EV2,023ElectricRutvik Shah+91 98220 44553Tyre rotation & alignment121 Nov 2026₹1,416
Swift – JoshiMH12 GH 3030Maruti Swift ZXi2,017PetrolMegha Joshi+91 98220 44554AC not cooling118 Nov 2026₹6,254
Field details
Vehicle · Text
Registration · Text
Make & Model · Text
Year · Number
Fuel · Single select
Petrol, Diesel, CNG, Electric, Hybrid
Owner · Text
Owner Phone · Phone
Jobs · Link to another table
Links to Service Jobs
Visits · Count
Last Visit · Rollup
latest of Date In via Jobs
Lifetime Spend · Rollup
sum of Total via Jobs

Service Jobs

18 fields · 5 sample rows

  • Job log (Grid)
  • Workshop board (Kanban)
  • Bookings (Calendar)
  • Book a service (Form)
  • Workshop revenue (Dashboard)
JobTextJob Card #AutonumberVehicleLink to another tableDate InDateDate OutDateOdometer (km)NumberWork TypeMultiple selectMechanicSingle selectStatusSingle selectPartsCurrencyLabourCurrencyGST (18%)FormulaTotalFormulaNext Service DateFormulaNext Service at (km)FormulaPaidCheckboxInvoiceAttachmentNotesLong text
40k km periodic serviceJC-0001Honda City – Kulkarni17 Nov 202618 Nov 202640,210General service, Oil changeSalimDelivered₹4,200₹1,800₹1,080₹7,08017 May 202750,210Yes
Brake pads + disc skimmingJC-0002Creta – Thomas19 Nov 202652,800BrakesGaneshIn bay₹6,500₹2,200₹1,566₹10,26619 May 202762,800
AC not coolingJC-0003Swift – Joshi18 Nov 202688,450AC service, ElectricalPeterWaiting for parts₹3,800₹1,500₹954₹6,25418 May 202798,450Compressor clutch on order — ETA 2 days.
Tyre rotation & alignmentJC-0004Nexon EV – Shah21 Nov 202615,020Tyres & alignmentSalimBooked₹0₹1,200₹216₹1,41621 May 202725,020
Battery replacementJC-0005Honda City – Kulkarni22 Jun 202622 Jun 202634,900BatteryPeterDelivered₹5,600₹300₹1,062₹6,96222 Dec 202644,900Yes
Field details
Job · Text
Job Card # · Autonumber
Vehicle · Link to another table
Links to Vehicles
Date In · Date
Date Out · Date
Odometer (km) · Number
Work Type · Multiple select
General service, Oil change, Brakes, Tyres & alignment, Battery, AC service, Engine, Suspension and 2 more
Mechanic · Single select
Salim, Ganesh, Peter
Status · Single select
Booked, In bay, Waiting for parts, Ready, Delivered
Parts · Currency
INR
Labour · Currency
INR
GST (18%) · Formula
ROUND(({Parts} + {Labour}) * 0.18, 0)
Total · Formula
{Parts} + {Labour} + {GST (18%)}
Next Service Date · Formula
IF({Date In}, DATEADD({Date In}, 6, 'months'), BLANK())
Next Service at (km) · Formula
IF({Odometer (km)}, {Odometer (km)} + 10000, BLANK())
Paid · Checkbox
Invoice · Attachment
Notes · Long text

Form view “Book a service” asks for: Job, Vehicle, Date In, Odometer (km), Work Type, Notes.

Vehicle Maintenance 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