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
| التاريخ | الملعب | البداية (ساعة) | عدد الساعات | العميل | السعر | المستحق | المتبقي | تنبيه |
|---|---|---|---|---|---|---|---|---|
| 46296 | بادل 1 | 19 | 2 | محمد عادل | 900.00 | 900.00 | 0.00 | |
| 46297 | تنس 1 | 16 | 2 | طارق فؤاد | 500.00 | 500.00 | 0.00 | |
| 46298 | بادل 1 | 10 | 1 | أحمد سمير | 300.00 | 300.00 | 0.00 | |
| 46298 | خماسي B | 17 | 1 | أكاديمية النجوم | 400.00 | 400.00 | 0.00 | |
| 46298 | بادل 1 | 19 | 2 | محمد عادل | 900.00 | 900.00 | 0.00 | |
| 46299 | بادل 2 | 16 | 1 | كريم حسن | 300.00 | 300.00 | 0.00 | |
| 46299 | تنس 1 | 16 | 1 | أحمد سمير | 200.00 | 200.00 | 0.00 | |
| 46299 | خماسي A | 17 | 1 | عمر خالد | 400.00 | 400.00 | 0.00 | |
| 46299 | بادل 1 | 18 | 2 | أحمد سمير | 900.00 | 900.00 | 0.00 | |
| 46299 | خماسي B | 18 | 2 | هشام رمضان | 1,200.00 | 1,200.00 | 0.00 | |
| 46299 | خماسي A | 19 | 2 | طارق فؤاد | 1,200.00 | 1,200.00 | 0.00 |
Example from the “الحجوزات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الإعدادات: The day shown in the daily grid, any date inside the month you want summarized, and the hour the courts open and the hour they close.
- الملاعب: Each court's name, type, normal hourly price, peak hourly price and peak start and end hours, with the month's bookings, hours, revenue and occupancy rate. Holds up to 30 courts.
- العملاء: The customer or team name and mobile number, with their number of bookings, hours, amount due, balance owed, number of no-shows and cancellations, and their rank among customers. Holds up to 200 customers.
- الحجوزات: One line per booking: date, court, start hour, number of hours, customer, discount, deposit, amount paid, status and booking type. The price, peak hours, end time, amount due, balance and the "تعارض" (overlap) alert appear. Holds up to 2000 bookings.
- الجدول اليومي: Choose the day and the courts appear in rows and the hours in columns, with the name of the customer booking each hour in each cell, plus the booked hours, each court's occupancy rate and the number of courts booked in each hour.
- الملخص: The month's bookings, hours, revenue, amount collected, balance and cancellations, a table for each court, occupancy per hour and per part of the day, revenue for the last six months, the top five customers, and four charts.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Bookings are priced by the hour with peak hours separated from normal ones, so you never forget that 19:00 costs more than 10:00. The sheet catches overlapping bookings on the same court so time is never sold twice, and shows which court hours are empty so you know when to run offers.
How to use it
- In "الإعدادات" (Settings) choose the day you want to schedule, any date inside the month you want summarized, and the hour the courts open and close.
- In "الملاعب" (Courts) enter each court, its type, normal hourly price, peak hourly price and the peak start and end hours.
- In "العملاء" (Customers) enter the customer or team name and mobile number, so they appear in the selection list and the sheet calculates their visits and balance.
- In "الحجوزات" (Bookings) log each booking: date, court, start hour, number of hours, customer, discount, deposit and what they paid, and choose the status. The price, amount due and balance are calculated on their own.
- Check the alert column: "تعارض" (overlap) appears in red if two bookings overlap on the same court, and cancelled bookings drop out of the calculation.
- Open "الجدول اليومي" (Daily grid) to see courts in rows and hours in columns, and "الملخص" (Summary) for revenue, occupancy and charts.
Before you start:
- Bookings are in whole hours: enter the start hour as a number (for example 18 for 6 PM) and the number of hours as a number. The latest closing hour is 24, that is, midnight.
- Booking price = peak hours x peak price + remaining hours x normal price. Peak hours are the hours that fall inside the court's peak period.
- Amount due = price - discount for a confirmed booking. If you choose "لم يحضر" (no-show), the amount due is only the deposit held, and "ملغي" (cancelled) has no amount due.
- Amount paid is everything the customer paid, including the deposit. If you refund the deposit on a cancelled booking, leave the amount paid blank.
- A weekly fixed booking (a team or academy): copy its line and make the next date = date + 7, and choose the booking type "ثابت أسبوعي" (weekly fixed) to separate its revenue in the summary.
- Occupancy rate = booked hours / (number of courts x days in the month x daily operating hours).
- The sheet holds 30 courts, 200 customers and 2000 bookings, and the "الجدول اليومي" (Daily grid) shows the first 12 courts.
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.
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. |
Frequently asked questions
How does the sheet price a booking in peak hours?
It counts the booking hours that fall inside the court's peak period. Price = peak hours x peak price + remaining hours x normal price. So a padel court booking from 17 to 19 includes one peak hour if the peak starts at 18.
How does the sheet detect two overlapping bookings on a court?
It compares non-cancelled bookings on the same date and court. If one booking starts before another ends and ends after it starts, it writes "تعارض" (overlap) in red on both bookings. A cancelled booking is not counted.
How do I record a weekly booking for a team or academy?
Copy the booking line, set the new line's date to the date + 7, and choose the booking type "ثابت أسبوعي" (weekly fixed). The revenue from fixed bookings then appears separately in the summary.
What does the sheet calculate when a customer does not show up?
Choose the status "لم يحضر" (no-show) and the amount due becomes only the deposit held, while the booked hours still count in occupancy because the court was reserved. "ملغي" (cancelled) has no amount due and does not count in occupancy.
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, 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
More free templates for: Gyms and fitness
More free templates
- Gym memberships tracker (Excel)
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Swimming times and personal bests
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Wedding and event hall booking sheet
- 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





