How to document a mileage timeline someone else can follow

Create an evidence file before copying figures

Start with the official MOT history and the service or inspection documents available to you. Keep originals or faithful copies in a folder you control. Use clear filenames that describe the event and date without unnecessarily exposing previous owners' personal information. A short source label in the worksheet should help you locate a document, not reproduce its contents or include private contact details.

For each item, distinguish the date of the observation from the date you received it. If an invoice covers work on a different date, note that distinction. If the document does not establish a date or unit, record the gap. Do not fill missing observations by assuming a typical annual mileage, dividing an interval evenly or copying an estimate from an advertisement.

Use consistent fields without altering the evidence

Keep separate fields for the original reading, its original unit, the event date and the source. Add a converted miles column only when the unit is confirmed. Preserve the number as it appears even when you suspect a transcription mistake. Your proposed explanation belongs in a different note so a reader can tell an observation from an interpretation.

Enter records oldest first in our worksheet. Dates are optional, but the tool assumes row order when they are absent and flags backwards dated entries rather than silently sorting them. It also highlights different readings on the same date. You may need more context to understand the order of those observations; the display order alone is not evidence that distance went backwards.

• Observed: exactly what the source records.
• Calculated: a unit conversion with its factor stated.
• Reported: an explanation someone has supplied.
• Unknown: a date, unit, reading or interval without adequate evidence.

Write questions alongside the disputed entries

When two rows conflict, describe the specific issue. For example, identify that the later entry is lower after confirmed unit conversion, or that two source dates do not match the assumed order. Avoid a general 'failed mileage check' label, which can hide both the cause of a warning and the limits of the underlying information.

Record follow-up requests and any answer received. If the seller mentions instrument replacement, retain the claim and request the workshop paperwork. If an MOT error is suspected, use the official correction route rather than rewriting the worksheet as if the source had already changed. Keep an unresolved-question list so an unanswered request does not disappear when you add more reassuring entries.

Export a summary with its limitations attached

Compare the readings before downloading the TXT summary. The file includes the entered values, normalised miles, flags and a statement that no vehicle database was queried. Recheck the source labels and remove information you do not intend to share. The worksheet holds inputs in page memory, so reloading clears them; the downloaded file persists on your own device until you manage it.

Version your notes when a source record is corrected or new evidence arrives. Keep enough context to explain why the interpretation changed without distributing unnecessary personal data. A tidy, reproducible summary supports a conversation, but it cannot certify genuine mileage or vehicle condition. Include remaining uncertainties prominently rather than presenting the absence of an automated warning as a positive verification.