Template
Restaurant KPI dashboard template
Six numbers typed in each night; eight KPIs computed. A daily sheet for the month and a summary that compares month to date with the targets you set.
You enter date, net sales, orders, COGS, labor cost and labor hours from the POS close-out. The sheet computes average ticket, food cost %, labor cost %, prime cost %, sales per labor hour, and the month-to-date versions of each against a target column with the variance.
Download
Restaurant KPI dashboard
Excel file (Daily, Summary). Opens in Excel, Google Sheets (File, Import) and Numbers. Blue cells are yours to fill; black cells are formulas; the first rows are an example to overwrite.
The KPIs and why each one
| KPI | Formula | Target (typical) |
|---|---|---|
| Average ticket | Net sales ÷ orders | Track the trend; raise it with menu engineering |
| Food cost % | COGS ÷ net sales | 28% to 35% |
| Labor cost % | Labor cost ÷ net sales | 25% to 35% |
| Prime cost % | (COGS + labor) ÷ net sales | 55% to 65% |
| Sales per labor hour | Net sales ÷ hours | $35 to $50 full service |
| Average daily sales | Net sales ÷ days logged | Against your break-even per day |
How to use it
- 1
Set targets
On the Summary sheet, the yellow cells hold your food, labor, prime cost and sales-per-hour targets.
- 2
Log each day
Net sales after discounts and refunds, before tax and tips. COGS per day is an estimate (purchases or theoretical usage); the monthly count is the real number.
- 3
Read the variance
A positive variance on a cost percentage means you are over target. Fix the schedule or the order before the month is gone.
- 4
Start a new file each month
Or copy the Daily sheet; the Summary sums rows 5 to 35.
The live version
Every KPI in this sheet is on the Orqestra Overview and P&L the morning after the POS syncs, with the same period last week or last year beside it, by location, with alerts when prime cost crosses the target. See sales analytics and the guide to the restaurant KPI dashboard.
See it with your own numbers
Request access, connect Clover in a minute, and your first reports are ready after the first sync. No card needed.