Table of Contents
- Why Tracking Daily Food Costs Matters
- Understanding the Food Cost Formula for Restaurants
- Setting Up a Daily Food Cost Spreadsheet
- Creating a Food Cost Report Template
- Implementing Food Waste Tracking Systems
- Daily Tracking Process: Step-by-Step
- Tools and Methods for Tracking Food Costs
- Common Mistakes to Avoid
- Frequently Asked Questions
Last Updated: October 12, 2026
Why Tracking Daily Food Costs Matters
To track daily food costs is essential, as food costs are often the second-largest expense in any hospitality business, right after labour. Yet many restaurant owners and managers treat them like an afterthought. They order stock, cook meals, and hope the numbers work out at the end of the month. That approach rarely ends well.
Tracking daily food costs gives you control. You’ll spot waste before it becomes a pattern. You’ll catch pricing inconsistencies with suppliers. You’ll understand exactly which dishes are profitable and which ones drain your margins.
The real benefit isn’t just knowing your costs. It’s being able to act on them. When you have daily data, you can adjust menus, renegotiate supplier contracts, or retrain kitchen staff with confidence. You’re making decisions based on facts, not guesses.
Understanding the Food Cost Formula for Restaurants
The food cost formula for restaurants is straightforward, but it’s the foundation everything else builds on. Here’s the formula:
Food Cost % = (Opening Inventory + Purchases − Closing Inventory) ÷ Food Sales × 100
Breaking this down: you start with what you had at the beginning of the period. You add everything you bought. You subtract what’s left at the end. That number tells you what you actually used. Divide by your sales revenue and multiply by 100, and you’ve got your food cost percentage.
Most restaurants aim for a food cost percentage between 28-35%, depending on their concept. Fine dining typically runs higher (35-40%) because ingredients are premium. Quick-service operations run lower (25-30%) because they rely on volume and efficiency.
The food cost formula for restaurants works the same whether you’re tracking daily, weekly, or monthly. The difference is frequency. Daily tracking catches problems faster. Weekly tracking is easier to manage but slower to reveal issues. Monthly tracking is too late, by then, waste has already compounded.
Track at least weekly, ideally daily. The more frequently you measure, the faster you can respond to cost creep. Many restaurants that switched from monthly to daily tracking cut their food waste by 10-12% within the first quarter.
Setting Up a Daily Food Cost Spreadsheet
A good daily food cost spreadsheet doesn’t need to be fancy. It needs to be consistent and complete. Start with a simple structure that captures the essential data points, then automate the calculations so you’re not doing maths by hand every morning.
Essential columns and data points
Your daily food cost spreadsheet should include these columns:
- Date, the tracking period
- Opening Inventory Value, what you had at the start of the day or shift
- Purchases, everything delivered or bought that day, with cost
- Closing Inventory Value, what’s left at the end
- Food Used, calculated automatically (Opening + Purchases − Closing)
- Food Sales, total revenue from food that day
- Food Cost %, calculated automatically (Food Used ÷ Food Sales × 100)
- Variance, the difference between your target cost % and actual (useful for spotting anomalies)
Include a column for notes. When a number looks unusual, you’ll want to know why. Was there a staff event? A delivery delay? A menu special that changed the mix?
Automating calculations
Once you’ve set up the columns, use formulas to calculate the numbers automatically. In Excel or Google Sheets, you can write simple formulas that do the maths for you. For example:
- Food Used = Opening Inventory + Purchases − Closing Inventory
- Food Cost % = (Food Used ÷ Food Sales) × 100
- Variance = Target % − Actual %
Automating these removes human error and saves time. You enter the raw data (opening inventory, purchases, closing inventory, sales), and the sheet does the rest. This is where a daily food cost spreadsheet becomes genuinely useful, it turns raw numbers into actionable insights without extra work.
Don’t skip the formula setup. Manual calculations are slow and prone to mistakes. Even a small error compounds across weeks. Set it up once, then reuse the same template every day.
Creating a Food Cost Report Template
A food cost report template sits one level above your daily spreadsheet. It summarises the daily data into a format you can actually read and act on. Think of it as your weekly or monthly snapshot.
Your food cost report template should include:
- Period (week or month)
- Daily breakdown, each day’s food cost %
- Average food cost % for the period
- Target food cost %
- Variance, how far you are from target
- Trend, is it improving or getting worse?
- High-cost days, which days had unusual costs
- Action items, what you need to fix
The food cost report template pulls data from your daily spreadsheet. If you’ve set it up right, you just plug in the daily totals and the report generates itself. This saves hours every month and ensures consistency.
Many restaurants also add a section for commentary. What drove the variance? Was it a special event, a supplier price increase, or staff waste? This context turns numbers into a story you can act on.

