4 ways to automate stock counts

Liam Jones

Liam Jones

Founder, Pilla App

Date Modified

29 May 2026

I'm Liam Jones, founder of Pilla and a qualified management consultant. I've helped hundreds of businesses set up workflows, and in this article I'm going to show you four real examples of how to set up your stock counts. I'll start from the simplest and then add some more powerful options. You can open up each template in our workflow builder playground as a starting point and experiment for yourself. If you have any suggestions or you need some help, you can email me directly.

The workflows at a glance

  • #1 - The basic check-in. A simple count where the person logs the item, what the system expected, what they actually counted, the variance, and a note.
  • #2 - With written guidance. The same shape with guidance panels on how to count a shelf and what to do when a variance is big.
  • #3 - With photo evidence. The guided count plus a photo of the shelf or storage, so a recount or a queried variance has something to look at.
  • #4 - With photo and signature. The photo-evidenced count plus two signatures, the counter's and a manager sign-off, so a queried count has a name against it.

Article Content

#1 - The basic check-in

Who it's for: Single-site businesses doing a periodic count, anyone who needs to know what is actually on the shelf without running a full audit.

Available on: Basic.

What it is: A stock count is a record of what you physically have, logged against what the system says you should have. This version captures five things per line: the item, the expected count, the counted total, the variance, and a note. Each line is one stamped record. The person counting runs the canvas once per item or category, and the day's count is the list of completions.

In practice: Take a single-site hardware shop. On the first of the month the assistant counts the paint aisle. They open the canvas, type "Matt emulsion 5L", read "Expected count" off the system as 18, count the shelf and the stockroom and put "Counted total" as 15, log a variance of minus 3, and write "two tins damaged, one sold but not scanned" in the notes. They submit and move to the next line. By the end of the aisle there is a row per product, each with a number against the system and a reason where the two do not match.

Why it works: The variance is the point. A count on its own only tells you what is on the shelf. A count against the expected number tells you whether the system can be trusted, and the note tells you why it cannot. The moment the count is logged on the canvas, it is a server-side record the manager can pull later, not a number on a clipboard that gets thrown out at the end of the day.

Steps included:

  • 1 text input (item)
  • 3 number inputs (expected count, counted total, variance)
  • 1 text input (notes)

