# Running your lot on a spreadsheet: when it's fine — and the five points where it breaks > An honest take on running a used-car lot from Excel or Google Sheets: the columns that make a spreadsheet genuinely work, and the five breaking points to watch for. - Source: https://www.dealervlo.com/blog/used-car-inventory-spreadsheet - Published: 2026-08-30 - Author: Chris Abouraad - Tags: operations, inventory, dealer software --- There's a version of this article every software company writes, and it's a sales pitch wearing a how-to hat: *spreadsheets bad, buy our thing.* I sell the thing, so let me write the other version — because I ran my lot's side-math on spreadsheets for years, and for a certain size of operation a good sheet is not a compromise. It's the right tool. The useful question isn't "spreadsheet or software?" — it's "*where's the line*, and which side of it am I on?" Here's both halves, honestly. ## When the spreadsheet is genuinely the right call ![Checklist of conditions where a used-car inventory spreadsheet genuinely works: under roughly ten cars, cash deals, one operator, one or two listing channels, and no in-house financing.](/images/post/used-car-inventory-spreadsheet/1) A one-person lot flipping eight cash cars doesn't have a data problem a $200/month suite solves. What it has is a *discipline* problem to avoid: the sheet only works if it's kept current, and the sheet that's three weeks stale is worse than no sheet — it's wrong numbers with confidence. If that list above describes your lot and you'll actually maintain the file, skip the software pitch for now and just build the sheet right. ## Build it right: the columns that matter ![The essential columns for a used-car dealer inventory spreadsheet: stock number, VIN, vehicle, odometer, buy date and source, buy price, recon spent, all-in cost, asking price, title status, listed date, sold date, and sold price.](/images/post/used-car-inventory-spreadsheet/2) Most inventory sheets fail the same way: they're a *list of cars* when they need to be a *ledger of positions*. The difference is the money-and-time columns — buy price on day one (the [intake habit](/blog/vehicle-intake-process-used-car-dealers) that makes every later number possible), recon as it's spent, listed and sold dates. With those, one column of arithmetic gives you real per-unit margin, real days-on-lot, and eventually which auction [actually makes you money](/blog/how-dealers-make-money-at-car-auctions). Without them, your [turn rate](/blog/inventory-turn-rate-used-car-dealers) is a feeling. Sheets versus Excel barely matters; Sheets wins on a small lot because it's on your phone in the auction lane and two people can read it at once. The format was never the constraint. ## The five points where it breaks Here's the honest other half. The sheet doesn't fail gradually — it fails at specific, predictable points, each one the moment a *ledger* gets asked to do a *workflow's* job: ![Five-step sequence showing where a spreadsheet breaks down for a used-car dealership: deal paperwork retyping, photo management, multi-channel listings, a second person, and buy-here-pay-here payment tracking.](/images/post/used-car-inventory-spreadsheet/3) **1. The paperwork point.** The sheet knows the VIN, the buyer's in your texts, and the deal math is in your head — and now the buyer's order, the [Buyers Guide, the odometer statement](/blog/used-car-deal-jacket-checklist), the title application, and maybe a lender packet each want the same data typed again. Forty-five minutes a deal, and every retype is a shot at the typo that bounces at the registry. This is the point that broke *me* — it's the reason DealerVLO exists. **2. The photo point.** Twenty photos per car times twenty cars is four hundred files, and the sheet can't hold one of them. Folder schemes rot; the listing needs the photos where the inventory record is. **3. The channels point.** The moment you're on [more than one channel](/blog/where-to-list-used-cars-online-free) — your [website](/blog/do-car-dealers-need-a-website), Marketplace, anywhere else — every arrival, sale, and price drop becomes multi-platform manual labor. This is the quiet one that eats Saturdays. **4. The second-person point.** The day you hire help or take a partner, you discover how much of "the system" was actually in your head. A shared sheet helps; a system where the keys, title status, photos, and deal history hang off one stock number transfers a lot better. **5. The BHPH point.** If you start [carrying notes](/blog/bhph-underwriting-approval-criteria), you now need a payment ledger per deal, running balances, and payoff math with per-diem interest. Spreadsheets *can* do this, the way a pocketknife can dress a deer — it's the point where everyone who's tried it eventually stops. Hit any two of those and the free spreadsheet has quietly become the most expensive tool on the lot — priced in your evenings. ## Crossing over without losing your history Two practical notes for the day you switch, whichever software you pick: **Your sheet is an asset — bring it.** A well-kept sheet's columns are exactly what imports into a real system, and your buy-price history is irreplaceable. (This is also the argument for building the sheet right *now*, even if you switch later.) **Judge the software by the five points.** Whatever broke the sheet is the job to demo: does the deal paperwork [fill from one record](/blog/automated-dealer-paperwork-by-state)? Do photos live on the unit? Does the website feed itself? The [DMS comparison](/blog/best-dms-independent-used-car-dealers) covers the field with real prices — and per the usual disclosure, DealerVLO's on that list and it's mine. ## Frequently asked questions ### Can you run a dealership on a spreadsheet? Under ~10 cars, cash deals, one person — yes, genuinely, if you keep it current. The line is where workflows (paperwork, photos, channels, staff, BHPH) start, because a sheet is a ledger. ### What columns should the sheet have? Stock #, VIN, vehicle, odometer, buy date/source/price, recon spent, all-in, asking, title status, listed date, sold date, sold price. The money-and-dates columns are the point. ### When does it stop being enough? At five points: deal-paperwork retyping, photo volume, multi-channel listings, a second person, and BHPH note tracking. Any two and you've crossed. ### Sheets or Excel? Equivalent — Sheets wins on phone access at the lane. The format was never the constraint. ### What does software cost by comparison? From $29/month flat (DealerVLO, with paperwork and website included) to several hundred for module-priced suites. The real comparison is against the hours the sheet's retyping costs. ## Bottom line Run the spreadsheet proudly while you're on the right side of the line — but build it like a ledger, keep it current, and watch for the five breaking points. When two of them are part of your normal week, the math has already changed. And when it does: [DealerVLO](/used-car-dealer-software) is the crossing built for exactly this lot — the sheet's ledger, plus the workflows it can't do: VIN-decoded inventory, the deal jacket that [fills every form](/blog/automated-dealer-paperwork-by-state), photos on the record, and your website fed automatically. [$29/month flat](/pricing), no card for the trial — bring your spreadsheet. --- ## FAQ ### Can you run a used-car dealership on a spreadsheet? Under roughly ten cars, cash deals, one person doing everything — yes, genuinely. A well-kept sheet with the right columns tracks inventory and rough margin fine at that size. The honest answer changes when paperwork volume, photos, multiple channels, a second person, or in-house financing enter the picture — those are workflow problems, and a spreadsheet is a ledger, not a workflow. ### What columns should a used-car inventory spreadsheet have? The working minimum: stock number, VIN, year/make/model/trim, odometer, purchase date, purchase source, buy price, recon spent (updated as it happens), all-in cost, asking price, title status, listed date, sold date, and sold price. Buy price and the two dates are the ones dealers skip and regret — without them you can never compute real margin or days-on-lot. ### When does a spreadsheet stop being enough for a dealership? At five predictable points: when deal paperwork means re-typing the same data onto multiple forms; when photos outgrow a folder scheme; when listing the same car on several channels becomes manual copy-work; when a second person needs the same numbers you have; and when BHPH payment tracking enters the picture. Each one is the sheet meeting a job it was never designed for. ### Is Google Sheets or Excel better for car dealership inventory? For this purpose they're equivalent — Google Sheets has the edge for a small lot because it's on your phone at the auction and two people can look at it at once. The format isn't the constraint; the constraint is that any spreadsheet only knows what you type into it, and everything downstream of the sheet — forms, photos, listings — is still manual. ### What does dealer software cost compared to a spreadsheet? A spreadsheet is free on the sticker and costs you in retyping — every deal document, every listing, every channel, by hand. Published dealer software pricing for independents runs from DealerVLO's $29/month flat (DMS, paperwork, and website in one) up through $99 to several hundred a month for module-priced suites. The honest comparison is $29 versus the hours the sheet's downstream retyping consumes.