How to Do an Inventory Count: A Stocktake Guide for Small Sellers

·

How to Do an Inventory Count: A Stocktake Guide for Small Sellers

An inventory count is the moment you stop trusting the screen and go and look at the shelf. The system says you have 30 of a product; the shelf holds 27. The missing three were sold at a weekend stand and never entered, handed out as samples, or came back damaged and went in the bin. Until someone counts, the record keeps promising stock you can’t ship.

In the UK and Australia the same job is usually called a stocktake. The work is identical: record what is physically there, compare it with what your records expect, explain the difference, then correct the record.

This guide is for small sellers without a warehouse team or a quiet week to close the doors: a shop with a counter, a stand at events, an online store, perhaps a Telegram shop on the side. It covers choosing the scope of a count, counting while orders keep arriving, handling product variants, and dealing with the differences you find.

What an inventory count is, and why stock numbers drift

An inventory count is a physical check of the units held in one stock location, recorded item by item and compared with the quantity your stock record says should be there. The result is a list of differences you can investigate and correct.

A stock record only changes when a person or a system tells it to, so anything that moves a unit silently opens a gap. In a small business the causes are ordinary:

  • Unrecorded sales: a cash sale at a market stall, an order taken by message and fulfilled by hand.
  • Samples, gifts and staff use: units that leave the shelf without ever being a sale.
  • Damage and expiry: stock thrown away instead of written off.
  • Returns: a refund processed while the item never goes back on the shelf.
  • Receiving errors: a delivery booked in from the invoice rather than from what was in the box.
  • Variant mix-ups: a customer buys Blue / L, someone records Blue / M. The product total is right; both variants are wrong.
  • Stock between locations: units sent to a pop-up or second stockroom that never quite arrive.
  • Theft: uncomfortable, but it shows up the same way, as a shortfall nobody can explain.

None of this fixes itself. Counting regularly catches a gap while its cause is still traceable, not months later when a paid order can’t be filled.

Inventory count, stock count or stocktake: one job, three names

In the US, people talk about an inventory count or a physical inventory. In the UK, Ireland, Australia and New Zealand the everyday word is stocktake, which Cambridge and Collins both list as one word, although “stock take” and “stock-taking” are common too. “Stock count” is understood everywhere.

A stock check or spot check is a quick look at a few lines when something seems off. A stocktake usually implies something planned and recorded, whether it covers everything or a defined part.

Full count, partial count or cycle count: choosing the scope

The right scope depends on how far you trust your current numbers and how much disruption you can afford.

A full count of one location

Every product in the warehouse chosen for the count, across all the physical areas that warehouse includes, such as the shop floor, the back room and any storage shelves, counted in one session. It gives you a clean baseline: the right choice for a first count on a new system, after a chaotic season, or for a reliable year-end figure. It is also the most disruptive option, because anything that moves during it muddies the result.

A partial count of the products that matter most

A chosen set of products: fast sellers, valuable lines, a category that just had a delivery problem, or anything a customer paid for that turned out to be missing. It takes far less time and can usually run around normal trading.

Cycle counting on a rotating schedule

Split the catalogue into groups and count one group each week or fortnight, so the whole range is checked over a set period. A common refinement is to count valuable and fast-moving items more often than slow, cheap ones. It turns one painful day into a short routine, but only if the schedule holds.

MethodWhat you countWhen it fitsDisruptionMain risk
Full countEverything in the chosen warehouse, across all its areasFirst baseline, year-end, after a messy seasonHigh: hours, ideally outside trading timeStock moving mid-count
Partial countA chosen set of productsFast sellers, valuable lines, suspected problemsLow to mediumOnly finds errors where you look
Cycle countA rotating group each week or fortnightOngoing accuracy without a big shutdownLow, but frequentThe schedule slips and groups get skipped
Spot checkOne or a few lines, unplannedA complaint, an oversell, a figure that looks wrongMinimalFixes the symptom, not the cause

