Template

Restaurant daily sales report template

The sheet a manager fills at close: what sold by daypart and channel, what came in by tender, what the drawer should hold, and what labor cost today. Two checks catch a typo before it reaches the bookkeeper.

Sections: sales by daypart (with average ticket), sales by channel, tenders and adjustments, cash drawer (expected, counted, over or short, deposit), labor (hours, cost, labor %, sales per labor hour). Checks: channel total must equal daypart total, and gross collected minus tips and tax must equal net sales.

Download

Daily sales report

Excel file (Daily report, 7-day log). 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.

How to use it

  1. 1

    Print or copy one per day

    The 7-day log sheet collects the week's totals; start a new file each week or add sheets.

  2. 2

    Fill from the POS close-out

    Net sales by daypart and by channel, each tender, discounts, refunds, tips and tax.

  3. 3

    Count the drawer

    Opening float, paid-outs and the counted total; the sheet shows over or short and the deposit.

  4. 4

    Add labor

    Hours and cost from the time clock; labor % and sales per labor hour appear.

Reading it

LineWhat it tells you
Average ticket by daypartWhere the check size is weak; a $12 lunch ticket and a $31 dinner ticket need different fixes
Channel splitHow much of sales comes through marketplaces (and their commission)
Over / (short)A drawer that is short more than a few dollars on the same shifts is a pattern
Labor %Against your target for that day of the week
Sales per labor hourBelow $35 on a full-service shift means too many hours for the sales

The automatic version

With the POS connected, Orqestra's Today page and daily digest email have every one of these numbers filled in, the drawer close-out is a guided count with a sign-off that locks the day, and the figures roll into the P&L. See sales analytics and the guide to the daily sales report.

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.