UBC

Business journal

Spreadsheet or inventory software: when to switch

When a spreadsheet is enough to track inventory, the concrete signs it is time to move to software, and a checklist for choosing an inventory system.

Author: UBC editorial team · Published · Updated

6 min read

A spreadsheet can be enough for a small inventory if it stays accurate and manageable. Inventory software becomes worth testing when the work outgrows your current setup. Compare the actual processes, integrations and permissions available; a manually maintained file is not the same as a configured cloud spreadsheet.

Laptop keyboard for working with records and orders
Workflow illustration; not a photograph of UBC premises or equipment. ThinkPad T430 (keyboard).jpg — Vitaly Zdanevich / Wikimedia Commons — CC0 1.0. Resized and converted to WebP.

What spreadsheets do well

Spreadsheets get a bad press, but for many small sellers they are the right tool for years.

  • Almost free. You probably already have Excel, Google Sheets or LibreOffice.
  • Completely flexible. Add a column when you need one; no vendor roadmap involved.
  • Familiar. No training, no migration project.
  • Your data stays yours, in a format anything can open.
  • A good teacher. Tracking stock by hand forces you to learn your business: what sells, how long suppliers take, where margin leaks.

Where they fall short

This comparison concerns a manually maintained file without configured integrations. Excel and Google Sheets can support collaboration and version history; scripts and connectors can automate updates. Whether these are available and reliable depends on the setup. A version history is not the same as a structured ledger of receipts, sales and returns.

  • Nothing updates itself. Every sale, return and delivery has to be typed in. Miss one and the number is wrong.
  • Several people, several versions. Files emailed around, “stock_FINAL_v3.xlsx”, cells overwritten with no record of who or when.
  • No movement history unless you build it. You can see 12 units left, but not why there were 20 yesterday.
  • Fragile formulas. A row inserted in the wrong place breaks a SUM and nobody notices.
  • No link to your sales channels. If you sell in a shop and online, someone copies numbers between them.
  • Cost and margin per sale is hard work, especially when you buy the same item at different prices.

Side-by-side

Spreadsheet Inventory software
Upfront cost Close to zero Subscription or licence
Setup Immediate Days to weeks (load items, configure)
Stock updates Manual Automatic with each sale and receipt
Multiple users Cloud co-authoring available; emailed copies can diverge Check roles, permissions and change log
Multiple channels Manual copying Synchronisation (depending on the product)
Movement history Only if you build it Built in
Flexibility Unlimited Limited to what the product offers
Wired barcode scanner for identifying products
Workflow illustration; not a photograph of UBC premises or equipment. CCD Barcode Scanner.jpg — Network.nt / Wikimedia Commons — Public domain. Resized and converted to WebP.

Signals it is time to switch

If two or more of these sound familiar, it is worth evaluating software:

  1. You sell on more than one channel — a shop, your own web store, one or more marketplaces — and you have sold something online that was already gone from the shelf.
  2. More than one person updates stock, and you have lost changes or argued over which file is right.
  3. Counts regularly disagree with the records and you cannot explain why.
  4. Stockouts cost you sales, or you discover too late that cash is tied up in items that do not move.
  5. Reconciling takes real time. Four hours a week on the spreadsheet adds up to around 200 hours a year.
  6. You are not sure of your margin per sale, because purchase costs change and the sheet does not follow them.
  7. You have many variants (sizes, colours, bundles) and the sheet has grown into hundreds of rows nobody can review.

A quick calculation of the time cost

Say you or a colleague spend 4 hours a week maintaining the sheet and fixing discrepancies, and you value that time at €20 an hour. That is €80 a week, roughly €4,000 a year over 50 working weeks. If software halved that time, it would free up about €2,000 of time a year. Set that against the subscription and the setup effort. Plug in your own figures: the answer varies a lot from business to business.

To see what each product actually earns you before deciding, the free margin calculator can help with the numbers.

Before you switch: tidy up first

Software does not fix messy data; it imports it. Before migrating:

  • Give every item and variant a single, consistent SKU.
  • Do a full stocktake so you start from real quantities.
  • Check the purchase cost of every item.
  • Decide who will book deliveries and stock adjustments.

If you do not yet have a stock routine, start here: how to keep stock records in a small business.

Checklist for choosing inventory software

Ask for a trial or a demo and test each point with your own products, not the sample data.

What to check The concrete question
Multichannel sync Does a web store sale reduce shop stock straight away? Which channels does it connect to today, not on the roadmap?
Purchases and receiving Can I record purchase orders, part-deliveries and supplier issues?
Cost and margin per sale Does it work out the cost of each sale and show margin per product and per order?
User roles Can I give a staff member access without showing purchase costs or letting them delete items? Is every change logged?
Data export Can I download all items, movements and sales in an open format (CSV, Excel) whenever I want?
EU hosting and GDPR Where is the data stored? Do they offer a data processing agreement?
Variants Does it handle sizes, colours and bundles without workarounds?
Total cost What does the fee include? Are there charges per user, per channel or per order volume?

Pay particular attention to export. If you ever want to change systems, you need to be able to take your history with you.

The bottom line

There is no single right answer. If you sell through one channel, work alone and the sheet takes little time, keep it and sharpen your stock routine. If you sell on several channels, share the work with others or keep chasing the same discrepancies, test whether the candidate software reduces your actual workload and discrepancies.

How UBC handles this See UBC capabilities →

← All articles