Inventory Count (Stocktake): Steps, Methods and a Count Sheet Template

An inventory count, or stocktake, is a physical count of every item in stock at a set point in time, compared against what your system says you should have. The count gives you your real closing stock; the comparison gives you the variance: stock that went missing, was wasted or moved without being recorded. For restaurants and shops with several branches, a good count needs four things: the right method for each type of item, a disciplined process, one count sheet used by every branch, and a proper look at the variances.

Why the count matters

The stock figure in your system is a calculation: opening stock plus receipts, minus sales, waste and transfers. Every missed waste entry, unrecorded transfer, wrong delivery quantity or oversized portion pulls it further from what is actually on the shelf. The count is the only point where the calculation is replaced by a fact.

That fact feeds straight into your numbers. Closing stock from the count goes into cost of goods sold (opening stock + purchases − closing stock) and, for a restaurant, into food cost %. A wrong count means a wrong cost and a wrong margin for the period. The count is also the only way to put a value on waste and shrinkage: stock lost to spoilage, breakage, mistakes or theft that never passed through the till.

Types of inventory count

There are four common methods. Most businesses with several branches end up combining two or three of them.

Periodic count

You count everything at fixed intervals, such as each month-end, and work out usage from the difference between counts. It is simple, needs nothing beyond a count sheet, and suits small operations that do not record every stock movement. The weakness: between counts you do not know what you have, and a problem that started in the first week only shows up at month-end.

Perpetual inventory

Your system updates the stock balance with every receipt, sale, transfer and waste entry, so you always have a book quantity to check against. You still count, because the book balance is only as good as the entries behind it. It suits businesses whose POS and purchasing systems record movements item by item, as most restaurant groups and retail chains now do.

Cycle count (partial or rolling count)

Instead of counting everything at once, you count a small group of items on a rotating schedule, so every item is counted several times a year without closing. Count high-value, fast-moving or easily lost items most often: proteins, dairy and beverages in a restaurant; electronics, cosmetics or best sellers in a shop. Cycle counting needs a perpetual system underneath, because every item you count needs a book quantity.

Annual full count

A complete count of every item in every location, usually at the financial year-end, because closing stock goes into the year's accounts. Even businesses that cycle count all year normally do one, and it is the count your accountant or auditor will ask about.

How to do an inventory count, step by step

1. Prepare

• Freeze movements. Count outside trading hours, stop receiving, and agree a cut-off: everything before it is recorded, and nothing moves after it until the count is done.
• Post what is pending: outstanding deliveries, transfers between branches and the day's waste log, so the book quantity is complete.
• Sort the storage. Group identical items, clear out empty boxes, label each location, and agree how open packs will be counted.
• Print the sheet in shelf order, with the unit of measure on every line, so the team walks each area once.

2. Count

• Count in pairs: one person counts, the other records. Where you can, hide the book quantity, so the team records what they see rather than what they expect.
• Use the unit on the sheet. If it says kilograms, weigh; if it says cartons, count full cartons and put loose pieces on their own line. Never mix two units on one line.
• Count by location, not by item: chiller, freezer, dry store, then the bar or shop floor. An item stored in two places gets one line per place.
• Mark each location as done, so nothing is counted twice or skipped.

3. Reconcile

Once the count is in, compare it with the book quantity line by line. Variance quantity = counted quantity − book quantity. Variance value = variance quantity × unit cost. A negative variance means stock is missing; a positive one usually means something was received or transferred in without being recorded.

Set a threshold for recounts, by quantity or by value, and recount every line above it before anyone starts investigating. Many variances disappear on a second count. For the ones that remain, check the usual causes in this order: unrecorded waste, transfers between branches, receiving errors, unit mix-ups, portioning, and only then loss or theft.

4. Post the result

When the variances are explained or accepted, the branch manager signs off, the book quantities are adjusted to the counted figures, and the variance value is recorded as a stock adjustment. File the signed sheet: it is your evidence for the period's numbers and the starting point for the next count.

Stock count sheet template

Use these fields as the column headers of your stocktake template in Excel or Word: the count details at the top, then one row per item.

