Inventory Tracking System for Small Business: An Honest Guide
An inventory tracking system keeps a live count of what you hold, where it is and when to reorder — instead of a spreadsheet you patch by hand. This guide is honest about when a spreadsheet or a cheap app is the right call, the concrete signs you've outgrown them, and when a right-sized owned system for small business finally earns its place.
An inventory tracking system for small business records what you hold, where each item sits and every movement that changed the quantity. Instead of one number someone overwrites, the balance is built from receipts, picks, transfers, returns and adjustments, so anyone can see how it got there.
The practical problem is usually not a missing stock list. It is a spreadsheet where quantities are typed over, locations live in one person’s head and nobody can say why a shelf holds 14 when the sheet says 20. Setting up tracking properly means deciding what to record for each item, each location and each movement, then making that recording quick enough that people actually do it.

Scanning a label at the point of movement is what keeps the record close to the shelf. Illustrative photograph, not an OpsMavix project.
Image credit: Tiger Lily, Pexels License. No edits.
Key Takeaways
- Tracking means every quantity change is a recorded movement, never a typed-over balance.
- Clean item records with one SKU, one base unit and defined pack sizes prevent most counting confusion.
- Every place stock can sit, including vans, returns and goods awaiting inspection, needs its own location code.
- Each movement should record item, quantity, from, to, type, person, time and source document.
- Scanning helps only when labels, locations and item records are already clean.
- Move off the spreadsheet with a counted opening balance and a clear cutover time, not a copied column.
In this guide:
- 1. Decide What Your Tracking System Must Answer
- 2. Build Clean Item Records
- 3. Map and Label Every Stock Location
- 4. Record Every Movement the Same Way
- 5. Set Up Barcode Scanning Step by Step
- 6. Move Off the Spreadsheet Without Losing Control
- 7. Compare the Available System Approaches
- 8. Pilot One Area Before Wider Rollout
- Frequently Asked Questions
- How OpsMavix Can Help
1. Decide What Your Tracking System Must Answer
Start with the questions people ask every day
Before choosing fields or software, write down the questions staff and customers actually ask. Each question tells you which record has to exist.
| Question asked | Record that answers it |
|---|---|
| How many do we have? | Item record plus the sum of its movements |
| Where is it? | Location code on every movement |
| Can we promise it to this customer? | Quantities split into on hand, reserved and unavailable |
| Why is the shelf short? | Movement history with person, time and reason |
| What did this delivery actually contain? | Receipt linked to the purchase order |
| Which batch went to which customer? | Batch or serial number captured at receipt and dispatch |
If nobody in the business needs the last row, do not build batch tracking yet. Tracking effort should match the questions that matter.
Tracking, control and management are different jobs
This guide covers the mechanics of tracking: what to record and how to set it up. Deciding what to buy and when sits under stock management, covered in our stock management system for small business guide. Keeping the recorded figure honest through receiving checks, adjustment approvals and cycle counts is inventory control, covered in inventory control software for small business. If you run shops with tills, inventory software for retail stores covers the point-of-sale side.
When a spreadsheet is still enough
A spreadsheet can work when one person handles stock, there is one location, the range is small and a stockout is an inconvenience rather than a lost contract. Even then, use it as a movement log (one row per change) rather than a single quantity column. That habit makes any later move much easier.
2. Build Clean Item Records
One item, one SKU, one base unit
Every distinct thing you count needs one internal code (SKU) and one base unit of measure, the smallest unit you track. Pack sizes are then conversions of that base unit, not separate items.
A hypothetical example: screws are tracked in eaches. The supplier sells boxes of 100 and you sell bags of 25. Receiving 5 boxes is 5 × 100 = 500 eaches. Selling 4 bags is 4 × 25 = 100 eaches. If the system stored boxes and bags as separate stock items, those two movements would never meet. Our guide to wholesale pack size management covers cases, cartons and eaches in more depth.
Fields every item record should have
| Field | Why it matters | Rule to agree |
|---|---|---|
| SKU | The internal key every movement refers to | Never reused, never changed after use |
| Description | What people search for and see on labels | Consistent pattern, such as type, size, colour |
| Base unit | What one unit of quantity means | Each, metre, kilogram or litre, chosen once |
| Pack conversions | Turns cases or bags into base units | Supplier pack and selling pack held separately |
| Barcode value | Lets a scan find the item | One barcode maps to one item and one pack size |
| Default location | Where new receipts should go | Optional, but speeds up put-away |
| Tracking method | None, batch or serial | Set before any stock is received |
| Unit cost | Values movements and variances | Agree the costing basis with your accountant |
| Status | Active, discontinued or blocked | Discontinued items stay for history |
Batch and serial tracking only where needed
Batch tracking groups units that share properties such as an expiry date. Serial tracking identifies each individual unit. Both add steps at receipt and dispatch, so use them for items where traceability, warranty or expiry genuinely matters.
Packaged tools usually require this to be decided up front. Zoho Inventory’s batch tracking help, for example, says the feature must be enabled in settings before batch-tracked items can be created, lets you record manufactured and expiry dates when stock is received, and notes that it is available only on certain plans.
Supplier barcodes and your own codes
Many products already carry a manufacturer barcode. GS1 UK describes the GTIN as the main identifier for most product businesses and advises keeping GS1 numbers in internal systems such as inventory software. If you sell your own products through retailers or marketplaces, check what identifiers they require. For internal labels such as locations or unbranded parts, your own codes are usually enough for tracking within the business.
3. Map and Label Every Stock Location
Use a simple location hierarchy
A location code should tell a new member of staff where to walk. A common pattern is area, aisle or bay, shelf and bin, written in a fixed format.
| Level | Example code | Notes |
|---|---|---|
| Site | MAIN | Only needed with more than one building |
| Area | MAIN-A | Stockroom, mezzanine, yard |
| Bay | MAIN-A-02 | Number bays in walking order |
| Shelf | MAIN-A-02-3 | Count shelves from the floor up |
| Bin | MAIN-A-02-3-B | Only where shelves are divided |
Pick the shallowest level that lets someone find an item in under a minute. A small stockroom may only need bay and shelf.
Give non-shelf places a location too
Stock that is not on a shelf still exists. If it has no location, it disappears from the record or gets counted twice.
| Place | Suggested location | Why it needs one |
|---|---|---|
| Goods in area | GOODS-IN | Delivered but not yet checked or put away |
| Returns awaiting inspection | RETURNS-HOLD | Physically present but not sellable |
| Damaged or quarantined | QUARANTINE | Kept for supplier claims or disposal |
| Vans or site kits | VAN-1, VAN-2 | Stock out with engineers still belongs to you |
| In transit between sites | TRANSIT | Left one site, not yet received at the other |
| Packing bench | DISPATCH | Picked for an order but not yet shipped |
Mark RETURNS-HOLD and QUARANTINE as not available to sell, so tracking feeds the available figure correctly.
Label before you go live
Print a barcode label for every location and fix it to the shelf edge rather than the product, because products move and shelves do not.
4. Record Every Movement the Same Way
The fields every movement needs
A movement is any event that changes quantity or location. Treat each one as a new line in a log, never as an edit to a balance.
| Field | Example |
|---|---|
| Movement type | Receipt, pick, transfer, return, adjustment, count |
| Item | SKU and, where used, batch or serial |
| Quantity | In base units, positive or negative |
| From location | MAIN-A-02-3 (blank for a receipt) |
| To location | VAN-1 (blank for a sale or write-off) |
| Person or system | Named user, till or online channel |
| Date and time | Recorded automatically |
| Source document | Purchase order, sales order, transfer or count reference |
| Reason | Required for adjustments, such as damaged or count correction |
The current quantity at any location is simply the opening balance plus all movements into it minus all movements out of it. When the shelf and the record disagree, you read the log rather than argue from memory.
Common movement types
| Type | Changes total stock? | Changes location? | Typical source |
|---|---|---|---|
| Receipt | Yes, increases | Into GOODS-IN or a shelf | Purchase order |
| Put-away | No | GOODS-IN to shelf | Receipt |
| Pick or sale | Yes, decreases | Out of a shelf | Sales order or till |
| Transfer | No | Shelf to van, site or bin | Transfer request |
| Customer return | Yes, increases | Into RETURNS-HOLD | Return authorisation |
| Adjustment | Yes, up or down | One location | Reason code and evidence |
| Count result | Only if a variance is posted | One location | Count reference |
How adjustments are approved and how counts are reviewed is a control question. Our stock adjustment approval workflow guide covers the evidence and approval side.
Hypothetical worked example: one SKU through a week
A hypothetical business stocks an item, SKU BOLT-M8-50, tracked in eaches. It starts the week with 240 on shelf MAIN-A-02-3 and nothing elsewhere.
| Step | Movement | Quantity | MAIN-A-02-3 | VAN-1 | RETURNS-HOLD | Total |
|---|---|---|---|---|---|---|
| 0 | Opening balance | 240 | 0 | 0 | 240 | |
| 1 | Receipt: 5 boxes of 100 | +500 | 740 | 0 | 0 | 740 |
| 2 | Pick for sales order | -120 | 620 | 0 | 0 | 620 |
| 3 | Transfer to engineer van | 200 | 420 | 200 | 0 | 620 |
| 4 | Customer return awaiting inspection | +10 | 420 | 200 | 10 | 630 |
| 5 | Damaged items found, adjustment | -6 | 414 | 200 | 10 | 624 |
Check the arithmetic: 240 + 500 - 120 + 10 - 6 = 624. The transfer moves 200 from the shelf to the van but leaves the total unchanged. Available to sell is 624 - 10 = 614, because the returned units are not yet inspected. Whether the 200 on the van are offered to other customers is a business rule to decide and configure.
If someone counts the shelf and finds 410 instead of 414, the log shows exactly which movements to check: the receipt, the pick and the damage adjustment.
5. Set Up Barcode Scanning Step by Step

