RV dealership inventory reporting should help answer three different questions: How long have we held this unit, how long has it actually been ready to sell, and what costs belong to it? Combining those answers produces a more useful review than sorting the lot by age alone.

The framework below is a recommended management-reporting design, not an industry benchmark or a claim about any particular dealership's results. It works for retail-only dealerships as well as businesses that also operate service departments.

Start with one record for each inventory episode

Build the review around a stable unit identifier. A VIN can identify the vehicle, but it may not uniquely identify the dealership's ownership episode. A unit sold previously and later taken back in trade needs a new inventory episode without losing its history.

Keep the original acquisition date, current location, ownership type, new-or-used classification, unit category, and current sales status. Track transfers as movements of the same inventory episode, not as additional units added to the company-wide total.

A dealer management system may already hold much of this information. For example, Lightspeed's RV inventory guidance discusses acquisition methods, repair status, new-versus-used reporting, and aging and floorplan reports. Review the data and reports your current system provides before building a separate process.

Keep inventory age and selling exposure separate

Define inventory age as elapsed calendar days from the agreed acquisition event to the reporting date for an unsold unit. Decide whether that acquisition event is receipt, purchase, or another documented milestone. Do not allow the definition to change between stores.

Then define a separate retail-ready milestone. Your dealership might require inspection completion, approved pricing, photographs, and a live listing before a unit qualifies. The point is not that every dealer needs the same checklist; it is that your team needs one consistent meaning.

Days since the first retail-ready date are not necessarily the same as total days available for sale. A unit might be ready, then pulled from availability for a repair or placed on hold. Measuring actual selling exposure requires a history of those status intervals, not just one date field.

Keep both views. Financial exposure can begin before the sales team has a realistic opportunity to sell the unit.

Compare two aging units before prescribing the same action

Consider this hypothetical example. Unit A has been in inventory for 80 days but became retail-ready 20 days ago. Unit B has been in inventory for 45 days and was ready for 43 of those days.

The older unit is not automatically the stronger candidate for an immediate price reduction. Unit A warrants an investigation into its 60-day preparation period. Unit B warrants a closer look at demand, positioning, inquiries, and price. Either investigation could reveal other explanations.

A single aging column hides that distinction. Two clocks, accompanied by the actual status history, make the discussion more specific.

Use this approach to ask better questions rather than letting the dashboard make pricing decisions without context.

Separate expected unit margin from realized results

For unsold units, a useful management estimate starts with the expected selling price and subtracts acquisition cost and the preparation or other directly assigned costs your dealership chooses to include. Label the result as an estimate and state the exclusions.

For sold units, use the actual selling price and recorded costs. Keep projected preparation work separate from completed work so the same cost is not counted twice. Display unresolved vendor bills or missing cost assignments as exceptions.

Decide how financing charges, sales commissions, transportation, warranties, finance-and-insurance income, and other items are treated. Some may belong in separate measures rather than in the unit margin shown to every user. Review those definitions with the person responsible for your accounts.

For financed inventory, use the applicable recorded charges or a clearly labeled estimate based on actual terms. Do not assign a made-up daily holding cost and present it as an accounting result.

Build a weekly exception view

A practical first version can prioritize four groups:

  • Not retail-ready: Units waiting on a named preparation task, with an owner and next review date.
  • Ready but receiving little interest: Units needing investigation into visibility, fit, listing quality, or price.
  • Cost information incomplete: Units with unresolved preparation costs or unclear ownership treatment.
  • Status inconsistent: Units marked available in one system but sold, held, or transferred in another.

Choose age thresholds using your own unit mix and operating history. A 90-day alert can be a useful internal rule, but it should not be presented as a universal definition of bad RV inventory.

End each exception review with an action, an owner, and a follow-up date. Next week, check what happened to that action rather than simply rereading the aging list.

Preserve the history needed to explain change

A current inventory export tells you what is on the lot now. It may not tell you what was available last month or which preparation stage caused a delay.

Store dated snapshots or event history when the source supports it. Distinguish current inventory position from inventory movement: repeatedly summing daily snapshots would count the same unit many times.

When comparing locations, align the reporting date and ownership rules. Separate consigned units from owned inventory where appropriate, and make transfers visible without treating an internal movement as a retail sale.

Frequently asked questions

Is this useful for a dealership without a service department?

Yes. A retail-only dealership can still track acquisition, outside preparation, listing readiness, inquiries, holds, and sales. Replace internal repair milestones with the preparation process you actually use. There is no need to build a service dashboard for a department that does not exist.

Do we need to replace our dealer management system?

Not necessarily. Begin by reviewing its existing reports and available exports or integrations. A supplemental reporting layer is worth considering when important questions cross systems or require definitions the standard reports do not provide.

Make the inventory meeting more actionable

Ferguson BI helps connect business data and build reporting around operational decisions. Start a conversation about your inventory review with a description of the systems involved and the unit-level question your current reports cannot answer.