Tracking Inventory Cost Basis in One Place

The GM asks a simple question in the hallway: "What do we have in that silver truck?" The used-car manager quotes hammer plus a round recon guess. The office quotes the DMS, which never got the tire invoice. The closer quotes a number he heard on delivery day, before pack. Three answers, one vehicle, and a Marketplace price that was set from the most optimistic of the three. If the truck ages, nobody can say whether the next cut is still above cost, because cost was never a single object.

Tracking inventory cost basis in one place is bookkeeping with a sales purpose. It is how you price, how you decide wholesale versus another week of retail, and how you stop paying spiffs on gross that did not exist. Independent lots often live in a spreadsheet plus a folder of invoices. Franchise stores often live in a DMS that is only as good as the last person who posted a sublet. The tool matters less than the rule: one official number, updated on a known cadence, visible to the people who are allowed to see cost.

This is operational guidance, not tax or GAAP instruction. How you capitalize recon, pack, and floor-plan interest is a question for your accountant. The floor still needs a working cost it can trust.

Why Tracking Inventory Cost Basis in One Place Changes Decisions

Without a single basis, every meeting becomes a negotiation about whose printout is right. That negotiation is slower than a price cut and less honest.

Pricing needs a floor

Retail is capped by the market. Your floor is basis plus the margin you refuse to go under, except as a written exception. If basis is fuzzy, the floor is fuzzy, and reps will sell the fog.

Aged reviews need a real minus

A weekly inventory exposure meeting cannot decide whether to cut, relist, or wholesale if "we have about X in it" is a vibe. Age plus unknown cost is how lots take a late wholesale that would have been a small wholesale on day 20.

Pay plans and honesty

If gross is calculated from a cost nobody posted, you will either short the rep or short the store. Both create side systems (shadow spreadsheets, "the real cost"). Side systems are how you lose the single place.

Buying needs feedback

If last month's auction cars always pick up unposted recon, your bid ceilings are wrong. The true landed cost of an auction car is the unit-level math. One-place tracking is how that math survives contact with invoices.

What Belongs in Cost Basis (and What Does Not)

Write a one-page policy. If it is not written, every department will invent a version.

Include, in the working number the used-car manager uses

• Purchase price (hammer, street, trade allowance you actually assigned, dealer-to-dealer)
• Auction buyer fees and similar purchase fees
• Transport to your lot
• Recon and sublets required to make the unit your retail piece
• Pack, if the store uses pack, applied by the same rule every time

Memo fields that should exist even if they are not in "DMS cost"

• Estimated floor-plan interest at expected turn (or actual if you have it)
• Aftersale charges you are fighting
• Recon still in process (committed but not invoiced)

The working cost for a price decision should include committed recon, not only posted recon. Otherwise you will advertise too cheap and "discover" cost when the tire bill lands.

Exclude from vehicle basis, or park separately

• General overhead (rent, utilities) unless your accountant's method puts a standard pack in and everyone knows that is what pack is
• Marketing
• The salesperson's opinion of what the customer will pay
• A "manager special" reduction that was never documented as an exception to basis (that is a price decision, not a cost change)

Trade-ins

Basis on a trade is the appraisal you took it in at, plus recon, plus fees, not the number the customer wanted on the worksheet. If you over-allowed to make a front-end, that over-allowance is part of the story of that deal. It still becomes the truck's cost. Hiding it by understating basis on the trade is how the used lot subsidizes new or front-end in the dark.

A Workflow for Tracking Inventory Cost Basis From Buy to Sold

Pick a system of record. DMS if you have one that people will actually complete. A tightly controlled spreadsheet if you do not. Not both competing.

At purchase (same day)

1. VIN, stock number, source (auction, trade, street, dealer).
2. Purchase amount and known fees.
3. Photos of the odometer and the sale document or bill of sale.
4. Recon estimate with a date to convert estimate to actuals.

If the unit is still in transit, it still exists. "We will enter it when it gets here" is how hammer-only folklore starts.

At recon complete

• Replace estimates with invoices.
• If recon blew the estimate, the used-car manager re-underwrites retail versus wholesale before photos go to posting.
• Update the working cost the same day, not in a month-end pile.

