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
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
Fill from the POS close-out
Net sales by daypart and by channel, each tender, discounts, refunds, tips and tax.
- 3
Count the drawer
Opening float, paid-outs and the counted total; the sheet shows over or short and the deposit.
- 4
Add labor
Hours and cost from the time clock; labor % and sales per labor hour appear.
Reading it
| Line | What it tells you |
|---|---|
| Average ticket by daypart | Where the check size is weak; a $12 lunch ticket and a $31 dinner ticket need different fixes |
| Channel split | How 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 hour | Below $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.