Inventory Management for Small Businesses UK: Complete Guide (2025)

Why inventory management matters for small businesses

Inventory is typically the largest asset on a product business's balance sheet, yet many small businesses manage it with a notepad or a basic spreadsheet. That works at the very beginning, but it breaks down quickly as you add SKUs, grow volume, or start selling on multiple channels.

Poor inventory management creates a cascade of problems: stockouts that lose you sales and damage your seller metrics on platforms like Amazon and eBay; overstocking that ties up cash and generates storage fees; inaccurate stock counts that lead to overselling and refunds; and difficulty understanding which products are actually profitable.

Good inventory management, by contrast, gives you a real-time picture of what you have, what you've committed to customers, what's on order from suppliers, and what's been sitting on the shelf for too long. It's the foundation of a scalable product business.

Manual vs spreadsheet vs software: comparison

Most UK small businesses start with a spreadsheet and it serves them well until a certain point. The tipping point is usually when they're spending more than a few hours a week updating stock counts, or when their first significant oversell happens and they have to refund customers.

FIFO, LIFO, and weighted average costing

When you sell a unit of stock, you need to record what it cost you to buy it. That cost becomes your Cost of Goods Sold (COGS), which directly affects your gross profit. Three main methods exist for calculating this:

FIFO (First In, First Out)

Under FIFO, you assume the oldest stock is sold first. If you bought 100 units at £5 in January and 100 units at £6 in March, the first 100 units you sell are costed at £5. FIFO is the most common method for UK small businesses and is recommended by UK GAAP (FRS 102). It also tends to reflect physical reality for products that can spoil or go out of date.

LIFO (Last In, First Out)

Under LIFO, you assume the newest stock is sold first. LIFO is not permitted under UK GAAP (FRS 102) or IFRS. You cannot use LIFO for your statutory accounts in the UK. It is mentioned here only because some US-sourced inventory guides recommend it, which can mislead UK sellers. Stick with FIFO or weighted average.

Weighted average cost

Under the weighted average method, you calculate a running average cost across all units in stock. If you have 100 units at £5 and receive 100 more at £6, your average cost becomes £5.50 per unit. This method smooths out price fluctuations and is also acceptable under UK GAAP. It works well for commodities and products where individual batch pricing is impractical.

ABC analysis

ABC analysis is a simple but powerful technique for prioritising your attention across your product range. It categorises every SKU into one of three bands based on its contribution to total revenue (or profit):

• A items: The top ~20% of SKUs that generate ~80% of revenue. These deserve the tightest stock control, safety stock, and reorder point monitoring. Never let an A item run out.
• B items: The middle ~30% of SKUs generating ~15% of revenue. Moderate attention. Set reorder points but don't over-invest in safety stock.
• C items: The bottom ~50% of SKUs generating ~5% of revenue. These should be managed for efficiency — minimal safety stock, potentially reduced or eliminated if margins don't justify the complexity.

To run an ABC analysis, export all your SKUs with their total revenue or gross profit for the last 12 months. Sort by revenue descending. The top 20% are your A items. You may be surprised how concentrated your revenue is — for most UK e-commerce businesses, 10–15 SKUs generate half the total revenue.

Review your ABC classification quarterly. Products can migrate between bands as trends shift — especially if you sell seasonal or fashion products.

Dead stock: causes and cures

Dead stock is inventory that hasn't sold in a long time and is unlikely to sell at full price. It's a silent killer for small businesses: it ties up cash, takes up storage space, and often ends up being written off at a loss.

Common causes of dead stock

• Overbetting on a trend that didn't materialise
• Buying too much to hit a supplier's minimum order quantity (MOQ)
• Seasonal stock not sold in season and not discounted quickly enough
• Poor demand forecasting leading to over-purchasing
• Products made obsolete by a new version or competitor

How to deal with dead stock

• Discount aggressively: A 50% margin on dead stock is better than 0% margin on a write-off. Use time-limited promotions.
• Bundle with faster-moving items: Pair dead stock with an A-item in a bundle at a slight discount.
• Return to supplier: Some suppliers will accept returns or credits, especially if you have a good relationship.
• Sell on secondary channels: If a product isn't moving on Amazon, try eBay, Vinted, or B-stock platforms.
• Write off and reclaim VAT: If stock has no commercial value, you can write it off, claim the cost as a tax deduction, and reclaim the VAT on the original purchase.

Inventory turnover ratio

The inventory turnover ratio measures how many times you sell through your entire stock in a given period. A higher ratio generally means your capital is working harder and you're not tying up cash in slow-moving stock.

