Margin

How to track car flipping expenses: the system, not the spreadsheet

The eleven cost lines on every flipped car, the receipt rule that stops the small ones vanishing, and the two numbers a car must carry at all times.

By Deelary Team 8 min read

Every flipper tracks expenses. Ask them how, and most will describe a spreadsheet they update on Sunday, a glovebox of receipts, and a figure for each car that they are fairly sure is close.

Fairly sure is the problem. The profit on a flip is the sale price minus every dollar that went into the car, and the dollars that go missing are not the big ones. They are the $35 listing fee, the $85 title transfer, the $120 of parts bought across three trips and the $90 detail paid in cash. On a typical sub-$10,000 flip they add up to several hundred dollars, which is routinely the difference between the profit you remember and the profit you made.

This is the system that stops them going missing. It works in a notebook, a spreadsheet or an app, because it is a set of rules rather than a tool.

Rule one: every car carries eleven lines

A car’s cost is not one number. It is a short list, and the list is the same for every car, so decide it once:

LineWhat goes in it
PurchaseThe hammer or agreed price, nothing else
Buyer or auction feeBuyer premium, gate fee, internet fee, broker fee
TransportTow, transporter, fuel and tolls to collect it
PartsEverything fitted, including the second trip for the clip you forgot
LabourWhat you paid a mechanic, or your own hours at a rate
DetailCleaning, products, the odour treatment
Listing and advertisingMarketplace fees, boosted posts, a sign
Title, registration, inspectionTransfer fee, temp tag, emissions, notary
HoldingLot rent per car, insurance per car, interest if the car is financed
Repairs after saleThe goodwill fix you did so the buyer did not come back
OtherKeys cut, a battery jump, the one-off nobody predicted

The purpose of fixed lines is that the question at the counter is never “is this an expense?” It is only “which line?” That removes the judgement call that makes people skip small ones, and it makes every car comparable with every other car, which is where the useful patterns live. The true cost of a car walks through what each line typically costs.

Rule two: the receipt is logged where it is printed

This is the rule that decides whether the system works, and it is the one every spreadsheet breaks.

A receipt that is logged on Sunday has to survive four days in a pocket, a glovebox or a dash, and then be read, remembered and typed. A receipt that is logged at the counter survives nothing, because it is already on the car before you reach the truck. Photograph it, write the amount and the line it belongs to, and attach it to that car. The paper can go in the bin.

Two things follow from this. The system has to be in your pocket, which is why a desktop spreadsheet is the wrong shape for the job even when the columns are right. And the photo has to be kept, because the thermal paper fades in months and the tax return can be questioned for years. This is the exact job the receipt capture in Deelary does: the amount and date are read from the photo on the device, you confirm the line, the photo stays attached to the expense.

If you stay on a spreadsheet, the discipline is the same: phone photo at the counter, entry that evening at the latest. The free car flipping spreadsheet has the eleven columns and the formulas; the receipts are up to you.

Rule three: two numbers live on every car at all times

Expense tracking is not for its own sake. It exists so that two numbers are always current.

The first is total cost in the car: purchase plus every line above, today. This is the number you need when a buyer asks what you can do on it, because any price below it is a loss and the gap above it is your room. It changes every time a receipt lands, which is why it cannot be a Sunday figure.

The second is projected profit: your asking price minus total cost. Add a $240 tire receipt and the total rises by $240 and the projected profit falls by $240, in the same second. If that number drops below what the car is worth to you, you find out standing at the tire shop, which is when you can still decide not to do the second pair.

When the car sells, the asking price becomes the sale price and the projected profit becomes the real one. It stays on the car, which is what makes the next rule possible. Vehicle profit tracking is these two numbers on a screen.

Rule four: the days are an expense line too

A car bought for $7,300 all-in and sold for $8,400 made $1,100. Whether that was a good flip depends entirely on a number most expense systems do not record: how many days the $7,300 was in it.

Forty days is $28 a day of capital. Seventy-seven days is $14. A hundred and ten days is $10, and for those extra seventy days the money could not be in the next car. Cox Automotive put cars under $15,000 at 29 days’ supply in August 2026, so a cheap car taking three times the market to sell is a pricing problem that the expense sheet should be able to show you.

So the purchase date and the sold date are fields, not notes, and days held is a column. If you pay a holding cost, lot rent, insurance or interest, it goes on the holding line as a daily rate multiplied by the days. If you do not, the days still count, because profit per day of capital is how two flips get compared. Days on the lot is the long version.

Rule five: nothing is averaged, everything is per car