At list

The advertised price is a separate field. It must be set with the working cost in view. Do not let a posting tool or a website export invent a price from an old DMS column. Cleaning a DMS inventory export before you post is the data-hygiene twin of this article: bad cost and bad price travel together.

At sold

• Final cost should include late invoices you know about.
• If a bill arrives after funding, have a rule: adjust cost for reporting, and whether pay is restated. Write the rule. Do not argue it per deal.
• Archive the vehicle in operational systems so it cannot be discounted again as if it were live.

Who may edit basis

• Office or admin: fees, invoices, pack per policy.
• Used-car manager: recon estimates and the retail/wholesale flag.
• Floor reps: they should not be able to quietly change cost to make a deal look fat.

If everyone can edit, you do not have one place. You have a wiki.

Reviews, Exceptions, and Pack Discipline

Weekly: exceptions and incompletes

A short list:

• Units with purchase entered and recon still estimated past your SLA (for example, past photo day)
• Units listed with no working cost (should be impossible)
• Pack missing or double-applied
• Negative or implausible costs (typos, extra zeros)

Monthly: sample and reconcile

Pull a sample of sold units. Match basis to invoices and to the deal jacket. You are looking for systematic misses (tires always late, auction fees never entered, pack applied twice on trades). Fix the process, not just the row.

Pack discipline

Pack is fine when it is boring:

• Same dollar or same formula
• Applied at intake, not at the desk as a punishment
• Visible in the working cost or explicitly described as "cost plus pack"

Pack that appears only when a deal is fat, and disappears when a deal is thin, is not pack. It is a mood.

When systems disagree

If the spreadsheet and the DMS diverge, declare a winner the same day. Migrating "later" means you will run two books through the next aged meeting. If you are moving systems, freeze edits to the losing system except for a dated cutover.

Privacy and politics

Not every associate needs to see cost. Managers and the people who price do. A sales associate posting from a queue needs the asking price and the facts of the car, not necessarily the pack. Role-based access is part of "one place," not a contradiction.

How PostToMarket Automates This

PostToMarket is not a general ledger. Tracking inventory cost basis in one place still lives in your office system. What PostToMarket does is keep the listing layer from drifting away from that record: the same VIN, the same status, the same sold date, and copy that does not fight the price you set from basis.

One operational inventory, even if accounting lives next door

• Unlimited vehicles in inventory so the posting list can match the cost list unit for unit.
• Bulk CSV and Excel import with import history and row-level errors, which is how a clean export of stock numbers, VINs, and prices should enter the tool after the office has posted cost.
• Statuses of draft, posting, posted, sold, and failed so a unit with incomplete cost can stay draft until someone is willing to stand behind the window price.

Price and description that do not freelance

• AI-generated titles and descriptions from specs, edited before posting, so nobody types a "was $X now $Y" story that does not match the official price field.
• Photo picker so the unit can support the number that basis requires.

Sold and queue hygiene so cost is not revisited on a ghost

• Mark as sold and archive from inventory or the queue the day it funds.
• Per-rep queues, manager assignment, team queue view so the people who post are working the live, costed units.
• Leads inbox so a conversation about "what's your best price" can be handled by someone who knows the floor, not by an associate guessing.

No tool guarantees a sale above cost. PostToMarket reduces the operational failure where the only number the internet knows is a hope.

One Number, Then a Listing That Respects It

Tracking inventory cost basis in one place means a written definition of cost, a same-day intake, recon converted from estimate to invoice, a short list of who can edit, and weekly hunts for incomplete rows. When the GM asks what you have in the truck, there should be one answer, and the Marketplace price should be set with that answer in the room.

If your cost file is finally honest and your listings are still a weekend project, the hold-time tax continues. Starter is $59 per month for a solo seller or independent lot, one login. Dealership is $299 per month for up to 13 logins so office, managers, and floor can keep inventory status in sync with the book. Start a 10-day free trial through secure Stripe checkout. Cancel anytime.

Start your 10-day free trial and keep every unit's public listing tied to the same inventory you costed, instead of a third version of the truth on Facebook.