Inventory
Inventory Tracking Methods for Independent Retailers
The right tracking method depends on your product count, transaction volume, and the time you have available — not on how sophisticated the system sounds.
Inventory tracking is the practice of monitoring what you have on hand, where it is, how quickly it moves, and when to reorder. For independent retailers and small-scale distributors, the mechanics of this vary significantly depending on how many distinct products are stocked and how many transactions happen each day.
A gift shop with 80 SKUs and 15 transactions per day operates in a different environment than a small hardware distributor with 1,200 SKUs and 60 daily orders. Both need inventory tracking, but the same system won't serve both equally well.
The building blocks: what any system needs to track
Regardless of method, inventory tracking requires the same core information for each product:
- SKU or item code — a unique identifier assigned to each product variant (size, colour, format)
- Current quantity on hand — how many units are physically in stock
- Reorder point — the quantity at which a purchase order should be triggered
- Reorder quantity — how many units to order when the reorder point is reached
- Lead time — how many days between placing and receiving an order from this supplier
These five fields are the minimum. Everything else — cost per unit, preferred supplier, bin location, expiry date — is useful but optional depending on your operation.
Manual tracking: pen, paper, and physical counts
Manual tracking uses physical count sheets, purchase order logs, and periodic reconciliation without digital tools. It sounds rudimentary, but it remains appropriate for businesses with fewer than 100 SKUs and low transaction volumes where the cost of implementing software exceeds the cost of the occasional stockout it would prevent.
The key discipline for manual tracking is consistency: counts at defined intervals (weekly for fast-moving items, monthly for slow), a standardized paper format so counts are comparable over time, and a clear procedure for recording receipts and sales against the count. Informal manual tracking — where counting happens "when someone remembers" — produces unreliable data regardless of how small the product range is.
When manual tracking breaks down
Manual tracking becomes unreliable when transaction volume is high enough that sales are not being logged consistently between counts. If a business sells 40 units of an item on a busy Saturday and the count sheet doesn't reflect that until Tuesday, the reorder point trigger fires late. For businesses processing more than 30 transactions per day across multiple product lines, manual tracking typically requires more staff time than its cost savings justify.
Spreadsheet tracking
Spreadsheet-based inventory — built in Microsoft Excel, Google Sheets, or LibreOffice Calc — sits between manual paper systems and dedicated software. It accommodates several hundred to a few thousand SKUs comfortably, allows formula-driven reorder alerts, and can be maintained by one person with basic spreadsheet skills.
A functional inventory spreadsheet for a small retailer typically includes:
- A product list with SKU, description, unit of measure, and supplier
- Current quantity on hand (updated manually or via daily sales export)
- Reorder point and reorder quantity per SKU
- A conditional formatting rule that highlights rows where current quantity falls below the reorder point
- A separate tab for open purchase orders, recording what's been ordered and the expected delivery date
The most common spreadsheet tracking failure is not technical — it's that the "current quantity" column gets updated inconsistently. If sales are updated weekly but receipts are updated immediately (or vice versa), the data is unreliable. Whatever update frequency you choose, it needs to apply equally to both inflows and outflows.
Limitations of spreadsheets
Spreadsheets don't integrate with point-of-sale systems or e-commerce platforms without custom development. Every sale that isn't recorded promptly creates error. They also don't handle multi-location inventory or lot tracking without significant complexity. For businesses that operate more than one physical location or sell through multiple channels simultaneously, spreadsheet tracking usually creates more reconciliation work than it saves.
Software-based tracking
Inventory management software ranges from simple standalone tools to systems that integrate with accounting, POS, and e-commerce. For independent Canadian retailers, the relevant tier is entry-level software costing $30–$150 CAD per month.
The principal advantage over spreadsheets is integration: modern inventory tools connect directly to Shopify, Square, Lightspeed, and QuickBooks, so sales automatically decrement inventory and purchases automatically increment it. This removes the manual update requirement that causes most spreadsheet errors.
When software makes sense
Software becomes worth the cost when:
- Transaction volume is high enough that manual updates are a material time burden
- The business sells through more than one channel (e.g., physical store plus online)
- Lot tracking, expiry date management, or serial number tracking is required
- Reporting on product velocity, margin by SKU, or turnover ratio is needed for purchasing decisions
For a business with under 200 SKUs and a single sales channel, the time and cost of implementing and maintaining a software system often exceeds the benefit. The spreadsheet approach serves adequately until transaction volume makes it impractical.
SKU discipline: the underlying requirement
No tracking method works reliably without consistent SKU assignment. This means every product variant — every size, colour, and format — has a unique code, that code is used consistently across orders, receipts, and sales records, and new products are assigned codes before they enter stock rather than after.
SKU codes don't need to encode product attributes in elaborate ways. A simple sequential numbering system (SKU-00001, SKU-00002) with a separate description field works as well as complex alphanumeric codes and is less prone to transcription errors.
Cycle counting vs. full physical counts
A full physical count — where all inventory is counted at once — is accurate but disruptive. Many small retailers conduct one full count per year (often at year-end) and use cycle counting for the rest of the year. Cycle counting means counting a subset of inventory on a rotating schedule so that every SKU is counted two to four times annually without shutting down operations for a full inventory day.
A practical cycle count schedule for a retailer with 400 SKUs: count 20 SKUs per week across a 20-week cycle. The 20 SKUs counted each week rotate through the full product list. High-velocity items can be assigned a higher count frequency by appearing in the rotation twice.
For more on the supply chain context that inventory decisions fit into, see How Small Businesses Can Build Resilient Supply Chains.