The temptation, once there are a few cars, is to track costs by month. Parts this month, fees this month, a total. It feels like bookkeeping. It is useless for flipping, for two reasons.

The sale price of a car is decided by that car’s cost, not the month’s. A monthly total cannot tell you that the blue sedan is in for $7,300 and the white truck for $9,100.

And the tax return wants cost per car. Schedule C’s cost of goods sold section works from inventory at the start of the year, purchases during it and inventory at the end, which means the cost basis of each car you still own on December 31. Publication 334 walks through the lines. A monthly total has to be reverse-engineered into per-car figures in February, by someone who no longer remembers which parts went on which car. Car flipping taxes covers the rest of what the IRS asks for; all of it starts from a per-car record.

Per-car does not mean you lose the monthly view. It means the monthly view is a report run from per-car data, which is the right way round.

Rule six: the categories are for the report, not for tidiness

Once five or six cars have been through the system, the lines start to tell you things no single car could.

Cars from one auction average $300 more in parts than cars from the other. Detailing is quietly a tenth of your reconditioning spend. The transport line on out-of-state cars is eating the margin you thought you were getting on the hammer price. The sedans turn in 30 days and the trucks in 60. None of that is visible on a car; all of it is visible when the same eleven lines are summed by source, by make or by month.

This is the reason to be strict about the lines in the first place. A “misc” column that absorbs anything awkward produces a report that says you spent $1,900 on misc, which is a number with no decision in it. The app’s sales report groups real profit by source and by make for the same reason; the free spreadsheet’s summary sheet does a simpler version.

What the system looks like in practice

Buy the car. Create it with the purchase price, the date and where it came from. At the auction office, photograph the fee receipt and log it. At the tow, log the tow. At the parts counter, photograph the receipt, log it on the car, and if the parts were for two cars, split it. When you list it, log the listing fee and the asking price. Every receipt lands on the car the day it exists.

When a buyer offers, the total cost and the gap are already on the screen. When it sells, enter the sale price and date; the real profit and the days held are now fixed and the car moves to the sold list, where it feeds the reports.

That is the whole system. Eleven lines, logged at the counter, two numbers always current, the days counted, nothing averaged. It takes less time than the Sunday spreadsheet, because the work is spread across the moments it belongs to.

Which tool, honestly

A notebook works for one car at a time and fails at two. A spreadsheet works for two or three cars at a time if the receipts go in the day they happen, and the free car flipping spreadsheet is built for exactly that stage. Spreadsheet vs dealer software covers where the line usually falls.

Past that, the problem is not the columns but the counter. Too many receipts in too many places, with too many days between the cost and the keyboard. The Deelary app is the system above with the counter built in: the car is created from a VIN scan, the receipt is read from a photo and attached, total cost and projected profit sit on the car, the days count themselves, and every car, cost and sale exports to CSV when the accountant asks. Free for two cars on iPhone and iPad, which is enough to find out whether the system suits you before the third car does.

Frequently asked questions

What expenses should I track when flipping cars?

Everything that leaves your account because of that car: the purchase, the auction or buyer fee, transport, parts, labour you paid for, detail, listing and advertising, title and registration, inspection, and any holding cost such as lot rent or interest. Eleven lines cover almost every flip. The purchase is the one nobody forgets; the other ten are where the margin leaks.

Do I track expenses per car or per month?

Per car, always. A monthly total tells you what you spent; a per-car total tells you what each car cost, which is the only number that decides the sale price and the only number the tax return wants. Monthly figures are a report you run from the per-car data, not the other way round.

Should I include my own labour?

Track it either way, decide how to use it later. Log the hours and a rate you would pay someone else. If you want the cash number, show it at zero; if you want the honest number, show it at the rate. The mistake is not writing it down at all and then believing a $400 brake job was free.

What about costs that cover several cars?

Split them. A parts run for two cars is two expense entries, one on each car, with the receipt attached to both. Lot rent or insurance is divided by the cars on the lot that month. A cost that belongs to no car in particular belongs to the business and goes in overhead, not on a car.

How long do I keep the receipts?

As long as the tax return they support can be questioned, which for most people means several years. Keep the photo rather than the thermal paper, which fades. A receipt photographed on the day and attached to the car is the version that still exists in April.

When is a spreadsheet no longer enough?

When the receipts stop going in the day they happen. For most flippers that is somewhere between three and six cars at once, when there are too many counters, too many trips and too many days between the cost and the keyboard. The spreadsheet did not fail; the discipline did, and the fix is to log at the counter.

Sources