Free Excel workbook · Before and after handoff review
What changed between a vehicle checkout and its return?
Put manually recorded departure and return observations next to each other. Spot new reported concerns, missing checks and mileage discrepancies that need a supervisor to investigate.
Free, no account required · Editable Excel file · Formulas and validation · No macros · Fictional examples included
The operational problem
A handoff that is easy to lose track of.
A driver returns a pickup with a new mirror concern. The previous sheet is incomplete, and nobody can easily tell what was noted before departure.
What this workbook adds
A repeatable manual record and a way to spot exceptions.
Use matching vehicle and trip references for both observations. Compare recorded condition before and after the same handoff, then identify items that still need review.
How to use the workbook
A practical four-step routine.
- 01
Reference the same handoff
Use matching vehicle and trip identifiers for the departure and return records.
- 02
Capture departure observations
Log reported condition, odometer and check completion before the vehicle leaves.
- 03
Capture return observations
Record what is observed at return, including new concerns or missing responses.
- 04
Review flagged differences
Investigate newly reported issues and inconsistent mileage. A comparison is not proof of when damage occurred or who caused it.
What to record
Keep the fields consistent.
- Vehicle and trip reference
- Departure condition observations
- Return condition observations
- Missing checks and review flags
What this does not do
Know the limitation.
The workbook compares manually entered observations; it does not diagnose damage, assign blame, replace an inspection policy or manage repair completion.
As with any spreadsheet, staff must enter accurate information and verify exceptions using their own procedures.
Related fleet workflows
Use the right record for the right job.
When manual coordination gets difficult
Connect vehicle availability, checkout, return and records in Crew Keys.
The free workbook handles this specific manual tracking need. Crew Keys covers the digital shared-fleet workflow without requiring GPS hardware; it does not automatically identify physical keys, damage causes or site receipts.