Oil Change Tracker

For auto service shops: customer vehicles, every oil change with odometer and oil grade, and the next service due by date and kilometres.

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

Trackers

Tables

Vehicles, Oil Changes

Fields

28

Views

grid, kanban, calendar, 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)
RegistrationTextOwnerTextPhonePhoneMake & modelTextYearNumberFuelSingle selectOil changesLink to another tableServicesCountLatest serviceRollupHighest odometer (km)RollupLifetime spendRollup
MH 02 DN 4521Sameer Joshi+91 98200 11234Maruti Swift2,020PetrolJC-3101, JC-3388217 Nov 202646,900₹7,000
KA 05 MK 8890Lakshmi Narayan+91 98450 66778Toyota Innova Crysta2,018DieselJC-3392119 Nov 20261,12,500₹5,600
DL 8C AF 1123James Patel+91 99100 44556Honda City Hybrid2,023HybridJC-3360120 Oct 202615,100₹3,800
TN 09 BX 7712Divya Raghavan+91 94440 22331Hyundai Creta2,021DieselJC-3401122 Nov 2026₹0
Field details
Registration · Text
Owner · Text
Phone · Phone
Make & model · Text
Year · Number
Fuel · Single select
Petrol, Diesel, CNG, Hybrid
Oil changes · Link to another table
Links to Oil Changes
Services · Count
Latest service · Rollup
latest of Service date via Oil changes
Highest odometer (km) · Rollup
max of Odometer (km) via Oil changes
Lifetime spend · Rollup
sum of Total via Oil changes

Oil Changes

17 fields · 5 sample rows

  • Service log (Grid)
  • Bay board (Kanban)
  • Calendar (Calendar)
  • Workshop stats (Dashboard)
Job cardTextVehicleLink to another tableService dateDateOdometer (km)NumberOil gradeSingle selectOil typeSingle selectLitresNumberFilter replacedCheckboxInterval (km)NumberNext due (km)FormulaNext due dateFormulaPartsCurrencyLabourCurrencyTotalFormulaTechnicianSingle selectStatusSingle selectNotesLong text
JC-3101MH 02 DN 45212 Jun 202638,2000W-20Synthetic3.1Yes10,00048,2002 Dec 2026₹2,900₹500₹3,400RajuPicked up
JC-3388MH 02 DN 452117 Nov 202646,9000W-20Synthetic3.1Yes10,00056,90017 May 2027₹3,100₹500₹3,600AnilPicked up
JC-3392KA 05 MK 889019 Nov 20261,12,50015W-40Mineral7.5Yes7,5001,20,00019 May 2027₹4,800₹800₹5,600KevinIn bayAir filter also due — call owner.
JC-3360DL 8C AF 112320 Oct 202615,1000W-20Synthetic3.510,00025,10020 Apr 2027₹3,300₹500₹3,800RajuPicked up
JC-3401TN 09 BX 771222 Nov 20265W-30Semi-synthetic5.510,00022 May 2027₹0AnilBooked
Field details
Job card · Text
Vehicle · Link to another table
Links to Vehicles
Service date · Date
Odometer (km) · Number
Oil grade · Single select
0W-20, 5W-30, 5W-40, 10W-40, 15W-40
Oil type · Single select
Synthetic, Semi-synthetic, Mineral
Litres · Number
Filter replaced · Checkbox
Interval (km) · Number
Next due (km) · Formula
IF({Odometer (km)}, {Odometer (km)} + {Interval (km)}, BLANK())
Next due date · Formula
IF({Service date}, DATEADD({Service date}, 6, 'months'), BLANK())
Parts · Currency
INR
Labour · Currency
INR
Total · Formula
{Parts} + {Labour}
Technician · Single select
Raju, Anil, Kevin
Status · Single select
Booked, In bay, Done, Picked up
Notes · Long text

Oil Change Tracker: 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