Give every asset a stable identity
Begin with the internal unit number your team uses, then add the VIN or serial number from the available records. Reconcile mismatches before distributing a final list. Keep the same identifier on photographs, inspection notes and supporting documents.
Core columns
Include unit ID, VIN or serial, year, make, model and asset type. Add body or attachment details where they distinguish one unit from another.
Ownership and records
Identify the owner shown on the documents and whether records are available, pending or missing. Flag liens or other release conditions for follow-up.
Make condition information traceable
Separate what a record shows from what someone remembers. For mileage, hours and inspections, include the observation date and source. Avoid broad descriptions such as excellent fleet when individual units have different histories or unresolved issues.
Operating condition
Record known faults, warning indicators, damage and whether operation has been checked. Describe non-running or incomplete units directly instead of leaving the field blank.
Supporting material
Link the available service records, inspection reports and photographs. Mark information awaiting verification so a preliminary list is not mistaken for an inspected specification.
Add location and release information
Two otherwise similar assets can require very different collection plans. Record where each unit is physically located and when it can leave. Keep sensitive site access instructions in a separate document shared with the people who need them.
Collection fields
Include city, state, site contact, release window and known loading restrictions. Flag assets that require special handling so transport can be scoped before an agreement.
What transfers
Identify included attachments, batteries, keys and accessories. Note equipment or company property being removed before pickup, especially when photographs show those items installed.
Keep one controlled version
Date the file and identify its owner. When a unit is withdrawn, reserved or sold, update its status rather than deleting its history without explanation. Share a fresh export when the group or condition changes materially.
Use consistent labels
Choose a small set of statuses and use them consistently. Keep unknown separate from none, and distinguish a tentative release date from a confirmed one.
Send a clean package
Provide the spreadsheet and organized photo folders together. Remove unrelated customer or employee information before sharing documents outside the organization.
Start with a simple unit schedule.
Download the blank CSV, open it in Excel or Google Sheets, and add one row per asset. Send the completed list by email.
Download the asset-list template
