Inventory management in Excel: when the spreadsheet stops working

Most trade and construction businesses start with a spreadsheet. It is free, everyone knows it, and early on it does the job perfectly well. The problem is that the shift from “this works” to “this lies” never happens on a particular day. It creeps up on you.

Below we go through when Excel is genuinely enough, six signs that you have passed the limit, what the gap costs in kroner using your own numbers, and how to move across without losing a week to it.

What is actually wrong with inventory management in Excel?

A spreadsheet shows what was ordered. It does not show where the goods actually are, who has them, or what is already reserved for a job.

That is not a weakness in Excel. Excel is an excellent tool — for calculating. A warehouse is not a calculation. It is a state that changes every hour, and a spreadsheet is a photograph of it at one moment.

Concretely, there are three things a spreadsheet cannot do, however well it is built:

• Record who took something, and when. The sheet holds a value, not a history. When the number is wrong, there is no trail back to where it went wrong.
• Update where the item actually moves. The item leaves on site, out of the van, at half past six in the morning. The sheet is updated in the office, by someone else, later.
• Separate “in stock” from “reserved”. The last set is physically on the shelf but promised to the job starting Monday. To the sheet, those two states look identical.

You recognise the result from the shop floor, not from the numbers: the carpenter stands at the shelf looking at a figure that says three, when there is one. The plumber rings two colleagues to work out who took the mitre saw last Friday.

When is Excel genuinely good enough?

Let us be honest about this first, because not everyone needs to switch. Excel is fine as long as all four of the points below hold true for you:

1. One person handles everything in and out — nobody else helps themselves.
2. Stock sits in one place, and that person is physically there when goods move.
3. You have few line items and low turnover.
4. Nothing is lent out and returned — things are consumed, they do not circulate.

If all four hold: keep the spreadsheet. There is no reason to pay for a system that solves a problem you do not have.

But notice what points 1 and 4 really say. The moment the business has two people fetching their own materials, or starts lending out tools that are meant to come back, the assumption is broken. Most trade businesses pass that point long before they notice.

Six signs the spreadsheet no longer holds

None of these are about people being careless. They are about the sheet having last been updated by someone who was not in the warehouse when the goods moved.

1. Someone rings around to find out who has the tool

The phone round is the clearest indicator there is. It means the answer is not written down anywhere — it lives in colleagues' memory. And memory does not scale.

2. You buy something you already own

The fitter is on site, the drill is missing, the job has to get done. So a new one is ordered. It is an entirely rational decision in the moment — and it hides the cause just long enough that nobody ever addresses it.

3. The stock count is used to explain discrepancies, not fix them

If half a day of the count goes on discussing why the number is wrong, you are no longer counting the warehouse. You are auditing the spreadsheet.

4. The sheet has an “owner” — and everything stops when they are on holiday

A system only one person can operate is not a system. It is a dependency. The question is not whether that person leaves, but when.

5. Withdrawals get logged at the end of the day, from memory

Anything recorded afterwards is recorded approximately. And approximate numbers produce precise errors, because nobody treats them as approximate.

6. Nobody trusts the number, so everyone walks over and checks

This is the end of the line. Once the sheet has become a hint that must be verified on the shelf, you are carrying both the cost of maintaining it and the cost of not having it.

What does a slightly wrong spreadsheet cost?

The uncomfortable thing about this cost is that it never appears on an invoice. Nobody books “searching” as a line in the accounts. It disappears a quarter of an hour at a time, out on the projects — and a duplicate purchase does not look like loss, it looks like a perfectly normal materials order.

Run the numbers with your own figures:

The figures above are a calculation, not a claim about your business — swap the minutes, the rate and the count for what you actually have. The point is not the total. The point is that none of the three lines appears in the accounts as an error. They appear as wages, as materials and as mileage — and they grow in step with activity, so they read as growth.

And that is before the expensive version: the day the equipment does not turn up at all and the whole crew stands still. One such day eats more than a full year of search minutes.

What does an inventory system do that a spreadsheet cannot?

The difference is not that the system has more fields. The difference is that the system knows who and when, and that it is updated in the place where the item actually moves.

That last row is worth a second thought if you keep equipment in work vans. You cannot claim for a tool you never recorded owning.

How do you move from spreadsheet to system without losing a week?

The most common reason businesses stay in Excel is not the price. It is the assumption that switching requires a project. It does not, if you do it in this order:

1. Do not migrate everything. Start with what actually goes missing: tools and machines, plus the 30–50 line items you use most often. The rest can come in as it gets touched.
2. Tidy the sheet before you import. One row per item, one column per attribute, no merged cells, no colour codes that carry meaning. Mess in the sheet becomes mess in the system.
3. Label physically first. QR or barcode on the shelf and on the equipment. Without labels, logging is still something people type — and then you are back to memory.
4. Set one day as your zero point. Count once, and let the system be the truth from that day. Running sheet and system in parallel “for a while” is the surest way to fail — you end up maintaining two warehouses and trusting neither.
5. Log withdrawals where the item moves. On the phone, at the moment something is taken. If logging still happens at the PC in the evening, you have changed tools without changing the problem.

Expect it to take a few days — not because the system is slow, but because labelling takes as long as labelling takes.

What should you look for in an inventory system for trade and construction?

Whichever supplier you end up with, this is the checklist that separates a system people use from one that sits unused:

• It has to work on a phone, in the field — not as a website squeezed onto a small screen.
• Scanning by QR code, barcode or NFC. Logging that requires typing does not get done.
• Loans with a responsible person and a return date, not just a stock level that moves up and down.
• History per unit — what has happened to this particular machine.
• Role-based permissions, so the apprentice and the managing director see and can do different things.
• Reporting per project, so materials land on the right job and actually get invoiced.
• Export or an API, so your data is still yours if you ever want to move on.

And one practical rule to finish: test with real stock for a couple of weeks before you decide. An inventory system is not judged in a demo. It is judged on a busy Thursday, by a fitter wearing gloves.

Frequently asked questions

Can you run inventory management in Excel?

Yes, and for the smallest businesses it is often the right choice. Excel works as long as one person handles everything in and out, stock sits in one place, and nothing is lent out and returned. Break one of those assumptions and the sheet starts showing something other than reality.

When should a trade business move from Excel to an inventory system?

When more than one person fetches materials themselves, or when tools circulate between projects and vans. The practical signal is the phone round: the moment someone has to ring a colleague to find out where something is, the lack of a system costs more than the system.

Do we have to enter the whole warehouse at once?

No, and it is usually a bad idea. Start with tools and machines — that is where the money disappears — and the 30–50 line items you use most. The rest comes in as items get touched.

What happens to the data we already have in the spreadsheet?

It can be imported, provided the sheet is tidy: one row per item and one column per attribute. The tidying usually takes longer than the import itself, and it has to be done either way.

How long does the switch take?

The setup takes hours, not weeks. What takes time is physically labelling shelves and equipment, and counting once to set a zero point. Set aside a few days, and pick a week without a delivery deadline on top.

Is an inventory system worth it for a business with few employees?

It depends on whether equipment circulates, not on headcount. Five fitters sharing machines across four projects have a bigger tracking problem than twenty people at one fixed location. Run the search-time and duplicate-purchase numbers from the table above and compare them with the price.

In short

A spreadsheet is not the wrong tool because it is simple. It is the wrong tool once your warehouse starts changing faster than anyone can write it down — and that happens the moment more than one person takes stock out somewhere other than at the PC.

The system does not take responsibility away from your people. It gives them the chance to do the job without losing half a day looking for something the business already owns.

How many of the six signs did you recognise in your own warehouse?