The Restaurant Inventory  Guide

The COGS formula, a count sheet that takes under an hour, a worked example, and how the count feeds food cost, variance and the order.

By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Updated November 2026.

Free printable: Year-End Inventory Count checklist (PDF)

Restaurant inventory is the weekly count of everything in the walk-in, the freezer, the dry storage and the line, valued at what you paid for it. It is the only way to get a true cost of goods sold, the only way to see waste and theft, and the only sane basis for ordering. Most operations that say they "do inventory" count monthly, late, and do nothing with the number. This guide covers the COGS formula, how to set up a count sheet that takes under an hour, a worked example, and how the count feeds food cost, variance and the order.

Why count: the number you cannot get any other way

Invoices tell you what you bought. The POS tells you what you sold. Neither tells you what you used. The difference between purchases and usage is the change in what is on the shelf, and the only way to know that is to count it. Without a count, a month where you stocked up looks like a terrible food cost and a month where you ran the walk-in down looks like a great one, and both are wrong.

The second reason is variance. Once you know what you used, you can compare it to what the POS says you sold (converted to ingredients through recipes). The gap is waste, over-portioning, spoilage, theft and unrung comps. A restaurant doing $100,000 a month in food sales with a three point gap between theoretical and actual food cost is losing $3,000 a month of product, and most that have never counted carefully are in that range.

The COGS formula

Cost of goods sold = Beginning inventory + Purchases − Ending inventory
Food cost % = COGS ÷ Food sales × 100

Beginning inventory is last week's ending count. Purchases are every invoice dated in the period, including the ones that arrived without a signature. Ending inventory is this week's count. Run it separately for food and beverage, and inside food by category if you want to know where the problem is (proteins, produce, dairy, dry, frozen).

Two adjustments keep it honest. Transfers: product moved to the bar for garnish or to a second outlet is not usage here, it is usage there. Employee meals and comps: either ring them through the POS at cost so they show in sales, or log them and subtract from COGS. Pick one and never change it.

Setting up the count sheet

