You run a restaurant or cafe that takes bookings by phone and WhatsApp, and you want to know before the doors open: which table is free in which half hour, whether a table was booked for two customers at once, whether a party is bigger than its table, how many guests to expect tonight, how much deposit you are holding, and which customers keep coming back. The free restaurant and cafe table reservations sheet (the page is in Arabic) puts all of it in one file, in Excel or online.
The problem it solves
A paper booking diary does not warn you when you write two bookings on one table, does not tell you how many customers failed to show this month, and does not rank who booked more than once. When the evening fills up you flip pages looking for a table for six after nine. Here each booking is typed once and shows up in the evening grid and in the month's numbers.
Steps, from opening the file to the report
- Settings: enter the venue name, the date of the evening you want to see, the start of the first slot (for example 18:00) and the first day of the month for the summary.
- Tables: each table's number, area (inside, outside or VIP), seats and minimum charge.
- Reservations: date, time, duration in hours, guests, table (from a list), customer name, phone, occasion and deposit.
- Status: "مؤكد" (confirmed) when booked, then "حضر" (attended) or "لم يحضر" (no-show) after the time, or "ألغى" (cancelled).
- Check the alerts: the capacity and clash columns in the reservations sheet.
- Evening grid, repeat customers and Summary: these are calculated for you.
What each sheet holds
In "الحجوزات" (Reservations) the sheet works out each booking's end time from its time and duration, writes "فوق السعة" (over capacity) when guests exceed the table's seats, and writes "تعارض" (clash) in red when another non-cancelled booking on the same table overlaps in time. A booking starting the moment another ends is not a clash, and cancelled or no-show bookings are ignored.
"جدول السهرة" (Evening grid) has tables in the rows and twelve half-hour slots in the columns for the chosen date: a cell turns green with the customer's name in each booked slot, and red with ⚠ if the slot is booked twice. Below it are the guests and booked tables in each slot. "العملاء المتكررون" (Repeat customers) lists those who reached the visit count you set, ranked by visits and then by latest visit.
Walk-through on the sample numbers
The names and numbers below are sample data inside the sheet, not real people. The example has twelve tables and 35 reservations, the chosen month is November 2026 and the chosen evening is Friday 13 November:
- The month's statuses: 30 reservations in November: 11 attended, 14 confirmed, 3 no-shows and 2 cancelled.
- No-shows: 3 ÷ (11 + 3) = 21.4%, and cancellations 2 ÷ 30 = 6.7%.
- Guests: 49 guests attended, 64 are waiting in confirmed bookings, and the average non-cancelled party is 4.5 guests.
- The clash: table D3 is booked for "عمرو حسين" from 18:30 to 20:30 and for "أميرة جلال" from 20:00 to 22:00, so both rows show "تعارض" and the 20:00 slot in the evening grid shows ⚠.
- Capacity: "وليد منصور" booked five guests on table D2, which seats two, so the row shows "فوق السعة".
- Peak of the evening: at 20:30 there are 31 guests on 5 tables, and that figure includes both clashing bookings.
- Deposits: held for all confirmed bookings 2,300; this month's deposits of those who attended 1,500, of no-shows 250 and of cancellations 800. Whether to keep or refund a deposit is your policy with the customer.
- Repeat customers: six, the first being "شركة النور" with three visits and the latest on 12 November, then "عمرو حسين" with three, then "سارة عادل" with two visits and one no-show.
Common mistakes
- Forgetting to change the status after the time: the booking stays "مؤكد" and is left out of the no-show rate and the customer's visits.
- Typing the duration in minutes: duration is in hours, so an hour and a half is 1.5.
- Typing a phone number in different forms: the sheet recognises a customer by phone, so write the number the same way every time.
- Leaving a cancelled booking as "مؤكد": it keeps holding the table and shows a clash. Change it to "ألغى".
- Counting a deposit as income: it is money paid in advance, deducted from the bill or handled by your policy, so do not add it to sales.
When to move from a sheet to a system
A sheet suits one venue and one host taking bookings. If booking calls pile up, you want customers to book from a link that shows only the free times, or a reminder message before the booking to cut no-shows, ask for a custom program from Softwiro.
Next step
Open the template page, download the sheet, clear the sample bookings, enter your tables and seats, then log tonight's bookings and open the Evening grid. If you also cost your dishes, try the recipe costing sheet.





