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.
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.
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.
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.
Expect 150 to 350 lines for a full service kitchen. If it is 600, you have a SKU problem, not a counting problem.
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.
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.
The count gives you actual usage. Three things come out of it.
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.
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 sheetA 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.
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.
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 servicesFree printable
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.
Here it is. We also sent a confirmation to your inbox.
Download the PDFFree tool: the par level calculator sets pars from usage and the delivery schedule and tells you what to order. No signup.
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.
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.
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.
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.
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.
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.