Inventory & Stock Management System; For UK Businesses Selling Physical & Digital Products

If you sell physical products, import goods, run multiple revenue streams, or need to know exactly what stock you have and what it’s worth, this is the tool you’ve been looking for.

Built specifically for UK small businesses selling anything from used electronics and food products to care services and digital downloads, this system gives you full visibility over your inventory without expensive software.

What’s inside:

📦 Product Catalogue (Sheet 1)

Your master list of every product or service you sell. Add the SKU code, category, type, unit of measure, cost price, selling price, reorder level, and supplier. The gross margin is calculated automatically. Supports physical products, digital products, services, imports, bundles, and raw materials.

📊 Stock Control (Sheet 2)

Your live stock position at a glance. Enter your opening stock, log stock in and out, and the system calculates your current stock level automatically. Status flags (OK, Low Stock, Out of Stock) update in real time.

🔄 Stock Movement Log (Sheet 3)

The full audit trail. Every time stock comes in (purchase, import, return) or goes out (sale, used, damaged), you log it here. 100 rows. Includes movement type, quantity, unit value, reference number, and activity stream.

💰 Sales Tracker (Sheet 4)

Track every sale with the product, customer, quantity, revenue, cost of goods, and gross profit, all auto-calculated. Use the Activity/Stream column to separate multiple product lines (e.g. IT sales, food sales, wholesale) so you can see how each one performs.

📈 Dashboard (Sheet 5)

Your annual overview. Total revenue, total cost of goods, gross profit, and gross margin, plus a monthly breakdown and an activity-by-activity profitability comparison.

Perfect for businesses that:

✅ Sell multiple products or run multiple revenue streams

✅ Import goods and resell them (UK or internationally)

✅ Need to track stock levels and get low-stock alerts

✅ Want to know their actual profit margin per product line

✅ Sell both online and in person

Real example of how it works:

A business selling used laptops, imported Nigerian peanuts, and bread can set up three activity streams, track stock for each product separately, log every sale under the right stream, and see exactly which product line makes the most profit, all in one file.

File details:

∙ Format: Microsoft Excel (.xlsx)

∙ Compatible with: Excel (Mac & PC), Google Sheets

∙ 5 sheets; Catalogue, Stock Control, Movement Log, Sales Tracker, Dashboard

∙ Dropdown menus throughout; no typing errors

∙ Zero formula errors; works straight from download

WHAT YOU GET:

∙ Readme Inventory System

• 1 × Excel file (.xlsx)

∙ 5 specialist sheets

∙ 100-row movement log and sales tracker

∙ Auto stock alerts and live margin calculation

∙ Instant download after purchase