# Car maintenance sheet Excel (free): oil and filters

> Free Excel sheet to track car maintenance by km and months: service log, next due oil and filter dates, fuel consumption, licence dates and yearly cost per km.

Source: https://softwiro.com/blog/car-maintenance-log-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Personal car maintenance sheet in Excel (free): oil and filter dates by km

Know when each service is due by kilometres and months, and what your car costs per year and per km.

15 November 2026 6 min read

## In short

- Give each item an interval in km and in months (the sample intervals are examples); the sheet takes whichever comes first.
- The next due km and date come from the latest entry in the service log, with a status of overdue, due soon or fine.
- Hold up to ten cars, each with its own current odometer, fill-ups and items.
- A fuel log gives litres per 100 km, and licence and insurance dates show the days left.
- The summary gives the year's cost and cost per km with four charts.

You want to know when to change your car's oil, filters, tyres and battery without trusting memory or the sticker on the windscreen, and to know what the car costs you per year and per kilometre. The free [personal car maintenance sheet](https://softwiro.com/templates/car-maintenance-log) does that: you type each item's interval in km and in months and log what you do, and the sheet works out the next due point and tells you: overdue, due soon or fine.

## The problem it solves

Routine servicing is forgotten because it runs on two clocks, kilometres and months, and whichever comes first sets the date. A car that barely moves can go half a year on one oil change before the odometer gets close, while a car that moves a lot hits the distance before the months. With two cars it is harder still. The sheet checks both limits for every item and takes the earlier, and it adds up what you spend on the car in servicing, fuel and renewals.

## How the sheet works, step by step

1. In Settings type today's date, the year you are reviewing, and how many km or days before the due point you want to be warned.
2. In السيارات (Cars) type each car: name, model, plate, the odometer when you started tracking and the current odometer.
3. In جدول الصيانة (Schedule) choose the car and item and type the km interval and the months interval, plus the last change before you used the sheet (date and odometer) if you know it. The intervals in the file are general examples, so type your own car's from the owner's manual.
4. In سجل الصيانة (Service log) log each service: date, car, item, odometer, workshop and cost.
5. In الوقود (Fuel) log each fill-up in date order for each car: date, odometer, litres and price per litre.
6. In التراخيص (Documents) type the licence, insurance and inspection with their expiry dates.
7. Open المتابعة (Follow-up) to see the items closest to due, and الملخص (Summary) for the year's cost.

The core rules: **due by distance = last-change odometer + km interval**, **due by date = last-change date + months interval**, **overdue** means either has passed, **soon** means less than the limit in Settings is left, and the **current odometer** is the larger of what you typed in Cars and the highest reading you have logged.

## What each sheet holds

- Settings: the date, the warning limits and the lists of items and documents.
- Cars: each car with its odometer, yearly cost, cost per km, consumption and count of overdue items.
- Schedule: for each item its interval, last change, next due point and status.
- Service log: what you actually did each time, and what it cost.
- Fuel: the fill-ups, consumption and cost per km.
- Documents: the days left on licence, insurance and inspection.
- Follow-up: the 20 items closest to due across all cars.
- Summary: today's status, the year's cost, a monthly table and four charts.

## Walk-through on the sample numbers

The figures below are sample data for two imaginary cars (a Corolla and a Tucson) in November 2026, not a recommendation for any real car: the service intervals are examples and today is 15 November 2026.

- Corolla oil: changed on 18 September at 85,647 km, interval 10,000 km or 6 months. Next due 95,647 km and 18 March 2027. The current odometer is 87,096, so 8,551 km and 123 days remain, and the status is fine.
- Cabin (AC) filter: last changed before the sheet on 10 August 2025 at 76,500 km, interval 15,000 km or 12 months. By distance it is due at 91,500 (4,404 left), but by date it was due on 10 August 2026, 97 days ago, so the status is overdue and it tops the Follow-up list.
- Corolla tyre rotation: done on 17 April at 81,556, due at 91,556 km (4,460 left) and on 17 October 2026, which passed 29 days ago, so it is overdue because of the months, not the distance.
- Brake pads: last change before the sheet at 58,000 with a 30,000 km interval, so due at 88,000 with only 904 km left: due soon.
- Totals: of 18 items in the schedule 3 are overdue, 4 are due soon and 11 are fine. On documents, the Corolla's inspection expired 14 days ago, the Tucson's licence expires in 16 days and three documents are valid.
- 2026 cost for both cars: servicing 6,750, fuel 32,815.30 and licence and insurance renewals 14,830, a total of 54,395.30 over 18,560 km counted from the fuel fill-ups, or 2.93 per kilometre. The Corolla is 2.16 (17,270 over 8,011 km) and the Tucson 3.52, because the Tucson's comprehensive insurance was 12,500. The Corolla uses 7.40 litres per 100 km and the Tucson 8.90.

## Common mistakes

- Typing intervals from memory: the intervals in the file are examples; the right ones are in the owner's manual and the workshop's advice.
- Not updating the current odometer: items look newer than they are, so update it whenever you see the car's odometer.
- Logging the oil but not the filter: log each item on its own line, since each has its own due point.
- Typing fill-ups out of order: consumption is worked out from the car's previous fill-up, so keep date order.
- Leaving "last change" empty: an item with no log and no data shows "complete the data".

## When to move to a system

The sheet suits your own car or your family's cars. If you run a fleet with drivers and want automatic reminders and a manager's review, use the [fleet fuel and maintenance sheet](https://softwiro.com/templates/fleet-fuel-maintenance) (and its [guide](https://softwiro.com/blog/fleet-fuel-maintenance-free-excel-online.html)), or ask Softwiro for a system built around your way of working. If you drive your car for a living, the [taxi and Uber driver income sheet](https://softwiro.com/templates/taxi-driver-income) gives your net per day.

## Your next step

Download the sheet, type your car and its current odometer in Cars, then add three items whose last change you know to the Schedule: oil, the filter and your tyres. Open Follow-up a few minutes later to see what is due, then add the rest of the items over the next days. Fees and insurance follow local law.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: personal car maintenance (1/3)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-1.jpg)[![Cheat sheet: personal car maintenance (2/3)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-2.jpg)[![Cheat sheet: personal car maintenance (3/3)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/car-maintenance-log/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Are the intervals in the sheet right for my car?

No, they are general examples. Type each item's interval from your owner's manual, your use and the workshop's advice.

### How does the sheet know the next service date?

It takes the item's latest change from the service log and adds the interval: last-change odometer + km interval for distance, and its date + months for date. With no log entry it uses what you typed in the Schedule.

### When does it show overdue or due soon?

Overdue when the odometer passed the distance point or the due date has passed; due soon when less than the limit in Settings is left, in km or in days.

### Does it hold more than one car?

Yes, ten cars, each with its own items, odometer and fill-ups. For a fleet with drivers the fleet fuel and maintenance sheet fits better.

### How is the yearly cost per km worked out?

(the year's servicing + fuel + licence and insurance renewals made in it) ÷ the kilometres between fuel fill-ups in that year. It is approximate because the km come from fill-ups only.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
