Unit Cost Rollup for Used-Car Dealers: The Per-VIN Method

For a used-car dealer, a unit cost rollup means adding every cost tied to one vehicle (purchase price, auction fee, transport, reconditioning, and financing cost) into a single running total attached to its VIN. That total is what you compare against the sale price to find true gross. The manufacturing pages that rank for this term describe the same idea with bills of materials. On a car lot the “components” are invoices, and the rollup is only as good as your habit of assigning them to the right unit.

Loturn

loturn.com

See Each Vehicle’s True Cost

Loturn tracks every vehicle cost, from purchase price to transport and recon, so independent dealers can see profit before a sale.

Explore Loturn

TL;DR

A unit cost rollup is the sum of all acquisition and recon costs assigned to one VIN, updated as costs arrive, not after the sale.
Capitalize true acquisition and required recon costs into the vehicle. Expense things that do not make it sale-ready, according to your written policy and your CPA’s advice.
Use the rollup to watch gross and aging weekly. Units past 45 days deserve a line-by-line review and a logged action.
Demo vehicles follow different rules. Under one professional guide they are depreciated fixed assets, and when sold their remaining book value moves to used inventory.
Loturn tracks every cost per vehicle, so the rollup is live instead of rebuilt from spreadsheets.

What a unit cost rollup means on a car lot
What goes into the rollup
A worked example
Handle recon as work in process
Use the rollup to protect gross and speed up turns
Demo vehicle accounting
Keep the numbers true: records and routines
See every unit’s cost in one place
FAQ
Sources

What a unit cost rollup means on a car lot

In manufacturing, a cost rollup aggregates the materials, labor and purchased inputs of an item’s components into one cost. One Business Central explainer defines it as calculating an item’s total cost by combining the relevant costs of its components, and the ranking pages all work this way. A car has no bill of materials, but the logic transfers: a vehicle’s cost is built up from everything you spent to make it ready to sell.

AccountingTools puts a used car’s cost at its purchase price, plus upgrades, plus the auction fee, plus travel incurred to acquire it. Add what you spend on recon and you have the rollup. The same source notes that a unit sitting in inventory for a long time may need to be written down to the lower of cost or appraised wholesale value, which is why the rollup has to be current and not just a number on the day of purchase.

The rollup answers three questions a dealer asks daily:

What is my real cost in this unit right now?
What gross will I make at the asking price?
How low can I go on a deal and still make money?

If any of those answers comes from memory, a text thread or a shoebox of receipts, the rollup is not really happening.

What goes into the rollup

The IRS audit guide for dealerships says the base cost of the car is increased by reconditioning costs the dealer incurs preparing it for sale. BHPH United’s accounting education page advises capitalizing true acquisition costs including auction buy fees, transportation to the lot, and required recon, and notes that cosmetic add-ons that do not materially improve condition can be expensed to reconditioning expense depending on policy.

Here is how that translates into a working rule set. Your CPA has the final say on your policy.

Cost	Usually rolled into the unit?	Notes
Purchase price (net of trade allowance logic)	Yes	The base of the rollup
Auction or buy fee	Yes	Part of acquiring the car
Transport to your lot	Yes	Assign to the VIN, not to general freight
Required mechanical recon	Yes	Parts and sublet invoices
Detail and safety items needed to sell	Yes	Per your written recon policy
Cosmetic extras that do not improve condition	Policy decision	May be expensed as reconditioning expense
Floorplan interest	Track per VIN	Gives you true carrying cost by unit
Advertising, rent, salaries	No	Operating expenses, not unit cost

Pick a policy once, write it down and apply it to every unit. Inconsistent treatment is what makes gross numbers impossible to compare from one month to the next. Our guide on per-VIN inventory costing goes through the tax-form side of this.

Trade-ins and the double-deduction trap

The IRS specialization guide for independent used car dealers warns that some dealers record sales net of the trade-in, then include the traded vehicle’s cost again when it is sold, producing a double deduction. A clean rollup avoids this: record the sale at the gross price, record the trade-in as a new inventory unit at its allowance value, and start a fresh rollup on that VIN.

