Softwiro
Free Excel template

Padel and 5-a-side court booking sheet (hourly)

A free Excel sheet for booking padel, 5-a-side football and tennis courts by the hour. You enter each court's normal hourly price, peak hourly price and peak time, then log each booking with its date, start hour and number of hours. The sheet calculates the price on its own, detects any two overlapping bookings on the same court, draws the day's grid of courts by hour with customer names, and shows occupancy per court and per hour, revenue, balances owed by customers and top customers.

Excel file (.xlsx) · 407 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

Example from the “الحجوزات” tab (Arabic), with the numbers and formulas that are in the file.
التاريخالملعبالبداية (ساعة)عدد الساعاتالعميلالسعرالمستحقالمتبقيتنبيه
46296بادل 1192محمد عادل900.00900.000.00
46297تنس 1162طارق فؤاد500.00500.000.00
46298بادل 1101أحمد سمير300.00300.000.00
46298خماسي B171أكاديمية النجوم400.00400.000.00
46298بادل 1192محمد عادل900.00900.000.00
46299بادل 2161كريم حسن300.00300.000.00
46299تنس 1161أحمد سمير200.00200.000.00
46299خماسي A171عمر خالد400.00400.000.00
46299بادل 1182أحمد سمير900.00900.000.00
46299خماسي B182هشام رمضان1,200.001,200.000.00
46299خماسي A192طارق فؤاد1,200.001,200.000.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

  1. 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.
  2. In "الملاعب" (Courts) enter each court, its type, normal hourly price, peak hourly price and the peak start and end hours.
  3. 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.
  4. 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.
  5. Check the alert column: "تعارض" (overlap) appears in red if two bookings overlap on the same court, and cancelled bookings drop out of the calculation.
  6. 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.

Excel file (.xlsx) · 407 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: hourly court booking (1/3)Cheat sheet: hourly court booking (2/3)Cheat sheet: hourly court booking (3/3)
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 sheetIn 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 · Ask for a demo

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

All templates · Free tools