Small Business Inventory Management: The Complete Guide

Inventory management comes down to three questions you can answer on any day: what do I have, what should I order, and what is my stock worth? This guide gives you a method for each, with the formulas and a worked example, so you can run a shop's stock from a notebook, a spreadsheet or an app.

If you only have a minute, the whole method is this:

1. Keep one stock record per product (what you have, what it cost, what it sells for).
2. Update it every time you sell or receive stock.
3. Count what is physically on the shelf on a schedule and fix the record when it disagrees.
4. Reorder at a set number, not by feel.
5. Review slow sellers monthly, before they become dead stock.

The rest of this guide shows how to do each step.

What inventory management actually covers

Inventory is the stock you hold to sell. Managing it means keeping three things in balance:

• Availability: a customer asks for it and you have it.
• Cash: you are not paying for shelves of stock that does not move.
• Accuracy: the number in your records matches the number on the shelf.

Many small shops lose money on one of these without noticing. Running out of a top seller costs sales you never see. Over-ordering ties up cash that could pay rent. An inaccurate record means you do not trust any decision built on it, including your profit, because profit depends on what your stock cost.

Step 1: Build a stock record for every product

A stock record is one line per product. Whether it sits in a notebook, a spreadsheet or an app, it needs these fields:

Variations deserve their own lines. A T-shirt in three sizes and two colours is six stock lines, because you run out of one size, not of "T-shirts".

If you want to try this without any software, the free stock sheet records stock in and out, flags low stock and shows the stock value, and exports to CSV.

Step 2: Record every movement

Stock changes in only four ways. Record each one when it happens, not at the end of the week:

• Received: you bought more from a supplier.
• Sold: a customer bought it.
• Returned: a customer returned it, or you returned it to a supplier.
• Lost or damaged: breakage, expiry, theft, samples, items you gave away.

The fourth one is where most gaps hide. If you never record losses, your book stock stays higher than your real stock and the difference shows up only at the next count.

The formula behind every stock record is:

Closing stock = opening stock + purchases received − sales − losses

A worked example, using made-up figures:

You count 26 on the shelf. Two units are unexplained. That gap is the useful number: it tells you the record or the shelf has a problem, and it is small enough to trace. If the gap were 20, you would stop reordering by the record until you found out why.

Step 3: Count the shelf, not the record

A physical count is the only way to find out whether your record is right. There are two practical methods.

Full count. Close for a few hours, count everything, and correct the records. Good for a small shop once or twice a year, and for a clean starting point when you first set up a system. In the US, if your business keeps an inventory for tax purposes, IRS Publication 538 (edition 01/2022) says you must take a physical inventory at reasonable intervals and adjust your book figures to agree with the count. Some small businesses are exempt from keeping inventories for tax, so check with an accountant; other countries have their own rules.

Cycle counts. Count a small slice of products each week so the whole range is covered several times a year. Count high-value and fast-moving items more often. This catches errors early without closing the shop.

A simple cycle-count routine:

1. Pick the day (the quietest weekday).
2. Pick 10 to 20 products using the ABC list below.
3. Count each one twice if the first count looks wrong.
4. Write the real count next to the record.
5. Investigate any difference before you correct it. Was a sale missed? A delivery not entered? A customer return?
6. Correct the record and note the reason.

The reason matters. If the same product is short every month, the record is not the problem; something is leaving the shop.

Step 4: Decide what to watch most with ABC analysis

Not every product deserves the same attention. ABC analysis ranks products by how much sales value they bring and gives the top ones the most care.

How to do it:

1. List each product with its sales value for the last 3 to 12 months (units sold × selling price).
2. Sort from highest to lowest.
3. Add a running percentage down the list.
4. Mark the products that make up the first ~80% of sales as A, the next ~15% as B, and the rest as C. The exact cut-offs are a convention, not a law. Pick lines that suit your range.

Worked example with 10 made-up products and $8,000 of sales:

Three of ten products bring 77.5% of the sales. Those three get the weekly count, the tightest reorder point and a spare supplier. The five C products can be counted once or twice a year and ordered in larger, less frequent batches, or dropped if they are tying up cash.

Step 5: Reorder at a number, not by feel

The reorder point is the stock level at which you place the next order. The formula:

Reorder point = (average daily sales × lead time in days) + safety stock

• Average daily sales: units sold per day over a normal recent period.
• Lead time: days between placing an order and having the stock on the shelf.
• Safety stock: the buffer that covers a busy week or a late delivery.

A simple way to size the buffer:

Safety stock = (highest daily sales × longest lead time) − (average daily sales × average lead time)

Worked example for one product (made-up figures):

• Safety stock = (8 × 5) − (6 × 4) = 40 − 24 = 16 units
• Reorder point = (6 × 4) + 16 = 24 + 16 = 40 units

When the record or a count shows 40 units, order. If the supplier is on time and sales are average, you receive stock with about 16 units left. If both go wrong at once, you only just avoid running out.