A worked example

The numbers below are illustrative, not a benchmark. Say you buy a sedan at auction.

Line	Amount
Purchase price	$12,400
Auction buy fee	$350
Transport to lot	$275
Recon: parts	$700
Recon: labor	$450
Floorplan interest to date	$120
Rolled-up unit cost	$14,295

You list it at $16,995. Gross at that price is $2,700. If you only tracked the purchase price, you would think you had $4,595 of room. That gap of $1,900 is the difference between a good deal and a break-even one, and it is the reason to have the rollup before the sale.

Now suppose the car sits another 30 days and floorplan interest adds $150, plus a $200 repair after a customer’s inspection. The unit cost moves to $14,645, and a $15,500 offer that looked fine yesterday now yields $855. A live rollup shows that before you say yes.

Handle recon as work in process

Recon is where rollups usually break. Parts get bought on a card, labor is done by a sublet shop two weeks later, and nobody ties either to a VIN. BHPH United recommends using work in process for recon until it is complete and then moving the costs into the vehicle’s cost.

A simple process:

Open a recon order per VIN with a budget before work starts.
Assign every parts invoice, sublet bill and labor entry to that order.
Review the order when it reaches roughly 80% of budget, not after it blows through.
Close the order when the car is front-line ready and roll the total into unit cost.

We cover this in detail in per-VIN recon WIP accounting.

Our view on rollups

Most independent dealers we talk to do not have a cost problem, they have a visibility problem. The money is spent, but it lands in a general expense bucket, and the unit looks more profitable than it is until the month-end books say otherwise.

We built Loturn around the idea that every cost belongs to a vehicle from the moment it is incurred. Purchase price, transport and recon are assigned to the unit as they happen, so you can see your profit before a sale and not after it. Generic accounting software was not designed for that, which is why dealers end up with spreadsheets next to it.

The rollup should not be a monthly project. It should be a by-product of doing business: enter the invoice, pick the VIN, and the number updates.

Eric Dosset

Use the rollup to protect gross and speed up turns

A rollup only pays off if you act on it. NADA’s inventory guide recommends tracking each used vehicle’s make, model, age, classification and value and comparing inventory against sales. Its quick-analysis form breaks both down by age group, market segment, sales price, vehicle source and other categories, and calculates an inventory-to-sales ratio.

The same guide gives two controls worth building into your routine. Months’ supply is inventory dollars divided by average monthly cost of sales, and it converts to days using 30 days. NADA’s guide for used inventory is 12 annual turns, or about 30 days. Because the rollup gives you accurate inventory dollars per unit, those ratios stop being rough guesses.

A weekly aging rhythm

Kruse Control’s playbook suggests reviewing an aged report every Monday, examining units past 45 days line by line and logging the action: a price move, a marketing change or a wholesale decision. Its larger point is that an aging policy works only with a recurring rhythm and documented action.

The rollup makes each of those reviews concrete. When you open a 52-day unit, you see its full cost, its accumulated floorplan interest and the gross left at the current price. If you want to understand how to read the report itself, how dealers read aging reports is a good companion. For a wholesale exit, our wholesale deal accounting guide shows how to book it so the loss or small gain is attributed to the right VIN.

Floorplan and forecasting

Dealership accounting guidance calls for VIN-level landed-cost and floorplan-interest tracking, because interest is a cost that grows daily against a specific car. See per-VIN floorplan fee accounting for how to post it.

For forecasting, accurate unit costs feed two things: expected gross on current inventory and cash tied up by age bucket. Pair them with a 13-week cash flow forecast and you can see which units will release cash soon and which will not.

When a unit’s market value falls below its rolled-up cost, the rollup also flags a write-down. Our inventory write-down guide shows how to document it.

Demo vehicle accounting

Dealers searching for demo vehicle accounting are really asking where the rollup goes when a car leaves inventory to be driven by staff and customers.