Most small sellers combine them: a full count once or twice a year as the baseline, with partial or cycle counts in between for the lines that cause trouble.

How often a small business should count stock

The right frequency depends on how valuable your stock is, how fast it moves, and how many people and places touch it. A few anchors help:

  • A full count once a year is a common baseline. Many businesses time it around their financial year-end; ask your accountant whether they need one and what it should cover.
  • Regular partial counts for risky lines: expensive items, small items that are easy to pocket, anything that sells in bursts.
  • After every peak. A promotion pushes many units through in a short time, so a count belongs in the review after a peak sales week like Black Friday.
  • After an event. Stock that went to a market or trade show should be counted when it returns, before it mixes with the rest, as part of closing each day of a trade show.
  • Whenever the numbers lie. An oversold product or a low-stock alert that doesn’t match the shelf is a reason to count now, not at the next scheduled date.

Preparing for the count when orders keep coming in

Most stocktake advice starts with “stop all movement”. For a small seller with an online store that never closes, that isn’t always realistic. You can still get a trustworthy count if you control what moves and when.

Know which stock record you are counting. A shop floor and its back room are two physical areas, but they are often one warehouse in the system. Then they form one count: use a sheet per area and add the results together. Only stock held in a separately configured warehouse needs its own count.

Pick the quietest window and write down a cut-off time. Before opening, after closing, or your slowest weekday morning. The cut-off is your reference point: the count describes the shelf at that moment.

Log every movement after the cut-off. The cut-off doesn’t stop the business. Any sale, return, delivery or transfer that touches the counted area afterwards goes on a log: time, product, variant, quantity, direction. Before you read the differences, reconcile those movements back to the cut-off so counted and expected describe the same moment: a unit counted at 10:15 and sold at 10:40 has left the record but was on the shelf when you counted. Systems differ on when they capture the expected quantity (when the count starts, as lines are entered, or when it is finalised), so check yours first. If you can’t tell, pause sales from the counted area while you count.

Settle paid orders that haven’t been packed. Systems differ on when an order reduces the stock record: at payment, or when it is packed or shipped. If yours deducts at payment, those units are on the shelf but no longer expected there, and counting them will “find” stock that is already sold; if not, they belong in the count. The cleanest option is to dispatch them before the cut-off. Otherwise, move them to a labelled area, list the order numbers, and count or exclude them according to your system’s rule.

Keep deliveries and transfers apart. Finish booking in deliveries before the cut-off, or leave the boxes unopened until afterwards. Where units on the road sit in your records depends on the system and the transfer’s status: still with the sending warehouse, or in a separate in-transit state until received. Check every open transfer before you count either end and, ideally, receive or settle stock in transit between warehouses first.

Protect the lines that sell during the count. If a fast seller with a few units left could sell while you work, count it first and note the time, or take it off sale for the hour you need.

Tidy before you count, not during. Keep each product in one place, separate damaged or expired items, and label shelves so the sheet and the stockroom follow the same order.

How to do an inventory count, step by step

Paper, spreadsheet or software, the procedure is the same:

  1. Choose the warehouse and the scope. One count covers one stock location as your system defines it, however many rooms it spans: everything there, or a defined list of products.
  2. Record the cut-off and clear open movements. Note the time, deal with paid-but-unpacked orders, keep unbooked deliveries and incoming transfers out of the count area, and start the movement log.
  3. Prepare the sheet without expected quantities. List product, variant, SKU and shelf location, but leave the system figure off. A counter who can see “30” tends to find 30.
  4. Count shelf by shelf, not product by product. Work through each area in a fixed direction. If a product sits in two places, record both and add them up.
  5. Give every variant its own line. Red / S and Blue / L are different stock. A swap between sizes is invisible in the product total and obvious at variant level.
  6. Count what is there, never what should be there. Open boxes unless they are sealed and verified. Don’t round, and don’t estimate.
  7. Record damaged and expired stock separately. It is physically present but not sellable, and needs its own decision.
  8. Check everything before you finalise. Make sure every line in scope has a quantity, and have a second person recount high-value lines and anything that looks wrong. Only then close the count, noting the date, warehouse, cut-off and who counted. In some systems a finalised count can’t be changed, so treat closing as the last step.

