Skip to content

Car maintenance log: free CSV template and record-keeping guide

By Carstori editorial · Published · Last reviewed

Keep one maintenance log per vehicle. For every service, record the date, odometer reading and unit, work performed, parts, shop or DIY author, cost and currency. Attach the original invoice to that entry. A spreadsheet and receipt folder work; a dedicated garage can make the records easier to search and connect to parts.

Start with the next receipt, not the entire backlog

The most useful system is one you will update after the next service. Create a folder for each car, then add your newest invoice. Backfill older records in small batches. An incomplete but clearly dated history is more useful than a perfect template with nothing in it.

Give each invoice a readable filename such as service-date, vehicle nickname and job description. Keep the full original, including the reverse side if warranty terms are printed there. Avoid putting a VIN or home address in filenames you might share.

Use the free maintenance-log CSV in Excel or Google Sheets

Download the blank CSV above and open it in Excel, Google Sheets, Numbers or another spreadsheet that reads CSV files. It contains column headings and blank rows, with no macros, formulas, sample repair prices or sign-up requirement. Save a separate copy for each vehicle.

Use the free maintenance-log CSV in Excel or Google Sheets
CSV fieldWhat to record
vehicleA consistent private name; keep different cars separate
serviceDateDate the work happened, in YYYY-MM-DD form
odometer / odometerUnitThe reading at service and km or mi; unknown stays blank
workCompleted / partsUsedCompleted work and parts as documented, not future recommendations
shopOrDIYWho performed the work; identify your own work as DIY
receiptFilename / evidenceTypeWhere the evidence is stored; shop invoice, DIY note or reconstructed note
totalMinor / currencyInteger minor units and a three-letter currency code; for CAD, 12345 means CAD 123.45. This is a unit example, not a repair price.
warrantyReference / notesWhere the written terms are kept, and any uncertainty or corrections

Keep unknowns, credits and receipts clear

The CSV is an independent blank log, not a Carstori import format. It does not calculate totals or recommend service intervals. Keep the original receipt files in a nearby folder; a filename in a cell is only a reference, not an embedded attachment.

Use one row for a completed service. Leave an unknown amount empty and explain it in notes; zero means a known zero charge. If you record a later credit on another row, use a negative integer and identify the original entry in notes. Keep different currencies in separate totals.

Set the serviceDate column to a date format you can read consistently, or plain text if your spreadsheet changes the YYYY-MM-DD display. Do not replace a missing historical date or odometer with today's value. Keep uncertain work in notes until you can date it reliably.

Separate a purchase from a completed service

Buying a filter does not prove when it was installed. For DIY work, keep the purchase receipt and a separate service entry describing when you used the part, which vehicle received it and the odometer at that time. If one bulk purchase serves several cars, reference the same receipt from each relevant entry without charging the whole purchase to every car.

A note written from memory should say that it is owner-reported. Preserve the distinction between an original shop invoice, your own service note and a reconstructed entry.

Document DIY work and bulk purchases

Make a quick review part of the routine

Before filing a record, check that the vehicle and date are correct, the photo is readable, and the invoice total agrees with your entry. Look for credits or refunded items. A negative adjustment should reduce recorded spending rather than become another charge.

The FTC recommends keeping repair records and checking the manufacturer's maintenance schedule. Use the schedule for your particular vehicle; a log records what happened, but does not determine what service is due.

Source: FTC: Auto Repair Basics.

Keep an export you can read without the app

Occasionally export your history and open a few receipts from the backup. A file existing is not the same as a usable backup. Keep the original images alongside the log so an abbreviated description can be checked later.

When selling a car, make a separate sharing copy. Remove personal contact and payment details, retain the service evidence you intend to share, and keep your private originals. A tidy history helps explain past work; it is not a promise about the car's current condition.

Prepare a service-history packet before selling

Common questions

Is a spreadsheet enough?

Yes, if you consistently update it and retain the supporting receipts. An app is useful when manual entry, finding receipts or linking spending to components becomes the part you avoid.

Should I throw away the paper after scanning?

Check any warranty, contract or local requirement first. Keep an original when it may be needed, and verify that every page of the digital copy is readable.

Keep reading