How to Keep Track of Inventory: A Step-by-Step Guide

Knowing how to keep track of inventory is the difference between selling confidently and constantly firefighting stockouts, oversells and surprise write-offs. The good news is that the method is the same whether you carry 50 SKUs or 5,000: set up clean records, count consistently, and keep your numbers synced with where you sell. This step-by-step guide walks through the whole routine, with a worked example and the mistakes to avoid.

Step 1: Give every product a unique SKU

Tracking starts with naming. Assign each product a stock-keeping unit (SKU) — a short, unique code that never changes and never gets reused. The SKU is how every count, sale and order refers to the item, so consistency here prevents errors everywhere downstream. Keep it readable but stable: avoid baking in prices or seasons that might change.

Step 2: Record your opening stock accurately

You cannot track changes without a trustworthy starting point. Do a full count of every SKU and record the on-hand quantity per location. This is the one time a thorough physical count is worth the effort, because every figure afterwards builds on it. If the opening count is wrong, every later number inherits the error.

Step 3: Log every movement

From day one, record each event that changes a quantity: receipts from suppliers, sales, returns, transfers between locations and adjustments for damage or loss. The principle is to add and subtract rather than overwrite, so you keep a history. A movement log lets you answer not just “how many do I have” but “why is the number what it is” — essential when reconciling a discrepancy.

Step 4: Set reorder points and reorder quantities

A reorder point is the stock level that triggers a new purchase order. Set it using your average daily sales and your supplier’s lead time, with a safety buffer. The reorder quantity is how much to buy when you hit that point. Together they turn replenishment from guesswork into a rule, so you order before you run out rather than after a customer complains.

A simple reorder point formula is: (average daily sales × lead time in days) + safety stock. Review these figures each quarter as demand changes.

Step 5: Keep counts in sync with where you sell

If you sell on more than one channel, the hardest part of tracking is keeping every storefront consistent. The reliable way is real-time sync: when a sale happens anywhere, the on-hand count drops everywhere at once. Updating each marketplace by hand always lags, and the gap is where overselling happens. This single habit prevents most multi-channel stock problems.

Step 6: Cycle count to stay accurate

Even good records drift through miscounts, theft and breakage. Cycle counting keeps them honest without shutting the business down. Instead of one annual stocktake, you count a small group of SKUs regularly — say your top sellers weekly and everything else on a rotation. Discrepancies surface early, when they are small and easy to investigate.

Worked example: tracking a month of one SKU

Consider a phone case, SKU CASE-BLK-01 (illustrative figures). You open the month with 200 units at one warehouse.

• Opening on hand: 200
• Week 1: sold 70 across two channels → 130
• Week 2: sold 55, received a return of 5 → 80
• Reorder point is 90, so the week-2 close of 80 triggers a purchase order
• Week 3: received 250 from supplier, sold 60 → 270
• Week 4: sold 65, wrote off 3 damaged → 202

You close the month at 202 on hand, with a clear trail explaining every change. Because the reorder point was breached in week 2, the replenishment arrived in week 3 before stock ran out. With real-time sync, the channel sales would post to your count automatically; you would only log the receipt, the return and the write-off by hand.

Common mistakes when tracking inventory

• Counting only when there is a problem. Tracking is a routine, not a rescue mission. Ad-hoc counts always lag reality.
• Ignoring committed stock. Selling against on-hand rather than available stock causes oversells on busy days.
• Manual multi-channel updates. Hand-syncing marketplaces guarantees drift within days.
• No safety stock in reorder points. Lead times vary; a buffer absorbs the wobble.
• Overwriting totals instead of logging movements. You lose the audit trail and cannot diagnose discrepancies.
• One annual stocktake only. Errors accumulate for a year before you catch them.

Match the tool to your stage, too. For a tiny single-channel catalogue, a disciplined spreadsheet can keep track of inventory. As you add SKUs, locations and channels, manual reconciliation overwhelms the time saved, and a barcode app or full inventory platform pays back quickly. The right tool is the one that lets your team keep numbers current with the least friction, because an up-to-date approximate count beats a precise count that is three days old.

How WhiteBox helps

WhiteBox handles the hard parts of keeping track of inventory for you. It syncs stock in real time across Shopify, Lazada, Shopee, Amazon and TikTok Shop, so every sale updates your on-hand count automatically and overselling is prevented. You get multi-warehouse tracking, barcode receiving and picking, reorder points, cycle-count support, forecasting and reporting, with unlimited users so the whole team keeps records current. Pricing starts from S$49 (about US$38) per month with a 14-day free trial, and most teams are live within an afternoon. See pricing or start a free trial.

Frequently asked questions

How often should I count inventory? Run rolling cycle counts continuously — top sellers weekly, the rest on a rotation — rather than relying on one annual stocktake. Errors then surface while they are small.

What is a reorder point? The stock level that triggers a new purchase order. A common formula is average daily sales multiplied by lead time, plus safety stock.

Can I keep track of inventory in a spreadsheet? Yes for a small, single-channel catalogue. Once you have multiple channels or hundreds of SKUs, manual updates lag and errors multiply.

What is the difference between on-hand and available stock? On-hand is the physical count. Available is on-hand minus stock already committed to open orders. Always sell against available.

How do I stop overselling across channels? Use real-time sync so a sale on any channel immediately reduces the count everywhere. Manual updates are too slow to prevent oversells during busy periods.

Related reading: Inventory Management Guide, Inventory tracker tools and methods, What is an inventory management database, Multichannel selling guide.