Skip to content

Guides· 10 min read· Dishment team

Stock count sheet and inventory report template for restaurants

A restaurant stock count sheet and inventory report you can copy: the columns, a filled-in example, a stock count order and team, an equipment count, how to work out variances, and sign-offs.

Free Excel templateStock count sheetThe article’s tables and formulas, ready to use — opens in Excel and Google Sheets.

The count is done and the sheets are full, but tomorrow nobody knows what to do with the numbers. That is what an inventory report, or stock count sheet, is for: it brings the count into one document, compares book stock with what is actually there, shows the variance in manat and records who is responsible with signatures. This article gives you a restaurant stock count sheet template, a filled-in example, a stock count order and an equipment count sheet, all as tables you can copy.

How to run the count itself (how often, by zone, prepped items, theoretical vs actual usage) is covered in our restaurant inventory count guide. This one is about the paperwork.

What an inventory report is

An inventory report (in Azerbaijan usually called an "inventarizasiya aktı") lists the products that are physically in the store room, kitchen and bar on a given date. Compared with book stock, it shows a shortage or surplus for each item. People also call it a stock count sheet or stocktake report.

A restaurant usually has three documents:

  • Stock count order: who counts, when and where.
  • Count sheets: rough sheets filled in by hand, zone by zone.
  • Inventory report: the final document with variances in manat and signatures.

The stock count order and team: a template

Counting should never be left to one person, especially the person responsible for that area. So you appoint a count team first. In a small cafe that is two or three people: the manager, the head chef or storekeeper and, if possible, the accountant.

Copy this text and fill in your details:

ORDER No. ___ , Baku, ___ ________ 20__

On carrying out a stock count

  1. A count of food, drink and packaging stock at ________ restaurant is to be carried out on ___ ________ at ___:___.
  2. The count team is: chair, manager ________; members, head chef ________, accountant ________.
  3. Person with material responsibility: storekeeper ________.
  4. All receipt, write-off and transfer documents are to be handed in before the count starts; deliveries and transfers stop for the duration of the count.
  5. Results are to be submitted to the director by ___ ________.

Director: ________ (signature)

Stock count sheet and inventory report: fields you need

Header:

  • Report number, date, and start and finish time of the count.
  • Restaurant and storage area: for example "kitchen fridge 1", "dry store", "bar".
  • Count team members and the person with material responsibility.
  • The last document included in book stock: the number of the last delivery and the last write-off.

Table columns:

  1. Line number.
  2. Item name, exactly as in your system.
  3. Unit: kg, l, pcs. The same as on the recipe card.
  4. Book stock: what the documents say should be there.
  5. Counted stock: what was actually counted.
  6. Variance in quantity: counted − book.
  7. Unit cost: at the average purchase price.
  8. Variance in manat: variance × unit cost.
  9. Note: recounted, document found, reason.

At the bottom: totals for shortages, surpluses and the net variance, plus signatures of the team and the person with material responsibility.

Inventory report example: a filled-in sheet

A cafe in Baku, month-end count. Prices and quantities are examples:

No.ItemUnitBookCountedVarianceUnit cost, ₼Variance, ₼Note
1Ricekg42.041.6−0.44.20−1.68
2Beef (for lula)kg18.516.9−1.621.00−33.60counted twice
3Butterkg6.05.2−0.816.50−13.20
4White cheesekg4.04.3+0.311.00+3.30checking the delivery
5Black teakg3.02.9−0.124.00−2.40
6Lemonspcs8064−160.25−4.00tea add-on has no recipe card
7Cola 0.33 lpcs9690−60.90−5.40
8Herbs for qutabkg2.52.506.000.00
Shortages−60.28
Surpluses+3.30
Net variance−56.98

Copy the table into Word or Excel; the columns are ready. In Excel, put =E2-D2 in the Variance column and =F2*G2 in Variance, ₼.

Sign-offs:

  • Chair of the count team: ________ (name, signature)
  • Team members: ________
  • Person with material responsibility: "The count was carried out in my presence and I have seen the results" ________ (signature)

A short weekly count: a mini report for expensive items

Between full monthly counts, it is enough to count 10–15 expensive or easily vanishing items once a week: meat, butter, cheese, saffron, coffee beans, alcohol. The form is the same, just shorter, and two signatures will do: whoever counted and whoever checked. The real value shows when you put the weeks side by side:

ItemWeek 1Week 2Week 3Week 4
Beef, kg−0.3−1.1−0.2−1.3
Butter, kg−0.2−0.2−0.3−0.1
Cheese, kg+0.10−0.10

In this example the beef shortage jumps every other week. Look at the rota for those weeks: who was on shift, which day had a banquet, who signed for the deliveries. One week's variance can be chance; a repeating one is a pattern.

