DEV Community

nanocodes
nanocodes

Posted on

How to do a stock take in a small shop (with a free template)

A stock take is a physical count of everything in your shop and store room, compared with what your records say you should have. It is one of the cheapest ways to find out where money is leaking. Done regularly, it exposes theft, damage, miscounted deliveries and goods that simply do not sell, before they cost you real money.

Many small shop owners avoid it because it feels slow and disruptive. It does not have to be. With a plan, a small shop can be counted in a few hours.

Why a stock take matters

  • Your records drift. Every handwritten sale, returned item and delivery is a chance for a small error. Over a month those errors add up.
  • Shrinkage is invisible. Theft, spoilage and damage do not announce themselves. A count is how you notice them.
  • It guides buying. You find out what is piling up and what is always empty, which tells you what to order next.
  • It protects your profit figures. If your stock numbers are wrong, your profit numbers are wrong too.

Before you start

  1. Choose a quiet time. Before opening or after closing works best.
  2. Stop or separate sales. If you must sell during the count, write those sales down separately and adjust afterward.
  3. Receive deliveries first. Do not count while new stock is arriving.
  4. Tidy the shop. Put loose items back where they belong so nothing is counted twice.
  5. Prepare a count sheet. Every item should have one line, with space for the system figure, the counted figure and a note.

The steps

  1. Divide the shop into zones. Shelf one, shelf two, counter, store room. Count one zone at a time and mark it finished.
  2. Work in pairs. One person counts aloud, the other writes it down. This halves mistakes.
  3. Count every unit, including opened packs, display items and stock in the back.
  4. Compare each count with your record. The difference is your variance.
  5. Recount the big variances. A second count often fixes the problem. If it does not, look for unrecorded sales, returns, damaged goods or items put in the wrong place.
  6. Record the reason for every adjustment. "Damaged", "expired", "counted wrongly before" and "unknown" are very different signals.
  7. Update your records so tomorrow starts with correct numbers.

What to look for in the results

  • Repeated shortages on the same item. That is a theft, pricing or packing problem, not bad luck.
  • Slow movers. Items you have not sold for months tie up cash. Consider discounts or bundles.
  • Expiring goods. For food, drink and medicine, check dates during every count.
  • Overstock. Too much of one item usually means a reorder habit that needs changing.

How often should you count?

  • Fast-moving or high-value goods: monthly, or even weekly.
  • Everything else: every quarter.
  • A full count: at least once a year, and again whenever staff change.

You can also do cycle counts: count a few product groups every day instead of the whole shop once. The shop never has to close, and each item still gets checked regularly.

Use a template

A ready-made count sheet saves time and stops items being missed. We made a free stock taking template that you can use for your next count.

Make the next count easier

The less you have to correct, the faster a count goes. Recording every sale when it happens keeps your numbers close to the truth. SaleTick updates stock automatically with every sale, and it can warn you about low stock and expiring items, so the number on screen should be much closer to what is on the shelf.

Disclosure: I work on SaleTick.

Top comments (0)