# Restaurant and cafe table reservations sheet

> Tables with seats and minimum spend, a reservations log with clash and capacity alerts, an evening grid by half-hour, no-show rate and repeat customers.

Source: https://softwiro.com/templates/restaurant-table-reservations
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for restaurant or cafe table reservations. You enter your tables with their area (indoor, outdoor or VIP), number of seats and minimum spend, then log each reservation with its date, time, sitting length, number of guests, table, customer name and number, occasion and deposit. The sheet warns you if the same table is booked twice at overlapping times or if a party exceeds the seats, draws an evening grid of tables by half-hour, calculates guests per day, no-show rate and deposits held, and lists repeat customers with their number of visits and last visit.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-restaurant-table-reservations.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-restaurant-table-reservations-blank.xlsx)

Excel file (.xlsx) · 173 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| التاريخ | الوقت | المدة (ساعات) | الضيوف | الترابيزة | العميل | الحالة | المقاعد | السعة | تعارض |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 46298 | 1 | 2 | 4 | D3 | عمرو حسين | حضر | 4 |  |  |
| 46304 | 1 | 2 | 2 | D1 | منى فؤاد | حضر | 2 |  |  |
| 46311 | 1 | 2 | 6 | D5 | شركة النور | حضر | 6 |  |  |
| 46318 | 1 | 2 | 2 | O1 | سارة عادل | حضر | 2 |  |  |
| 46325 | 1 | 2 | 8 | V2 | كريم ممدوح | حضر | 10 |  |  |
| 46327 | 1 | 2 | 4 | D3 | عمرو حسين | حضر | 4 |  |  |
| 46328 | 1 | 2 | 2 | D2 | هدى سالم | حضر | 2 |  |  |
| 46329 | 1 | 2 | 5 | O4 | سارة عادل | لم يحضر | 6 |  |  |

Example from the “الحجوزات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات: The venue name, the date of the evening you want to schedule, the start of the first slot in the grid, the first day of the month you want summarized, and the minimum number of visits for a customer to count as a repeat customer.
- الترابيزات: Each table's number, area, seats and minimum spend, with the number of reservations on the selected date. Holds up to 30 tables.
- الحجوزات: The reservations log: date, time, duration, guests, table, customer, phone, occasion, deposit and status (confirmed, attended, cancelled or no-show). The end time, seats, area and capacity and clash alerts appear. Holds up to 500 reservations.
- جدول السهرة: Tables in rows and 12 half-hour slots in columns for the selected date. The customer's name appears in a booked slot and clashes are colored red, with guests and the number of tables booked in each slot below.
- العملاء المتكررون: A list of customers whose visits reached the set minimum, sorted by number of visits and then by latest visit, with each customer's phone and number of no-shows.
- الملخص: The month's reservations by status, no-show rate, cancellation rate and guests who attended, deposits held, deducted, forfeited and refunded, the month's alerts, and guests per day, with three charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

The evening grid shows at a glance which table is free in which half hour, the clash and capacity alerts stop a booking that cannot be honored before the customer arrives, and the repeat customers list shows who deserves a call before the busy season.

## How to use it

1. In "الإعدادات" (Settings) enter the venue name, the date of the evening you want to schedule, the start of the first slot (for example 18:00) and the date of the first day of the month you want summarized.
2. In "الترابيزات" (Tables) enter each table: its number, area (indoor, outdoor or VIP), number of seats and minimum spend.
3. In "الحجوزات" (Reservations) log each reservation: date, time, sitting length in hours, number of guests, table, customer name, phone, occasion and deposit.
4. Change the status after booking: "مؤكد" (confirmed) when booked, "حضر" (attended) or "لم يحضر" (no-show) after the time, and "ألغى" (cancelled) on cancellation.
5. Check the capacity and clash columns in the reservations: red means a table booked twice at overlapping times, and yellow means a party larger than the seats.
6. Open "جدول السهرة" (Evening grid) to see tables by half-hour for the selected date, and "العملاء المتكررون" (Repeat customers) and "الملخص" (Summary) for the month's figures.

**Before you start:**

- Sitting length is entered in hours (1.5 means an hour and a half). Reservation end time = start + duration, and a reservation that starts exactly when another ends is not a clash.
- A clash appears when another reservation on the same table overlaps in time on the same day. A reservation with status "ألغى" (cancelled) or "لم يحضر" (no-show) is not counted.
- Capacity: "فوق السعة" (over capacity) appears if the number of guests exceeds the table's seats. If the table is not in the "الترابيزات" (Tables) sheet, "ترابيزة غير مسجلة" (table not registered) appears.
- No-show rate = no-show / (attended + no-show), that is, only those whose time has come. Confirmed reservations whose time has not yet come are not included.
- Deposits held = the deposits of "مؤكد" (confirmed) reservations across all dates. Beside it are the month's deposits: what is deducted from the bill of those who attended, what was forfeited for no-shows and what is refunded to those who cancelled. Whether to forfeit or refund is your restaurant's policy.
- A repeat customer is identified by phone number: anyone with two or more visits (you can change the minimum in Settings), sorted by number of visits and then latest visit. A visit is a reservation with status "حضر" (attended).
- The evening grid shows 12 half-hour slots from the time you set. The sheet holds 30 tables, 500 reservations and 30 repeat customers in the list.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-restaurant-table-reservations.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-restaurant-table-reservations-blank.xlsx)

Excel file (.xlsx) · 173 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: table reservations (1/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-1.jpg)[![Cheat sheet: table reservations (2/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-2.jpg)[![Cheat sheet: table reservations (3/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How do I stop the same table being booked by two customers at the same time?

Enter the reservation time and sitting length. The sheet calculates the end time and writes "تعارض" (clash) in red for any two non-cancelled reservations on the same table whose times overlap on the same day. If the second reservation starts exactly when the first ends, it is not a clash.

### How do I calculate the no-show rate for a restaurant?

No-show rate = reservations marked "لم يحضر" (no-show) / (attended + no-show), that is, only those whose time has come. The sheet calculates it for your selected month. Confirmed reservations whose time has not yet come and cancelled ones are not included.

### What happens to the deposit if the customer does not show up or cancels?

The summary shows the deposit held for your confirmed reservations, what is deducted from the bills of those who attended, the deposits of no-shows and the deposits of those who cancelled. Whether it is forfeited or refunded is your own policy with the customer, not a rule in the sheet.

### How do I find my repeat customers?

The sheet goes by the customer's phone number: every number with two or more visits (you can change the minimum in Settings) appears in "العملاء المتكررون" (Repeat customers) with its number of visits and last visit date. A visit is a reservation whose status you set to "حضر" (attended).

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Restaurants and cafes

## More free templates

- Recipe costing for restaurants and cafes (Excel)
- Restaurant and cafe inventory and waste sheet
- Canteen management sheet
- Photo studio bookings sheet
- General appointments scheduler sheet
- Grocery store management sheet
- Stationery shop and photocopy management sheet
- Electronics shop sheet: serials, warranty and repairs
- Electronics factory sheet: BOM, production and quality
- Wholesale clothing trade sheet: traders, stock and collection
- Food wholesale and distribution sheet in Excel: routes, expiry and collection

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
