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

KPIFormulaTarget (typical)
Average ticketNet sales ÷ ordersTrack the trend; raise it with menu engineering
Food cost %COGS ÷ net sales28% to 35%
Labor cost %Labor cost ÷ net sales25% to 35%
Prime cost %(COGS + labor) ÷ net sales55% to 65%
Sales per labor hourNet sales ÷ hours$35 to $50 full service
Average daily salesNet sales ÷ days loggedAgainst your break-even per day

How to use it

  1. 1

    Set targets

    On the Summary sheet, the yellow cells hold your food, labor, prime cost and sales-per-hour targets.

  2. 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. 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. 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.