What inventory management actually means
Inventory management is the process of tracking the products you buy, hold, and sell — so you always know what is in stock, what is running low, and what is not selling. For a small business, it is the difference between confidently telling a customer "yes, we have that" and apologetically saying "let me check the back." Good inventory management answers four basic questions at any moment: what do I have, where is it, what did it cost me, and when do I need to reorder. It applies to anyone who sells physical goods — a craft maker on Etsy, a corner shop, a wholesale distributor, or a service business that resells parts. The size of your operation does not matter; the discipline does.
Why small businesses get this wrong
Most small business owners start by tracking inventory in their head. That works when you have ten products. By thirty, you are selling things you do not have and ordering things you already do. The two most common failure modes are stockouts (running out of a popular product and losing the sale) and overstock (tying up cash in items that sit on a shelf for months). Both quietly drain profit. Stockouts cost you customers — research suggests shoppers who hit an empty shelf often go elsewhere instead of waiting. Overstock costs you cash flow and storage space, and the longer items sit, the more likely they are to get damaged, expire, or become irrelevant. The fix is not complicated software. It is a simple system you actually use.
The data you need to track for every product
For each item you stock, capture five things: a unique SKU or product code, a clear product name, the cost price (what you paid), the sale price (what the customer pays), and the current quantity on hand. Optional but useful: the supplier name, the lead time to reorder, and a reorder point — the stock level at which you should place a new order. SKUs matter more than people expect. A simple format like CAT-001 (category prefix plus a number) lets you scan inventory quickly, group similar items, and avoid confusion between similar products. Once you have these basics in place, every other inventory decision — pricing, reordering, valuing your stock for tax — becomes straightforward.
FIFO, LIFO, and weighted average — which costing method to use
When you buy the same product at different prices over time, you need a rule for which cost to use when something sells. FIFO (first in, first out) assumes the oldest stock sells first, so the cost of goods sold reflects older purchase prices. LIFO (last in, first out) does the opposite. Weighted average blends all your purchases at a single average cost. For most small businesses, FIFO is the natural choice — it matches how you actually sell physical inventory (older stock first), and it is accepted in most countries for tax purposes. LIFO is restricted in many jurisdictions, including the entire EU. Weighted average works well when products are interchangeable and prices fluctuate often. Pick one, document it, and stick with it across reporting periods so your numbers stay comparable.
How and how often to count your stock
A physical count compares what your records say with what is actually on the shelf. Two approaches work for small businesses. A full inventory count is done once or twice a year, usually at year-end for tax purposes — you stop selling for a few hours, count everything, and reconcile the difference. Cycle counting is the smarter alternative: count a small subset of items every week so the whole inventory cycles through over a month or quarter. Cycle counting catches problems early, avoids the disruption of a full stop, and trains the habit of accuracy. When you find a discrepancy, do not just adjust the number and move on. Ask why — was it theft, breakage, a miscount at receiving, or an unrecorded sample given to a customer? The pattern matters more than the single fix.
Setting reorder points so you never run out
A reorder point is the stock level that triggers a new purchase order. The basic formula is straightforward: take the average daily sales of an item, multiply by the lead time in days from your supplier, and add a small buffer for safety stock. If you sell three units of something per day and your supplier takes seven days to deliver, your reorder point is at least 21 units. Add a few more for safety — bad weather, a supplier delay, a sudden spike in demand. Reorder points work even better when your inventory tool flags items automatically as they cross the threshold. Without that automation, you end up checking spreadsheets manually or, more often, discovering the stockout when a customer asks for it.
Inventory and your profit and loss
Inventory is not an expense the moment you buy it — it is an asset on your books until you actually sell it. The cost only hits your profit and loss statement as cost of goods sold (COGS) when the item is sold. This is one of the most misunderstood parts of running a product business. If you spent $5,000 on stock in March but only sold half of it, your March P&L should show $2,500 in COGS, not $5,000. The remaining $2,500 sits as inventory on your balance sheet. Getting this right matters for two reasons: your real profit looks very different from your bank balance during heavy buying months, and your tax return depends on accurate ending inventory. For more on reading your numbers, see our guide on the profit and loss statement.
When spreadsheets stop working
A spreadsheet is fine for the first thirty or forty SKUs. The cracks start to show when you have multiple sales channels, recurring orders, or more than one person updating the same file. Common spreadsheet failures include two staff editing the same row at the same time, formulas breaking when someone deletes a column, and stock counts that drift from reality because nobody updated the sheet after a sale. The signal that you have outgrown a spreadsheet is simple: when you stop trusting the numbers, you have outgrown it. The next step does not have to be expensive. Many small business invoicing tools include basic inventory tracking that updates stock levels automatically every time you create an invoice — turning a manual chore into an automatic side effect of doing business.
Inventory built into your invoicing
The simplest inventory system is the one you do not have to think about. Kelvo tracks your products alongside your invoices — when you add an item to an invoice and send it, the stock level updates automatically. You can set cost prices to track your real margins, see which products are running low, and pull a full profit and loss report that includes COGS without any manual entry. The free plan includes inventory for up to 25 items, unlimited clients, expense tracking, and the P&L report. For product-based small businesses, having invoicing and inventory in one place removes an entire class of errors — you can never invoice a product and forget to deduct it from stock, because the deduction is the same action. Start free at kelvo.app and replace your inventory spreadsheet in under ten minutes.