How to do a stocktake in a small shop without losing a day

Why the numbers drift in the first place

Every shop that has never counted believes its records. Every shop that has counted knows better. Stock drifts for boring reasons: a bottle broke and nobody wrote it down, a box was used for the shop itself, a delivery arrived short, a sale was rung up on the wrong product, and sometimes something walked out of the door. None of these show up in the records on their own. A count is the only moment the records and the shelf meet.

That is also why a count is worth doing even when it finds nothing. A count that matches is proof, and the next time a number looks strange you know it was right a month ago.

Before you start

Pick a moment when stock is not moving: after closing, before the first delivery, or a slow morning. If you cannot stop sales, note the time you start and count each area in one go, so a sale during the count cannot fall between two people.

Then prepare the list. Every product with the quantity the records claim, in the order the shelves are actually walked, not in alphabetical order. If two people count, give each one a whole shelf or a whole room. Two people on the same shelf is how the same box gets counted twice.

• Print the list or open it on the phone, one line per product, book quantity beside it.
• Agree on the unit before anyone starts: is a case one, or twelve?
• Keep a pen or a note field for the reason when a line does not match.

Counting without losing your place

Count what is in your hand, not what should be there. The single most common counting error is glancing at the book quantity, seeing a plausible number, and ticking it. Cover the book quantity if you have to. Count, then compare.

Tick each line the moment it is done and leave it exactly where it is. Lists that reorder themselves as you tick, or that hide counted rows automatically, make people lose their place on a physical shelf. A list that stays put is faster.

When a line does not match, write the reason now, on the shelf, while you can still see the damaged box or the empty space: damaged, expired, lost, miscount, theft. Reasons collected an hour later are guesses.

After the count

Review the differences before you apply anything. Large differences deserve a recount of that one line; it takes a minute and it is where most counting mistakes hide. Then apply all corrections in one step so the records show one count, on one date, by one person, with the before and after for every line.

Keep that record. A count that is applied silently, by editing quantities one at a time, cannot be audited later and cannot tell you whether shrinkage is going up or down. Six months of count records are what turn a vague feeling of "things go missing" into a number you can act on.

How often

A small shop does well with a full count once a month and, every week, a short count of the twenty products that move most. These are the products that drift, and twenty lines take fifteen minutes. A warehouse with hundreds of lines usually moves to cycle counting: a different section every week, so every shelf is counted a few times a year without ever closing.

Line the full count up with the end of your accounting year. The valuation your accountant asks for is that count multiplied by cost, and a count you already keep costs nothing extra.

The year-end stocktake

A limited company that deals in goods must keep a statement of the stock it held at the end of each financial year, with all the stocktake sheets behind it (Companies Act 2006, s.386). The Act asks a private company to keep them for three years (s.388), but for Corporation Tax a company must keep its records for six years from the end of the accounting period (Finance Act 1998, Sch. 18, para. 21), so in practice keep them for six. Since April 2024 sole traders, and partnerships without a company as a partner, use the cash basis by default, and on the cash basis there is no need to account for stock. If you use traditional accounting, which GOV.UK suggests for a business with high levels of stock, your accountant needs the closing figure.

Book every delivery and sale up to the moment you start. If the shop stays open, keep new deliveries unopened in one marked spot and note the time of each sale made during the stocktake. Give each phone its own shelves and mark a shelf done so nobody counts it twice. Write the date of the stocktake, the year-end date and who counted on the sheet. Goods lent to a customer are still yours but not on the shelf: add them to the year-end list from Invenva's On loan list, not to the count.

Stock is valued at the lower of cost and net realisable value, leaving out any VAT you can reclaim, and FRS 102 allows first in, first out or a weighted average cost, which is how Invenva keeps the purchase price. To count on paper, use our free stocktake sheet for Excel. Its second sheet, Year-end list, turns the stocktake into a valued list: line numbers, unit cost, value, a total and two signature lines.

Mistakes we see most

• Counting from memory, or from the book quantity, instead of from the shelf.
• Fixing quantities one by one during the week and calling it a count.
• Two people on the same shelf, or nobody sure who had the back room.
• Recounting only the lines with big differences and trusting the rest.
• Never writing the reason down, so a year of shrinkage has no explanation.

Doing it in Invenva

Stock Count in Invenva is built around exactly this list: every row starts with the book quantity, you tick rows in place and they stay where they are, a mismatched row gets a reason chip on the spot, and Apply writes one count record with who, when, and before and after for every line that changed. You can scan barcodes to tally instead of typing, and a count can be limited to one category or one shelf.

Two people can split the shelves between two phones. On the yearly Pro plan the first 7 days are free: enough to count the whole shop, apply the result and export the stock list for the accountant.