Implementing Food Waste Tracking Systems
Food waste tracking systems go deeper than just tracking costs. They help you understand where waste is actually happening, in storage, during prep, in portion control, or in the bin.
A simple food waste tracking system works like this: designate a waste bin in your kitchen. Throughout the day, staff log what goes in and why. Was it spoiled? Overcooked? Trimmed too much? Leftover from a cancelled order? At the end of each day, weigh the waste and record it.
Over a week or two, patterns emerge. Maybe you’re buying too much of a perishable item. Maybe your prep techniques are generating excess trim. Maybe portion sizes are too generous. Once you see the pattern, you can fix it.
Food waste tracking systems don’t require fancy equipment. A scale, a notebook, and discipline are enough. Some restaurants use a dedicated app. Others use a simple spreadsheet. The method matters less than the consistency.
Food waste is invisible until you measure it. Most kitchens waste 4-8% of their food purchases without realising it. Tracking it for one month usually reveals at least one obvious fix that saves money immediately.
Daily Tracking Process: Step-by-Step
Here’s the practical process for tracking daily food costs. Follow these steps every day, and you’ll have reliable data within a week.
Step 1: Record opening inventory
Start your shift by recording what you have. This is your opening inventory value. Walk through your storage areas, cold storage, dry goods, freezer, and note quantities and values. Use your supplier invoices from the previous day to get accurate costs.
You don’t need to count every item every day. Most restaurants count once a week and use that as a baseline. For high-turnover items (produce, proteins), you might estimate based on recent purchases and usage. The key is consistency. Use the same method every day so your numbers are comparable.
Step 2: Log daily purchases
Every delivery gets logged. Record the date, supplier, items, quantities, and cost. Keep your invoices organised. At the end of the day, total up everything that came in.
This is where many restaurants get sloppy. Invoices get lost. Items are forgotten. Prices are guessed. Don’t let this happen. Assign someone to log purchases immediately when they arrive. Use a simple form or spreadsheet. Make it a daily habit, not a weekly scramble.
Step 3: Document food usage
This is trickier. You can’t track every plate that leaves the kitchen. Instead, you track what you used from inventory. Some restaurants do a mid-shift count of key items. Others estimate based on covers served and standard recipes. The method depends on your setup.
The important thing is to be consistent. If you estimate one day and count the next, your numbers will be all over the place. Pick a method and stick with it.
Step 4: Calculate closing inventory
At the end of your tracking period (usually the end of the day or shift), count what’s left. This is your closing inventory. Use the same method you used for opening inventory so the numbers are comparable.
Step 5: Analyse variances
Once you have your numbers, calculate your food cost percentage using the formula. Compare it to your target. If it’s higher than expected, dig into why. Was it a busy day with more waste? A delivery error? Staff training issue? A menu special that changed your cost mix?
Variance analysis is where the real work happens. Numbers without context are just noise. Understanding why they moved is where you find opportunities to improve.
Set a variance threshold. If your food cost percentage is more than 2-3% above target, investigate that day. Small variances are normal. Large ones signal a problem worth solving.
Tools and Methods for Tracking Food Costs
You don’t need expensive software to track daily food costs. A spreadsheet works fine. But if you want to simplify the process, several tools can help.
Pen and paper works if you’re disciplined. A simple notebook for daily logs, then manual entry into a spreadsheet weekly. It’s slow, but it’s free and it works.
Spreadsheets (Excel, Google Sheets) are the standard. Set up your template once, then reuse it. Add conditional formatting to flag variances. Use charts to visualise trends.
Point-of-sale systems often have built-in inventory and costing modules. If you already use a POS, check whether it has these features.
Dedicated inventory management software exists, but it’s usually overkill for small to medium operations. Evaluate based on your size and complexity.
Whichever tool you choose, the principle is the same: record opening inventory, purchases, and closing inventory consistently. The calculations follow automatically. The format matters less than the discipline.
Common Mistakes to Avoid
Most restaurants make the same mistakes when they start tracking daily food costs.
Not counting consistently. You count opening inventory one way, closing inventory another way. The numbers don’t match up.
Forgetting to log purchases. An invoice gets misfiled. A delivery isn’t recorded. Your purchase total is incomplete.
Estimating instead of counting. Estimating is faster, but it’s also inaccurate.
Not investigating variances. Your food cost is 5% higher than target. You note it and move on.
Waiting too long to track. You try to reconstruct yesterday’s inventory from memory.
Ignoring the data. You collect numbers for weeks and never look at them. Data without action is pointless.
Tracking daily food costs isn’t complicated. It’s a discipline. You record opening inventory, purchases, and closing inventory.
The restaurants that do this well don’t have special knowledge. They have systems.
Frequently Asked Questions
How do you calculate daily food costs in a restaurant?
Daily food costs are calculated using the formula: (Opening Inventory + Purchases) – Closing Inventory = Food Cost. Record your opening stock value at the start of the day, add any new purchases made that day, then subtract the remaining inventory at close. This gives you the cost of food used. Divide this by your daily sales revenue and multiply by 100 to get your food cost percentage, which helps you track profitability trends.
What should a daily food cost sheet include?
A comprehensive daily food cost sheet should include: opening inventory value, date, supplier purchases with costs, items received, food waste logged, closing inventory count and value, daily revenue, calculated food cost, and food cost percentage. Include columns for item category (proteins, vegetables, dry goods), quantity units, unit costs, and variance notes. This structure allows you to spot cost anomalies quickly and identify where waste occurs.
How often should a restaurant check food costs?
Daily tracking is ideal for maintaining tight control and spotting issues immediately, though weekly reviews work for smaller operations. High-volume kitchens benefit from daily checks, whilst establishments with stable menus can manage with weekly summaries. Monthly reconciliation is essential regardless of frequency. Regular checks, whether daily or weekly, let you catch discrepancies, adjust portion sizes, and respond to price fluctuations before they impact your margin significantly.
What tools can help with food waste tracking?
Dedicated food waste tracking apps, spreadsheets with waste logs, or simple paper records work well. Document discarded items by category, quantity, and reason (spoilage, over-preparation, customer rejection). Some kitchens use colour-coded bins or weighing systems to quantify waste. Combining waste data with your daily food cost spreadsheet reveals patterns, such as excessive prep waste or spoilage, so you can adjust purchasing, portion control, or storage practices to reduce costs.
