How to count inventory 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 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 inventory count

In the US no federal rule fixes the day you count, but your figure has to stand for the end of the tax year. If you sell goods, your return asks for inventory at the start and end of the year (Schedule C, Part III, for a sole proprietor). A small business that meets the IRS gross receipts test may choose not to keep inventories, but its method must still reflect income clearly. Either way the closing figure sets your cost of goods sold: a box missed on the count lowers the profit you report, and a box counted twice raises it.

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 during the count. Give each phone its own shelves and mark a shelf done so nobody counts it twice. Write the count date, 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.

Inventory is valued at cost or the lower of cost or market; for goods you cannot match to an invoice the regulations assume the ones left are the latest bought (first in, first out). Invenva keeps a moving weighted average purchase price for every item; if your accountant uses another method, type that unit cost into the year-end list. To count on paper, use our free inventory count sheet for Excel. Its second sheet, Year-end list, turns the count 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.