Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124

For most small businesses, inventory is the second-largest use of cash after payroll and rent. Yet it rarely gets managed with the same discipline. Payroll runs on a schedule. Rent is a fixed line item. Inventory, by contrast, is often tracked in a spreadsheet that someone updates when they remember to, or not tracked in any structured way at all until a bestseller runs out mid-season or a storage unit fills up with stock that stopped moving a year ago.
That gap matters more for a small business than a large one. A national retailer that misjudges demand on one product line barely notices. A small business that ties up a third of its working capital in the wrong stock can spend months recovering.
This guide covers what inventory management actually involves, the core methods worth knowing, how to build a working system from scratch, and where a spreadsheet stops being enough.
Inventory management is the process of tracking, ordering, and controlling the stock a business buys and sells, so it has the right amount of product on hand without tying up more cash than necessary.
At a large company, that process is usually a dedicated function with its own software and staff. At a small business, it’s typically one person, often the owner, doing it alongside sales, hiring, and everything else.
That difference shapes the whole approach. A small business can’t absorb the cost of overstock the way a larger one can, and it usually can’t negotiate the supplier terms that make just-in-time ordering low-risk. The goal isn’t to copy enterprise inventory practices at a smaller scale. It’s to run a version built for thin margins, limited storage, and one or two people managing it.
The challenges are fairly consistent across industries, even though the products differ.
Knowing how much to buy. Order too much and cash sits on a shelf instead of in the business. Order too little and a customer walks out empty-handed or worse, buys from a competitor and doesn’t come back.
Limited space. Most small businesses don’t have a warehouse to absorb excess stock. A storage closet or a corner of the shop floor has to do double duty, which makes overbuying a physical problem as much as a financial one.
Manual tracking errors. Spreadsheets and handwritten logs drift from reality fast. A miscount here, a forgotten update there, and the numbers on paper stop matching what’s actually on the shelf.
Supplier leverage. Small businesses generally don’t have the order volume to negotiate the pricing or flexible terms that larger buyers get, which makes lead times and minimum order quantities harder constraints to work around.
Seasonal and demand swings. A slow month can look like healthy inventory levels right up until a rush hits and reveals how thin the buffer actually was.
None of these are solved by one trick. They’re solved by picking a method that fits the business and applying it consistently, which is the next section.
A handful of methods cover most of what a small business needs. Few businesses use just one; most combine two or three.
ABC analysis sorts inventory into three tiers based on value and sales impact, not just volume:
The practical benefit is focus. A business with 500 SKUs doesn’t need to watch all 500 with equal intensity, it needs to watch the 50 or so that actually move the needle.
A quick example: a boutique candle shop carries 120 SKUs. Ranking them by annual revenue shows that 18 scented candles account for roughly 70% of sales – those become A items, checked weekly. The next 30 or so items (seasonal scents, gift sets) make up another 20% of revenue and become B items, reviewed monthly. The remaining 70-plus SKUs – one-off colors, discontinued scents still on the shelf – generate the last 10% and become C items, counted quarterly and candidates for clearance if they don’t move.
FIFO means the oldest stock sells first. It’s standard for anything perishable or trend-sensitive – food, cosmetics, seasonal apparel – where holding onto older inventory too long turns it into a write-off. Rotating stock physically (older items to the front) makes FIFO easy to enforce without extra software.
The reorder point is the stock level that triggers a new order, calculated as expected demand during the supplier’s lead time, plus a buffer for uncertainty (safety stock):
Reorder point = (average daily sales × lead time in days) + safety stock
Example: a product sells 8 units a day, and the supplier takes 6 days to deliver. Lead-time demand is 48 units. Add a safety stock buffer of 15 units for demand variability, and the reorder point is 63 units – the moment stock hits that number, it’s time to order, not the moment the shelf looks low.
EOQ estimates the order size that minimizes total cost by balancing ordering costs (placing and receiving an order) against carrying costs (storing it). It’s most useful for A-tier items with steady, predictable demand for volatile or seasonal products, it tends to oversimplify.
JIT means ordering stock to arrive right when it’s needed, minimizing how much cash sits in storage. It works well when suppliers are fast and reliable. For a small business with a single supplier and a multi-week lead time, it’s a riskier fit – a single delayed shipment can mean empty shelves with no buffer to absorb it.
Most small businesses don’t need a sophisticated system on day one. They need a consistent one.
1. Pick one tracking method and commit to it. Spreadsheet, dedicated software, or a hybrid, the specific tool matters less than using it consistently. Switching methods every few months is what causes the drift that leads to phantom inventory: stock that exists on paper but not on the shelf, or vice versa.
2. Set par levels and reorder points for your top sellers first. Trying to calculate reorder points for an entire catalog on day one is a good way to never finish. Start with the 15–20 SKUs that drive most of the revenue, using the ABC framework above, and expand from there.
3. Build in cycle counting. Instead of one exhausting annual count, count a rotating slice of inventory on a regular schedule – A items weekly or biweekly, B items monthly, C items quarterly. Discrepancies get caught while they’re small, not after they’ve compounded for a year.
4. Connect inventory to your books. If sales, stock counts, and accounting live in three disconnected places, someone is doing manual reconciliation and manual reconciliation is where errors hide the longest. Setting up a solid framework for small business bookkeeping ensures your inventory costs accurately flow into your financial statements.
A spreadsheet is a perfectly reasonable inventory system for a business with a small catalog and one sales channel. The signs it’s time to move on are fairly clear:
When those signs show up, a handful of tools cover most small business needs:
| Tool | Best for | Starting price* |
|---|---|---|
| Zoho Inventory | Multi-channel sellers (in-store, online, marketplace) | Free tier available; paid plans scale with order volume |
| Square for Retail | Businesses already using Square for point-of-sale | Free plan; paid tiers add barcode and vendor tools |
| QuickBooks Online (Plus/Advanced) | Single-location retailers or service businesses with a light product line | Add-on to an existing QuickBooks subscription |
| Katana | Small manufacturers and makers tracking raw materials and production | Paid plans only, no free tier |
*Confirm current pricing directly with each vendor, plans and rates change frequently.
None of these is universally “best” – the right one depends on sales channels, whether the business manufactures anything, and what it already uses for point-of-sale or accounting. It’s worth testing free tiers or trials against actual order volume before committing to a paid plan. If the business is also choosing accounting software around the same time, best small business accounting software is worth reading alongside this, since the two decisions often affect each other.
A few numbers reveal whether an inventory system is actually working, beyond a gut sense of “we seem to be running low on things.”
How many times inventory is sold and replaced over a period, calculated as COGS [cost of goods sold – the direct cost of the products a business sells, defined in detail in the IRS’s Tax Guide for Small Business] ÷ average inventory value. A low ratio suggests overstocking or slow-moving products; a very high one can mean the business is understocked and risking stockouts.
The cost of holding inventory, including storage, insurance, and capital tied up. It typically runs 20–30% of inventory value per year. When working with tight cash margins, cutting unnecessary overhead – whether by avoiding overstocking or using free payroll software for your team, helps keep operating capital free for inventory replenishment.
The share of demand that couldn’t be met because an item was out of stock. This one is easy to underestimate, since a stockout often shows up as a customer who simply leaves rather than a complaint that gets logged.
The percentage of received stock that actually sells within a given period. A consistently low sell-through rate on a product is usually the clearest early signal that it needs to be discounted, bundled, or dropped.
Buying in bulk without running the carrying-cost math. A supplier discount for ordering 500 units instead of 100 looks like savings on the invoice. If 300 of those units sit unsold for six months, the storage and capital cost can erase the discount entirely.
Counting inventory once a year and trusting the number the rest of the time. A lot can drift in eleven months. Cycle counting catches problems while they’re still small and cheap to fix.
Treating every sales channel as the same pool of stock. A business selling in-store and online without synced inventory will eventually oversell a product on one channel while it sits unsold in the other.
Ignoring supplier lead time until it becomes urgent. Reorder points built on the assumption that a supplier will always deliver on time tend to fail exactly when they’re needed most – during a supplier’s own busy season.
Not distinguishing A items from C items. Applying the same level of attention to a top seller and a slow-moving accessory wastes time on the products that matter least and under-manages the ones that matter most.
A small business doesn’t need every method in this guide running at once. The practical starting point is narrower: pick a tracking system, calculate reorder points for the products that actually drive revenue, and build in a counting rhythm that catches errors before they compound. Everything else – software, KPIs, more advanced methods like EOQ – is worth adding once that foundation is in place, not before.