A restaurant inventory spreadsheet that people really use

The short answer

A restaurant inventory spreadsheet is a count sheet with one row for each item and a few columns: item, unit, par, on hand, and to order. Keep the rows in shelf order and keep the sheet short enough that a cook will fill it in.

What is a restaurant inventory spreadsheet?

It is a list of everything you buy, with room to write down how much you have. One row for each item. One column for each thing you want to know.

You can build it in Excel or Google Sheets in an evening. You do not need a fancy template. You need a sheet your cooks will fill in without grumbling.

If you want the bigger picture first, read our guide to restaurant inventory management. This post is only about the sheet.

What columns does a kitchen count sheet need?

Start with five. Add more only when you miss them.

  • Item. Use the name your cooks use. Write “limes,” not the name on the invoice.
  • Unit. Count in the unit you order. If you order a case, count cases. If you order pounds, count pounds.
  • Par. The amount you want on the shelf when the truck arrives. Our par level post shows how to set one.
  • On hand. What you actually counted. This is the only column a cook fills in by hand.
  • To order. Par minus on hand. Let the spreadsheet do this sum, so nobody does it in their head on a Friday.

Later you may add a column for the supplier, the storage spot, or the price per unit. Do not add them on day one. A sheet with twelve columns is a sheet nobody finishes.

Example: a made-up count sheet with made-up numbers, not typical
ItemUnitParOn handTo order
Salmon filletslb401228
Short riblb602238
Limescase312
Romainecase413
Russet potatoes50 lb bag431
Lime cremaqt624
Heavy creamqt853
Fry oiljug312

Read the first row. The kitchen wants forty pounds of salmon. A cook counted twelve. The sheet says order twenty-eight. Nobody had to think.

Try it here
Heard. Limes are low. I put 1 case on the Fresh Valley order.

Pick Chef Maya in the pretend kitchen and say “We’re low on limes.” Try the demo

How do you lay it out so a cook can fill it in a walk-in?

A walk-in is cold, loud and crowded. The cook has one free hand and no patience. Build the sheet for that cook, not for the office.

  1. Put the rows in shelf order. Start at the door and end at the door. Group by storage spot: walk-in, freezer, dry storage.
  2. Use big type and wide rows. A cook in gloves must be able to read it and write in the box.
  3. Leave the math to the sheet. Only “on hand” is typed. The “to order” column is a formula the cook never touches.
  4. Keep it to one page. Two sides at most. Start with the items that hurt when they run out.
  5. Bring a clipboard or a tablet. A phone in a cold walk-in can be slow, and a dead signal is common. Many kitchens count on paper and type it in later.

Count with a second person, one calling the number and one writing it down. Our count routine post shows how to walk the shelves.

What does a spreadsheet do well?

It is cheap, and it is yours. You can change a column in a minute. Nobody has to learn a new program.

  • It does the sum. Par minus on hand gives you the order every time.
  • It keeps old counts. Save a copy each week and you can see how the limes moved.
  • It is easy to share. In Google Sheets, the chef and the sous chef can open the same file.
  • It starts today. You do not wait for a demo, a contract or a setup call.

For a small kitchen with one count a week, this may be all you ever need.

Where does a spreadsheet break?

A spreadsheet does exactly what you typed and nothing else. It does not know what a cook did on the line. It does not know the truck came in short.

  • It goes stale. The count is right on Monday. By Thursday the shelf has changed and the sheet has not.
  • Someone breaks a formula. One cut and paste and the “to order” column is wrong. Nobody notices until the order is short.
  • Many copies. Someone saves “count final” and “count final 2.” Now you have two truths.
  • It does not know about prep. A batch of lime crema uses limes and cream. The sheet does not take them off the list.
  • It does not know about sales. Salmon sold on Saturday does not lower the number on the sheet.
  • Typing takes time. A cook counts in the cold, then someone retypes it at a desk. That is a second chance for a mistake.

None of this means the spreadsheet is bad. It means you should know its limits.

When should you move on from a spreadsheet?

Stay with it while it saves you time. Move on when it starts to cost you time.

  • You run out of things the sheet said you had.
  • Counting takes so long that people skip it.
  • Two people keep two versions of the sheet.
  • You add a second location or a second kitchen.
  • You want to see waste, prep and orders in one place.

Before you buy anything, read our guide on how to choose restaurant inventory software. It lists what to ask and what to skip.

How does Heard help with this?

Heard is a voice board for restaurant kitchens. You can start a 30-day free trial of Heard from the pricing page while our first 10 places last.

The Starter plan lists an import from a spreadsheet or an order guide, so your count sheet does not have to be typed in again. Heard keeps a stock list with a par for each item. Say “We’re low on limes” and Heard marks the limes low and puts one case on the order. See the low stock page for how it works. The pricing page lists what each plan includes.

Someone still counts the shelves. The demo is a pretend kitchen with made-up people and numbers, and nothing is sent to anyone. Try the demo, pick Chef Maya, and say “We’re low on limes.”

Quick questions

What columns should a restaurant inventory spreadsheet have?

Start with item, unit, par, on hand and to order. Add supplier or price later, only if you need them.

How do I work out what to order?

Subtract what you counted from par. The answer is the gap, and the gap is what you order. Let the spreadsheet do the sum.

When should a kitchen stop using a spreadsheet?

When it costs more time than it saves. Signs are skipped counts, two versions of the sheet, or a second location.

Free tools: Plate cost calculator, Par level calculator