A stock count document in Dishment: book quantity, counted quantity and the difference
Stock count: enter the counted quantity and the difference shows straight away in units and in manat (demo data)

The storekeeper's statement

Before the count starts, the person with material responsibility writes a short statement: "By the start of the count, all receipt and issue documents have been handed in and every item I received has been booked." That one sentence prevents the later argument that an invoice was still in someone's pocket.

Equipment count sheet

Equipment and furniture don't need counting every week like food, but checking at least once a year is worth it: what you have, where it is and what state it is in. The form is simple:

Asset No.ItemLocationBook, pcsCounted, pcsConditionNote
0012Combi ovenkitchen11working
0015Walk-in coolerstore11needs repairnoisy compressor
0021Coffee machinebar11working
0034Till tabletdining room22working
0040Tabledining room1515working
0041Chairdining room60573 unusablewrite-off form

Writing off unusable equipment is a separate document, done with your accountant.

Counting the cash in the till

Counting cash is a stock count too, done at every shift close: notes and coins are counted by denomination and compared with the expected amount. We show how in our guide to X and Z reports.

DISHMENT

Want to see this in your restaurant?

We'll show you Dishment on your own menu in 30 minutes.

Free demo

You found a variance: what to do next

  1. Recount first. Check any large variance again with a different person.
  2. Check the paperwork. A delivery not entered, a write-off not recorded, a transfer to the wrong venue. How to record write-offs is in our article on food write-offs.
  3. Check the recipe cards. A lemon variance like the one in the example usually means the lemon served with tea has no recipe card, so sales never deduct it. See our recipe card template.
  4. Write the reason in the Note column and fix the process.
  5. Bring book stock in line with the count, so the next count starts from real numbers.

Can you deduct a shortage from wages? Under Article 175 of Azerbaijan's Labour Code, an employer can deduct from pay by its own order only the amounts the law lists, including damage caused by the employee's fault, capped at one month's average pay (except where the employee carries full material liability). Anything else needs the employee's written consent. Docking everyone equally without proving fault is both a legal risk and a blow to trust in the team. Talk to an accountant or lawyer in such cases.

Common mistakes

  • Showing book stock before the count. Whoever sees the number tends to write down what is expected. Count first, compare later.
  • Mixed units. "3 packs" on the sheet, grams in the system: someone converts it later and the error looks like theft.
  • Watching percentages, forgetting manat. A 20% variance on lemons costs less than 9% on meat. Sort the table by value.
  • Keeping an unsigned report. An unsigned report proves nothing in a dispute.
  • Taking deliveries during the count. New stock gets counted twice or not at all.

Stock counts in Dishment

In Dishment's Inventory and recipes module, a stock count is its own stock document:

  • The Add all ingredients button adds every active ingredient as a line, pre-filled with book stock, and you overwrite it with the counted quantity. So count blind on paper first, then type the numbers in. To count just a few items, such as expensive ones each week, add lines by hand.
  • The variance on each line is valued at the venue's average purchase price, and the document shows shortages, surpluses and the total.
  • You record a reason and a note. When the count is posted, book stock at that moment is stored in the document and balances are set to the counted figures.
  • A posted document never changes: to fix a mistake, the system creates a reversing document that undoes every movement, and both stay in the history.
  • The ingredient consumption report shows count variances separately from sales and write-offs, and it exports to CSV.

For the count sheet, print the form above without the Book column. Losses at the till are shown separately by theft and loss control. Prices are on the pricing page.

FAQ

Who signs the inventory report?

The chair and members of the count team, plus the person with material responsibility, who confirms by signing that the count took place in their presence and that they have seen the results.

How many people should be on the count team?

For an internal restaurant count, at least two: one counts, one writes, and the person responsible for an area never counts it alone. For an official stock count, agree the team with your accountant.

How do I build a stock count sheet in Excel?

Copy the table above into Excel, set Variance to counted minus book and Variance, ₼ to variance times unit cost, and add totals at the bottom. Continue the same file on a new sheet each month.

When should a restaurant do a stock count?

Expensive items are usually counted weekly and everything monthly, plus whenever the person responsible for stock changes and after big holidays. More in our restaurant inventory count guide.

How is an equipment count different?

It covers equipment and furniture, not food: each item with its asset number, location and condition. Instead of unit cost, you record the condition: working, needs repair or unusable.

DISHMENT

Try it free for 30 days

We open the account and move your menu over together. No card needed.

30 days free

Dishment

Meet your next Friday rush with Dishment

Sifariş№ 001

30 days free. We'll move your menu over together and train the team. No card needed.

or write to us WhatsApp · +994 50 563 86 36