Auto Lot Finder Back to Auto Lot Finder

Guide

Car inventory days on lot: tracking aging on a yard

Days on lot is the number of days since a vehicle was taken into inventory. On a dealer lot it is how long a unit has gone unsold; on a salvage yard it is how long a car has held a space while being parted out. Either way, the oldest cars are the ones costing the most, and a list sorted oldest first is the simplest management tool a yard has.

How to count it

Days on lot = today's date minus the intake date. In a spreadsheet with the intake date in column D, =TODAY()-D2 gives it for row 2. Count from the day the car arrived on the property, not from the day it was listed for sale, or the oldest units will look younger than they are.

Aging buckets

BucketWhat to do
0 to 30 daysNormal. Make sure intake work (photos, fluids, listing) is done.
31 to 60 daysReview price or what is being pulled. Ask why it has not moved.
61 to 90 daysDecide: reprice, wholesale, move to parts, or schedule for crush.
Over 90 daysThe space is worth more than the car. Act this week.

The right thresholds depend on the business: a high-volume dealer lot turns faster than a yard parting out late-model cars. Pick buckets once and review the oldest bucket every week.

Keep sold and crushed cars out of the count

Aging is about what is still on the property. Mark a car sold or scrapped when it leaves, keep the record searchable, and count only the cars still on the lot.

Where Auto Lot Finder fits

Auto Lot Finder shows days on lot on every vehicle and sorts the vehicle list oldest first, so the cars that have sat longest are at the top. Sold and scrapped cars leave the map and the count but stay searchable, and the CSV export carries a days on lot column for the monthly report.

See the oldest cars first

Try the sample yard in your browser: open Vehicles and sort oldest first.

More guides: Work & create · all Adelyons guides