UK Reseller Inventory and Sales Digital Tracker Vinted eBay & Etsy Excel Spreadsheet HMRC Friendly Bookkeeping

As a fellow Reseller and small business owner myself, I found it so difficult to keep record of inventory without paying and extortionate fee on Subscriptions. This is what lead me to create this HMRC friendly spreadsheet to make life a bit easier. I utilize this same spreadsheet to run this very platform that your are on right now. See contents below

Take control of your reselling business with this **automated Excel Reseller Inventory, Sales, Profit & Expense Tracker**, designed especially for UK online sellers.

Whether you sell on **Vinted, eBay, Etsy, Depop, TikTok Shop, Shopify, Facebook Marketplace, Amazon or multiple platforms**, this all-in-one workbook helps you keep your stock, sales, costs and profits organised in one place.

No more separate notebooks, random spreadsheets or wondering how much profit you actually made!

### ✨ WHAT'S INCLUDED

**📊 PROFESSIONAL BUSINESS DASHBOARD**

See the important numbers at a glance, including:

* Total sales

* Net profit

* Units sold

* Business expenses

* Stock value

* Sales overview

* Sales by platform

* Product performance

* Low-stock alerts

* Profit overview

* HMRC tax-year figures

Your dashboard updates automatically as you enter your business information.

### 📦 AUTOMATED INVENTORY MANAGER

Manage your reseller stock from one organised inventory.

Record:

* SKU

* Product / item name

* GTIN / Barcode

* Product category

* Supplier

* Purchase date

* Unit cost

* Quantity purchased

* Quantity sold

* Quantity available

* Selling price

* Stock value

* Reorder level

* Stock status

* Product notes

Stock quantities automatically update based on your recorded paid sales.

You'll also receive clear:

**IN STOCK**

**LOW STOCK**

**OUT OF STOCK**

indicators to help you manage inventory.

### 🏷️ SKU SMART AUTOFILL

Save time entering every sale.

Simply select your product **SKU** on the Sales sheet and the spreadsheet automatically finds the matching product in your Inventory.

It can automatically populate:

* Product / Item Name

* Unit Cost

This helps reduce repetitive data entry and pricing mistakes.

### 🔢 GTIN / BARCODE TRACKING

The updated Inventory Manager now includes a dedicated **GTIN / Barcode** field.

Perfect for sellers who need to keep product identifiers organised for marketplace listings and stock management.

The GTIN field is designed to preserve long barcode numbers and leading zeros.

### 💷 SALES & PROFIT TRACKER

Record sales from:

* Vinted

* eBay

* Etsy

* Depop

* TikTok Shop

* Shopify

* Facebook Marketplace

* Amazon

* In-person sales

* Other marketplaces

Track:

* Sale date

* Transaction / order ID

* Selling platform

* SKU

* Product

* Quantity

* Selling price

* Buyer postage

* Other income

* Gross income

* Marketplace/payment fees

* Postage costs

* Unit cost

* Cost of goods

* Other selling costs

* Net profit

* Payment status

* Payment method

Your profit calculations are handled automatically.

### 🧾 BUSINESS EXPENSE TRACKER

Keep your business spending organised, including:

* Stock purchases

* Packaging

* Postage and courier costs

* Marketplace fees

* Payment processing fees

* Advertising and marketing

* Website/software subscriptions

* Office and stationery costs

* Phone/internet

* Travel

* Bank charges

* Insurance

* Professional fees

* Training

* Other business expenses

You can also record **receipt and invoice references** to make supporting paperwork easier to find.

### 🇬🇧 HMRC-FRIENDLY RECORD KEEPING

A dedicated tax-year summary helps UK resellers organise important business figures, including:

* Sales / receipts

* Cost of goods sold

* Marketplace/payment fees

* Postage costs

* Other selling costs

* Business expenses

* Net business profit before tax

* Remaining inventory

* Stock value

Designed to make your bookkeeping records clearer and easier to review when preparing your accounts or working with an accountant.

### 👤 IDEAL FOR

✔ Vinted sellers

✔ Vinted Pro sellers

✔ eBay sellers

✔ Etsy sellers

✔ Depop sellers

✔ TikTok Shop sellers

✔ Clothing resellers

✔ Jewellery sellers

✔ Vintage sellers

✔ Collectible sellers

✔ Online boutiques

✔ Small UK businesses

✔ Side hustlers

✔ Full-time resellers

✔ Multi-platform sellers

### ⚡ AUTOMATED FEATURES

Instead of calculating everything manually, the workbook helps automate your reseller admin.

**Enter your inventory → Select your SKU → Record the sale → Let Excel calculate the numbers.**

The workbook helps you quickly understand:

**What you've sold.

What stock you have left.

What it cost you.

What you've spent.

And most importantly — what profit you've made.**

### 📥 DIGITAL DOWNLOAD

This listing is for a **DIGITAL EXCEL SPREADSHEET**.

No physical item will be shipped.

Microsoft Excel or compatible spreadsheet software supporting the workbook's formulas and functions is required.

### ⚠️ IMPORTANT HMRC INFORMATION

This spreadsheet is designed to help with **bookkeeping, business organisation and digital record keeping**.

It does not provide tax, legal or accounting advice.

It does not submit Self Assessment returns or Making Tax Digital updates directly to HMRC and should not be described as HMRC-approved software.

Where HMRC-compatible software is required for official submissions, appropriate compatible software should be used.

Please consult HMRC guidance or a qualified accountant if you're unsure about your individual tax obligations.

---

**📊 Know your numbers. 📦 Control your stock. 💷 Understand your profit.**

Spend less time managing spreadsheets and more time growing your reselling business.