A spreadsheet is the default tool for tracking car flipping profit in the UK. Here is exactly what to track, the formulas that matter, and the point at which a spreadsheet starts costing you money.
Written and reviewed by FlipTrack Editorial Team
Almost every UK car flipper starts with a spreadsheet. It is free, it is familiar, and it is genuinely better than tracking nothing or running the numbers in your head. If you are flipping one or two cars a year, a well-built spreadsheet can carry you a long way. The problem is not that spreadsheets are bad. It is that they were never designed for the specific workflow of buying and selling cars for profit, and that mismatch quietly costs you accuracy as soon as your volume increases.
This guide gives you the structure to build a functional car flipping spreadsheet today, the formulas that actually matter, and an honest account of the point at which a spreadsheet starts working against you.
The mistake most people make is tracking only the headline numbers - what they paid and what they sold for. That gives you gross margin, which is not your profit. A useful spreadsheet tracks every cost against every vehicle so you can calculate real net profit. At a minimum you need a column for each of these:
The category breakdown matters more than people expect. Knowing your total repair spend is far less useful than knowing whether it is parts or labour eating your margin, or whether your auction fees are quietly pushing your effective purchase price too high. Generic categories like repairs hide where your money is actually going.
You can download the ready-made template above and start logging today, or build your own. Either way, the cleanest setup is one row per vehicle on a master sheet, with cost categories as columns across the top. Each car occupies a single line, every cost type has its own column, and your calculated metrics sit at the end of the row. This gives you a portfolio overview at a glance and keeps every car self-contained.
For flippers who incur a lot of individual transactions per car, an alternative is a separate tab per vehicle with one row per transaction, and a summary tab that pulls the totals together. This captures more detail but takes more maintenance. For most people starting out, the one-row-per-vehicle master sheet is the better balance of detail and effort.
A spreadsheet only earns its place if it calculates the metrics that drive decisions. Build these formulas in once and they work for every row:
Core spreadsheet formulas
| Metric | Formula logic | Why it matters |
|---|---|---|
| Total cost | Purchase price + every vehicle cost | Shows the money actually committed |
| Net profit | Sale price - total cost | Shows the result after recorded costs |
| ROI | Net profit ÷ total cost × 100 | Compares return with capital committed |
| Break-even | Running total cost | Shows the minimum sale price before negotiation |
| Days held | Sale date - purchase date | Shows how long capital was tied up |
| Profit per day | Net profit ÷ days held | Adds turnover speed to the result |
A spreadsheet built like the above will serve you well at low volume. The problems appear as you scale, and they are structural rather than fixable with better formulas.
The most damaging spreadsheet problem is not a missing formula - it is a missing transaction. Costs reconstructed from memory after the sale are easier to omit, particularly fuel, checks, small parts, listing fees and cash payments. Missing costs overstate profit and weaken the next buying decision.
That gap does not just make your reported profit wrong. It corrupts your next buying decision, because you are calculating margins on the next car using numbers that are systematically too optimistic. Over time you end up feeling busy and profitable while the actual numbers never quite add up.
There is a clear point where a spreadsheet stops being the right tool. If you are running more than two or three cars at once, incurring costs away from your desk, tracking for HMRC, or finding that your logged profit and your bank balance never quite reconcile, the spreadsheet has become the bottleneck rather than the solution.
A purpose-built tool removes the friction that causes missed transactions. Logging a cost against the right vehicle from your phone the moment it happens, attaching the receipt photo there and then, and seeing your break-even and net profit update instantly is a different workflow entirely. It captures the costs a spreadsheet loses, which is exactly where your real profit is hiding.
A spreadsheet is a fine starting point and the structure above will give you a genuinely useful one. But its limitations are built in, not solvable. It lives on a laptop when costs happen on the road, it stores no evidence, and it relies on you to remember every transaction. For a casual flipper that is manageable. For anyone running real volume, the costs that slip through the gaps add up to more than the price of a tool that closes them.
FlipTrack UK does everything a flipping spreadsheet does and the things it cannot - mobile cost logging, receipt photos, automatic break-even and ROI, VRM auto-fill, and a full portfolio view. Free to start with up to three vehicles, no card required.
Start free - no card required →What should a car flipping spreadsheet track?
At minimum: vehicle reference, purchase date and price, target sale price, every cost broken down by category (auction fees, transport, MOT, repairs, parts, valet, advertising, platform fees, insurance, tax, HPI), sale date and price, and calculated fields for total cost, net profit, ROI, break-even, and days held.
Is a spreadsheet good enough for tracking car flipping profit?
For one or two cars a year, a well-built spreadsheet can work. Its limitations appear when costs happen away from the workbook, receipt evidence is stored separately or multiple active vehicles make same-day logging and portfolio reconciliation harder.
How do I calculate break-even price in a spreadsheet?
Break-even is the running total of every cost logged against a vehicle - the purchase price plus all subsequent costs. Build a formula that sums the purchase price and every cost column for that row. It must update every time you add a cost, or your target sale price will be based on a stale number.
When should I stop using a spreadsheet for car flipping?
When you are running more than two or three cars at once, incurring costs away from your desk, tracking for HMRC, or finding your logged profit never reconciles with your bank balance. At that point the missed transactions cost more than a purpose-built tool that captures them.
Share this article
Related articles
Best Car Flipping App UK: What to Look For and What Is Available
7 min read · Profit Tracking
How to Track Profit When Flipping Cars in the UK (The Complete Method)
9 min read · Profit Tracking
How to Calculate Break-Even Price When Flipping Cars in the UK
6 min read · Profit Tracking
What Records HMRC Expects UK Car Flippers to Keep
8 min read · Tax & Finance