Free Restaurant KPI Excel Template: What It Tracks and How to Use It

This is a free Excel workbook for tracking the numbers that decide whether an independent restaurant makes money. You type in monthly figures you already have — sales, cost of goods, labor, covers, a stock value — and it calculates 17 restaurant KPIs, shows the last six months on a colour-coded dashboard, and compares each one to a target you set. No macros, no add-ins, no account.

Who it is for

Owner-operators and managers of single-location restaurants, cafés and bars who want a monthly picture of cost, margin and capacity without building a spreadsheet from scratch. If you already have a bookkeeper’s P&L, this sits beside it and turns the totals into ratios you can act on. If you do not yet track food or labor cost as a percentage of sales, this is the simplest place to start.

What is in the workbook

Five sheets:

1. How To Use — a one-page guide, the colour key, and five notes on reading the results.
2. Monthly Data Entry — twelve monthly columns for revenue (total, food, beverage, catering, takeaway/delivery), costs (food and beverage COGS, labor, overhead, recorded waste), operations (covers, seats, bookings, no-shows, labor hours, inventory turns) and guest metrics (review score, new reviews, repeat guests, unique guests, average wait).
3. Calculated KPIs — auto-calculated from the entry sheet:
   • Margin and cost: food cost %, beverage cost %, labor cost %, prime cost %, gross profit margin, net profit margin
   • Revenue per unit: revenue per cover, revenue per labor hour, revenue per seat
   • Operations: seat occupancy, no-show rate, repeat guest rate, waste % of revenue, inventory turnover
   • Guest metrics: online review score, new reviews, average wait time
4. Dashboard — a six-month snapshot of the key revenue, cost, profitability, guest and operations KPIs, colour-coded green (on target), amber (within 5% of target) and red (off target). It ships with sample data so you can see how it reads before you enter your own.
5. Targets & Benchmarks — one editable target per KPI, next to reference low/high ranges and a note on why each range varies by concept.

How often to update it

Monthly, after the stock count and payroll are done. Most of the entry takes ten to fifteen minutes from a POS sales report, supplier invoices, a payroll total and a stock value. If you want to track food cost or labor cost more often, the workbook is monthly by design — the weekly version is what the paid system is for (see below).

What decisions it helps with

• Is prime cost drifting? Food, beverage and labor cost side by side for six months make a slow creep visible.
• Did a slow month come from fewer guests or lower spend? Revenue per cover next to covers served answers it.
• Is the room working? Seat occupancy and no-show rate show capacity you are paying for but not selling.
• Are guests coming back? Repeat guest rate, review score and new-review count in one place.
• Which target am I actually missing? Set your own targets and the dashboard shows the exceptions, not the averages.

For the reasoning behind each KPI — what moves it and what to do — the restaurant KPI guide explains the framework, with a detailed article on each of food cost, labor cost, profitability, average check, table turnover, customer retention, break-even and inventory turnover.

What it does not do

Being clear about the limits saves you a wasted afternoon:

• It is monthly, not weekly or daily.
• It calculates and colour-codes; it does not tell you why a KPI moved or what to do first.
• It does not import from your POS or accounting software; you type the totals.
• It does not cost recipes or menu items.
• The reference ranges on the targets sheet are rules of thumb across many concepts, not standards for yours — set your own targets.
• It is one location, one currency, one year per file.

How it differs from the Restaurant Performance System

The template answers “what are my numbers?”. The Restaurant Performance System is built to answer “what should I do this week?” — the Input → KPI → Diagnosis → Priority → Action loop, in about 15 minutes a week.

Start with the free template; if you find yourself wanting the “why” and the “what next”, that is what the system is for. The diagnosis applies fixed rules to your own targets — it tells you what to check first, not the root cause for certain.