A barcode scanner cuts typing errors, but a careful count on paper still beats a hurried one with a scanner.

Reading the discrepancy report: expected, counted, difference

Seller checking a product jar against a printed count sheet, with a laptop showing on-hand and counted quantities on the desk

Set the count against the record and every line has three numbers: what the record expected, what you counted, and the difference. That list is your discrepancy report, and it is where the real work starts.

Product / variantExpectedCountedDifference
Canvas tote, black3027−3
T-shirt, blue / M1214+2
T-shirt, blue / L108−2
Ceramic mug, white24240

Read the lines together. The T-shirts balance overall: two more M, two fewer L. That could be two L sales recorded as M, but also a delivery booked in under the wrong size, an exchange processed the wrong way round, or a counting slip. Recount both sizes and check recent sales, returns and deliveries before correcting anything. If it is a recording swap, nothing is lost, but the record will oversell size L. The totes show a shortfall that needs an explanation.

  • Recount before you explain. Large or high-value differences get counted again, ideally by someone else.
  • Look for pairs. A plus on one variant and a minus on its neighbour often points to a recording or shelving error rather than missing stock, but confirm it before you treat it that way.
  • Check the cut-off and the movement log. Orders, deliveries and transfers either side of the cut-off cause many small differences.
  • Walk back through recent movements: sales by hand, samples, items refunded but never put back on the shelf, damaged stock thrown away.
  • Don’t ignore positive differences. An extra unit can mean a return was restocked twice or a delivery was never booked in.
  • Write the cause next to the line. Even “unexplained” helps: a product that keeps coming up unexplained is telling you something.

Reconciling the count and correcting your stock records

Reconciliation turns a count into better numbers. Once a difference has been recounted and, where possible, explained, the stock record for that line in that location should match what you counted.

  • Adjust line by line, for the warehouse you counted. Don’t spread a shortfall across other warehouses or round it into another variant.
  • Keep the reason with the adjustment. Over a year, those reasons show where stock really goes.
  • Decide what happens to non-sellable stock: write off, return to the supplier or sell as seconds, and record it.
  • Keep the report. A dated count is the evidence behind your stock figure, and your accountant may ask for it.
  • Fix the cause, not just the number. Recurring variant swaps point to the till or the picking routine; missing returns point to a returns process with no restocking step.

Counting stock when you sell in more than one place

One rule covers most multichannel setups: count stock locations, not sales channels. If your counter, kiosk, online store and Telegram shop all draw on a shared inventory record for the same stock, one count of that stock serves every channel. If the channels run on separate systems, each holding its own quantity for the same units, one count isn’t enough on its own: you also have to reconcile each system’s figure against what you counted. Separate figures per channel are how numbers drift in the first place, which is why running several channels from one stock pool makes counting simpler.

When stock is recorded under different warehouses, each warehouse gets its own count, ideally on the same day. Event stock is easiest to control when it is set up as its own warehouse: counted out, sold through the counter or self-service kiosk at the event, and counted back in. With several stock locations, staggered counts are fine as long as nothing moves between two warehouses while either is being counted.

How counts work in Trapyfy

Trapyfy is a commerce platform for sellers who run several ways of selling from the same stock: a Telegram shop, a staffed point of sale and a self-service kiosk all sell from your warehouse stock. Stock is held per warehouse and country, and variable products hold stock per variation rather than per product.

