How to keep track of stock when you are the one running the place

There are four ways, and three of them work for a while

Keeping it in your head works, genuinely, and further than people admit. One person, a few dozen lines, goods they touch every day: the head is faster than any app and it is never out of battery. It stops the day somebody else starts serving customers, because a system that lives in one head cannot be handed over, and it stops when the number of lines passes what you can hold, which is lower than you think once you are tired.

Paper is the second, and it fails differently. It is honest at the moment of writing and useless a week later, because nobody adds up a notebook. Then the spreadsheet, which is where most small businesses land and where a lot of them should stay for a while. And then software, which is worth it at a specific point and not before.

The thing you are actually tracking is not the number

This is the part that makes the difference between a record that stays true and one that quietly drifts. What matters is not what is on the shelf today; you can count that any time. What matters is every CHANGE: three sold, twenty received, one broken, two taken for the shop itself.

A system that stores the change can answer why a number is what it is. A system that stores only the total can be wrong without anyone being able to see where it went wrong, which is how a shop ends up with a number nobody trusts and a stocktake nobody wants to do.

The habit matters more than the method

Every method above works if the entry is made at the moment the goods move, and every one of them fails if it is left until later. Later is where the box that came in short, the item used in the shop and the sale rung up on the wrong line all disappear.

That is the real test of any method: not whether it can produce a report, but whether it can be used with one hand, between customers, without sitting down. This is why a shop with an expensive system often has worse numbers than a shop with a notebook by the door.

When a spreadsheet stops being enough

Not at a number of products. At one of these four, and usually the first one:

• A second person needs to write in it. Two people in one spreadsheet is where the overwriting starts, and neither of them sees it happen.
• You need it where the goods are. A spreadsheet lives on a laptop, and stock arrives in a stockroom.
• You need to know what changed and who changed it. A spreadsheet holds the number that is there now, not the story of how it got there.
• You want to be told rather than to look. Nobody opens a file to check whether something is running low, so nobody finds out until a customer asks.

Doing it in Invenva

It is built around the change rather than the total. A product is added once, usually by scanning the barcode already on it, and after that every entry is one number: this many in, this many out. The total is worked out from those, so it can always be explained.

Each entry keeps who made it, when, and the customer or supplier when there was one, and entries cannot be edited afterwards. A mistake is fixed with an undo that writes its own opposite entry, so the history stays honest.

It works with no signal and syncs when there is one, which is what makes the stockroom possible, and a second person can be given goods in and goods out without being given prices or the ability to delete products.

Low stock and approaching dates arrive on their own, rather than waiting in a screen. The demo is a stocked shop with history in it and needs no account.