Getting started

When does a business outgrow Excel for stock control?

By the Ceazr team · Published · Reviewed

Short answer

Excel stops working for stock control when more than one person, or more than one location, needs to update the same numbers. The usual signs are counts that never match the sheet, nobody knowing who changed a figure, and items running out because no one saw them getting low. If you have a second branch, several staff recording movements, or products with expiry dates, it is time to move.

What Excel does well

A spreadsheet is a sensible place to start. It is free, everyone knows it, and you can shape it to fit your business in an afternoon. For one shop, a few hundred products and one person who does all the stock work, a well-kept sheet can be enough.

The trouble is that a spreadsheet only records what someone typed. It doesn't know who typed it, why, or whether the same item was sold at the same moment somewhere else. Those gaps don't matter when you are small. They matter a lot once you grow.

Signs you have outgrown the spreadsheet

SignWhat it costs you
Counts rarely match the sheet, and nobody can say whyYou can't tell theft from typing errors, so you can't fix either
Several copies of the file exist, or people overwrite each otherNobody trusts the numbers, so they check the shelf instead
You can't see who changed a figure, or whenLosses go unexplained and nobody is accountable
Items run out before anyone noticesLost sales and rushed, expensive reorders
Stock moves between branches on WhatsApp messagesTransfers go missing between sending and arriving
Expired stock turns up on the shelfWrite-offs, and in food or pharmacy, a safety risk

If two or more of these sound familiar, the spreadsheet is now costing you more than software would.

Why it gets worse with every new location

Each new branch adds people, and each person adds another chance of a missed row or an overwritten cell. You end up with one sheet per branch, or one giant sheet that only one person dares to edit. Moving stock between branches is the weak point: the sending branch takes it off, the receiving branch forgets to add it, and the stock vanishes on paper even if it is sitting on a shelf.

Product count matters less than people think. A single shop with thousands of lines can cope in Excel. Two branches with five staff each usually can't. Our guide on stopping stock going missing between branches covers this in detail.

What to look for when you move

  • Separate stock per location, with a combined total when you need it.
  • A login for every person, so each change has a name on it. Avoid pricing that makes you share logins.
  • An [audit trail](/glossary#audit-trail) that records who changed what, when and why.
  • Recorded [transfers](/glossary#stock-transfer) between locations instead of two separate edits.
  • [Reorder points](/glossary#reorder-point) and low-stock alerts.
  • Batch and expiry tracking if you sell anything that goes off.
  • Spreadsheet import, so you don't retype your product list.

Our multi-location inventory software checklist goes through these questions in more depth.

What to set up first

You don't have to use every feature on day one. Start with the steps that fix the most common spreadsheet failures, typing errors and late reorders, then add the rest:

  1. Scan instead of typing. Use barcode scanning when you receive deliveries and count stock. Every typed entry is a chance to pick the wrong product, quantity or location.
  2. Set reorder points for your best sellers. Start with the products you can least afford to run out of and add the rest over the following weeks. Our guide on setting reorder points shows the formula.
  3. Record transfers and set permissions. Move stock between branches as recorded transfers, and limit each person to the locations they work at.
  4. Connect your online store, if you have one, so website stock follows what is on the shelf and you stop selling items you no longer have.

Moving your spreadsheet into Ceazr

You don't have to rebuild anything by hand. Export your sheet as it is, tidy the product names and codes, and import it. If your sheet is messy, the team can import it for you. Our guide on how long it takes to switch inventory software explains how to plan the change-over.

Questions people also ask

How many products is too many for Excel?
There is no fixed number. The number of people and locations updating the sheet matters more than the number of products. One person with a large catalogue can manage; several people across branches usually can't.
Can I keep using Excel alongside inventory software?
You can keep Excel for analysis and one-off reports, but stock levels should live in one place only. Two sources of truth quickly drift apart.
What does automated stock tracking actually mean?
Stock levels change when a sale, delivery or transfer is recorded, so nobody retypes numbers into a sheet. Alerts fire when an item falls below its reorder point, and every change is logged with who made it, when and why.
Will I have to retype my product list?
Not with Ceazr. You import products, locations and opening stock from a CSV or Excel file, or send the sheet to the team and they import it for you free.

Try Ceazr free for 14 days. No card needed.