Restaurants operate on some of the thinnest margins of any business — typically 3-9% net profit on every dollar of revenue. At those margins, the difference between a profitable month and a losing one often comes down to whether you're watching your food cost and labor cost closely enough to catch problems before they compound.
Most independent restaurant owners don't have a dedicated accountant or expensive restaurant management software. But they do have Excel — and a well-built spreadsheet can give you the same visibility into your key numbers that the big chains pay a lot of money to get. Here's how to build it.
Before building anything, understand the three metrics that drive restaurant profitability. Everything else flows from these.
Prime cost — food cost plus labor cost — is the single most important number in restaurant management. If your prime cost is above 65% of revenue, profitability becomes very difficult regardless of how well you manage everything else. Below 60% and you have a healthy foundation to work from.
The foundation of your restaurant spreadsheet is a daily sales log. Every day you enter your total sales — broken down by category if your POS system tracks them — and a few key metrics. This sheet feeds everything else.
| Column | What to Enter |
|---|---|
| Date | The trading date |
| Day of Week | =TEXT(Date, "dddd") — auto-calculated |
| Food Sales | Total food revenue for the day |
| Beverage Sales | Total beverage revenue for the day |
| Total Sales | =Food Sales + Beverage Sales |
| Covers | Number of guests served |
| Average Check | =Total Sales / Covers |
| Notes | Weather, events, closures — anything affecting sales |
Food cost percentage is calculated as cost of goods sold divided by total food sales. The challenge is that cost of goods sold isn't just what you bought this week — it's your opening inventory plus purchases minus closing inventory. Tracking this properly requires a weekly count.
Food cost percentage formula:
Set up a weekly food cost sheet with these rows:
Track your food cost percentage weekly and chart it over time. A creeping food cost percentage — say, moving from 29% to 33% over two months — is a clear signal that something needs attention: portion sizes, pricing, waste, theft, or supplier costs.
Labor cost is the other half of prime cost and the one most restaurant owners have the most direct control over. Track it weekly alongside your sales so you always know your labor percentage in real time — not at the end of the month when it's too late to adjust.
| Column | What to Enter |
|---|---|
| Week Ending | The last day of the week being tracked |
| Total Sales | Pulled from your daily sales tracker with SUMPRODUCT |
| Kitchen Labor | Total wages paid to kitchen staff this week |
| Front of House Labor | Total wages paid to FOH staff this week |
| Management Labor | Manager salaries allocated to this week |
| Total Labor Cost | =Kitchen + FOH + Management |
| Labor Cost % | =Total Labor / Total Sales |
| Prime Cost % | =Food Cost % + Labor Cost % |
With daily sales, food cost, and labor cost tracked separately, building a weekly profit and loss summary is straightforward. This is the sheet you review every Monday morning to understand where last week landed and what needs attention this week.
The key is showing every line as both a dollar amount and a percentage of sales. Percentages are what make weeks comparable — a $6,000 labor cost means nothing without knowing whether sales were $15,000 or $25,000 that week.
With these four sheets in place you have a complete weekly reporting system for your restaurant. Every Monday morning your workflow is simple — enter last week's daily sales totals, enter your food purchases and closing inventory count, enter your payroll figures, and your P&L updates automatically.
The visibility this gives you is genuinely valuable. You'll catch a rising food cost percentage before it becomes a crisis. You'll see which days of the week are carrying your sales and which need attention. You'll know your prime cost every single week instead of finding out at month end when there's nothing you can do about it.
If you'd like a custom restaurant tracking workbook built for your specific operation — your revenue categories, your cost structure, your staffing model — that's exactly what we do at HelpMyData.
Tell us about your restaurant and we'll build a complete Excel system for tracking daily sales, food cost, labor cost, and weekly profit — starting at just $75.
📧 Get Started Today