Your inventory numbers are wrong.
Not dramatically wrong. Not "half my stock is missing" wrong. Wrong in the way that quietly costs you money every month — a jar of pigment you thought you had three of but actually have one, a roll of ribbon that got used for samples and never logged, sixteen units of a product listed as "in stock" on Etsy when you actually have eleven.
You know this. You've known it for a while. Every time you go looking for something and it's not where it should be, or you oversell and have to send an awkward apology email, or your costs don't match your purchase records — you think, "I really need to do a proper count." Then you don't, because it sounds tedious, you're not sure how to start, and your current system is "close enough."
Close enough is expensive. Here's what to do about it.
The answer first: what a stocktake actually gives you
Before the how-to, here's what you get out of this — because understanding the payoff makes the work feel less like a chore.
You find out what you actually have. Not what your spreadsheet says. Not what you remember buying. What is physically sitting in your workspace right now.
You find shrinkage. Shrinkage is the gap between what your records say and what exists. For small makers, typical shrinkage runs 2-5% of inventory value. For businesses with poor tracking, it can hit 10-15%. That's money you spent on materials that evaporated — used without being logged, damaged and tossed, miscounted on receipt, or given away as samples.
You find dead stock. Materials you bought months ago that you'll never use. Finished products that haven't sold. Packaging for a product you discontinued. Dead stock ties up cash that could be buying things you actually need.
You get accurate cost of goods sold. If you don't know what you have, you can't accurately calculate what you used. If you can't calculate what you used, your profit margins are a guess. Every financial decision downstream of a wrong inventory count is built on sand.
You stop overselling. Nothing damages customer trust faster than "sorry, that item is actually out of stock." An accurate count prevents that.
The bottom line: A stocktake isn't busywork. It's the single fastest way to find money you're losing and fix problems you didn't know you had.
Before you count: preparation checklist
Don't just walk into your workshop and start tallying things. Thirty minutes of preparation saves hours of confusion.
Pick a date and block the time. A full count of a typical small maker's inventory takes 2-4 hours. Don't try to squeeze it between orders. Block a morning or afternoon when you won't be filling orders, shipping packages, or restocking mid-count.
Stop all inventory movement. No receiving shipments, no selling, no pulling materials for production during the count. If items are moving while you're counting, your numbers will be wrong before you finish. This is why many sellers do stocktakes on a day their shop is closed or paused.
Decide what you're counting. Most small businesses have three categories of inventory to count:
- Raw materials and ingredients — what you buy to make things
- Finished goods — products ready to sell
- Packaging and supplies — boxes, labels, bags, jars, tissue paper
You might also have equipment, but equipment doesn't need counting the same way — it needs an asset check (is it still here and working?), not a quantity count.
Print or prepare your count sheets. You need a document — paper or digital — with every item you expect to have, a blank column for the counted quantity, and space for notes. Pull this from whatever system you currently use. If you don't have a system, this is the moment to build a list of everything you stock.
Organize your space first. Group like items together. Consolidate partial containers. Move items off the floor and out of random corners. You cannot accurately count inventory you cannot find.
Gather your tools. A clipboard or tablet, a pen, a calculator, a scale (if you measure ingredients by weight), and small sticky notes or tape to mark areas you've already counted.
The count: do it in zones
Do not wander around your workspace counting things as you notice them. You will miss things, double-count others, and lose track of where you stopped. Count in zones.
1. Divide your workspace into physical zones. A zone is a shelf, a cabinet, a storage bin, a closet, a section of a table — any distinct area where you store inventory. Label them: Zone A (main shelving), Zone B (under the worktable), Zone C (closet), Zone D (shipping station). Keep it simple.
2. Count one zone completely before moving to the next. Start at one end, work to the other. Count every item. Don't skip things because they're hard to reach or because "I know how many of those I have."
3. Count, don't calculate. If you have a bin that should hold 50 soap molds and it looks about right, don't write down 50. Count them. The whole point is to replace assumptions with facts.
4. Weigh bulk items instead of counting individually. If you have a 10-pound bag of wax pellets, don't count pellets. Weigh the bag. If you buy flour in 25-pound sacks, weigh the open sack. Record the weight, note the unit (lbs, oz, kg, g), and move on.
5. Mark each zone as "counted" when you finish it. A sticky note, a checkmark on your sheet, whatever works. This prevents the "did I already count that shelf?" problem.
6. Write down everything, even if it's not on your list. If you find three rolls of twine you forgot you bought, add them. If you find a bag of beads from a product you no longer make, write it down. The count captures reality, not your plan.
If you have a helper: One person counts and calls out quantities. The other person records. This is faster and more accurate than one person doing both — your eyes stay on the shelf instead of bouncing between the shelf and the clipboard.
After the count: reconcile and fix
The count itself is the easy part. The value comes from what you do with the numbers.
1. Compare counted quantities to your records. For every item, put the counted number next to what your system says you should have. Highlight every discrepancy.
2. Categorize each discrepancy. Not all mismatches mean the same thing:
Over by a small amount (1-3 units): Probably a receiving error — you got more than you recorded, or you recorded a sale that was later cancelled. Adjust your records to match the count.
Under by a small amount (1-3 units): Likely usage that wasn't logged — samples, test batches, items used for product photos, breakage. Adjust your records. Make a note of the probable cause so you can track it going forward.
Significantly off (10%+ variance): Investigate before adjusting. Did you move inventory to a different location and forget? Is there a batch of finished product you sold at a market but never recorded? Did a large purchase never get entered into your system? Don't just "fix the number" — find the leak.
Item exists but isn't in your system at all: Add it. This is untracked inventory, which means untracked cost. If you don't know what you paid for it, estimate conservatively.
Item is in your system but doesn't physically exist: Verify it wasn't moved, sold, or consumed. If it's genuinely gone, write it off. This is shrinkage — record it as a loss so your financials reflect reality.
3. Update your records to match the physical count. The physical count is the truth. Your records are the ones that need to change, not the items on the shelf. Record every adjustment with a reason — "stocktake adjustment: counted 11, system showed 16, probable cause: unlogged samples."
4. Calculate your shrinkage rate. Add up the total value of all negative discrepancies (items you had less of than expected). Divide by the total value of your expected inventory. Multiply by 100.
Example: Your records said you had $4,200 worth of inventory. After counting, the adjustments totaled -$380 in missing or short items. Your shrinkage rate is 9% — well above the 2-5% typical range. That's a signal to tighten your tracking immediately.
5. Identify and deal with dead stock. During the count, you probably noticed items that have been sitting untouched for months. Make a list. For each one, decide:
- Use it — can it go into a current product or a new one?
- Discount it — sell it at a reduced price to recover some cost
- Donate it — get it off your shelf and take a write-off
- Toss it — if it's expired, degraded, or worthless, throw it away and stop pretending it's an asset
Dead stock is not inventory. It's a storage fee you're paying on something that will never make you money.
Don't do this once a year — build a cycle counting habit
A full stocktake is valuable, but it's also disruptive. You have to pause operations, block time, and deal with a mountain of discrepancies at once. The alternative is cycle counting: counting a small portion of your inventory on a regular schedule so you never need a marathon session again.
How cycle counting works:
Pick a rotation — weekly or biweekly works for most small businesses. Each session, count one zone or one category. Over the course of a month or a quarter, you'll have counted everything at least once.
- Week 1: Count all raw materials
- Week 2: Count all finished goods
- Week 3: Count all packaging and supplies
- Week 4: Count your highest-value items again (these deserve more frequent checks)
Each cycle count takes 15-30 minutes. You reconcile immediately, fix any discrepancies on the spot, and move on. Problems get caught in days instead of months. Shrinkage stays visible. Your numbers stay honest.
Prioritize by value and velocity. Items that are expensive or move quickly should be counted more often. A $200 jar of saffron that you use weekly deserves a weekly check. A $5 bag of rubber bands that you refill quarterly can wait.
When to still do a full count: Even with cycle counting, do a complete physical inventory at least once a year — ideally at the end of your fiscal year or before tax season. This is your anchor point, the number everything else gets measured against. If you've been cycle counting all year, the full count should be fast and boring. That's the goal.
How Ardent Seller makes this easier
If you've been tracking inventory in a spreadsheet, the reconciliation step probably sounds painful — and it is, because spreadsheets don't track adjustments, don't log reasons for changes, and don't give you a history of what happened.
Ardent Seller has a built-in guided stocktake workflow that walks you through the count zone by zone, flags discrepancies automatically, lets you record adjustment reasons, and logs everything to an audit trail. You can run cycle counts on your own schedule and see your shrinkage trend over time — so you know whether your tracking is getting better or worse.
If you're still deciding whether to do your first count, start with the free plan and use it to build your item list. That list becomes your count sheet. The count becomes your baseline. And from there, everything else — costing, pricing, reordering — gets more accurate because it's built on numbers you've actually verified.
The checklist
Here's everything from this guide in one place. Print it, bookmark it, or copy it into a note.
Preparation:
- Block 2-4 hours with no orders or shipments
- Pause all inventory movement (no receiving, selling, or production)
- Decide scope: raw materials, finished goods, packaging, or all three
- Prepare count sheets with expected items and blank quantity columns
- Organize workspace — consolidate, group, and clear clutter
- Gather tools: clipboard, pen, calculator, scale, sticky notes
During the count:
- Divide workspace into labeled zones
- Count one zone fully before moving to the next
- Count physically — no estimating, no rounding, no "about"
- Weigh bulk items rather than counting individual units
- Mark each zone as complete when finished
- Record unexpected items not on your list
After the count:
- Compare counted vs. recorded quantities for every item
- Categorize discrepancies (minor over, minor under, major variance, untracked, missing)
- Investigate any variance over 10% before adjusting
- Update records to match physical count with documented reasons
- Calculate shrinkage rate (goal: under 5%)
- Identify and deal with dead stock (use, discount, donate, or toss)
Going forward:
- Set up a cycle counting schedule (weekly or biweekly, one zone per session)
- Count high-value and fast-moving items more frequently
- Run a full count at least once per year (end of fiscal year or pre-tax season)
Your inventory is the backbone of your business. Count it.