Car flipping math: the all-in number your memory keeps rounding down
Every flipper can quote the buy price and the sale price of their last car. Almost nobody can quote the middle — the second parts run, the tow from the auction yard, the title fee, the listing bump, the set of used tires that "didn't really count." The middle is where flip profit actually lives, and memory systematically shrinks it. The fix is one discipline: a receipt-level log where every recon dollar lands against the car that caused it, so ALL-IN is a fact instead of a feeling.
Before we talk money: the legal reality
Flipping titled vehicles is regulated, and the rules aren't fine print. Most states cap the number of vehicles you may sell in a year without a dealer license — commonly somewhere between two and eight, varying widely by state. And title jumping — selling a car without ever titling it in your name — is illegal everywhere. None of what follows is legal or tax advice; your state's DMV rules and your tax professional govern what you may do. Good records don't change the rules. They do make staying inside them — and reporting the income — enormously easier.
All-in = buy price + every receipt, tagged to the car
The working structure is two tables. A flips register: one row per car — bought date, buy price, sold date, sold price. And a costs log: one row per receipt, tagged to its flip — parts and mechanical, paint and body, detailing supplies, transport, title and registration, listing costs. The register then computes what the shoebox of receipts never volunteers: RECON per car, ALL-IN, and when it sells, the real NET. Here's what the honesty looks like on a real-shaped book:
| Flip | Buy | Recon | All-in | Sold | Net | Days |
|---|---|---|---|---|---|---|
| F-150 XLT — auction | $9,800 | $1,690 | $11,490 | $13,400 | +$1,910 | 56 |
| Civic LX — auction | $2,900 | $460 | $3,360 | $4,700 | +$1,340 | 28 |
| Passat TDI — auction | $3,600 | $1,985 | $5,585 | $4,500 | −$1,085 | 51 |
The third row is the important one. The Passat needed a transmission, and the flip lost a thousand dollars — a fact the seller's memory would have quietly reclassified as "about broke even" within a month. Keeping the losers visible, in red, is the entire discipline: the auction find that needs a major component is the most expensive lesson in this business, and it only teaches you once if it's written down.
Days held: the sitter tax
An unsold car costs money silently — capital tied up, insurance, the driveway spot, and price decay on the listing. Track days held from purchase, live, and set yourself a sitter threshold (45 days is common). A car past the line isn't a failure; it's a decision that's overdue — reprice, relist with better photos, or wholesale it out and free the capital. The flippers who compound are the ones whose money keeps moving.
A flips register with live all-in, a receipt log per car, and the losers kept visible
The Car Flipping Tracker is this ledger as a workbook: 30 flip slots where RECON fills live from a 200-row receipt log, NET and margin compute at sale (red on a loss), DAYS HELD runs until the car sells (amber past your sitter dial), and the dashboard carries profit per day held, CASH IN THE DRIVEWAY, the home run, and the lesson. Pure formulas, no macros, Excel & Google Sheets.
Start with the car in the driveway right now
Enter its buy price, dig out the receipts you still have, and log forward from today — every parts run, the moment it happens. When it sells you'll know, for the first time, exactly what a flip paid you per day of your life it consumed. To restate the boundary: this note describes record keeping, not legal or tax advice. Dealer-license thresholds, title rules, and sales-tax handling vary by state; your DMV and your tax professional have the real answers.