# Wedding and event hall booking sheet (free Excel)

> Hall bookings by date and shift with package pricing, double-booking alerts, a monthly calendar, payments log, instalments and cancellations.

Source: https://softwiro.com/templates/event-hall-bookings
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Wedding and event hall booking sheet

A free Excel booking sheet for wedding and event halls. You record each booking with the event date, the shift (morning or evening), the number of guests, the package and the extras. The sheet works out the total from the hall rental, the per-guest package price and the extras, and warns you if the same hall is booked for the same day and shift twice. You log every payment with a receipt number, so the deposit, amount paid and balance due show up, late instalments are flagged, and you get a monthly calendar for each hall and a list of upcoming events.

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

Excel file (.xlsx) · 535 KB · 12 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

| رقم الحجز | تاريخ المناسبة | القاعة | الفترة | العميل | الضيوف | الإجمالي | المدفوع | المتبقي | تنبيه |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| H-101 | 46297 | قاعة الماسة | مسائي | محمود عبد الله | 350 | 212,500.00 | 212,500.00 | 0.00 |  |
| H-102 | 46304 | قاعة اللؤلؤة | مسائي | إسلام فتحي | 220 | 112,200.00 | 112,200.00 | 0.00 |  |
| H-103 | 46305 | قاعة الماسة | صباحي | ياسر منصور | 150 | 71,250.00 | 71,250.00 | 0.00 |  |
| H-104 | 46311 | قاعة الياسمين | مسائي | هاني زكريا | 100 | 40,500.00 | 40,500.00 | 0.00 |  |
| H-105 | 46318 | قاعة الماسة | مسائي | أيمن شحاتة | 380 | 288,500.00 | 288,500.00 | 0.00 |  |
| H-106 | 46325 | قاعة اللؤلؤة | مسائي | مصطفى جمال | 200 | 125,500.00 | 125,500.00 | 0.00 |  |
| H-107 | 46332 | قاعة الياسمين | صباحي | سلمى إبراهيم | 60 | 21,000.00 | 21,000.00 | 0.00 |  |
| H-108 | 46339 | قاعة الماسة | مسائي | وائل سعيد | 300 | 188,500.00 | 131,950.00 | 56,550.00 |  |
| H-109 | 46346 | قاعة اللؤلؤة | مسائي | كريم عصام | 230 | 179,000.00 | 53,700.00 | 125,300.00 | حجز مزدوج |
| H-110 | 46346 | قاعة الماسة | مسائي | رامي فؤاد | 250 | 133,750.00 | 80,250.00 | 53,500.00 |  |
| H-111 | 46353 | قاعة الماسة | صباحي | شركة النور للتدريب | 180 | 64,500.00 | 32,250.00 | 32,250.00 |  |

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

## What is inside

- "الإعدادات" (Settings): Today's date, how many days ahead you want to see upcoming events, the summary year, and the hall and month shown in the calendar.
- "القاعات" (Halls): Each hall's name, capacity and rental for the morning and evening shifts, with its number of events for the year, revenue and occupancy rate beside it.
- "الباقات والإضافات" (Packages and Extras): A table of packages with a per-guest price and what each includes, and a table of extras (buffet, photography, DJ, stage decoration and so on) with the price of each and whether it is charged per guest or as a fixed amount.
- "الحجوزات" (Bookings): One line per booking: its number, event date, hall, shift, client, mobile number, guests, package, three extras, discount and status. The sheet shows the hall rental, package price, extras, total, deposit, amount paid, balance due and the double-booking warning. It holds 1,000 bookings.
- "الدفعات" (Payments): A log of every payment with receipt number, date, booking number, amount, type (deposit, instalment or final payment) and method, with the client's name and hall, and a warning if a receipt number is repeated or the booking does not exist. It holds 2,000 payments.
- "الأقساط" (Instalments): The agreed instalment dates and amounts for each booking. The sheet marks each one "مسدد" (Paid), "قادم" (Upcoming) or "متأخر" (Late) based on what the client has paid and today's date.
- "تقويم القاعة" (Hall Calendar): Pick a hall and a month and the month appears in weeks starting on Saturday, with the morning and evening shifts for each day: green "متاح" (Available), or the client's name and event type, or a red "حجز مزدوج" (Double booking).
- "القادمة" (Upcoming): Events within the number of days you set, sorted by date and shift, with the client, mobile number, total and balance due, plus the number and value of late instalments.
- "الإلغاءات" (Cancellations): Canceled bookings with what the client paid, what was refunded and what was kept, and their totals.
- "الملخص" (Summary): Booking value, amount collected and amount outstanding for a year you choose, a monthly table, breakdowns by package and by hall, and three charts.

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

