Free Reselling Spreadsheet Template UK (Google Sheets + Excel)

If you're reselling from car boot sales, charity shops, or online, you need a system to track what you buy, what you sell, and what you actually make after all costs. Most resellers start with a spreadsheet, and that's fine.

Here's a complete reselling spreadsheet template you can build in Google Sheets or Excel in about 15 minutes. I'll walk through every column, the formulas you need, and realistic example data. Then I'll explain where spreadsheets break down and what I switched to instead.

The reselling spreadsheet layout

Your main sheet needs 15 columns. Each one tracks a specific part of the buy-list-sell cycle.

Put each item on its own row. Don't skip the status column — it's how you'll know at a glance how many items are sitting unlisted in your death pile.

Trip expenses tab

Create a separate sheet tab called "Trip Expenses". This tracks your sourcing costs, which most resellers forget entirely.

That £1.50 cost per item sourced is a hidden expense on every single item you bought that day. If you're not tracking it, you're overstating your profit. On a trip where you only buy 2 items, the cost per item jumps to £5.25 — suddenly your margins are a lot thinner.

Key formulas you need

Copy these into your spreadsheet. All assume row 2 is your first data row (row 1 is headers).

That last formula auto-calculates eBay fees based on the platform column. Vinted sellers pay no fees (the buyer pays the protection fee), so those stay at £0. For Facebook Marketplace local collection, fees are also £0.

Example data: 6 realistic UK reselling entries

Here's what a filled-in spreadsheet looks like with actual UK prices and real fee calculations.

Notes on the fees:

• eBay: 12.8% of sale price + £0.30 per order. The £18 dress: £18 x 0.128 + £0.30 = £2.60. The £45 Le Creuset: £45 x 0.128 + £0.30 = £6.06. The £28 toaster: £28 x 0.128 + £0.30 = £3.88.
• Vinted: £0 seller fees. The buyer pays the protection fee, not you.
• Facebook Marketplace: £0 fees for local collection. If you use the shipping option, there's a selling fee, but most UK sellers do collection.

The Pyrex bowls sold via Facebook local collection — no postage, no packaging, no fees. That's £13 pure profit. The toaster only made £3.12 after all costs and took 19 days. That's the kind of insight you only get when you track properly.

Where spreadsheets break down

I used a spreadsheet like this for months. It works, but it has real limitations that get worse over time.

Painful on mobile. Try opening a 15-column Google Sheet on your phone at 7am at a rainy car boot sale. Pinching, scrolling sideways, tapping into tiny cells. It's friction that kills consistency — you stop logging items because it's annoying.

No photo support. You end up with a camera roll full of item photos and a spreadsheet full of text descriptions, with no connection between them. Three weeks later you're looking at "blue mug" in row 47 and can't remember which blue mug.

Formulas break. Insert a row in the wrong place and your SUMPRODUCT pulls from the wrong range. Copy a formula down and it shifts references. You don't notice until your monthly profit number looks wrong.

No multi-currency. Source items from a French vide-grenier or a European trip? Now you're manually converting euros to pounds and hoping the exchange rate hasn't moved by the time you sell.

Gets slow past 200+ items. Google Sheets visibly lags on mobile once you have several hundred rows with formulas. Excel is faster but even worse to use on a phone.

Multi-platform tracking is messy. If you list the same item on eBay and Vinted simultaneously, you need either two rows or a complicated notes column. When it sells on one platform, you need to remember to update the other listing status.

Google Sheets needs internet. Car boot sales in a field with no signal? You're stuck noting prices on your hand and entering them later (which means forgetting half of them).

The better option: do it all from your phone

I built this spreadsheet template first. Then I hit every one of those problems and built FlipperHelper to solve them.

It does everything the spreadsheet does, but from your phone in about 10 seconds per item.

• Snap a photo at the market, log the price, done. No spreadsheet cells, no typing descriptions. The photo is attached to the item record permanently.
• Works offline. No signal at the car boot? No problem. Everything saves locally and syncs to Google Drive later when you have Wi-Fi.
• Multi-currency built in. Source from French vide-greniers or European markets and the prices convert automatically using live exchange rates.
• Export to Google Sheets. Your accountant or partner needs a spreadsheet? One tap generates a clean CSV and uploads it to your Google Drive as a proper Sheet. You get the best of both worlds.
• Track across 16 platforms. eBay, Vinted, Facebook Marketplace, Depop, Shpock, Gumtree, Etsy, and more. List on multiple platforms and record where it actually sells.
• Entry fees and transport costs per trip. Log them at the market and they're allocated automatically — no separate tab, no manual formulas.
• Real profit calculation. After purchase price, platform fees, postage, packaging, entry fees, and transport — the actual number, not an estimate.

Free on the App Store, no account required to start tracking.

If the spreadsheet template above works for you, use it. Seriously. Anything is better than not tracking at all. But if you're doing 20+ items a month and finding the spreadsheet annoying, the app is built for exactly that switch.

Frequently asked questions

What columns should a reselling spreadsheet have?

At minimum: Date Bought, Source, Item Description, Purchase Price, Date Listed, Platform, Listing Price, Date Sold, Sale Price, Platform Fees, Postage Cost, Packaging Cost, Net Profit, Days to Sell, and Status. A separate tab for trip expenses (entry fees, transport, parking) gives you the full picture.

How do I calculate reselling profit in a spreadsheet?

Net Profit = Sale Price - Purchase Price - Platform Fees - Postage Cost - Packaging Cost. In Google Sheets or Excel, that's =I2-D2-J2-K2-L2. For complete accuracy, also divide your trip expenses (entry fees, petrol) by the number of items bought per trip and add that to each item's cost.

What are the current eBay selling fees in the UK?

eBay UK charges 12.8% of the sale price plus £0.30 per order for most categories. So an item sold for £20 costs you £2.56 + £0.30 = £2.86 in fees. For full details, see our eBay UK fees 2026 breakdown.

Is Google Sheets or Excel better for tracking reselling?

Google Sheets is better if you want access from multiple devices or need to share with a partner. Excel is stronger for offline use and advanced features like pivot tables. Both support the same formulas. The main limitation of either is that they're painful to use on a phone at a market.

Is there a better alternative to spreadsheets for reselling?

Dedicated reselling apps handle everything a spreadsheet does but are designed for mobile use. FlipperHelper lets you snap photos, log prices in seconds, track across multiple platforms, and calculate profit automatically — including trip expenses. It works offline and can export to Google Sheets when you need a traditional spreadsheet.

Related reading

• How to Track Your Reselling Profits Properly — why most resellers overestimate their margins and the 5 metrics that matter
• HMRC £1,000 Trading Allowance for UK Resellers — when your reselling becomes taxable and what records to keep
• eBay Selling Fees UK 2026 — complete fee breakdown by category