Inventory management in retailing is the work of knowing what you have, where it is, what it cost and when to reorder it, so the right products are on the shelf without cash tied up in the wrong ones. The fastest way to do it well is to keep one live record in which every sale, return and delivery updates stock and your books together. That is what Point SMB is built around: sales, inventory, accounting and customers in a single workspace, so nobody retypes a sale from one tool into another.
This guide covers the routine a small retailer needs: how tracking works, how much to carry, which methods to use, which numbers to watch and how stock turns into a figure on your balance sheet.
TL;DR
- Retail inventory management means tracking every unit from purchase order to sale and returns, so you avoid stockouts, overstock and shrink (loss from theft, damage or error).
- Use a perpetual system, which updates on every sale and delivery, and back it with regular counts. Cycle counts are less disruptive than one big annual count.
- Set a reorder point for each fast-moving item: daily sales times supplier lead time, plus a safety buffer.
- Watch a few numbers: sell-through, stock turnover, weeks of supply and stockout frequency.
- Spreadsheets break when stock, sales and accounting live in separate files. A unified platform removes the re-entry that causes most errors.
Table of Contents
- What inventory management means in a retail business
- How retail stores keep track of inventory
- How much inventory to carry
- Inventory methods small retailers use
- The numbers that tell you if stock is working
- The retail inventory method: an accounting estimate, not a control system
- From stock to cash: connecting inventory with the books
- A weekly routine that keeps retail stock honest
- How Point SMB fits a growing retailer
- Common mistakes to avoid
- FAQ
- Sources
What inventory management means in a retail business
A retailer's stock is its largest working asset and usually its largest cash commitment. Managing it covers the whole life of an item: placing the purchase order, receiving the delivery, storing it, putting it on the sales floor, selling it, handling returns and reconciling what the system says against what is physically there.
The goal is balance. Too little stock and customers leave empty-handed. Too much and you pay to store goods that may later need markdowns. The scale of the problem is large: an IHL Group report from 2025 puts worldwide inventory distortion at about $1.7 trillion a year, roughly $1.2 trillion from out-of-stocks and $572 billion from overstocks. Most of the overstock cost, the report finds, traces to supplier issues and to buying and planning errors. Those are decisions a small shop can influence with better data.
How retail stores keep track of inventory
There are two basic approaches to counting stock.
Periodic systems count physical stock at set intervals, such as month-end. Between counts, the quantity on hand is an estimate based on purchases and cost-of-goods formulas. They are cheap to run but blind between counts.
Perpetual systems update the record with every sale, return, receipt and transfer, so the figure on screen is always close to what is on the shelf. The Australian government's small business guidance recommends a perpetual system that updates on every purchase or sale, with a stocktake monthly or quarterly to catch items that are missing, stolen, damaged or out of date.
A perpetual record is only as good as its inputs. Three habits keep it accurate:
- Receive against the purchase order. Count each delivery against what you ordered, flag errors and damage with the supplier straight away, unpack the entire shipment and update stock counts at once. Forbes Advisor describes this receiving routine as a core best practice.
- Record every movement. Sales, returns, write-offs, damaged goods and transfers between locations all change stock. A movement that is not recorded becomes a phantom unit.
- Reconcile on a schedule. Compare the system to the shelf, find the gap, and fix the cause rather than just the number.
Why spreadsheets stop working
A spreadsheet is a reasonable start. The trouble begins when stock sits in one file, sales in a point-of-sale export, invoices in a third tool and the ledger in a fourth. Every handoff is a retyping step, and every retyping step is a chance for a wrong quantity, a missed return or a cost that never reaches the books. By the time someone notices, the count is off and nobody knows which file is right.
Point SMB addresses that directly. It is a single workspace for sales, real-time inventory tracking, invoicing, accounting and a customer directory, designed to remove data re-entry and keep ledgers clean and audit-ready.
How much inventory to carry
The question every retailer asks is how much stock is enough. Two answers work together: a plan for the season, and a trigger for each item.
Plan the buy for the period
Rutgers University's retail budgeting notes give the standard planning arithmetic used in merchandising:
- Planned purchases = planned end-of-month stock + planned sales + planned reductions (markdowns, shrink) − beginning-of-month stock.
- Open to buy = planned purchases − merchandise already on order − merchandise already received. It is the budget you still have left to spend.
- Stock-to-sales ratio = merchandise in stock ÷ planned sales.
A worked example: a gift shop expects $20,000 of sales in December and wants $30,000 of retail stock at month-end. It starts December with $25,000 and expects $1,000 in markdowns and shrink. Planned purchases are 30,000 + 20,000 + 1,000 − 25,000 = $26,000 at retail value. If $9,000 is already on order and $4,000 has arrived, the open-to-buy is $13,000. That is the number to hold in mind before you say yes to another supplier.
Planning from history matters here. Retail commentators quoted in Afterpay's forecasting guide suggest six months of sales data is a start and a year or more gives a deeper picture, as long as every stock movement in and out has been recorded. That last condition is the reason clean tracking comes first.
Overbuying has a lasting cost. PwC's retail inventory management paper notes that store stock decisions are rarely reversible and that overstocking almost always ends in obsolescence and heavy clearance costs.
Set a reorder point for each item
For items you restock continuously, a reorder point tells you when to place the next order:
Reorder point = (average daily sales × supplier lead time in days) + safety stock
Safety stock is the buffer against surprises, a surge in demand or a late delivery. A common way to size it is (maximum daily sales × longest lead time) − (average daily sales × average lead time), as laid out in the same guide.
Example: a candle sells 4 a day on average and 7 on the busiest day. Your supplier usually delivers in 5 days but once took 8. Safety stock is (7 × 8) − (4 × 5) = 36 units. The reorder point is (4 × 5) + 36 = 56 units. When stock hits 56, you reorder.
The formula only works if daily sales and lead times are real numbers from your own records. If sales sit in one tool and receipts in another, you will be guessing at both.
Inventory methods small retailers use
These methods are not rivals. Most shops combine two or three.
| Method | What it does | Best for |
|---|---|---|
| Minimum stock level | Reorder when stock falls to a set quantity | Steady everyday items |
| Batch ordering | Order or make stock in fixed quantities | Items with supplier minimums or case packs |
| FIFO (first in, first out) | Sell the oldest stock first | Food, cosmetics, anything with a shelf life |
| Just-in-time | Stock arrives close to when it is needed | Shops with reliable suppliers and little storage |
| ABC analysis | Rank items by value, give the top tier the most attention | Catalogs with a few big sellers and a long tail |
| Cycle counting | Count a small subset on a rolling schedule | Any shop that cannot close for a full count |
The first four come from the UK's BBC Bitesize guide to stock control, which uses a shop reordering milk when 20 bottles are left as its example of a minimum level. Just-in-time saves storage but depends on suppliers delivering reliably.
Amazon Business explains the others: ABC analysis sorts stock into tiers, where a small share of items, the "A" group, drives most of the revenue, echoing the 80/20 rule. Cycle counting checks a few items at a time instead of one disruptive annual count. The same source also notes that FIFO as a physical practice moves older goods out first, while FIFO or LIFO as an accounting choice affects the cost of goods sold.
That accounting choice is worth settling early because it changes reported profit. Our guide on FIFO versus weighted average inventory walks through it for a small business.
The numbers that tell you if stock is working
You do not need a dashboard of 30 metrics. Five cover most decisions. Lumen Learning's retail management course defines several of them:
- Sell-through percent: sales divided by beginning inventory. It shows how much of what you started with actually sold.
- Inventory turnover: period sales divided by average inventory value. Higher means stock converts to cash faster.
- Stock-to-sales ratio: stock on hand divided by planned sales, a monthly planning check.
- Weeks of supply: how many weeks the current stock will last, based on past sales trend. A forward version uses planned sales instead.
- Stockout frequency: how often a product you intended to carry is unavailable. This is a practical measure of lost sales.
Forbes Advisor adds carrying costs, fill rate and order status tracking to the list. Add inventory accuracy, the share of items where the system matches the shelf, because every other number inherits its errors.
A quick example: you start the quarter with $40,000 of stock at cost and sell $60,000 at cost. Average inventory is $45,000, so turnover is about 1.3 for the quarter. If you sold through only 55% of one category, that is where markdowns will land.
The retail inventory method: an accounting estimate, not a control system
Readers often confuse this with inventory management. The retail inventory method is a way to estimate the dollar value of ending inventory when a full count is impractical. It uses your average markup: the cost-to-retail ratio is the cost of goods available for sale divided by their retail value. Multiply sales by that ratio to estimate cost of sales, then subtract it from goods available for sale to get ending inventory at cost.
Example: goods available for sale cost $70,000 and carry a retail value of $140,000, so the ratio is 50%. If you sold $90,000 at retail, estimated cost of sales is $45,000, and ending inventory at cost is $25,000.
It is a useful estimate for financial statements and interim periods. It does not tell you which items are missing or when to reorder, which is the job of day-to-day tracking. How stock is valued on the balance sheet, and why the figure matters to lenders and auditors, is covered in our piece on IAS 2 inventories.
From stock to cash: connecting inventory with the books
Inventory is cash in another form. Each reorder is a payment, and each slow seller delays the payment you get back. A retailer who sees stock separately from accounting tends to learn about the cash problem late, when the supplier invoice is due and the shelves are full of slow movers.
Three links matter most:
- Sale to stock. The moment an item sells, quantity falls and cost of goods sold is recorded.
- Receipt to payable. A delivery you receive creates what you owe the supplier.
- Stock to forecast. Planned purchases feed the cash you need next month. Our guide to cash flow forecasting shows how to turn them into a month-ahead view.
When all three happen in one system, you do not rebuild them at month-end. When they happen in separate files, month-end becomes a reconciliation project.
A weekly routine that keeps retail stock honest
This routine is built for a small team and takes under an hour once the system is in place.
- Monday: review reorder alerts. Look at items at or below their reorder point and place orders. Check open-to-buy before you commit.
- Receive deliveries the day they arrive. Count against the purchase order, note damage, and update stock immediately.
- Midweek: cycle count one section. Pick a category, count it, and investigate every variance over a threshold you set.
- Friday: read the five numbers. Sell-through, turnover, weeks of supply, stockout frequency and accuracy. Note what moved.
- Monthly: mark down slow stock early. A markdown at week eight costs less than a clearance at week thirty.
The pattern is the same at any size: record movements as they happen, count a little often, and act on a few numbers.
How Point SMB fits a growing retailer
Point SMB is the integrated business management platform from Tetra M Labs, built for small and growing businesses that have outgrown spreadsheets and a stack of disconnected apps. It brings sales, real-time inventory tracking, accounting, invoicing and a customer directory into one workspace, so a sale updates stock and ledgers without re-entry. Our built-in assistant, Dot, gives insights without compromising data privacy.
The Point plan is listed at $9.99 per month or $99 per year, and Point Invoicing at $4.99 per month, on the pricing page. Point SMB is currently in private beta, and you can request private access to join. It is designed to grow into a full ERP without re-platforming, so the system you set up for one shop does not need replacing when you add locations or staff. You can read more about the direction on the Point ERP page.
Common mistakes to avoid
- Treating the count as the goal. A correct count today is worth little if tomorrow's movements are not recorded.
- Reordering by feel. A reorder point built on actual sales and lead times beats memory every time.
- Ignoring returns and write-offs. They quietly distort stock and margins.
- Buying more because a supplier discounts. The discount is real, but so is the carrying cost and the risk of obsolescence.
- Keeping stock apart from accounting. Valuation, cost of goods sold and cash planning all depend on the same numbers.
- Waiting for year-end to count. Rolling cycle counts find problems while you can still trace the cause.
FAQ
What is inventory management in retailing?
It is the process of ordering, receiving, storing, tracking and selling merchandise so you meet customer demand with as little excess stock, shrink and stockout as possible. It covers each item from purchase order through sale and returns, and ends with reconciling records against what is physically on hand.
What is the difference between perpetual and periodic inventory?
A perpetual system updates stock with every sale, return and delivery, so the figure is current at any moment. A periodic system relies on physical counts at set intervals and estimates stock in between. Most small retailers do best with perpetual tracking plus regular counts.
How often should a retailer count stock?
Government small business guidance suggests a stocktake monthly or quarterly. Cycle counting, which checks a few categories on a rolling schedule, lets you keep that rhythm without closing the shop for a full count.
How do I know when to reorder?
Use a reorder point: average daily sales multiplied by supplier lead time, plus safety stock for surprises. Recalculate it when sales patterns or supplier delivery times change, and review items at or below that level every week.
What is the retail inventory method?
It is an accounting estimate of ending inventory value that applies your cost-to-retail ratio to sales instead of counting every item. It is used for financial reporting, while day-to-day tracking handles reordering and shrink.
Sources
- Fixing Inventory Distortion, IHL Group (2025)
- Manage your inventory, business.gov.au
- Retail Inventory Management Best Practices, Forbes Advisor
- Retail budgeting notes, Rutgers University
- Inventory forecasting guide, Afterpay
- Retail Inventory Management, PwC
- What is stock control?, BBC Bitesize
- Inventory management for small business essentials, Amazon Business
- Inventory Levels, Lumen Learning Retail Management