Inventory management system: why the year-end count always surprises you

Once a year someone closes the business for a day, takes a sheet of paper, and counts.

By the end of the day it turns out there is less than the system said for some items, and more for others. The numbers are corrected, there is a sigh, and things move on. Next year it will happen again.

That gap almost never starts on the counting day. It starts when the inventory moves in the real world, and no one told the system about it in time.

Inventory in a service business is not inventory in a shop

What we read about inventory management is usually written for retail: uniform items, a barcode, and a sale that subtracts one unit.

A service business that holds inventory works completely differently:

• The item is consumed as part of a job, not as part of a sale. Material used during a treatment, a part that was installed, or a kit that was opened do not go through a register.
• Some items are measured in units that are not whole: millilitres, metres, or grams. An item purchased in a package and consumed in parts requires a base unit and a conversion factor.
• Some of the inventory is allocated in advance to a customer. It is physically with you, but it is already designated for a particular order.
• Expiry and batch change the meaning of the balance. Material that has expired is not available inventory, even if it is still sitting on the shelf.

A system designed around "sold, one came off" will fit a service business only partially. That partial fit is a permanent source of gaps.

The practical rule: before choosing a system, describe how an item comes in, moves between locations, and is consumed on the job.

The three reasons the number in the system does not match the shelf

An unrecorded movement

An employee took an item to finish a job. It did not go into the system, because the customer was waiting.

This is not necessarily negligence. It is a system that requires a separate action from the work itself, and any separate action gets pushed aside when there is pressure. Inventory movement should happen as a result of the work, not as a report on it. If closing a job does not subtract what was consumed, the number in the system will be accurate only until the next job.

An undefined unit of measure

The same item is purchased by the carton, counted in packages, and consumed in units. Everyone who touches it speaks in different terms.

Without a defined base unit and conversion factors, every report will be correct in the eyes of the person who produced it and wrong in the eyes of the person reading it.

Inventory on the way, reserved inventory, and damaged inventory

Three states that are neither "yes" nor "no".

Ordered from the supplier and not yet arrived. Arrived and allocated to a particular customer. Arrived and damaged and waiting for a credit. A business that holds all three under the same number may order inventory that is already on its way, or promise a customer an item that is reserved for someone else.

The practical rule: one balance is not enough. Separate available, on the way, reserved, damaged, and expired.

What an Inventory Management System Must Have

• A unique identifier per item, not just a name. A name typed in several ways creates several versions of the same item.
• One base unit and conversion factors for every form of purchase or consumption.
• Movements, not just balances. The balance should be the result of movements, so it is possible to understand when and why it changed.
• Location: warehouse, technician's vehicle, or a cabinet in a treatment room. An item that exists in the system but whose location is unknown is hard to find in practice.
• A link to a job or customer on every outgoing movement. Without this link it is impossible to know how much material was consumed for a particular job.
• An accountable user for every deviation. A general alert is not a process; you need to know who checks and who approves.

The link to the job is the point that separates a list of items from inventory management. This is also where the topic connects to automation for businesses: when a connection between tools stops being enough: good automation does not just move data, it triggers an action from an event that already happened in the business.

The practical rule: every field in the system must answer an operational question: what moved, where it is, who it belongs to, and who handled it.

Reorder point: where inventory becomes cash flow

Inventory is money sitting on a shelf. Too much of it ties up money, and too little of it turns work away.

The tool that balances the two is the reorder point: a quantity below which the system alerts or opens a task to order from the supplier.

What we see defined incorrectly again and again:

• An identical reorder point for all items. An item that arrives quickly and an item that arrives after a long wait cannot share the same threshold.
• Ignoring variable lead time. A supplier that arrives at a different time in a busy season requires a different calculation.
• An alert with no owner. A message that reaches everyone may remain without a decision.

A correct definition rests on average daily consumption, actual lead time, and a safety margin derived from volatility. These data exist only if the movements were recorded.

The practical rule: the reorder point is an operational decision, not a number copied to the entire product catalog.

Why a periodic count does not solve the problem

An annual count corrects the number for one day a year. For the rest of the year, decisions are made based on a balance that may be wrong.

The more practical approach is cycle counting: a small group of items is counted every week in rotation. Expensive or volatile items are counted more frequently, and stable items less frequently.

The advantage is not only the accuracy of the number. A gap discovered close to when it formed makes it possible to check which job, transfer, or receipt created it. A gap discovered months later mainly makes it possible to correct the balance, without understanding the cause.

The practical rule: count a little and often, and document every adjustment with a clear reason.

When inventory needs to sit in the same system as the jobs

Some businesses get by with a spreadsheet. If the items are few, consumption is slow, and there is no dependency between inventory and what you promise the customer, there is no point in building a complex system.

The need changes when one of these holds:

• What you promise the customer depends on the availability of an item.
• The price you charge includes materials, and you want to know the real profitability of the job.
• There is more than one location, or inventory that travels with field staff.
• The same item is consumed in jobs and also sold separately.

In each of these situations, inventory that sits in a separate tool forces someone to update two systems. This is the same point where it is worth reading also about accounting software: beyond the books and the reports: a good system does not just store data, it connects it to the decision and to the work actually being done.

At alcyone14 we build inventory management as part of the same system that holds the customers and the jobs. Closing a job can record what was consumed, assigning an item to a customer prevents double allocation, and a drop below the threshold creates a task for a specific person.

Ready to know what you really have on the shelf?

In the businesses we see, the gap is not in the count, it is in the movements that were not recorded. In a 20-minute call we will map together where your inventory moves without anyone reporting it, and we will examine together whether a spreadsheet is enough for you or whether your process requires a system built around it. You can start on the operations management in one system page.

Frequently asked questions

What is the difference between an inventory management system and an Excel spreadsheet?

Excel holds a balance. A system holds movements from which the balance is derived. The difference shows up the moment someone asks why the number changed: in a spreadsheet there is no answer, because the previous value was deleted. In a system there is a row with who, when, how much, and on which job.

What do you do when the actual inventory does not match the system?

You correct it with a documented adjustment movement, with a reason, and not by editing the balance. The difference is not formal. An adjustment movement makes it possible to see, half a year later, which items deviate systematically, and that is exactly the information that leads to fixing the process.

Is a barcode needed?

Not always, and it is usually not the first investment. A barcode streamlines recording that is already happening. It does not solve a situation where the recording does not happen at all. First you make sure that an inventory movement is derived from the job, and only then is it worth speeding up the intake.

How do you manage inventory that is with field staff?

You define each vehicle or kit as a separate location. A transfer from the warehouse to the vehicle is a movement between locations and not consumption, and consumption is recorded only when the item was installed or used at the customer's site. Businesses that skip this separation discover inventory that disappears the moment it goes out the door.

What do you do with items that have an expiry date?

You manage them at the batch level rather than the item level, and set an alert in advance based on the time range in which they can still be used. An item with an expiry date that is recorded as regular inventory inflates the inventory value in the reports and creates a surprise at the end of the year.

Where do you start if today there is no inventory management at all?

Not with all the items. You start with the top decile that represents most of the value or most of the delays, define units and movements for it, and expand from there. Trying to set up full inventory in one day requires a full count before there is a working habit.