## What makes it different

A booking here is more than a date: it is tied to payment receipts, instalments and cancellations. So you know at any moment how much each client still owes, which instalment is late, and which day and shift is booked twice, before two clients find out on the night of the wedding.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date, how many days ahead you want to see upcoming events, and the summary year, and choose the hall and month you want in the calendar.
2. In the "القاعات" (Halls) sheet, enter each hall with its capacity and its rental for the morning and evening shifts.
3. In the "الباقات والإضافات" (Packages and Extras) sheet, enter packages with a per-guest price, and extras with their price and whether they are charged per guest (like the buffet) or as a fixed amount (like photography).
4. In the "الحجوزات" (Bookings) sheet, record each booking: its number, event date, hall, shift, client, number of guests, package and up to three extras. The rental, total, amount paid and balance due are calculated for you.
5. Record every amount a client pays in the "الدفعات" (Payments) sheet with a receipt number and the booking number, and the deposit, amount paid and balance due update in the booking. If you agreed on instalments, enter their dates and amounts in "الأقساط" (Instalments) so the sheet can flag late ones.
6. Check the warning column in Bookings (double booking, more guests than capacity and so on), then open "تقويم القاعة" (Hall Calendar), "القادمة" (Upcoming), "الإلغاءات" (Cancellations) and "الملخص" (Summary).

**Before you start:**

- Booking total = hall rental for the chosen shift + (package price x number of guests) + extras - discount. A "per guest" extra is multiplied by the number of guests, and a "fixed" extra is counted once.
- A double booking is two non-canceled bookings with the same hall, date and shift, and "حجز مزدوج" (Double booking) shows in red on both.
- The deposit is the sum of payments of type "عربون" (Deposit), the amount paid is the sum of all payments for the booking number, and the balance due = total - amount paid.
- A "ملغي" (Canceled) booking is not counted in the balance due or the total. Its revenue is the amount kept = amount paid - the refund you enter in the "المسترد" (Refunded) column.
- An instalment counts as paid if the booking's payments cover the sum of the instalments up to its date, and becomes "متأخر" (Late) if its date has passed before the today's date in Settings.
- The calendar starts each week on Saturday. Use the same booking number in Bookings, Payments and Instalments.
- The sheet holds 10 halls, 15 packages, 20 extras, 1,000 bookings, 2,000 payments and 1,000 instalments.

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

Excel file (.xlsx) · 535 KB · 12 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: event hall bookings (1/3)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/en-1.jpg)[![Cheat sheet: event hall bookings (2/3)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/en-2.jpg)[![Cheat sheet: event hall bookings (3/3)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/event-hall-bookings/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 does the sheet catch a double booking in a wedding hall?

It counts the non-canceled bookings with the same date, hall and shift. If there is more than one, it shows a red "حجز مزدوج" (Double booking) on each of them. The conflict also shows in the hall calendar and in the bookings summary.

### How is the booking total calculated?

Booking total = hall rental for the chosen shift + (package price x number of guests) + extras - discount. A "per guest" extra such as the buffet is multiplied by the number of guests, and a "fixed" extra such as photography is counted once.

### Where do I record the deposit and instalments?

Record each amount the client pays once in the "الدفعات" (Payments) sheet, with a receipt number, the booking number and the payment type. The deposit, amount paid and balance due then show in "الحجوزات" (Bookings). Write the agreed instalment dates in "الأقساط" (Instalments) so late ones show up.

### What happens when a booking with a deposit is canceled?

Set the status to "ملغي" (Canceled) and enter what you refunded to the client in the "المسترد" (Refunded) column. The booking drops out of the total and the balance due, and the amount kept (paid - refunded) is counted as cancellation revenue and shown in the "الإلغاءات" (Cancellations) sheet.

### 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: Events and weddings

## More free templates

- Wedding and event budget planner (Excel)
- Serviced apartments and short-stay bookings sheet
- Restaurant and cafe table reservations 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

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