Know what you own
Inventory management software: stock that keeps itself current
Almost every shop starts with a spreadsheet, and the spreadsheet is a genuinely good decision. It is free, everyone understands it, and for a few dozen products it is completely adequate.
What ends it is never a feature. It is that the spreadsheet does not change when the stock changes. Somebody has to update it after each sale, delivery and return, and the gap between the event and the update is the gap in which every decision you make is made from a wrong number.
Inventory management software closes that gap by making the stock figure a consequence of trading rather than a separate task. A sale decrements it. A delivery increments it. A transfer moves it. A write-off records the loss and says who recorded it. Nobody retypes anything, and the number on screen is the number on the shelf.
What you get
What this gives you
Every movement, recorded as it happens
Sales, returns, supplier deliveries, inter-location transfers, write-offs and stock-take adjustments all change the same figure, each with a timestamp and the person responsible.
Reorder levels that tell you, not the empty shelf
Set a minimum per product per location and get told what to buy before you run out, rather than finding out from a customer asking for it.
Cost prices, so margin is knowable
Stock carries what you paid for it, which is what turns a sales report into a profit report and makes 'which products actually make money' a question the system answers.
Variants and pack sizes done properly
Sizes, colours and flavours as variants of one product; cases that break down into units with the stock arithmetic handled, instead of two products that quietly disagree.
Stock takes as a check, not a discovery
Count, enter, and see the variance per line against what the system expected. A discrepancy becomes something you can investigate rather than the first time you knew anything.
Shrinkage that is visible
When every movement is attributed, the difference between what you bought, what you sold and what you hold stops being a mystery and starts being a number with a history attached.
When a spreadsheet stops being enough
There are three thresholds, and they are about coordination rather than size. The first is a second person: two people cannot both hold the current figure, and a shared file becomes a file with two versions and a conversation about which is right.
The second is a second channel. The moment you sell somewhere other than the counter, the spreadsheet has to be told about both, and the thing you are managing is no longer stock but the relationship between two records of stock.
The third is a second location. Per-location quantities in a spreadsheet are workable for about a fortnight; transfers between locations, which need to decrement one and increment the other atomically, are where it stops being workable at all.
If none of those is true for you, keep the spreadsheet. It is a real answer and buying software you do not need is its own kind of waste. If you want the intermediate step, a spreadsheet with a strict template — one row per SKU, columns for opening, in, out and closing, reconciled weekly — buys you another year and teaches you exactly which columns you actually use.
- One row per SKU, never one row per delivery
- Separate columns for opening, received, sold, adjusted, closing
- Record cost price alongside sell price or margin is unknowable
- Reconcile against a physical count weekly, not annually
- One person owns the file, or nobody does
How to stop losing stock in retail
Shrinkage has three sources and they need different responses, which is why 'we are losing stock' is not actionable until the system can tell them apart. Administrative error — goods received but never entered, sales rung up as the wrong product, returns not processed — is usually the largest and the easiest to fix. Supplier shortfall is the next, and is invisible without checking deliveries against the order. Theft is the one everyone assumes first and is often the smallest.
The single highest-value control is receiving against a purchase order. If goods are checked in against what was ordered rather than against the delivery note, short deliveries and wrong items are caught at the door instead of discovered at the count.
The second is attribution. When voids, discounts, refunds and adjustments record who made them, the pattern shows. Most of what looks like theft in an unattributed system is an untrained cashier repeating the same mistake, and finding that out costs nothing but changes the response entirely.
The third is frequency. An annual stock take tells you a number; a rolling count of a different category each week tells you where the number is coming from while you can still do something about it.
Cloud-based, multi-location and real-time
Cloud-based means the data lives on the vendor's servers and everyone with permission sees the same figures from anywhere — the shop, the warehouse, your kitchen table. The practical benefit is not the technology but that there is exactly one copy, and no version of the file on someone's laptop.
Multi-location means each location holds its own quantity, rather than everything contributing to one pooled number. This matters more than it sounds: pooled stock tells a customer an item is available when it is available two hundred kilometres away, and it makes transfers impossible to track.
Real-time is the claim to examine hardest. In a single system it is simply true — one figure, changed once. Where stock lives in one system and sales in another, 'real-time' means a sync, and a sync has an interval, a failure mode and a window in which the two disagree.
Compare
Spreadsheet, standalone inventory tool, or one system
| What you are comparing | Spreadsheet | Standalone inventory app | sell.ke |
|---|---|---|---|
| Updates when you sell | No — someone retypes it | Only if the POS is connected | Yes — the sale is the update |
| Multiple people | Conflicting versions | Yes | Yes, with per-role permissions |
| Multiple locations | Painful | Yes | Yes, with recorded transfers |
| Online store stock | Manual | Via an integration | Same figure, no integration |
| Margin reporting | If you maintain cost columns | Usually yes | Yes, per product and channel |
| Cost | Free plus your evenings | A subscription, plus the POS | One subscription, POS included |
Questions
Inventory management software — questions
What is the best way to manage store inventory?
Record movements where they happen rather than after the fact, so the count is a by-product of trading rather than a separate job. Then set a reorder level per product so the system tells you what to buy, and count a rolling subset of stock regularly rather than everything once a year. Those three habits matter more than which software you use — but they are very hard to keep up without software, which is the actual argument for it.
Is there a good Excel template for tracking store stock?
A usable one is simpler than most you will download: one row per SKU, columns for opening quantity, received, sold, adjusted and closing, plus cost price and sell price, reconciled against a physical count weekly. Avoid templates with a row per transaction — they look thorough and become unmanageable within a month. Be clear-eyed that any spreadsheet stops working the moment two people or two locations are involved.
What is the difference between inventory software and a POS system?
Inventory software tracks what you hold. A POS system sells it. Historically these were separate products connected by an integration, which is why many businesses run both and reconcile them. A unified system does both against one set of records, which removes the connection and therefore the reconciliation.
Can it handle stock across several branches or warehouses?
Yes. Each location holds its own quantity against a shared catalogue, transfers between them are recorded movements rather than a decrement here and a guess there, and reports run per location or across all of them. Multi-location is available from the Basic plan.
How often should I do a stock take?
Rolling counts beat annual ones for almost everyone. Count a different category each week so the whole shop is covered over a quarter, and count your highest-value and fastest-moving lines more often than that. The point is not the count itself but catching a discrepancy while its cause is still recent enough to identify.
Can I run more than one location?
Yes, from the Basic plan up. Locations share one product catalogue but hold their own stock, so moving goods between them is a recorded transfer rather than a re-count at both ends. Reports run per location or across all of them, and staff permissions are set per location — a branch supervisor does not need to see another branch's margins.
Can I bring across the products I already have?
Yes — bulk import from CSV or Excel, including photos, variants, pack sizes, prices, cost prices and opening stock counts. If what you have is a supplier price list rather than a clean spreadsheet, Amina can build the catalogue from a photo or a PDF of it, which is usually faster than retyping.
How much does sell.ke cost?
Plans run from USD 12/month for a single-location till to USD 115/month for unlimited scale, with the online store on your own domain included from USD 23/month. In Kenya the same plans are KES 1,499 to KES 14,999/month, billed in shillings. Every plan starts with a 14-day trial and no card, and there is no per-terminal licence and no commission on your sales. There is no hardware to buy either — sell.ke runs on a phone, tablet or laptop you already own.
Does it keep working when the internet drops?
The counter does. Offline mode keeps taking sales, printing receipts and reserving stock while the connection is down, then reconciles everything when it returns — so a bad afternoon costs you connectivity, not revenue or a gap in the record. The parts that are inherently online stay online: card and mobile-money authorisation, tax-authority submission, and the storefront itself all need a live link.
Read next
The other pages that answer the question you are probably about to ask.
Multi-location inventory
Per-location stock, recorded transfers, and reports that split or combine.
How to keep track of stock
Six habits that work at any size, and when a spreadsheet stops being enough.
All-in-one POS, inventory & online store
One system for the counter, the stock and the website — not three that sync.
POS that syncs with your website
Real-time stock between counter and storefront — because they are the same system.
POS systems explained
What a point of sale system is, what it replaces, and how to choose one.
Cloud POS
One copy of your data, reachable from anywhere, with no server in the back office.
Go deeper on a feature
Stock you can trust
Batch and expiry, serial numbers, reorder levels, stock takes and the formulas behind them.
Buying, suppliers and approvals
Purchase orders, goods-received notes, supplier bills and the cost figure every margin depends on.
Reports and real accounting
Double-entry books — trial balance, P&L, balance sheet — not a CSV export to somebody else's software.
See it for your trade
Try it on your own products
Fourteen days, no card. Import your product list or let Amina build it from a photo of your price list, and run it alongside whatever you use now.