• Branch: the name or code of the branch or warehouse
• Count date and cut-off
• Counter names: the person counting and the person recording
• Location: chiller, freezer, dry store, bar or shop floor
• Item code
• Item name
• Unit of measure: kg, litre, piece or carton
• Book quantity: what the system says should be there
• Counted quantity: what was physically found
• Variance quantity: counted minus book
• Unit cost: at cost price, not selling price
• Variance value: variance quantity × unit cost
• Notes: the cause found, the recount result or the action taken
• Signatures: the counter, the recorder and the branch manager

Here is an illustrative row. Branch 3, chicken breast, unit kg, book quantity 42, counted quantity 38.5, variance −3.5 kg, unit cost SAR 24, variance value −SAR 84. Notes: a 3.5 kg pack was sent to Branch 5 without a transfer entry; confirmed on recount. Once the transfer is posted, the variance clears in both places: the shortage in Branch 3 and the matching surplus in Branch 5.

Common mistakes

• Counting during service. Stock moves while you count. Count outside trading hours, or freeze the items being counted.
• Mixed units. Cartons on one sheet, pieces on another, kilograms in the system. Print the unit on every line and convert before you compare, never after.
• Ignoring transfers between branches. An unrecorded transfer shows up as a loss in one branch and a surplus in the other, and both managers get blamed for the wrong thing.
• No second count. Recount every line above your threshold before investigating; chasing what turns out to be a counting mistake wastes hours.
• Valuing at selling price. Variance value uses cost price; selling price overstates the loss.
• Adjusting without explaining. Writing the book quantity down to the count every month without asking why hides the same leak month after month.

“A count tells you what is on the shelf. The variance, and the reason behind it, tells you what to fix.”

How often to count: restaurant vs shop

There is no single rule. These are common practices; adjust them to your own stock.

• Restaurants: many count high-value and perishable items, such as proteins, dairy and beverages, every week, and do a full count at each month-end so the month closes on counted stock.
• Shops and retail chains: many cycle count high-value or fast-moving lines weekly or monthly, and do a full count once or twice a year, including the financial year-end.
• In both: count more often where variances are large, and less often where counts keep matching the book.

Counting across many branches

With several branches, the count itself is the easy part. The hard part is making the results comparable. Three things make the difference.

• One sheet, one method. Every branch uses the same template, the same item codes, the same units and the same cut-off rules. If one branch counts open packs and another ignores them, the comparison means nothing.
• Compare variance as a share, not just in riyals. A large branch will always have bigger variances in riyals. Compare variance value as a percentage of the cost of what the branch used in the period, item by item and branch by branch.
• Look for patterns, not single numbers. The same item short in every branch points to a recipe, supplier or unit problem. One item short in one branch, count after count, points to a process problem in that branch.

By hand, that means collecting every branch's sheets and matching them against its purchases, sales and transfers in a spreadsheet, usually after the period has closed.

How DataGrid helps

DataGrid brings every branch's stock, purchases, transfers and sales together in one place, so the book quantity your count is checked against is complete, and every branch's variance is calculated the same way, with one agreed number per item and per branch. The data is updated automatically every day, and the variance dashboards come ready-made, with no data team needed. When a variance looks unusual, the AI Advisor flags it and explains what changed, why, and what to check first: for example, that a shortage in one branch matches an unrecorded transfer to another. Your team makes the call. Book a demo to see your branches' variances side by side.

Frequently asked questions

How often should I do an inventory count?

Most restaurants count perishable and high-value items weekly and everything at month-end. Most shops cycle count through the year and do at least one full count a year. Either way, count more often where variances are large.

What is the difference between a periodic and a perpetual inventory count?

A periodic count tells you what you had at the end of each period, and you work out usage from the difference between counts. A perpetual system keeps a running book balance from every recorded movement, and the physical count checks that balance. Periodic is simpler; perpetual tells you where and when stock went missing.

Can I do an inventory count in Excel?

Yes. Excel works well for the count sheet itself: one row per item, with formulas for variance quantity and value. It gets hard with several branches, because someone has to pull book quantities from each branch's system, collect every sheet and keep item codes and units identical across files. The spreadsheet stays useful for counting; the comparison belongs in a system that pulls from the source data.