How to Track Food Cost Without Losing Your Mind (2026)
You don't need fancy software or a degree in data science to get your food cost under control. You need three things: a weekly food cost number, a real inventory count, and a habit of watching a few high-cost items closely. Do that, and the "money is leaking somewhere" mystery almost always turns out to be one of four things — waste, bad portioning, missed deliveries, or theft. All four are findable. Let me walk you through it the simple way.
First, some relief. If you spent your Sunday fighting invoices from three suppliers and your POS and your inventory count, and none of the numbers matched — that's not you being bad at math. That's just how it looks before you have a system. Every owner has been there. The trick isn't working harder on the reconciling. It's changing what you measure and how often.
Why Your Numbers Never Match (and Why That's Fine)
Here's the first thing to accept. Your meat supplier and your produce supplier say different things because they're selling you different products. Reconciling their invoices isn't a sign something's broken. It's just part of the job. Don't expect three suppliers to ever "agree" — they won't.
The bigger reason your numbers feel off is this: you can't get a true food cost from invoices alone. Invoices tell you what you bought. They don't tell you what you used. The gap between those two is sitting in your walk-in right now, as inventory. Until you count it, your food cost is a guess.
So the fix isn't more spreadsheet detective work. It's adding one missing piece: a real count of what's on your shelves.
The One Number That Actually Matters: Food Cost %
Before you track anything fancy, get comfortable with a single number. Food cost percentage. It's the simplest health check you have.
The basic weekly version is easy:
Food cost % = cost of food used ÷ food sales
If you used $3,000 of food and sold $10,000 of food, your food cost is 30%. Run that every week, then look at the monthly average so one weird week doesn't scare you. Most full-service spots aim for somewhere around 28–35%, but your target depends on your concept.
But notice the words "food used," not "food bought." To get "used" right, you need the count. Here's the real formula:
Food used = starting inventory + purchases − ending inventory
That's your true cost of goods. Count your shelves at the start of the period, add everything you bought, subtract what's left at the end. That's what you actually consumed. Divide by sales, and now your percentage means something.
Do a full inventory count at the end of every month or period. It's the single biggest jump in accuracy you'll make.
Start Small: Track a Few High-Cost Items Every Day
A full count is a monthly job. But you don't want to wait a whole month to spot a leak. So here's a trick that gives you answers fast, and it's the best advice in this whole conversation.
Pick your two or three most expensive items. Usually that's proteins — chicken breast, steaks, salmon. Then do a mini count on just those.
- Tuesday morning: weigh all your chicken breast and count your 8oz steaks.
- Wednesday morning: weigh and count them again.
- Look at what you sold Tuesday on the POS.
- The amount that disappeared should roughly match what you sold.
If you sold 20 steaks and 22 are missing from the count, you've got a small gap — no big deal. If 35 are missing, something's wrong, and now you know within a day, not a month. Rinse and repeat Wednesday to Thursday, Thursday to Friday. Go a full week on those items. When they look clean, move to the next high-cost item.
Is it a little tedious? Sure. But you'll build a deep gut feel for your expensive items fast — and catch problems while they're small.
Where the Money Actually Leaks: The 4 Usual Suspects
When your food cost is too high, it's almost never a mystery. It's one of these four. Check them in order.
1. You're not getting what you paid for
Check in every delivery. Weigh it. Count it. Suppliers make mistakes, and a box that's light every week adds up fast. If your invoice says 40 lbs and the scale says 36, you just found real money. This one is easy and people skip it constantly.
2. Waste
Have your staff track everything that hits the trash. Everything. A clipboard by the bin works fine. Burnt steaks, dropped plates, spoiled produce, over-prep at the end of the night. When you see the same item on the waste log again and again, you've found a leak — usually over-ordering or over-prepping. Fix the order sheet or the prep list.
3. Portioning
Set the exact amount for each dish and make sure the staff actually follows it. A cook who plates 7oz instead of 5oz on a busy Friday is quietly eating your margin. Scoops, ladles, and a scale on the line aren't fussy — they're how profitable kitchens stay profitable.
4. Theft or freebies
Staff giving food away or walking out with it is the same problem as staff stealing it. And finding it isn't hard. Watch the cameras. Do inventories out loud, so people know you're counting. Count a few items every shift. When the team knows you're watching, most of it stops on its own — or the one person doing it gets caught.
Waste, portioning, receiving, theft. That's the list. Your missing money is on it somewhere.
The Simple Tools: A Spreadsheet Beats Fancy Software
Here's the honest truth. You don't need an expensive enterprise system, and you don't need a computer science degree. Most owners who track food cost well do it in a plain spreadsheet.
Google Sheets is free and does everything you need. Set up one running sheet:
- Enter every purchase invoice (coded by category — meat, produce, dry goods, etc.).
- Enter your daily sales, split into food and drink. Drink is easy to break down further into beer, wine, liquor, and coffee.
- Enter your inventory value at count time.
- Let the sheet do the math.
If those three inputs are accurate — purchases, inventory, sales — your food cost number falls right out. Old school, yes. It works better than most software, because you understand every cell.
Two more tricks that make life easier:
- Work backwards from your recipes. Figure out how many portions come out of each batch, then cost it from the recipe. That gives you a per-plate cost, so you know the true cost of every dish on your menu.
- Track proteins the hardest. They're your biggest cost. One page for portions yielded (whether you butcher in-house or open a pre-portioned bag, count it). One page for protein counts at close, from your closing manager. Compare to weekly sales. A gap of 2 or 3 portions? Fine. A gap of 10-plus? That's a real problem worth chasing.
If you'd rather not run a spreadsheet, many modern POS systems now update your cost of goods weekly on their own, and some inventory tools will read your invoices for you. That's fine too. But don't wait for the perfect tool. Anything is better than nothing, and a free sheet you start today beats a $500-a-month system you keep meaning to buy.
Should You Just Accept a Percentage of Loss?
Partly, yes. Some loss is real and normal. A little waste, a little spoilage, a few portions off — that happens in every kitchen. Chasing every last gram will drive you mad and won't pay off.
So set a target food cost % and a sane tolerance. Small variance? Let it go. Big variance? Chase it. The daily protein count tells you which is which: 2 or 3 portions off is noise, 10-plus is a signal. That line keeps you sane and profitable at the same time.
What you should not do is accept a vague "I'm losing money somewhere" and move on. That feeling means you don't have a number yet. Get the number, and the fear shrinks. Half of money stress is just not knowing.
One More Tip: Fewer Suppliers, Less Headache
If you're truly at the end of your rope, look at your supplier list. Three suppliers means three invoices, three delivery checks, three sets of prices to reconcile every week. Using fewer suppliers — even just one for most of your order — can cost you a bit more per case. But it buys back a huge amount of time and sanity. For a lot of small operators, that trade is worth it. Your call, but it's on the table.
So here's the whole thing in plain terms. Stop trying to make three suppliers and your POS magically agree — they never will. Instead, do a real inventory count each period, run a simple weekly food cost % in a free spreadsheet, and watch your two or three priciest items with a quick daily count. When the number's off, walk the four suspects: receiving, waste, portioning, theft. Your missing money is always one of them. You don't need to be a data scientist. You need a scale, a spreadsheet, and the habit of looking every week. Start this Tuesday: weigh your chicken and steaks, check them Wednesday, and compare to what you sold. That one small habit is where the whole mystery starts to unravel.