The count sheet is a list of every product you stock, in the order you walk past it, with a unit and a cost. Build it once and the weekly count becomes mechanical.

  • Walk order, not alphabetical. Walk-in left to right top to bottom, then freezer, then dry storage, then the line and reach-ins. The sheet should match the walk.
  • One line per product and pack. A case of chicken breast and a 10-pound bag of the same are two lines with two costs.
  • A counting unit that matches how it sits on the shelf. Cases for sealed cases, each for open units, pounds for bulk protein and produce, portions for pre-portioned items. Note the conversion (one case equals six #10 cans) on the sheet so nobody does math on the floor.
  • Current unit cost from the most recent invoice. Update it when a price changes, or at least monthly. A count valued at last year's prices gives you last year's food cost.
  • Category tags (protein, produce, dairy, dry, frozen, paper) so you can roll up by category.
  • Par and order columns, covered below.

Expect 150 to 350 lines for a full service kitchen. If it is 600, you have a SKU problem, not a counting problem.

How to count in under an hour

  1. Same day, same time, same people. Sunday night after close or Monday morning before deliveries. Consistency matters more than the day.
  2. Nothing comes in during the count. If a delivery arrives mid-count, it sits in the office until the sheet is done.
  3. Two people. One counts and calls, one writes. It halves the time and most of the errors. The person who orders should not be the only person who counts.
  4. Count open containers by tenths or by weight. Half a case is 0.5. A bulk tub of sauce goes on the scale with the tare written on the sheet. Do not skip the open ones; they are where the money is.
  5. Count everything, including the line. Product in the reach-ins and on the steam table is still product. Count the ugly stuff at the back of the walk-in too.
  6. Enter it the same day. A count on a clipboard for three days is a count that gets lost.
  7. Review before you order. The count feeds the order. If something is short, find out why before buying more of it.

A 250-line kitchen with two people takes 40 to 55 minutes. Entering and reviewing is another 15 to 20. The first two weeks take longer while the sheet gets fixed. After that it is routine.

A worked example

Full service restaurant, one week, food only

Beginning inventory (last week's count): $18,400

Purchases (all invoices dated this week): $15,900

Ending inventory (this week's count): $17,100

COGS: $18,400 + $15,900 − $17,100 = $17,200

Food sales for the week: $52,000. Food cost: $17,200 ÷ $52,000 = 33.1%

Purchases alone would have said 30.6%. The walk-in was run down by $1,300, which is real cost that purchases hid.

Theoretical food cost from recipes and the POS mix came to 29.4 percent. The gap, 3.7 points, is $1,920 of product this week that was bought and not sold. The category roll-up showed proteins at 2.4 of those points. That is where to look first.

From the count to food cost, variance and waste

The count gives you actual usage. Three things come out of it.

  • Actual food cost by week and by category, as above. Compare to the benchmark for your concept (28 to 34 percent for most full service, see the food cost guide) and to your own trend.
  • Variance: actual usage versus theoretical usage from recipes and sales mix, by product. Sort by dollars. The top ten products will hold most of the gap, and they are almost always proteins and the one expensive produce item.
  • Waste tracking. A waste log (what, how much, why, who) during the week explains the variance. Without it you know there is a gap, not where it went. Our Waste, Spoilage and Comp Tracker is built for this.

Inventory value itself is worth watching. Most full service restaurants hold five to nine days of food on hand. Fifteen days means cash tied up and spoilage waiting to happen.

Run your own numbers

The free prime cost and pour cost calculators take a few numbers and show where you stand against the benchmark for your concept, and what each point is worth in dollars over a year. No signup.

Open the free tools Get the weekly Excel sheet

Ordering from the count: pars and order guides

Par = Average usage between deliveries × 1.25 (buffer)
Order = Par − On hand, rounded up to the pack

A par is what you need on hand to get to the next delivery with a buffer. Set it from usage, which you now have from the count, not from memory. Order quantity is par minus the count. Review pars quarterly and whenever the menu changes.

Ordering from pars does two things: it stops the walk-in filling with slow movers that spoil, and it makes stock-outs of fast movers rare because the par is built from how fast they actually move. It also removes the Thursday panic order at full price from the local market. Our Restaurant Inventory and Ordering Guide has the count sheet, usage, variance and par ordering in one workbook.

Mistakes that make counts useless

  • Counting on different days. A Sunday count one week and a Wednesday count the next makes usage meaningless.
  • Stale unit costs. The quantities are right and the dollars are wrong.
  • Skipping the line, the reach-ins or the second storage area. Product not counted looks like product used.
  • Not recording transfers and employee meals. They appear as variance and the kitchen gets blamed for the bar's garnish.
  • Letting the person who orders count alone. It is not about trust. A control checked only by the person it controls is not a control.
  • Counting and never comparing. A count entered and never set against sales is an hour wasted every week.
  • Chasing a half-point with sloppy counts. Tenths and estimates are fine for finding a three point problem. Weigh the top products before you accuse anyone of anything.

The bar inventory guide covers the same routine for liquor, draft and wine, where variance by bottle is the goal. The Prime Cost System page covers the help available when you want the first count and variance report built with you.

Want a second set of eyes on it?

The $495 Remote Prime Cost Review looks at four weeks of your real sales, purchases, inventory and payroll and shows you the three biggest leaks in dollars, with a 60-minute call to walk through the fixes. Fully remote, any US operation.

See the Prime Cost System On-site services

Related guides and tools

Free printable

Year-End Inventory Count checklist (PDF)

One week out, count day, and the checks to run before anyone goes home, with a category worksheet for Nov 30 vs Dec 31. Two printable pages.

You also get The Operator's Edge, one practical email a week. Unsubscribe in one click.

Here it is. We also sent a confirmation to your inbox.

Download the PDF

Free tool: the par level calculator sets pars from usage and the delivery schedule and tells you what to order. No signup.

FAQ

How do I calculate cost of goods sold for a restaurant?

COGS equals beginning inventory plus purchases minus ending inventory for the period. Beginning inventory is last period's count, purchases are every invoice dated in the period, and ending inventory is this period's count. Divide COGS by sales for the same period to get food cost percent.

How often should a restaurant take inventory?

Weekly for food, on the same day at the same time, with a full count of every storage area and the line. Monthly counts are too late to change anything and hide the swings that weekly counts catch.

How long should a restaurant inventory count take?

A full service kitchen with 150 to 350 line items takes 40 to 55 minutes with two people once the count sheet is in walk order, plus 15 to 20 minutes to enter and review. Counts that take three hours usually mean too many SKUs or a sheet that does not match the walk.

What is food cost variance?

Variance is the difference between actual usage (from the count) and theoretical usage (what the POS says you sold, converted to ingredients through recipes). It captures waste, over-portioning, spoilage, unrung comps and theft. Under 2 points of food cost is tight; 3 to 5 points is common in operations that have never tracked it.

How many days of food inventory should a restaurant have on hand?

Most full service restaurants hold five to nine days of food inventory. More than that ties up cash and increases spoilage. Set pars from actual usage between deliveries with a 20 to 30 percent buffer.

Should the chef count the inventory?

The chef should be involved, but not alone. Have two people count, and make sure the person who places the orders is not the only person who counts. Separating counting and ordering is the control that makes the number trustworthy.