Still running HK retail stock on Excel in 2026? Three common cracks
Still managing Hong Kong retail stock in Excel? Three common cracks: multi-editor chaos, stocktakes that punish, and tills that never talk to the sheet, plus when to move off the spreadsheet.
Customer asks for an item. Colleague opens stock_final_really_final_v3.xlsx and says two left. You check the shelf. None. Into 2026, plenty of Hong Kong SME shops still run inventory on Excel (or a shared sheet). Not because owners cannot learn systems, but because “open first, sell first” made a spreadsheet the fast, cheap start. Once the floor gets busy, headcount grows and SKUs get messy, the cracks become stock-outs, dead stock and month-end nightmares.
Most shops that “run stock on a sheet” have hit at least one of these three.
Crack one: many editors, no single truth
Manager edits quantity. Part-timer edits price. Weekend event saves a new file. Which copy counts? When shelf and sheet disagree, people trust the file they last touched.
More common: goods-in written, sales never deducted; or sales deducted, returns never added back. Excel does not talk to the till on its own. Someone pastes or imports by hand. Miss once and every “available to sell” figure carries a bias. Bias does not shout. It waits until a customer asks and someone says “wait, weren’t there still some?”
Crack two: stocktake becomes punishment, not calibration
Sheet-run shops often stocktake once or twice a year, overnight, because every line must be matched by hand. Huge variances appear and nobody can say theft, missed sale, or “the sheet was wrong from the start”. Stocktake turns emotional: blame staff, blame the file, blame yourself for no time.
Healthy stock control leaves a trail on every day move. Stocktake only calibrates; it is not archaeology. If every count feels like reopening a cold case, daily records are not trustworthy. A prettier Excel template will not save you.
Crack three: “bestsellers” on the sheet cannot drive decisions
Owners want to know which lines earn, so they add columns: cost, price, units sold. Costs go stale, promo prices never update, consignment mixes with own stock, and the margin you calculate is a comfort blanket. With Hong Kong rents and wages, a wrong hot-seller call means you replenish the wrong lines and choke the wrong shelf space.
Excel is fine for analysing an export. It is a poor live inventory system. Separate “record” from “analyse”: the first should move with sales; the second can use a sheet or a report for trends.
If replenishment and purchase orders also sit off the sheet, a busy weekend event makes shelf quantity and sellable quantity argue even louder. Get “sell = deduct, receive = add” right before you argue about pretty dashboards.
When to leave the spreadsheet
Watch for signals: SKU count past what you can reconcile by hand each week; a second till or a second shift; consignment, pre-orders or event-day volume; or you no longer dare let a new hire touch that file. Hit two of those and it is usually worth connecting stock to the till.
No mythology required. Every sale should auto-deduct, goods-in should leave a record, stocktake variances should have reasons you can chase. You can still export to Excel for your own analysis. The source of truth just stops being that v3 file. Retail systems such as Stribe POS pull inventory back onto the same path as the checkout, instead of leaving it as “another spreadsheet”.
A week of dual-running without drama
Moving off Excel does not mean deleting the spreadsheet on Monday morning. A calmer path: pick your top-selling category (or one till) and dual-run for one or two weeks. Every sale deducts in the new system; keep the sheet as a read-only mirror you update from an export, not by hand edits. Compare shelf spot-checks nightly for that category only. When the till-side count wins three nights in a row, expand the next category.
Owners often fear “big bang” cutovers because one bad Saturday would hurt. Dual-running a slice of the range turns the risk into a controlled test. It also surfaces training gaps early: who still edits the old file, who forgets to receive goods in. Bring those notes to a Stribe POS demo; implementers would rather hear your real friction than a polished wish list.
Related reads: High rent, high wages: how small shops see which SKUs actually earn and Consignment without the spreadsheet
What’s next
If Excel is still carrying stock, open the latest file and ask: did last week’s sales all deduct? Who may edit numbers? Did the last stocktake variance get a reason? To move toward inventory that moves with the till, book a Stribe POS demo or enquire with Retail Sale Solutions. Transition at the pace of your category and shop size.
