Car Flipping Profit Spreadsheet: Free 2026 Template & Math

You think you made two grand on that last flip. You probably cleared closer to nine hundred.

That gap? That's every cost you didn't write down. The $180 in gas driving to three inspections. The $90 you paid for a title you had to expedite. The three weeks it sat in your driveway burning insurance. Recon that ran $300 over your guess because the "good tires" were dry-rotted.

A car flipping profit spreadsheet isn't bookkeeping busywork. It's the thing that tells you which cars actually make money and which ones just feel busy. Let me show you how to build one and run the math.

What You'll Learn

• The one number that separates real profit from "felt like profit" (most flippers never track it)
• Every cost line your spreadsheet needs — including the four beginners always forget
• A worked flip from buy to net, with the surprise repair that eats your spread
• Why your true profit-per-flip is lower than your bank deposit suggests — and what the IRS thinks about that

The Straight Answer

Your car flipping profit spreadsheet needs exactly five cost buckets and one profit line. That's it. Don't overbuild it.

Here are the buckets:

1. Buy price — what you actually paid the seller
2. Recon — parts, labor, detail, anything to make it sellable
3. Tax, title & fees — what the DMV and paperwork cost you
4. Holding costs — insurance, plates, storage, interest if you borrowed
5. Sourcing/selling costs — gas, listing fees, transport, your time

Then: Sale price minus all five buckets equals net profit.

The reason most flippers overstate their earnings is they only subtract buy price from sale price. Buy at $6,200, sell at $8,900, feel like you made $2,700. But you didn't. You made whatever's left after buckets 2 through 5 — and those add up fast.

Track all five or you're guessing. And guessing is how you end up doing this for a year and wondering where the money went.

The Money Math (Worked Example)

Let's run a real one. Hypothetical, but this is exactly how a clean flip pencils out.

Say you find a 2014 Honda Accord EX, 128k miles, listed at $7,900 on Facebook Marketplace. You pull sold comps — eBay Motors completed listings, plus retail asks on Cars.com and Autotrader knocked down to reality — and clean examples are moving retail around $9,100. Seller "needs it gone this week." You walk it, it's solid, you negotiate to $6,200.

Here's the full picture:

Line item	Amount
Buy price	$6,200
Recon (tires, brakes, detail)	$700
Tax, title & fees	$450
Holding costs (3 weeks)	$150
Sourcing/selling (gas, listing)	$120
All-in cost	$7,620
Sale price	$8,900
Net profit	$1,280

So your gross spread looked like $2,700. Your actual net? $1,280. Still a good flip. But that $1,420 difference is the stuff that lives in your spreadsheet and nowhere else.

Now watch what one surprise does.

You get it home, and on the test drive the transmission shudders under load. Heads up — that Accord's got a CVT, and the classic complaint is torque-converter judder, which usually doesn't throw a clean code. You get it up on a lift and a shop confirms it. Now you're looking at a real bill — shop quotes on a CVT torque converter job commonly land north of $1,500 (check RepairPal or grab two local quotes for your market before you assume anything). Or you eat it on price and sell as-is disclosed. Either way, that $1,280 net just got wiped out — you're at break-even or upside down if the buyer walks and you re-list two weeks later.

That's the business. The spreadsheet doesn't stop the shudder. But it tells you the truth about what you made, so you don't repeat a break-even flip thinking it was a winner.

Want to run your own deal before you message a seller? free flip profit calculator does this math in about ten seconds.

The Process: Build Your Spreadsheet This Week

You can do this in Google Sheets in 20 minutes. No fancy software.

Step 1: Set up one row per car

Each flip gets a row. Columns across the top: Vehicle, VIN, Buy date, Buy price, Recon, Tax/Title/Fees, Holding, Sourcing/Selling, All-in, Sale date, Sale price, Net, Days held.

That last one — days held — is quietly the most important column you'll build. More on that in a sec.

Step 2: Log costs as they happen, not at the end

The single biggest bookkeeping mistake in flipping cars is reconstructing costs from memory when the car sells. You forget the $40 gas run. You forget the second detail. Log it the day you spend it — a receipt photo and a number in the sheet.

Keep every receipt. Recon receipts don't just help your books, they move retail buyers. A buyer who sees "new brakes, new tires, receipts in the glovebox" pays more than one who takes your word for it.

Step 3: Add a formula for all-in and net

Simple math. All-in = sum of buy + recon + tax/title/fees + holding + sourcing. Net = sale price − all-in. Let the sheet do it so you can't fudge it.

Step 4: Track your true profit-per-flip AND per-day

Here's where days held earns its keep. A $1,280 flip that took 12 days is a different animal than a $1,280 flip that sat 45 days. Divide net by days held and you get profit per day — the number that tells you whether your capital is working or napping.

A car sitting in your driveway isn't just idle. It's insurance, it's a plate, it's cash you can't put into the next deal. This is the metric that separated my good months from my slow ones.

Step 5: Pull valuation from real sold comps

