Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityHospitality OperationsRestaurant Daily Sales Report

SpreadsheetHospitality OperationsFree

Restaurant Daily Sales Report

Sales by category and daypart, covers and average check, labour percentage, comps and voids, and a cash and card reconciliation.

Shown with sample data

Colour

Restaurant Daily Sales Report

Sales by category and daypart, covers and average check, labour percentage, comps and voids, and a cash and card reconciliation.

Net sales
$16,591
Covers
330
Average check
$50.28
Labour %
24%
Comps and voids %
0.7%
Of gross sales
Sales per labour hour
$91.76
Labour cost
$3,960
Comps
$57
Net sales by category
  • Food$8,440
  • Wine$2,106
  • Spirits and cocktails$1,770
  • Private dining$1,450
  • Beer$1,080
  • Desserts$889
  • Non-alcoholic drinks$856
Sales mix
  • Food$8,44051%
  • Wine$2,10613%
  • Spirits and cocktails$1,77011%
  • Private dining$1,4509%
  • Beer$1,0807%
  • Desserts$8895%
  • Other$8565%

How to use it

  1. 1From the POS end-of-day report, type lunch and dinner sales for each category.
  2. 2On Dayparts, enter covers, labour hours and labour cost for each service.
  3. 3Log every comp, void and discount with the category, reason and approving manager.
  4. 4Count the drawer and settle cards, enter the figures on Payments, and investigate anything Short or Over before you leave.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The end-of-night report every GM should send. Enter lunch and dinner sales by category from the POS, covers and labour for each daypart, every comp, void and discount with its reason, and the expected and counted totals for each tender. The report calculates gross and net sales, sales mix, average check, labour cost as a percentage of sales and sales per labour hour, comps and voids as a share of sales, and flags any tender that is over or short.

Who it’s for

  • End-of-shift manager reports
  • Owners who want the same numbers every night
  • Spotting labour creep and comp abuse early

What’s included

  • Sales sheet: Sales by category for lunch and dinner.
  • Dayparts sheet: Covers, average check and labour for each service.
  • Comps and voids sheet: Every comp, void and discount with its reason.
  • Payments sheet: Expected against counted for each tender, including tax.

How to use it

  1. 1From the POS end-of-day report, type lunch and dinner sales for each category.
  2. 2On Dayparts, enter covers, labour hours and labour cost for each service.
  3. 3Log every comp, void and discount with the category, reason and approving manager.
  4. 4Count the drawer and settle cards, enter the figures on Payments, and investigate anything Short or Over before you leave.

Tips

  • Full-service restaurants commonly aim for labour around 25–35% of sales and comps plus voids under 1–2%; set your own targets.
  • Look at average check by daypart: a falling dinner check often means upselling has slipped.
  • Voids after an order is sent to the kitchen cost food; track reasons so you can retrain.

Questions

How is average check calculated?

Sales divided by covers (guests served). It is calculated for each daypart and for the whole day.

What is labour cost percentage?

Total labour cost for the period divided by sales for the same period. Include wages and, if you can, payroll taxes and benefits.

What is the difference between a comp and a void?

A comp gives away an item that was made (complaint, manager meal, goodwill); a void removes an item that should not have been rung in. Discounts reduce the price.

Related searchesrestaurant daily sales reportdaily sales report templaterestaurant manager logend of day report restaurantlabor cost percentagecash reconciliation

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHospitality OperationsFree

Restaurant Daily Sales Report

Sales by category and daypart, covers and average check, labour percentage, comps and voids, and a cash and card reconciliation.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More hospitality operations templates

View all
Recipe & Menu Costing Calculator2 sheets

Dishes costed

4

Average food cost

23%

Dishes above 35%

1

ABCD
1DishCategoryPortions per batchMenu price
2Tomato & basil soupStarter10$7.50
3Grilled chicken saladMain4$16.00
4Beef burger with friesMain4$13.00
5Chocolate brownieDessert12$6.50
Menu
SpreadsheetHospitality Operations

Recipe & Menu Costing Calculator

Cost every dish from its ingredients, see food cost percentage and margin, and get a price that hits your target.

10 min setupPreview
Vacation Rental Booking & Income Tracker2 sheets

Nights booked

30

Net income

$5,262

Average nightly rate

$169

Fees by platform
$309
$45.20
$38.40
Booking.comVrboAirbnb
SpreadsheetHospitality Operations

Vacation Rental Booking & Income Tracker

Bookings from every platform with nights, fees and net payout, plus occupancy and income for the season.

10 min setupPreview
Hotel Housekeeping Schedule2 sheets

Rooms to clean

6

Done

3

Early arrivals

2

ABCD
1RoomRoom statusPriorityHousekeeper
2101Check-outEarly arrivalRosa
3102Stay-overNormalRosa
4103Check-outNormalAhmed
5104Vacant cleanNormalN/A
Today
SpreadsheetHospitality Operations

Hotel Housekeeping Schedule

Assign rooms to housekeepers with room status, priority and inspection results.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