If you run a small business in the UK and are choosing stock control software, you have probably reached the point where a spreadsheet, a notebook or a basic till no longer tells you what you actually have. This guide covers the signs that you have outgrown your current setup, what to look for in a replacement, and the questions worth asking any vendor before you commit.
We build IDP, a desktop system for inventory, sales and accounts, so we have a point of view. We have tried to keep this useful whichever product you end up choosing.
Signs you have outgrown spreadsheets
A spreadsheet is a reasonable place to start. These are the signs it has stopped being enough:
- You count stock to find out what you have. If the only reliable number comes from walking the shelves, the sheet is a record of the last count, not of today.
- Two people edit the same file. Someone saves over someone else, or you end up with "stock-final-v3" in a shared folder.
- You sold something you did not have. A customer was promised an item that had already gone, and you found out afterwards.
- Stock sits in more than one place. A shop, a storeroom and a van each hold part of the total, and nobody can say quickly what is where.
- Invoices and stock live in different files. Every sale means typing the same thing twice, and the two never quite agree.
- You cannot say what you are owed. Customer balances sit in one sheet, supplier balances in another, and cash in a third.
If three or more of these sound familiar, the cost is already being paid, in time and in mistakes. Our earlier post on replacing five spreadsheets with one system goes into this in more detail.
What to look for in stock control software
Features lists are long and most of them do not matter on day one. These are the areas that usually do:
- Stock per location. A single company-wide number hides the fact that the item is in the wrong place. The software should track quantity per warehouse, shop or store, and let you move stock between them with a record.
- A hard stop on negative stock. The system should refuse a sale that would take a location below zero, not just show a warning someone can click past.
- Invoicing tied to stock. When you raise an invoice or ring up a sale, stock should fall automatically. Typing it twice is how the numbers drift apart.
- Customer and supplier balances. Credit limits, what each customer owes, what you owe each supplier.
- Accounts in the same place. A cashbook, ledgers, profit and loss and a balance sheet that come from the same transactions as your stock, so nobody re-keys figures for the accountant.
- Roles and permissions. Not everyone should be able to change prices or delete a record.
- Working offline. Covered below, because it is the one most often overlooked.
- A clear cost model. Per-user fees and per-transaction fees add up as you grow. Ask what happens to the bill when you add a member of staff.
Multiple locations: where most setups break
Many small UK businesses start with one location and quietly become two or three: a shop and a unit, a warehouse and a van, a trade counter and an online side. The moment that happens, "how many do we have?" becomes "how many do we have, where?"
Software that handles this well records receiving, transfers and sales against a specific location, so the answer is always specific. Our post on what changes when you add a second warehouse walks through it.
Offline working is not a minor feature
Plenty of stock tools run only in a browser. That is fine until your broadband drops during a busy Saturday, or the unit you work from has patchy signal. If the till or the stockroom cannot work without the internet, a connection problem becomes a trading problem.
Software that keeps working offline and syncs or backs up when you are connected gives you a safety margin. Cloud-only tools have their strengths, so this is a trade-off to weigh, not a rule. Just ask the question before you sign.
Questions to ask every vendor
Use this as a checklist in demos. Write down the answers.
- Is stock tracked per location, and can I transfer between locations with a record?
- Does the system block a sale that would make stock negative?
- Do invoices reduce stock automatically?
- Can I see customer and supplier balances, and set credit limits?
- Are cashbook, profit and loss and balance sheet included, or is that a separate product?
- What happens when the internet is down?
- Which operating systems does it run on?
- What is the pricing model: per user, per transaction, per module? What does the bill look like when I add two more staff?
- Is there a long-term contract, and what is the notice period?
- Can I export my data if I leave?
- How does it handle VAT on invoices and records, and does it support Making Tax Digital for VAT?
A note on VAT and Making Tax Digital
If your business is VAT-registered, your invoices must show the details HMRC requires, and Making Tax Digital for VAT has its own rules about how records are kept and how returns are submitted. Rules and thresholds change, so check HMRC's current guidance with your accountant instead of relying on a vendor's summary.
Ask each vendor, in plain words, exactly what their software does for VAT invoices and for MTD, and ask to see it on screen. Treat a vague answer as a no. If you are looking at IDP: UK VAT invoicing can be added to match your requirements, rather than being switched on by default. For Making Tax Digital returns, keep using the accounting software you already file with. Tell us how you work during the demo and we will quote any set-up up front.
Where IDP fits, and where it does not
IDP covers inventory across multiple warehouses (receiving, gate passes, transfers, low-stock alerts and negative-stock prevention), sales and invoicing with point of sale, customers and vendors with balances and credit limits, a cashbook, ledgers, profit and loss, a balance sheet, fixed-asset depreciation, and roles and permissions. It is offline-first on Windows, macOS and Linux, with a cloud-hosted option.
It is billed monthly with no long-term contract, no per-user fee within the plan limit and no per-transaction fee. See the product page for the full module list and the pricing page for current plans.
It is not a fit for every business, and we would rather say so early. If your needs go beyond a ready-made system, we also build custom software, web apps and AI agents; see our services.
Next steps
Before you look at any software, count your locations, list the three things that go wrong most often, and decide whether you can trade without internet. Those answers will do more to narrow the field than any feature comparison.
If you want a straight conversation about your setup, see how we work with UK businesses or talk to us.