Your sale-price estimate is only as good as your comps. Retail book values from Kelley Blue Book and J.D. Power Values (the old NADAguides) run optimistic — they're a starting point, not gospel. Sold comps beat asking comps every single time. If you're a licensed dealer or you've got auction access, cross-check against the Manheim Market Report. If not, stick to sold retail comps — eBay Motors completed listings, Cars.com/Autotrader sold data where you can get it — and use asking prices as a ceiling, not a target. Run a free VIN decoder to confirm trim, options, and history before you trust any number.

For more on pricing to actually sell, dig into the valuing and pricing cars guides.

Where It Goes Wrong

A spreadsheet only works if it's honest. Here's what quietly wrecks the numbers.

You forget the invisible costs. Gas, your hours, the DMV line you stood in twice because the lien release was missing a signature. Individually they're small. Across 15 flips a year they eat a whole car's worth of profit.

You value your time at zero. If a flip nets $600 but ate 20 hours of driving, listing, texting tire-kickers, and DMV runs, that's $30 an hour before you count the risk. Not nothing — but know the number. Put a "hours" column in your sheet and be honest.

You underestimate recon every time. Rookie move, and I did it for a year. Here's a screening rule, not a hard law: if you're already projecting recon north of ~15–20% of buy price on a normal retail flip, be extra cautious or price it like a wholesale car. That math flips on cheap beaters, German luxury, and rust-state trucks — sub-$3k cars and specialty stuff blow past 15% just on tires and brakes, so use your head. And pad your estimate either way — the "good tires" are always worse than they look under sunlight.

You ignore the title until closing. A "clean title" that turns out to be a washed salvage kills your resale value and can stall the transfer for weeks. Run an NMVTIS-based report through an approved provider before money changes hands — but know the coverage can lag, and Carfax/AutoCheck history reports can miss or delay brand records too. These checks reduce your risk; they're not bulletproof. When the deal smells funny — a story plus a rush sale plus missing paperwork — verify title status directly with the state DMV where your state allows it. The seller who "just needs it gone today" is either your best deal or your worst title problem — the paperwork tells you which.

You forget flipping cars is taxable income. This one costs people real money. If you're doing this with continuity and a profit motive, the IRS typically treats it as a business — that's Schedule C ordinary income on your net profit, and self-employment tax often applies on top. Treatment varies by facts and how you're set up as an entity, so confirm with a tax pro. Your spreadsheet is your tax record. Track it clean all year and you're not scrambling in April. And know your state's flip limit before you cross it — most states cap how many cars you can sell per year without a dealer license, and the number varies wildly. Check your state DMV's current rule; getting it wrong gets you fined. The dealer license rules breakdowns walk through the thresholds state by state.

Fees vary by state — a lot. Title transfer fees, registration, and sales tax due at titling can run anywhere from around $150 to $800-plus all-in depending on where you title the car. Don't copy another flipper's number from a different state. Verify with your own DMV every time.

Track It Automatically

A spreadsheet tells you what a flip made after it's done. The harder part is finding the underpriced car in the first place — before 14 other people message "is this available?"

That's what I built Car Flip Finder for. It watches Facebook Marketplace around the clock and scores every listing against live market value, so you see the underpriced cars first and know the estimated spread before you ever drive out to look. Feed the winners into your profit spreadsheet and let the math do the rest. Start with a free 14-day trial of full Dealer access — no card to start.

FAQ

What should a car flipping profit spreadsheet track?

Five cost buckets and one profit line: buy price, recon, tax/title/fees, holding costs, and sourcing/selling costs. Then sale price minus all five equals net profit. Add columns for days held and hours worked so you can calculate true profit-per-day, not just profit-per-flip. That's the number that tells you if your money's actually working.

How do I calculate profit per car flip?

Sale price minus your all-in cost. All-in is buy price plus recon plus tax, title and fees plus holding costs plus sourcing and selling costs. The mistake is only subtracting buy price — that overstates your profit by hundreds. Run it through a free flip profit calculator if you want the math done for you.

Do I have to pay taxes on car flipping profit?

Yes. If you're flipping regularly for profit, the IRS generally treats it as a business, so your net profit is Schedule C ordinary income and may be subject to self-employment tax. Occasional personal sales are treated differently — a gain can still be taxable (rare), but you can't deduct a loss on a personal-use car. Either way, if you're flipping for profit repeatedly, it's business income. Your profit spreadsheet doubles as your tax record — keep it clean all year, and talk to a tax pro about your specific situation.

How much does title and registration cost when flipping a car?

It varies by state, and the spread is wide. Title transfer, registration, and sales tax due at titling can run roughly $150 to $800 or more depending on where you title the car and the sale price. Never assume another state's numbers apply to yours — verify current fees directly with your state DMV.

What's a good profit margin on a flipped car?

Depends on your buy price and how fast it sells, but many flippers target a spread that leaves $1,000 to $2,500 net after all costs on a typical $6,000–$10,000 car. The real metric is profit per day held — a smaller net that turns over in two weeks often beats a bigger one that sits six weeks eating holding costs.