A note on order size: this formula says when to order, not how much. For how much, see how much inventory a small business should keep, which covers order quantity, shelf space and cash limits.

Step 6: Know which cost you are using

Stock bought at different prices makes "what did this item cost me?" a real question. The answer changes your profit.

Example: you buy 10 units at $4, then 10 more at $5. You sell 10 units at $8 each, so sales are $80.

Same sale, three profit figures. None is a mistake, but you must pick a method and keep using it. The IRS says the same in its inventory guidance: practices must be consistent from year to year, and tax rules differ by country, so ask your accountant which method applies to you.

In Daily Sales Record, the Cost Settings in the Sales section let you choose which cost the app uses (last, maximum or average cost), so you can see how the choice moves your profit figure.

Step 7: Measure how fast stock sells

Inventory turnover tells you how many times your stock sells through in a period.

Inventory turnover = cost of goods sold ÷ average inventory

Average inventory = (opening stock value + closing stock value) ÷ 2

Worked example (made-up figures, one month):

• Cost of goods sold: $7,200
• Opening stock value: $3,000; closing stock value: $3,300
• Average inventory: ($3,000 + $3,300) ÷ 2 = $3,150
• Turnover: $7,200 ÷ $3,150 ≈ 2.3 times a month
• Days to sell the average stock: 30 ÷ 2.3 ≈ 13 days

What a "good" number looks like depends on the business. A grocery stall turns stock over much faster than a furniture shop. Compare your own number month to month and product group to product group, not against a figure you found online. A falling turnover with rising stock value means you are buying faster than you are selling.

Step 8: Find dead stock before it finds you

Dead stock is stock that has not sold for so long that it is unlikely to. Set the cut-off by product type: perhaps 30 days for fresh goods, 90 days for fashion, a year for durable goods. Then, once a month:

1. List products with no sales since the cut-off date.
2. Add up their stock cost. That is the cash sitting on your shelf.
3. Pick one action per product: discount, bundle with a fast seller, return to supplier, donate or write off.
4. Stop reordering them.
5. Write down why they did not sell (wrong size? wrong season? price too high?) so the next order is smarter.

A discount that sells stock below the usual margin still beats a shelf of unsold items, as long as the price is at or above what the item cost you. Check that with the profit margin calculator before you mark anything down.

Spreadsheet or app?

A notebook or spreadsheet is a fine way to start. The test is not how many products you have; it is how many times you have to type the same thing.

If you manage dozens or hundreds of products, updating a spreadsheet after every sale becomes the slowest part of your day, and the first thing you skip on a busy afternoon. A sales and inventory app such as Daily Sales Record updates your stock when you save a sale, so there is one entry instead of two.

For a fuller comparison, see Excel vs a sales tracking app.

How Daily Sales Record handles stock

Here is what the app does, in order of how you would use it:

• Products: add a name, unit (piece, pack, ml and so on), quantity, cost and selling price. You can also add an SKU, barcode, category, expiry date, notes and images. Services can be marked as such, so they do not need stock.
• Purchases: record new stock in the Purchases section with quantity and cost, and the product's stock goes up.
• Sales: when you save a sale, the quantity comes off your stock. You do not mark anything as sold separately. Deleting a sale returns the quantity to stock.
• Low stock: the app can notify you when stock runs low.
• Stock Report: shows Stock Cost (quantity × purchase price), Expected Sale Value (quantity × selling price) and the Sell Profit between the two.
• Pro features: barcode scanning, product variations with stock per variant, and multiple stores or branches, each with its own products, stock and sales.

The free plan covers up to 50 products and 150 sales a month; Pro removes the limits. Daily Sales Record is cloud-based and needs an internet connection. The sales tracking app guide has the full overview.

Inventory management checklist

Save or screenshot this one.

Setup (once)

• One stock line per product (and per size or colour)
• Unit, cost price and selling price on every line
• Opening count done and written down
• A cost method chosen and noted
• Reorder point set for your top 10 products

Every day

• Record stock received when it arrives
• Record every sale as it happens
• Record breakage, expiry and giveaways

Every week

• Cycle count 10 to 20 products, A items first
• Check anything at or under its reorder point
• Compare record to shelf and write down the reason for any gap

Every month

• List products with no sales since your cut-off date
• Add up the stock cost of slow movers
• Recalculate reorder points for your top sellers
• Check stock value against what you can afford to hold

A 30-day plan to get your stock under control

By day 30 you have a stock record you can trust, a list of what to reorder and a list of what is not selling.

Final takeaway

Stock control is a loop: record every movement, count the shelf, compare, correct, reorder at a set number, and review what is not selling. You do not need special software to start. You do need the habit of writing down every sale and every delivery on the day it happens.

Dig deeper into each part of the loop:

• How to keep track of inventory: the day-to-day tracking methods
• Common inventory management mistakes: what to check first if your numbers do not match
• How much inventory a small business should keep: order size and cash limits
• How to track daily sales: the sales side of the same record

This article is general information, not accounting or tax advice. Inventory and tax rules differ by country; check yours or ask an accountant.