I stopped believing my inventory spreadsheets

Institutional Visibility

I stopped believing my inventory spreadsheets

When we track the birth and death of an object but ignore its life, we turn our organizations into graveyards of ghost assets.

The Ghost Ships of 1845

In , Sir John Franklin departed from England to chart the Northwest Passage. He brought two ships named Erebus and Terror. He also brought 8,000 tins of preserved food.

8,000 TINS

TOXIC SEALS

The Royal Navy tracked the quantity (8,000 cans) but ignored the quality (failed seals). The records verified delivery; they could not verify survival.

A man named Stephan Goldner supplied these tins to the Royal Navy. Goldner secured the contract because he was the lowest bidder. He produced the supplies in a factory located in Moldavia. The Navy kept records of the purchase.

They recorded the delivery of the tins to the ships. They did not record the quality of the seals on the tins. The seals failed during the voyage. The food inside became toxic. The men died because the records only tracked the arrival of the cans. The records did not track the condition of the contents over time.

The Thursday Afternoon Vacuum

It is on the last Thursday of a notice period. Rachel sits at her desk for the final time. She looks at an HR checklist on her monitor. The checklist asks for the return of her laptop. It presents a simple choice between yes and no.

Rachel does not have the laptop. She handed the device to a colleague ago. This transfer happened during a team move on the fifth floor. She remembers the colleague had a first name. She remembers the colleague sat by a window on that floor.

The window seats on five are now a meeting pod. The colleague left the company last summer. The checklist remains on the screen. It waits for a response. Rachel sends an email to the IT department. She explains the situation to a junior technician.

ASSET #L-7742

Missing from Register

Issued to:

Rachel (3 Years Ago)

Current Location:

Unknown [Window Seat]

The technician checks the master asset register. The register shows the laptop was issued to Rachel ago. It shows the original purchase price. It shows the date of the warranty expiration. The register contains no information about the team move. It contains no record of the handoff at the window seat.

Integrity vs. Information

I used to believe that inventory management was a problem of honesty. I thought employees kept equipment out of spite. I assumed people were careless with company property. I was wrong about this. Most people want to follow the rules. They want to return what they owe.

The problem is not a lack of integrity. The problem is a lack of information. We build careful records at the start of a relationship. We build careful records at the end of a relationship. We build no records in the middle. The middle is where the work happens.

The organization creates an information vacuum. It then asks the departing employee to fill that vacuum. This is a form of information tax. The company did not track the movement of the laptop between floors. It did not track the movement of the laptop between sites.

The Fiction of Accounting

My friend Jackson D. is a bankruptcy attorney. He manages the liquidation of failing businesses. He enters offices after the lights have been turned off. He holds a list of assets from the accounting department. The list says there are 412 laptops in the building.

Accounting List

412 DEVICES

Actual Inventory

180 DEVICES

The “Accounting Fiction”: Jackson often finds less than half of the assets listed on the master register.

Jackson often finds only 180 devices. He finds them in places the list does not mention. He finds them in breakroom cupboards. He finds them under piles of old marketing brochures. The accounting list is a work of fiction. It is a record of what should be there. It is not a record of what is actually there.

Jackson tells me that assets move like water. They flow to the point of least resistance. A developer needs a second monitor. He takes one from an empty desk. A manager needs a laptop for a new hire. She gives him a spare device from her pedestal. These movements are efficient for the work. They are invisible to the system.

The Handoff at the Pod

The internal move is the greatest enemy of the asset register. Departments reorganize their seating plans. Teams shift from the fourth floor to the second floor. People pack boxes and carry them to new desks. They do not update a central database when they move a docking station.

They do not call IT to report a change in chair location. The equipment follows the person. The record stays with the old floor plan. We act surprised when we cannot find the equipment later. We blame the person who moved. We should blame the system that failed to watch.

The laptop Rachel gave away is likely still in the building. It sits in a drawer on the third floor. It belongs to a different department now. No one knows how it got there. The current user thinks it was always there. The IT department thinks it is with Rachel. The HR department thinks it is a missing line item.

The Hidden Tax of Searching

40

Rachel’s Email

30

Tech’s Search

20

Manager’s Chat

90 Minutes of Labor spent searching for a 3-year-old machine.

This lack of visibility has a financial cost. Companies buy new equipment because they cannot find the old equipment. They pay for software licenses on devices that are in storage. They spend hours of labor searching for missing hardware. The labor cost of the search often exceeds the value of the item.

Rachel spent forty minutes writing emails about her missing laptop. The technician spent thirty minutes checking the register. The manager spent twenty minutes discussing the loss. This is ninety minutes of time spent on a three-year-old machine.

Tracking the “Hops”

The solution requires a change in perspective. We must track the “hops” of an object. An object enters the building through the postroom. It moves to a locker. It moves to a desk. It moves to a different site. Each of these movements is a transaction.

A transaction needs a record. We need a digital chain of custody that follows the item. This is why organizations use

internal package tracking software

to bridge the gap. They record the moment an item changes hands.

They do not wait for the end of the year to count the boxes. They count the movements as they happen. I once thought that technology would make these problems disappear automatically. I believed that chips and sensors would solve everything. I was wrong about that too.

Technology only works if it matches the way people behave. People do not want to fill out complex forms. They do not want to log into a portal every time they move a mouse. They need a system that is as fast as the move itself. They need to scan a code and walk away. The record must be a byproduct of the action. It should not be a separate task.

The Relationship Cost

Rachel finally closes her laptop. She leaves it on the desk. She has not checked the box on the HR list. She decides to leave it blank. She feels a sense of failure. She has been a good employee for . She has met her targets. She has helped her team.

Now she is leaving under a cloud of missing hardware. The company has turned her exit into a negotiation. It is a negotiation over a piece of plastic she does not have. The organization will eventually write off the cost of the laptop. It will disappear from the balance sheet.

The real loss is the relationship. Rachel leaves with a bad taste in her mouth. The company leaves with a hole in its data. Both parties are victims of the middle. They are victims of the period between the hire and the fire.

A Map That Moves

We must stop treating the middle as a dark age of information. We must start seeing the office as a series of movements. The laptop sits in a drawer that the checklist cannot see.

“When we track the arrival but ignore the move, we turn our employees into ghosts of their own equipment. We ask them to remember the location of a ghost. We do this while they are trying to say goodbye.”

The office is a living map. It changes every hour. A spreadsheet is a photograph of a map that has already been burned. We need the map to move with the people. We need to see the hop from the window to the pod. If we do not see the hop, we will never find the laptop.

A business is a collection of things in motion. It is not a collection of things in a list. When we understand the motion, we understand the business. Rachel walks out of the building. She does not look back. She leaves behind a problem that was never hers to solve.

The company will spend the next month looking for a laptop that is already in use. They will find it eventually. They will find it when the next person leaves. The cycle will begin again. We can break the cycle by watching the middle. We can start by scanning the box at the door. We can continue by scanning the box at the desk. The truth is in the movement.