KHIZHNYAKOV

← All templates

Vehicle Service and Repair Tracker — Excel Template

Service and repair log for several vehicles, a schedule by mileage and months, an "what is overdue" traffic light, and costs per vehicle and per 1,000 km.

Vehicle Service and Repair Tracker — Excel Template
≈ $4.89
390 ₽
Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets
Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

A forgotten oil change or timing belt replacement is expensive, and receipts and booklet entries get lost. Here you enter the work in the log, and the spreadsheet uses your schedule to calculate when the next service is due for each item and shows a traffic light: red = overdue, yellow = soon, green = OK.

What is inside

  • "Vehicles": up to 20 vehicles: license plate, make, year, mileage at the start of tracking and current mileage.
  • "Service schedule": up to 20 items (oil, filters, spark plugs, timing belt, brake pads, fluids) with an interval in kilometers and/or months and warning settings.
  • "Log": up to 500 records: date, mileage, type of work, category, parts and labor separately, workshop; mileage check.
  • "Service plan" and "Traffic light": the next replacement by mileage and by date, remaining km and days, and a status for every item of every vehicle.
  • "Costs": by vehicle, for 12 months, by category, by type of work and by month, cost per 1,000 km, a chart.

Who it is for

Owners of one or several private vehicles, small fleets, taxi and delivery drivers using their own cars, and small-business mechanics who track servicing without special software.

What you get

The package contains a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not accounting software. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Intervals and thresholds are kept in the schedule: check them against your vehicle's service booklet before use. The calculation is approximate.

📘 Car Maintenance Log in Excel: Service Schedule, Overdue Alerts and Costs

Questions and answers

How does the spreadsheet determine when the next service is due?
It takes the last log record for the item. The next service by mileage is the mileage at the last replacement plus the interval in kilometers; by time it is the replacement date plus the interval in months. The status depends on whichever comes first.
Where do I get the intervals?
From your vehicle's service booklet or manual. The intervals on the "Service schedule" sheet are only examples; enter your own. The spreadsheet calculates from the numbers you enter and does not replace the manufacturer's recommendations.
What if an interval applies only by time or only by mileage?
Leave the unneeded column empty: for example, brake fluid has only a term in months, and brake pads have only kilometers.
How does the spreadsheet know the current mileage?
It is the maximum of the mileage at the start of tracking, the manually entered mileage and the highest mileage in the log. Update "Current mileage" when you check the odometer.