Restaurant KPI Dashboard Template: Track Daily Sales, Labor %, Food Cost %, and Turnover in One View

One page, five numbers, one decision point: daily revenue, labor cost % of sales, food cost % of sales, table turnover rate, and customer satisfaction score. Without a clear dashboard, restaurants fly blind—missing cost spikes and service gaps until it's too late. This template turns raw daily counts into actionable insights that fit on a single screen.

The par level and ordering guide tells you what to order. The food cost percentage tracker tells you what you spent. This dashboard tells you whether those decisions are working: it is the control panel that connects purchasing to performance, and staffing to sales. It answers the five questions every owner asks at the end of the night: Did we make money? Did we staff right? Did we waste food? Did we turn tables? Did we keep guests happy?

1. The five metrics that matter

1. Daily Revenue — total sales for the day, broken out by dine-in, takeout, and delivery if you track them. Revenue without context is just a number; revenue against labor and food cost is a story.

2. Labor Cost % — (total labor cost ÷ daily revenue) × 100. Include wages, taxes, and benefits. The industry rule of thumb is 25-35%, but your number is your number. Track it daily, not weekly, to catch overtime before it becomes a habit.

3. Food Cost % — (COGS ÷ daily revenue) × 100. Use the same daily count from your food cost sheet. A sudden jump from 28% to 34% is not a mystery; it is a signal to check waste, theft, or pricing.

4. Table Turnover Rate — (covers ÷ seats) per service period. A 40-seat restaurant that serves 120 covers at dinner turned each table three times. Low turnover with high revenue means high checks; low turnover with low revenue means trouble.

5. Customer Satisfaction Score — whatever you track: Google rating, feedback forms, or complaint count. A 4.8 rating with a 38% food cost is a pricing problem; a 4.2 rating with a 28% food cost is a service problem.

2. How to build it in 20 minutes

Step 1: Create a daily log sheet or spreadsheet with five columns: Revenue, Labor Cost, Food Cost, Covers, and Satisfaction. Add calculated columns for Labor % and Food %.

Step 2: Pull revenue from your POS system at close. Pull labor from your schedule/payroll. Pull food cost from your daily count sheet. Count covers from the floor. Record satisfaction from your chosen source.

Step 3: Calculate the percentages and turnover. Plot the last seven days in a simple line chart or just look at the trend. Highlight any day where labor % exceeds 35% or food % exceeds 35%.

Step 4: Make one decision before you go home: adjust tomorrow's staffing, tweak the menu, or talk to the team about service. The dashboard is not a report; it is a decision tool.

3. What the numbers tell you

Labor % rising while revenue flat? Check the schedule for overtime or understaffing that forces extra shifts. Consider a pre-service briefing to improve table turns.

Food % spiking on weekends? Review waste logs and prep quantities. High-volume days often create over-prep; tighten pars using the par level guide.

Turnover low but revenue high? You are pricing well but turning tables slowly. Train hosts on table reset timing and consider reservation buffers.

Satisfaction down while costs up? Guests are feeling the service or quality dip. Cross-train staff and audit portion consistency. Cost control without quality control is false economy.

4. Templates and tools

This dashboard is one piece of a complete ops system. The par level sheet prevents over-ordering. The food cost tracker measures waste. The daily ops checklist keeps the floor consistent. Together, they turn reactive firefighting into proactive management.

Get the full kit: Ops Starter Kit — templates, runbooks, and checklists for service businesses.

Free lead magnet: First 30 Minutes — the exact onboarding checklist we use to win clients in the first half-hour.

More tools: Ops Starter Kit Vol. 2, Agent Ops 24/7, Automation Starter Pack.