Inventory management for small business, without an ERP

Jul 3, 2026·6 min read

Most small businesses manage inventory in a spreadsheet until the day it visibly breaks: a stockout discovered by an angry customer, a count that no one trusts, an afternoon lost to reconciling two conflicting copies of the same file. The usual advice at that point is to buy an ERP, which swaps one problem for a worse one: months of setup and a hundred modules you will never open.

There is a middle path: a simple system built on five habits, run in about twenty minutes a week. Here is what it looks like.

Why spreadsheets quietly fail

• No history. A cell gets overwritten and there is no record of who changed it, when, or why. The count drifts from reality with no trail to follow back.
• One editor at a time. The moment two people update stock, you have conflicting copies and a manual merge.
• No connection to sales. Sell in a shop and online and the spreadsheet does not decrement itself. The end-of-day manual sync is where counts go to die.
• Silent errors. One broken formula or a mistyped SKU, and every number below it is wrong with nothing to flag it.

None of this hurts at 20 products. At 200 SKUs across two sales channels it becomes weekly firefighting.

The five building blocks

1. A single product catalog

Every product gets one SKU and one record: name, SKU, cost price, selling price, and reorder threshold. Duplicate records are the root cause of most count errors, so make the catalog the only source of truth.

2. Stock movements, not stock edits

Never simply change the number. Record a movement instead: stock in when a delivery arrives, stock out for a sale or damage, an adjustment for a count correction, a transfer between locations. Each movement carries a timestamp, a reason, and a person, which is what an audit trail actually is, and what lets you answer where did those 12 units go months later.

3. A reorder point per product

For each product, set the stock level that should trigger a new order, based on how fast it sells and how long the supplier takes. Fast movers from slow suppliers get generous thresholds; slow movers get lean ones that free up cash.

4. Locations

Shop floor, back room, warehouse: track where stock sits, not just how much exists. Half of all impossible counts are units sitting in the other location.

5. Small, regular counts

Instead of shutting down once a year for a full stocktake, count a small slice every week: your top 20 sellers, or one shelf. Correct differences with adjustments, and investigate patterns. Recurring variance on the same products usually means theft, receiving errors, or unrecorded damage.

A 20-minute weekly routine

1. Monday, 10 minutes: open the low-stock report and place purchase orders for anything below its reorder point.
2. On each delivery: receive the goods against the purchase order, so stock in matches what you ordered and what you were billed for.
3. Friday, 10 minutes: cycle-count one shelf or category and record adjustments with reasons.
4. Monthly: review inventory value and cost of goods sold, and discount slow movers before they become dead stock.

Signs you have outgrown the spreadsheet

• You learned about your last stockout from a customer, not from a report.
• Two people edited the sheet and you cannot tell whose number is right.
• You sell in more than one place and reconcile them by hand.
• Counts are off every single time, and the team has stopped trusting the file.
• You spend more than an hour a week just keeping the numbers straight.

What to look for in software (that is not an ERP)

If two or more of those signs sound familiar, you need software, not a bigger spreadsheet. The checklist: every stock change recorded as a movement with a full audit trail; low-stock alerts per product and location; purchase orders that receive stock directly into inventory; sales (invoices and POS) that decrement stock automatically; built-in reports for inventory value, low stock, and COGS; and roles, so staff can record movements without being able to rewrite history.

That list is, quite literally, the spec Invotory was built against: inventory, invoicing, expenses, and point of sale in one workspace, without the ERP modules a small team will never open.