Labelled bins and shelves give every scan a location to attach to. Illustrative photograph, not an OpsMavix project.
Image credit: EqualStock IN, Pexels License. No edits.
Scan the movements that cause most errors first
Scanning removes typing errors in item codes and locations. It does not fix a wrong item record or an unlabelled shelf, so finish sections 2 and 3 first. Then add scanning in this order:
- Receiving. Scan the item and enter the counted quantity against the purchase order.
- Put-away. Scan the item, then the destination location label.
- Picking. Scan the location and the item to confirm the right product left the right shelf.
- Transfers. Scan out of one location and into the next, including vans.
- Counts. Scan the location, then each item counted there.
Choose devices that suit the work
| Option | Where it fits | What to check |
|---|---|---|
| Phone or tablet camera | Low volume, occasional scans | Scan speed in poor light and with gloves |
| Bluetooth scanner paired to a tablet | Desk receiving or a packing bench | Pairing reliability and battery life |
| Rugged handheld computer | Busy stockrooms and frequent scanning | Whether your software has a supported app for it |
| Fixed scanner at a bench | Packing or goods-in stations | Cable reach and label position on products |
Test with your own labels and products. A scanner that reads a crisp sample barcode may struggle with a curved bag or a faded supplier label.
Make scanning faster than not scanning
People skip steps that slow them down. Keep each scan workflow to the fewest screens possible and show a clear error when a barcode is unknown. Decide what happens when a label is missing, so people do not invent a workaround.
Hypothetical example: what a scan saves at receiving
Suppose a hypothetical goods-in clerk books 40 delivery lines a day. Typing a SKU and quantity takes about 25 seconds per line; scanning and confirming takes about 10 seconds. That is 40 × (25 - 10) = 600 seconds, or 10 minutes, a day. Over 250 working days that is 2,500 minutes, about 41.7 hours a year. The larger benefit is usually fewer wrong-item receipts, but measure your own timings before relying on any figure.
6. Move Off the Spreadsheet Without Losing Control
Clean the item list before importing
Export the spreadsheet and fix it before it touches the new system. Remove duplicate rows for the same product, split combined descriptions into consistent fields, choose a base unit for every item and mark discontinued lines. Importing a messy list simply moves the mess into a system that is harder to edit in bulk.
Count to set the opening balance
Do not copy the spreadsheet quantity column as the opening balance. Count each location and import counted quantities by location. Most packaged tools support a bulk route: Shopify’s initial inventory setup guide, for example, lists entering quantities individually, through a bulk editor or by CSV import, and suggests assigning inventory to each location based on physical counts.
Pick a cutover time and stick to it
Choose a quiet point, such as after close on a Friday. Every movement before that time belongs to the spreadsheet; every movement after it goes into the new system only. Deliveries that arrive during the count wait in GOODS-IN until the count is finished, then are received in the new system.
Hypothetical worked example: planning the opening count
A hypothetical business has 600 active SKUs. A trial count shows that locating, counting and recording a line takes about 45 seconds on average.
- Total counting time: 600 × 45 = 27,000 seconds, which is 450 minutes or 7.5 hours.
- With two counters working in separate areas: 7.5 ÷ 2 = 3.75 hours each, before breaks and recounts.
During the count, one line shows a spreadsheet quantity of 380 but a counted quantity of 362. The difference is 362 - 380 = -18 units. At a hypothetical unit cost of £7.40, that is -18 × £7.40 = -£133.20. Record these differences as a list for review rather than hiding them inside the opening balance, because they show where the old process was leaking.
Keep the old spreadsheet, read-only
Save the final spreadsheet as a read-only file with the cutover date in its name. You may need it to answer questions about earlier transactions. For UK companies dealing in goods, section 386 of the Companies Act 2006 requires accounting records to include statements of stock held at the end of each financial year and the stocktaking records behind them, so check with your accountant how your opening count and old records should be kept.
7. Compare the Available System Approaches
Match the approach to the gap
| Approach | When it fits | What to check |
|---|---|---|
| Structured spreadsheet log | One user, one location, small range | Whether people log movements rather than editing totals |
| Configure your existing tools | Your accounting or ecommerce tool already tracks stock but is not set up | Locations, units, permissions and history on your current plan |
| Packaged inventory app | Standard receiving, picking and transfers match how you work | Edition limits, scanning app, integrations and history retention |
| Focused custom application | A specific step, such as van stock or kitting, does not fit packaged tools | Data ownership, support and links to sales and accounting |
| Full ERP, packaged or custom | Stock is one of many joined processes that all need change | Finance fit, migration effort and delivery capacity |
This is not a ranking. A well-configured packaged app suits many small businesses for a long time. A focused custom application makes sense when a valuable workflow genuinely does not fit, and a full ERP when many connected processes need to change together.
Ask every option to run the same test
Give each supplier the movement example from section 4 and ask them to run it live with your own item and location codes. Mark each step as demonstrated, configurable, needing development or unsupported. Compare total cost over several years, including licences or hosting, setup, migration, training, scanners and ongoing support, rather than the first month’s fee.
8. Pilot One Area Before Wider Rollout
Choose a representative area
Start with one stockroom, one product family or one van. It should include receipts, picks, at least one transfer and a return, so the pilot exercises every movement type. A new, empty area cannot show whether opening balances and cutover worked.
Pilot acceptance checklist
- Every item in the area has one SKU, one base unit and correct pack conversions.
- Every shelf, bin and non-shelf place in the area has a scannable location label.
- A receipt against a purchase order adds the counted quantity, not the ordered quantity.
- A transfer moves stock between locations without changing the total.
- A return lands in RETURNS-HOLD and is not offered for sale.
- An adjustment cannot be saved without a reason.
- The history for any SKU explains its current balance line by line.
- A count of the area after two weeks matches the record, or every difference is explained.
Keep it working after go-live
Review movement history weekly for the first month. Look for vague adjustment reasons, negative balances and stock left too long in GOODS-IN or RETURNS-HOLD. Repeated problems usually point to an awkward step, so fix the step rather than add another rule. Our guides to inventory management best practices and inventory shrinkage cover counting routines and loss once tracking is in place.
Frequently Asked Questions
What is an inventory tracking system for small business?
It is a way of recording every item you stock, every location it can sit in and every movement that changes its quantity or location. The current balance is calculated from those movements, so it can always be explained.
What should be recorded for each stock movement?
At minimum: movement type, item, quantity in base units, from and to locations, the person or system responsible, date and time, the source document and, for adjustments, a reason.
Do I need barcode scanning to track inventory?
Not always. A small range handled by one person can be tracked accurately by hand. Scanning becomes worthwhile when several people move stock, the range is large or wrong-item errors are common. Clean item and location records come first either way.
Can I keep using a spreadsheet?
Yes, while the operation is small and simple. Use it as a movement log with one row per change rather than a single quantity column, and protect the formulas. Move on when several people or channels need the same figure at the same time.
How do I set opening balances when moving off a spreadsheet?
Count each location at a fixed cutover time and import counted quantities by location. Keep the differences between the old spreadsheet and the count as a separate list for review.
Should every item be batch or serial tracked?
No. Use batch tracking where expiry or recall traceability matters and serial tracking where individual units carry warranties or are high value. Both add steps at receipt and dispatch.
Can OpsMavix build an inventory tracking system?
Yes. OpsMavix can build focused applications or a full custom ERP, and can configure or integrate suitable existing tools where those approaches fit the requirements.
How OpsMavix Can Help
OpsMavix can map how stock enters, moves and leaves your business, define the item, location and movement records you need, and plan a cutover from spreadsheets that keeps the history intact.
That may involve configuring the tools you already use, building an inventory automation system with scanning and movement history, keeping online channels in step through ecommerce inventory automation, or connecting trade orders through a wholesale order management system.
Contact OpsMavix with one recent stock discrepancy, the records behind it and the handoff that creates the most rework. We can use that evidence to define requirements and a practical pilot.
Getting value from OpsMavix? Add us as a preferred source on Google — you'll see more of our operations content in your AI Overviews, AI Mode and Search.