Counts live under Inventory → Inventory count in the dashboard, and follow the steps above:

  • One count, one warehouse. You start a new count and choose the warehouse you are standing in. If your shop floor and back room are set up as one warehouse, a single count covers both; if they are set up as separate warehouses, each needs its own count.
  • Full or partial. Count everything in that warehouse, or a selection of products.
  • Expected, counted, difference. You type the quantity you actually see; completing the count produces a discrepancy report with all three figures.
  • A searchable history. Counts can be filtered by reference, warehouse, count type and start date, and each shows its status.
  • A permanent record of what you counted. A completed count keeps the products you counted and the quantities you entered, and exports to Excel or PDF. Unfinished counts can be deleted; completed ones can’t, so check your figures before you complete.

Full and partial are the two count types the documentation describes. Cycle counting, blind counts and spot checks, covered earlier, are ways of organising your counts rather than separate Trapyfy features: a cycle count, for example, can be planned as a series of partial counts.

The full reference is in the Inventory Count documentation.

A stocktake checklist you can print

Before the count

  • Choose the warehouse, list the physical areas it covers, and decide between a full and a partial count.
  • Book a quiet window and agree a cut-off time.
  • Check when your system deducts stock for paid orders; pack or set aside those not yet packed.
  • Finish booking in deliveries; check the status of transfers to and from this warehouse and settle them if you can.
  • Tidy shelves and separate damaged or expired stock.
  • Prepare count sheets without expected quantities on show.
  • Assign counters and a second person for recounts.

During the count

  • Work shelf by shelf in a fixed direction.
  • Record every variant on its own line.
  • Open boxes unless sealed and verified.
  • List damaged and expired units separately.
  • Log every sale, return, delivery or transfer after the cut-off, with time, variant and quantity.
  • Recount high-value lines and anything that looks wrong before you finalise.

After the count

  • Reconcile logged movements back to the cut-off.
  • Recount large and high-value differences before adjusting.
  • Check variant pairs, but confirm the cause before treating them as a swap.
  • Record a reason against each difference.
  • Correct the stock record for the warehouse you counted.
  • Decide what happens to damaged and expired stock.
  • Save or export the report and file it.
  • Fix the process behind the biggest differences.

Frequently asked questions

How often should a small business do an inventory count?

Many small businesses run one full count a year, often around the financial year-end, plus partial or cycle counts in between for fast-moving and high-value products. Count again after busy periods and events, and whenever an oversell or a mismatched low-stock alert suggests the record is wrong.

Is it stock take or stocktake?

Both are used. Cambridge and Collins list “stocktake” as one word, the most common form in UK and Australian business writing, but “stock take” and “stock-taking” also appear. In the US, the same process is usually called an inventory count or physical inventory.

Do I need to stop selling during a stocktake?

Not always. A full count is most reliable when nothing moves, so it works best outside trading hours. If an online store keeps taking orders, set a cut-off time, deal with paid-but-unpacked orders, count the fastest sellers first, and log every movement after the cut-off so you can reconcile it back to the moment you counted.

What is a blind count?

A blind count is one where the person counting can’t see the quantity the system expects. It stops counters from unconsciously confirming the number on the screen. Expected and counted quantities are compared only once the count is finished.

What causes inventory discrepancies?

The usual causes are unrecorded sales, samples and gifts, damaged or expired stock thrown away, returns refunded but never restocked, deliveries booked in from the invoice rather than the box, variants recorded under the wrong size or colour, stock lost between locations, and theft.

Can I do an inventory count with a spreadsheet?

Yes. For a small catalogue in one location, a spreadsheet with one row per variant and columns for location, expected, counted and difference works well. It gets harder with many variants, several locations or sales from several channels, because keeping expected figures current by hand becomes a job in itself.

When the shelf and the screen agree

A good count isn’t dramatic. It is a quiet hour, a clear cut-off, every variant on its own line, and a short list of differences with a reason next to each. Do that often enough and the stocktake stops being a dreaded annual event. It becomes the routine that lets you say “in stock” with confidence, whether the customer is at your counter, at your stand or ordering online.

If you want counts, warehouses and sales channels in one place, create a Trapyfy account and run your first count on the stock you already hold.