# Serviced apartment bookings Excel (free) + online

> Free Excel sheet for serviced apartments and short stays: Airbnb, Booking and direct bookings, overlap alerts, calendar, occupancy, ADR, RevPAR and profit.

Source: https://softwiro.com/blog/serviced-apartments-bookings-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Serviced apartments bookings in Excel (free): occupancy, ADR, RevPAR and overlap alerts

One workbook for units, bookings from every channel, a month calendar, upcoming arrivals and departures, and net profit per apartment.

13 November 2026 6 min read

## In short

- Each booking is typed once; nights, weekend nights, stay price, commission and balance are calculated.
- Two live bookings on one apartment that overlap are flagged red in the log and with a warning sign in the calendar.
- A month calendar of apartment × day and date-ordered lists of arrivals and departures.
- Occupancy, ADR and RevPAR, revenue per channel after commission, and net profit per apartment after expenses.

You rent furnished apartments by the night and want to know, without scrolling through WhatsApp messages and Airbnb and Booking notifications: which apartment is occupied today, who arrives and leaves this week, what the month's occupancy is, how much each channel leaves you after its commission, and whether an apartment was booked twice. The free [serviced apartments and short-stay bookings sheet](https://softwiro.com/templates/serviced-apartments-bookings) (the page is in Arabic) puts all of it in one file, in Excel or online.

## The problem it solves

When bookings arrive from four sources (direct, Airbnb, Booking and a broker), the whole picture is hard to see. Each site accepts a booking without knowing about the others, so double bookings happen. At month end you ask yourself whether you really made money after commissions, cleaning and electricity. Here each booking is typed once and the rest is calculated.

## Steps, from opening the file to the report

1. Settings: enter the property name, the first day of the month, today's date and the booking channel names.
2. Units: for each apartment its area, bedrooms, weekday rate, weekend rate (Thursday and Friday nights) and cleaning fee.
3. Bookings: enter the guest, phone, unit, channel, check-in and check-out. Nights, weekend nights, stay price, total, channel commission and balance appear.
4. Commission, discount and paid: type the channel's commission rate as in your agreement with it, and change the status to "مغادر" (departed) or "ملغي" (cancelled).
5. Expenses: log cleaning, utilities and maintenance per apartment.
6. Calendar, Upcoming and Summary: these are calculated from the bookings and expenses.

## What each sheet holds

"الحجوزات" (Bookings) is the heart of the file. Its note column writes "تعارض" (clash) in red when another non-cancelled booking on the same apartment overlaps your nights. The check-out night is not counted, so a guest arriving on the previous guest's check-out day is not a clash. A booking that spans two months is split by the nights falling in each month.

"التقويم" (Calendar) is the month as apartment × day: a cell turns green with the guest's name for every occupied night and red with ⚠ on a clash. "القادم" (Upcoming) has two date-ordered lists, arrivals and departures within the days you set, with the guest's phone and balance.

## Walk-through on the sample numbers

The names and numbers below are sample data inside the sheet, not real people. The example has six apartments and twenty-three bookings, and November 2026 is the chosen month:

- One booking, step by step: "محمد عبد الله" in "النرجس 12" (Narges 12), 28 October to 3 November via Airbnb: six nights, two of them a Thursday and a Friday. Stay price = 4 × 1,200 + 2 × 1,500 = 7,800, cleaning fee 250, so the total is 8,050 and Airbnb's 15% commission is 1,207.50. Only two of the six nights fall in November, so the month gets a third of the stay revenue = 2,600.
- Occupancy: 180 nights are available (6 apartments × 30 days) and 71 were sold, so occupancy is 39.4%.
- ADR and RevPAR: stay revenue after discounts is 89,970, so the average rate of a sold night is 1,267.18 and revenue per available night is 499.83.
- Net: commissions 9,339, net after commission 85,494.33, expenses 5,530, so net profit is 79,964.33.
- The clash: the bookings of "John Smith" and "سلمى حسن" on "النرجس 15" overlap on 14 November, so both show a red "تعارض".
- Best apartment: "مارينا 7" with net profit 23,500; the weakest is "ستوديو الزمالك" with 23.3% occupancy and net profit 6,874.

## Common mistakes

- Entering the check-out as the last night: check-out is the departure day, so a stay from the 10th to the 13th is three nights.
- Leaving a cancelled booking unchanged: it keeps blocking the apartment and shows a clash. Set its status to "ملغي".
- Forgetting the commission rate: left empty, the sheet treats it as zero and the channel's net looks higher than it is.
- Mixing ADR with occupancy: a high price with empty apartments gives a good ADR and a weak RevPAR.
- Deleting old bookings: keep them; they stay out of the chosen month but preserve your guest history.

## When to move from a sheet to a system

A sheet suits a limited number of apartments and one person typing. If you are copying bookings by hand from the channels, need guests to book from your own link with live availability, or want the cleaning team to see their tasks, ask for a [custom program from Softwiro](https://softwiro.com/request-sheet).

## Next step

Download the sheet from the [template page](https://softwiro.com/templates/serviced-apartments-bookings), clear the sample bookings, enter your apartments and rates, then log this month's bookings and look at the Calendar. If you also manage monthly rentals, try the [rental portfolio sheet](https://softwiro.com/templates/rental-portfolio).

## 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: serviced apartments (1/3)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-1.jpg)[![Cheat sheet: serviced apartments (2/3)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-2.jpg)[![Cheat sheet: serviced apartments (3/3)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/serviced-apartments-bookings/en-3.jpg)

0 downloads · 3 pages

## 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)

## Questions this raises

### How do I calculate occupancy for serviced apartments?

Occupancy = occupied nights ÷ available nights, where available nights = number of units × days in the month. The sheet works it out from the check-in and check-out dates you enter, per apartment as well.

### What is the difference between ADR and RevPAR?

ADR is the average price of a night actually sold = stay revenue ÷ occupied nights. RevPAR is revenue per available night = stay revenue ÷ available nights, so it also reflects occupancy.

### How do I know an apartment was booked twice?

The note column writes "تعارض" in red for every two non-cancelled bookings on the same unit whose nights overlap, and the calendar shows a warning sign on that day. A guest arriving on the previous guest's check-out day is not a clash.

### Does the sheet calculate Airbnb and Booking commission?

Type the channel's commission rate from your agreement in the commission column of each booking; the sheet then works out the commission amount and the net per channel. The rate is yours, not a fixed figure in the sheet.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