For example: if your COGS for the year was £120,000 and your average inventory value was £20,000, your inventory turnover ratio is 6. That means you turned over your stock 6 times during the year, or roughly every 2 months.

A turnover ratio below 3× in most e-commerce sectors suggests you're carrying excess stock. A ratio above your sector benchmark may indicate you're running lean (good) or that you're frequently stocking out (bad) — check alongside your stockout rate.

HMRC and VAT record requirements

UK businesses need to keep inventory records for tax purposes, and there are specific requirements if you're VAT registered.

General record keeping

HMRC requires you to keep records for 6 years. For a product business, this includes purchase invoices for stock, sales records, and documentation supporting your cost of goods sold calculations. If you're investigated, you'll need to be able to reconcile your inventory values.

VAT records

If you're VAT registered (mandatory above the £90,000 turnover threshold for 2024–25, or voluntary below it), you must keep VAT records for 6 years. This includes VAT invoices for stock purchases (which you reclaim as input VAT) and records of VAT charged on sales (output VAT). MTD (Making Tax Digital) requires you to keep digital VAT records and submit returns via compatible software.

Year-end stock valuation

At each accounting year end, you need to value your closing stock. Under UK GAAP, stock should be valued at the lower of cost or net realisable value (NRV). If you have dead stock worth less than what you paid for it, you can write it down to its NRV, which creates a deductible expense. Keep documentation of how you arrived at your year-end valuation in case of an HMRC enquiry.

When to upgrade from spreadsheets

Spreadsheets are a reasonable starting point, but there are clear signals that it's time to upgrade:

• You've had your first oversell: Overselling on Amazon or eBay results in cancellations that damage your seller metrics and can trigger account warnings. Once it happens, it will happen again on spreadsheets.
• You're selling on 3+ channels: Keeping stock counts synchronised across Amazon, eBay, Shopify, and your own website manually is a full-time job. One missed update causes an oversell.
• You have 100+ active SKUs: Updating a 100-row spreadsheet after every order becomes error-prone quickly, especially when you have variants (sizes, colours).
• You have staff: Multiple people editing the same spreadsheet simultaneously is a recipe for data corruption. Proper software has user roles, audit logs, and concurrent access.
• You're spending 3+ hours a week on stock admin: That time has a cost. If software saves you 2 hours a week at a reasonable effective hourly rate, the economics usually stack up even at modest subscription prices.

How Salync helps

Salyncis built specifically for UK small businesses selling physical products online. Here's what it does:

• Multi-channel sync: Connect Amazon, eBay, Shopify, and other channels. When you sell on any channel, stock is deducted from your central inventory count and updated everywhere else automatically.
• Purchase orders: Raise POs to suppliers, track expected delivery dates, and receive stock into your inventory with a few clicks. Lead times are tracked automatically.
• Low stock alerts: Set minimum stock levels per SKU. Salync notifies you before you hit zero so you can reorder in time.
• Inventory valuation: Salync uses FIFO costing by default and gives you a real-time view of your stock value — useful for year-end accounts and cash flow forecasting.
• SKU management: Map variants, bundles, and kit items so your stock levels are always accurate regardless of how a product is sold.

For more on how to choose the right software for your business, see our guide to the best free inventory management software in the UK.

Frequently asked questions

Do small businesses need inventory software?

Not immediately. A spreadsheet works fine up to around 50–100 SKUs or 2–3 sales channels. Beyond that, manual tracking becomes error-prone and time-consuming. If you are regularly overselling, losing track of stock, or spending hours updating spreadsheets, it is time for dedicated software.

What is the best inventory system for a small business in the UK?

It depends on your sales channels. For multichannel sellers (Amazon, eBay, Shopify), Salync is built specifically for UK businesses and includes purchase orders, low stock alerts, and real-time channel sync. For pure Shopify sellers at low volume, Shopify's built-in inventory tools may suffice initially.

How do you track stock manually?

Use a spreadsheet with one row per SKU. Track opening stock, units received (from purchase orders), units sold (from order exports), and calculate closing stock. Do a physical count weekly or monthly to reconcile against your spreadsheet and catch shrinkage or data entry errors.

What is a good inventory turnover ratio for a UK small business?

It varies by sector. Grocery and FMCG typically turn over 12–30× per year. Fashion turns 4–6×. Electronics 6–8×. General e-commerce 4–8×. A ratio below 3× in most product categories suggests excess dead stock that is weighing on your cash flow.