Picture a parts business run out of a warehouse the owner’s had for eleven years. Smart operator, good margins, knows his customers by first name. Ask him how he knows what’s on the shelves and he taps his temple and laughs. Then he pulls up a spreadsheet that, by his own admission, was last fully reconciled “around tax time.”
He’s not lazy. He’s busy, which is different. The count lives in his head, and the spreadsheet is a thing he updates when he remembers, which is about as often as anyone updates anything they have to remember to do.
Here’s the part that should bother you. That setup works great right up until it doesn’t, and you don’t get to pick the day it stops.
Think about driving a car with a piece of duct tape over the fuel gauge. You can do it. People did it for decades before gauges were standard. You learn your car, you count the miles, you keep a rough number in your head, and most days you’re fine. You pull in and fill up before it gets dicey.
Then one day you’re running late, you’re thinking about the meeting, and you coast to a stop on the shoulder. The car didn’t break. The gauge was never broken. You just had no way to see the one number that mattered until it was too late to do anything about it.
Inventory by memory is the taped-over gauge. You feel in control because most days you are. You know roughly what’s moving. You can eyeball the busy shelf and tell. But “roughly” and “most days” are doing a lot of heavy lifting in that sentence, and the day they stop covering for you is the day a customer wants the thing you swore you had three of.
The four ways it costs you, none of them obvious
The expensive part of this isn’t the dramatic out-of-stock moment. It’s the slow leak you stop noticing because it’s always been there.
You over-order. You’re not sure if you have the part, ordering more feels safer than checking, so you order more. Now you’ve got cash sitting on a shelf in cardboard.
You run out of the thing somebody wants right now. They needed it today, you didn’t have it, and they bought it from the guy down the road who did. You’ll never see that sale on a report because it never happened. It’s the most expensive kind of loss, the kind that doesn’t show up anywhere.
You sit on dead stock. There’s a corner of every warehouse where money goes to nap. You bought it, it didn’t move, and now it’s just there, slowly turning into a tax write-off three years from now. That’s cash you could be using, parked.
And the count never matches. You do the physical count, the sheet says one thing, the shelf says another, and you spend a Saturday afternoon figuring out which one is lying. Spoiler, they’re both a little bit lying, because the sheet was a guess and the shelf got picked over since the last guess.
None of these are catastrophes on their own. That’s why they survive. They’re small enough to absorb and frequent enough to feel normal.
When the gauge lives in one person’s head
Here’s the one that actually keeps owners up at night, once they let themselves think about it.
The knowledge is a person. When that person is on vacation, or out sick, or finally takes the two weeks they’ve earned, the business goes half-blind. Somebody calls asking if you’ve got it, and the answer is a shrug. You can’t run a real promotion because you can’t trust the count. You can’t train the new hire on the stock because the stock isn’t written down anywhere they can read, it’s written down behind someone’s eyes.
That’s not a knock on the person. They’re often the best employee you have. It’s a knock on the setup, because you’ve made one human being a single point of failure for the question your whole business runs on. What do we actually have?
The fix is boring, and that’s good
The honest version of the fix isn’t exciting. You want the number to be current without anyone having to remember to make it current. So you track stock as it actually moves. Something comes in the door, the count goes up. Something gets sold or used on a job, the count goes down. The truth lives in the system because the system watched it happen, not because somebody sat down once a month to reconstruct it from memory and receipts.
Once the number is real, the rest gets easy. The system can wave a flag when you’re getting low on something, before you’re standing there empty-handed in front of a customer. It can show you the stuff that hasn’t moved in a year, so you can finally see the cash you’ve got napping in the corner. You stop guessing and you stop over-ordering, because checking is now faster than worrying.
Now the warning. Do not build the 200-field monster. I’ve watched people try to track every washer and every label, and what they build is so much work to maintain that nobody maintains it, and a system nobody updates is worse than the spreadsheet, because at least the owner knew the spreadsheet was a guess. Track the things that actually cost you when you’re wrong about them. The expensive items, the fast movers, the parts a customer walks over. Leave the penny stuff alone. A small system people actually keep current beats a complete one that rots.
The point isn’t the software
You can run a business on a gauge in your head. Plenty do, for years. The question isn’t whether you can. It’s what you want to be doing with the part of your brain that’s currently holding a parts count, and what happens to the place when that brain takes a Tuesday off.
If you’re holding stock and the real number lives in one person’s head and a sheet that’s honest about as often as it’s updated, that’s worth a conversation. We build systems that track what you’ve actually got, owned by you, no tape over the gauge. If you want to talk through what that looks like for your shelves, grab a time here: https://app.allenapptools.com/book