When to upgrade:

  1. Add written guidance (#2) once more than one person runs the count, so everyone counts a shelf the same way and a misplaced case stops reading as a false variance.
  2. Add photo evidence (#3) once a variance gets queried after the fact and a number alone does not settle it.
  3. Add signatures (#4) once a count is something a head office, an auditor, or an insurer could ask you to stand behind.

#2 - With written guidance

Who it's for: Sites with rotating staff who all need to count the same way, so the count from a Saturday casual matches the count from the full-timer.

Available on: Standard.

What it is: The basic count plus two guidance panels woven through the canvas. The first panel tells the person how to work a shelf: start at the front, check the back of house and any displays, group by SKU, and ask before logging a zero. The second panel tells them what to do when a variance is big: log it, and flag a short on a high-value or fast-moving line to the duty manager straight away. A new starter on their first count gets the same method as someone who has done it for years.

In practice: Take a three-site convenience chain. Stock is counted by whoever is on shift, which on a given week might be four different people across the three shops. Before guidance, one person counted only the shelf and another included the stockroom, so the same product threw a different variance depending on who did it. The "How to count" panel now puts everyone on the same path: shelf, back of house, displays, group by SKU. The "What to do about variance" panel tells them not to sit on a short of cigarettes or spirits but to flag it to the duty manager there and then. The variances stop being noise and start being something the area manager can read.

What it adds to the previous template:

  1. A "How to count" panel before the inputs that walks the person through working a shelf in order and asking before logging a zero.
  2. A "What to do about variance" panel after the inputs that separates a small variance from a big one and names who to tell.
  3. A consistent method across everyone who counts, so the variance reflects the stock, not who happened to be on shift.

Why it works: Written guidance sits inline at the moment the person is about to count. They read the method the first time they open the canvas, and it is there again the next time. It is not a briefing they half-heard on their first day. The most common cause of a false variance is a misplaced case, and the guidance catches it before a zero gets logged in error.

Steps included:

  • 1 guidance panel (how to count)
  • 1 text input (item)
  • 3 number inputs (expected count, counted total, variance)
  • 1 text input (notes)
  • 1 guidance panel (what to do about variance)

When to upgrade: Move to Stock Count #3 once a number on its own stops settling an argument. The first time a big variance gets queried by head office a week later and nobody can remember what the shelf actually looked like, a photo at the moment of the count would have closed it.

#3 - With photo evidence

Who it's for: Businesses that want a photo of the shelf for recounts, so a queried variance has something to look at instead of just a number.

Available on: Standard.

What it is: The guided count plus a photo step at the end. The person takes a quick shot of the shelf or storage they have just counted, and it lands in the record next to the numbers. A variance is no longer just minus 7 with a note. It is minus 7 with a note and an image of exactly what the shelf looked like at the moment of the count.

In practice: Take a regional garden centre with a busy seasonal range. In spring, fast-moving lines like grow bags and bedding plants turn over so quickly that the system is almost always behind. An assistant counts the bedding bay, logs a variance of minus 40 on a tray line, and takes a photo of the half-empty bay. When the buyer at head office sees the variance and asks whether it is a miscount or genuine sell-through, the photo answers it in seconds: the bay is visibly stripped, the variance is real, reorder. No drive to the site, no recount, no argument.

What it adds to the previous template:

  1. A photo step at the end of the count, after the variance note.
  2. A visual record of the shelf or storage paired with the number, so a recount can be judged from the image.
  3. Context a number cannot carry: a stripped bay reads as genuine sell-through, a full shelf with a big short reads as a miscount or a problem.

Why it works: A number is data. A photo is context. A variance of minus 40 could be a miscount, theft, wastage, or genuine sell-through, and the number alone cannot tell you which. The photo, taken at the moment of the count on the same device, shows the state of the shelf and lets the person reading it decide without a return visit. It cannot be reconstructed after the fact.

Steps included:

  • 1 guidance panel (how to count)
  • 1 text input (item)
  • 3 number inputs (expected count, counted total, variance)
  • 1 text input (notes)
  • 1 guidance panel (what to do about variance)
  • 1 photo step (the shelf or storage)

When to upgrade: Move to Stock Count #4 once a count is something the business has to stand behind. The first time a stock loss goes to an insurance claim, or a head office wants a name against every count, a photo without a signature starts to look unfinished.

#4 - With photo and signature

Who it's for: Stock-sensitive businesses that need a signed, manager-reviewed count, where a variance has to have a name against it and a second pair of eyes.

Available on: Standard.

What it is: The photo-evidenced count plus two signatures at the end. First the person who counted signs. Then the duty manager signs after a quick review, which matters most on a big variance. The record now carries the numbers, the note, the photo, the counter's name, and a manager's confirmation that they looked. Two people are on the hook for the count, not one.

In practice: Take a multi-site off-licence group where spirits and high-value wine walk if nobody is watching. Every count on a controlled line ends with two signatures. The supervisor counts the spirits shelf, logs a variance of minus 6 on a premium whisky, takes a photo, and signs. The duty manager comes over, looks at the shelf and the number, agrees it is a genuine short rather than a miscount, and signs the sign-off. When the area manager reviews the week's counts, every controlled-line variance has a counter and a manager against it. A short that nobody signed off stands out immediately as one to ask about.

What it adds to the previous template:

  1. A counter's signature, so the person who did the count is named on the record.
  2. A manager sign-off signature, so a second person has reviewed the count, which is especially important on a big variance.
  3. Two-person accountability on every count, so a queried variance points at a named counter and a named reviewer rather than at nobody.

Why it works: The signatures are what close the loop. The numbers, the note, and the photo say what was counted and what it looked like. The counter's signature adds: and I am the person who counted it. The manager sign-off adds: and I have reviewed this and I agree. On a stock-sensitive line, a count nobody will sign is itself a signal, and a count two people have signed is one a head office or an insurer will accept without a return visit.

Steps included:

  • 1 guidance panel (how to count)
  • 1 text input (item)
  • 3 number inputs (expected count, counted total, variance)
  • 1 text input (notes)
  • 1 guidance panel (what to do about variance)
  • 1 photo step (the shelf or storage)
  • 2 signature steps (counter's signature, manager sign-off)

When to upgrade: The next variations layer Poppi on top. A Poppi briefing that surfaces the lines that threw a variance last time before the count starts. A Poppi gate that decides whether a variance is big enough to need a manager. A Poppi action that posts a flagged short straight to the area manager's channel. Coming in the next post update.

How to pick the right version

You do not need to know how the canvas builder works to pick the right version. You only need to answer three questions about how your team runs.

Is it just you running this, or do other people run it too?

If it is just you, the basic count (#1) is enough. You know how you work a shelf, you know when a variance is worth a note, and you do not need the canvas to coach you.

If anyone else runs the count (a part-timer, a new starter, a rotating crew across sites), go to #2 onwards. The guidance panels are what stop one person counting only the shelf while another includes the stockroom. You write the method once; everyone reads it inline as they count.

Do you need a photo as proof, or is the typed record enough?

If a variance would be handled on the spot (the manager looks at the shelf, agrees the number, moves on), the typed record is enough. Go to #1 or #2.

If a variance would be queried later by a head office, a buyer, or an investigation, a number on its own rarely settles it. They want to see the shelf. Go to #3. The photo at the moment of the count shows whether a big short is genuine sell-through or a miscount, without anyone driving back to site.

Do you need someone to sign off at the end?

If the count is operational and nobody will ever ask you to stand behind it, a record is enough. Stick at #3.

If the count is on a stock-sensitive line, or a head office or insurer expects a name against it, the signatures are the lock. Go to #4. The counter signs that they counted it, and the manager signs that they reviewed it, so a queried variance has two named people on the record rather than nobody.

Conclusion

A stock count is a record of what you physically have, logged against what the system says you should have, with the variance and the reason captured per line. The version a stock-sensitive business runs settles a queried variance from the photo and the two signatures, so nobody has to drive back to site to recount.

Pick the version that matches how your team runs today, not the most thorough one you can imagine running someday. Open each template in the playground above and try it on a real count this week.