A store keeper writing on a clipboard in front of shelves of sacks, steel tins and tubs

Stock register format for a restaurant

By Zentaro editorial team · Published · Last reviewed · 5 min read

A restaurant stock register needs seven columns for each item: the item name and unit, opening stock, stock received, stock used, expected closing, physical count, and variance. The sum is simple. Opening plus received minus used gives the closing you expect. The physical count shows what is really there. The gap between them is your variance.

A physical count next to the book figure

What a stock register does

A register shows where your raw material went. Without it, you only learn about a loss when the shelf is empty or the cash is short.

A good register answers three questions every week:

You do not need to track every pinch of salt. Start with the items that cost the most and move fastest: rice, oil, paneer, chicken, dairy, flour, gas.

The columns, one by one

ColumnMeaning
Item and unitName and unit of measure, such as rice in kg or oil in litres
OpeningWhat you had at the start of the period
ReceivedWhat came in, from supplier bills
UsedWhat went out to the kitchen
Expected closingOpening + received − used
Physical countWhat you counted on the shelf
VariancePhysical count − expected closing
RemarksThe reason for any variance

Keep one unit for each item and never change it. If rice is in kg, write kg every time. A mix of kg and sacks is how counts go wrong.

Where each number comes from

How often to count

A weekly count of your top items is a good start. A printable daily stock count sheet helps.

Example: a rice and oil register for one week

This is an example with made-up numbers.

ItemOpeningReceivedUsedExpected closingPhysical countVariance
Basmati rice (kg)4050622827−1
Refined oil (litres)3030471310−3

Rice shows a variance of minus 1 kg. That is small and easy to explain: a spilled bag, or an estimate of use. It is not worth a hunt.

Oil shows minus 3 litres. Out of 60 litres that came through, that is a larger share. It is worth a look. Was a can opened and not entered? Was oil taken for staff meals? Was the tin measured at purchase? A short talk with the cook and a check of the store usually finds the reason.

The register did its job. It did not say who did it. It said where to look.

What to do with variance

A variance is a question, not an accusation.

  1. Check the arithmetic.
  2. Check the received column against bills.
  3. Check the used column against issues and sales.
  4. Ask the cook and the store keeper.
  5. Write the reason in remarks, even "unknown".
  6. Watch the item next week. A one-time gap is a mistake. A repeating gap is a leak.

Over time, you learn a normal variance for each item. Oil and flour often run a little off. Paneer or chicken should be tight.

Who keeps the register

Give the register to one named person, and a deputy. Two people should never share the job on the same day, because entries then go missing. The owner or manager should check it once a week, and sign the page.

Keep the store itself tidy. Put one door on it and one key. Keep items in the same place each time, with labels. A tidy store makes counting faster and makes losses easier to see. If a cook needs a lot of an item out of hours, ask for a quick note on the issue slip.

Also separate stock for the kitchen from stock for staff meals, or at least write staff meals as their own use line. Staff meals are a real cost, and hiding them in kitchen use makes the dish costs look wrong.

Common mistakes

A short checklist

Common questions

What columns should a stock register have?

Item and unit, opening, received, used, expected closing, physical count, variance and remarks.

How often should I count stock?

Daily for fast items, weekly for most dry goods, and monthly for a full check.

What is variance in a stock register?

It is the physical count minus the expected closing. It shows loss, error or waste.

Can I keep a stock register in Excel?

Yes. A sheet with these columns works well. Lock the formulas so nobody overwrites them.

Which items should I start with?

The costliest and fastest-moving: rice, oil, paneer, chicken, dairy and gas.

What if the count is higher than the book?

Over is a warning as well. A bill may be missing, or a use was not written down. Check received and used.

Where Zentaro Serve fits

In Zentaro Serve, each dish is linked to its ingredients, so selling a dish takes its ingredients out of stock. Counted stock is then compared with the book figure.

See inventory software

Pricing is coming soon

We are keeping pricing simple. We will share it when Zentaro Serve launches in 2027. Join early access and we will tell you first.