AccountingTools states that demonstrators come out of regular inventory and are recognized as fixed assets that must be depreciated. When they are sold as used cars, the remaining book value after depreciation is transferred to used car inventory before the sale. Servicing demonstrators and company cars goes to a separate dealership vehicle expense.

In practice, the rollup continues across the vehicle’s life:

Start: the unit’s cost at transfer becomes the asset’s starting value.
During demo use: record depreciation and route service costs to the vehicle expense account, not to the unit’s inventory cost.
At sale: move the remaining book value back to used inventory, add any recon you do to prepare it, and calculate gross from that total.

Franchised dealers will also meet manufacturer accounting manuals. The GM Dealer Standard Accounting Manual describes the inventory value of demonstrators as built from the factory invoice (less holdback and non-related items), installed accessories at internal selling price plus labor and material, and destination, delivery and handling charges. Its companion account says new car inventory value includes the cost of new units transferred from demonstration inventory. That is a manufacturer-specific framework, so follow your own franchise’s manual.

Tax treatment of demos

Financial reporting and tax treatment can differ. IRS Revenue Procedure 2001-56 offers simplified methods for employer-provided demonstration automobiles. It defines a demo as a vehicle currently in the dealership’s inventory and available for test drives during normal business hours, and limits the exclusion to use by full-time salespeople. Whether a particular car qualifies, and how to report personal use, is a question for your CPA before you set your policy.

Keep the numbers true: records and routines

An accurate rollup depends on source records. The IRS guidance for independent used car dealers identifies the car or deal jacket as the key sale record that may track vehicle and reconditioning costs, and lists the VIN, stock number, sales price, tax, disclosures, warranty or insurance information and loan payoff where applicable.

For the monthly close, a CPA firm’s dealership checklist recommends that you reconcile the vehicle inventory subledger to physical counts, check that used-vehicle valuations make sense, record invoices and floorplan payoffs, compare departmental gross with prior periods and budget, investigate exceptions, and keep signed checklists and support.

A practical routine for a small lot:

Daily: assign every invoice to a VIN the day it arrives.
Weekly: review aged units and logged actions.
Monthly: reconcile rolled-up unit costs to the inventory balance and run a physical count. Our physical inventory count guide has the steps.
At each sale: follow a deal posting checklist so the final cost, fees and gross land correctly.

On the tax side, the IRS specialization guide notes that used car dealers normally carry inventory as a material income-producing item, which must be accounted for under an accrual method, and that many dealers nationwide were found using the cash or installment method improperly. Per-VIN costing supports that accrual discipline.

See every unit’s cost in one place

Loturn is a financial management platform built for independent used-vehicle dealers. It tracks every cost per vehicle, from purchase price to transport and recon, and includes native double-entry accounting with an automotive chart of accounts, inventory management, floorplan interest tracking and AI invoice management. We offer free data import and onboarding support.

Plans are published at loturn.com/pricing: Flipper at $99 per month, Dealer at $349 per month and Multi-Lot at $699 per month. Pick the one that fits your lot size and see your first live unit cost rollup on your own inventory.

FAQ

What is a unit cost rollup in car dealing?

It is the running total of every cost assigned to one vehicle: purchase price, fees, transport, recon and financing cost. You compare it with the sale price to see gross for that specific VIN.

Should floorplan interest be part of unit cost?

Track it per VIN either way, because it shows what each car costs you to hold. Whether you capitalize it or expense it is a policy decision to make with your CPA and then apply consistently.

Which recon costs go into the vehicle and which are expensed?

Costs required to make the car sale-ready are generally added to the vehicle’s cost. Cosmetic additions that do not materially improve condition can be expensed, depending on your written policy, as BHPH United describes.

How are demo vehicles different from regular inventory?

Under AccountingTools’ description, demos are treated as fixed assets and depreciated, then moved back to used inventory at their remaining book value when sold. Service costs on them go to a separate vehicle expense.

How often should I review unit costs?

Assign costs daily and review aged units weekly. A monthly reconciliation of unit costs to the inventory balance and a physical count catches what slips through.