Skip to main content

How Amenitiz calculates revenue and performance metrics

How Amenitiz calculates revenue, payments, occupancy, ADR, RevPAR and guests in Reports and the Dashboard, and why these figures can differ from one report to another.

Overview

This article explains how key revenue and performance metrics are calculated in Amenitiz.

It applies to the following areas:

  • General Report

  • Revenue Report

  • Pick Up Report

  • Occupancy Report

  • Annual Comparative Report

  • Dashboard

  • Performance page

All these reports use aligned definitions and consistent calculation logic.

If you need to understand how figures such as occupancy rate, ADR, RevPAR, revenue (gross and net), or guests are calculated, this article provides the official definitions.


Why revenue, payments and charges show different totals

Amenitiz counts money in three ways. Each answers a different question, so the totals for the same period will rarely match, even over a full year.

  • Revenue — what you sold for that period. Counted on the nights of the stay. A booking made in March for a stay in July appears in July. Used by the Dashboard, occupancy, ADR, RevPAR and the revenue figures in the General report.

  • Registered payments — the money you collected in that period. Counted on the date the payment was recorded, and refunds on the date of the refund. Used by the Registered payments report and the payments summary of the General report.

  • Charges — each item added to a booking. Counted on the date of the charge. Used by the Charges report.

Differences come from guests who pay before or after their stay, deposits received this year for next year's stays, refunds, and payments still to be recorded.

⚠️ Important

Before you send figures to your accountant, decide which question they need answered. For money collected in a period, including deposits for future stays, use the Registered payments report for that period. For what was sold in a period, use the revenue figures. Download both again if you change bookings or payments afterwards: reports always show the data as it is when you download them.


Room and availability concepts

Booked rooms (Rooms sold)

Definition:Total number of booked rooms for a given night. A room is considered booked for each night between its:

  • Arrival date

  • Departure date

Only bookings in Confirmed or Modified status are included. If more than one booking exists for the same room on the same night, all bookings are counted. This may result in occupancy above 100% in case of overbookings.

Formula: Rooms sold = sum(booked_rooms)

Available rooms

Definition: Total number of rooms that could be booked on a given night. It is not simply the number of rooms × the number of days.

  • A night with a booking always counts as available.

  • A night without a booking does not count as available when:

    • the room is set to Out Of Order or Out Of Inventory, or

    • all rates for that room are closed, or

    • the Availability for that night is 0 or lower.

Closed to arrival, closed to departure and visibility on the Booking Engine do not affect availability.

This definition ensures that, except in overbooking cases, booked rooms are less than or equal to available rooms.

Formula: Rooms available = sum(available_rooms)

Special case: Mother cottages

Mother cottages affect availability and occupancy calculations.

  • If a mother cottage is out of order or out of inventory, all child rooms are unavailable.

  • If a mother cottage is booked, all its child rooms are unavailable.

  • Mother cottages are unavailable by default, except when booked.

  • If a child room is booked through a mother cottage, it is always considered unavailable individually.

  • For occupancy purposes, rooms inside a mother cottage are counted as individual rooms.

  • When a mother cottage is booked, all rooms within the cottage are considered occupied.

Occupancy rate

Definition: Percentage of available rooms that are booked for a given night.

Formula: Occupancy rate = sum(booked_rooms) / sum(available_rooms)

Occupancy may exceed 100% in case of overbookings.

Unoccupied rooms

Definition: Total number of rooms not occupied on a given night.

Formula: Unoccupied rooms = max(available_rooms − rooms_sold, 0)

If overbookings occur (rooms sold exceed rooms available), unoccupied rooms are floored to 0 and never negative.


Revenue logic

Revenue can be attributed in two different ways depending on the metric.

Revenue attribution logic

Revenue can be attributed in two different ways depending on the metric.

Effective date revenue

Revenue is attributed to the date on which the charge is applied. This reflects accounting timing and is used in charge-based reports.

Night stay revenue

Revenue is attributed to the specific nights of stay that generated it.

Revenue from a stay is allocated across each night between arrival and departure.

This reflects operational performance and is used for KPIs such as:

  • ADR

  • RevPAR

  • RevPAC

Gross revenue, Net revenue and Taxes

Revenue is calculated from charges linked to bookings in Confirmed or Modified status.

For each charge:

  • Gross revenue = the total amount, tax included

  • Net revenue = the amount before tax

  • Taxes = gross revenue − net revenue

Discounts and cancelled charges are subtracted from the charge they belong to. OTA commissions are not deducted: revenue shows the amount charged on the booking.


Revenue breakdown types

Revenue is categorised as follows:

Room Revenue (Gross / Net / Taxes)

Includes room nights, excluding rooms set up as a reception hall.

Extras Revenue (Gross / Net / Taxes)

Includes extras and custom charges, excluding rooms set up as a reception hall.

City Tax Revenue (Gross / Net / Taxes)

Includes city tax charges, excluding rooms set up as a reception hall.

Reception Hall Revenue (Gross / Net / Taxes)

Includes all charges for rooms set up as a reception hall. Reception Hall revenue is real revenue but is not part of accommodation activity and does not impact room performance KPIs such as Occupancy or RevPAR.

Total Revenue (Gross / Net / Taxes)

Sum of all charges from all rooms, regardless of type.


Performance KPIs

ADR (Average Daily Rate)

Definition: Average revenue per booked room for a given date. Revenue and booked rooms are based on stay dates.

Formula: ADR = sum(revenue) / sum(booked_rooms)

Available per combination of:

  • Date

  • Hotel

  • Room

RevPAR (Revenue per Available Room)

Definition: Average revenue earned per available room for a given date. Revenue and rooms available are based on stay dates.

Formula: RevPAR = sum(revenue) / sum(available_rooms)

RevPAC (Revenue per Guest)

Definition: Revenue divided by number of guests for a given date range. Revenue and guests are based on stay dates.

Formula: RevPAC = sum(room_revenue) / sum(number_of_guests)

Length of stay

Definition: Number of nights between arrival date and departure date. For reporting periods, length of stay is calculated as a weighted average.

Formula: sum(average_length_of_stay × booked_rooms) / sum(booked_rooms)

If multiple bookings exist for the same room and night, the average length of stay between them is used.

Lead time

Definition: Number of days between booking creation date and arrival date. Calculated as a weighted average for reporting periods.

Formula: sum(average_lead_time × booked_rooms) / sum(booked_rooms)

If multiple bookings exist for the same room and night, the average lead time between them is used.

Number of guests

Definition: Total number of guests staying in each room for a given night.

Only bookings in Confirmed or Modified status are included.

Formula: Guests = sum(guests)


Breakfast metrics

Breakfasts sold

Definition: Total number of extra breakfasts sold.

Breakfasts are counted when:

  • Recorded as an extra or custom charge

  • Tagged with an extra category marked as breakfast

Not included:

  • Breakfast included by default in the room rate

  • Cancelled breakfasts (counterpart charges)

If a breakfast has a 100% discount, it is included, as it was discounted rather than cancelled.

Allocation logic:

  • If the breakfast charge occurs during the stay → allocated to the date of the charge.

  • If the charge occurs outside the stay period → allocated to the arrival date.

Breakfast capture rate

Definition: Percentage of extra breakfasts sold per guest.

Formula: Breakfast capture rate = sum(breakfasts_sold) / sum(guests)

Allocation follows the same logic as breakfasts sold.

Breakfast gross revenue

Definition: Gross revenue generated from extra breakfasts.

Includes extras and custom charges linked to breakfast.

Formula: sum(total)

Allocation follows the same date logic described above.


Registered payments revenue

Registered payments revenue by payment method

Definition: Total revenue collected from registered guest payments.

Source: Payments recorded on your bookings, with a payment date.

Allocation logic:

  • Revenue is assigned to the payment date.

  • Refunds are assigned to the refund date.

Refunds cannot be reliably linked to their original transaction in most cases, as the original transaction reference is typically not available.

Important notes
- Reported on a cashflow basis.
- Available at hotel level only.
- Not allocated at room level.
- Not used for occupancy or room performance KPIs.

Booking Activity metrics

Cancelled bookings

Definition: Total number of bookings cancelled on a given date.

Formula: sum(cancelled_bookings)

Granularity: Available per day for your property.

Notes:
- Cancelled bookings are allocated to the cancellation date.
- Bookings are a non-additive (distinct-count) metric, as a single booking may include multiple rooms.

Active bookings created

Definition: Total number of active bookings created on a given date.

A booking is considered active when its status is Confirmed, Modified or pending.

Formula: sum(active_bookings_created)

Granularity: Available per day for your property.

Notes:
- Created bookings are allocated to the booking creation date.
- Bookings are a non-additive (distinct-count) metric, as a single booking may include multiple rooms.

FAQs

Why don't my revenue and my registered payments match?

This is expected. Revenue is counted on the nights of the stay, registered payments on the date the money was recorded. A guest who paid in December for a stay in January appears in December's payments and in January's revenue. Room revenue also leaves out extras and city tax, while payments include everything the guest paid.

To find a specific difference, download the Registered payments report and the Charges report for the same period and compare the bookings one by one.


Why is my occupancy at 100%, or why are rooms available equal to rooms sold?

A night without a booking does not count as available when its rates are closed, its Availability is 0, or the room is Out Of Order or Out Of Inventory. If you close your rates on nights you do not want to sell, only the booked nights are counted, so occupancy shows 100%.

Check the rates and availability for those nights in your calendar. Past dates cannot be reopened, so figures for past periods stay as they are. Occupancy above 100% means two or more bookings share the same room on the same night.


Does revenue include OTA commissions? What does "net" mean?

Revenue shows the amount charged on the booking. OTA commissions are not deducted. Example: a guest pays 100 € on an OTA that keeps 20 €. Revenue and ADR count 100 €, even though you receive 80 €.

Net revenue means the amount before tax. It does not mean after commissions.


Are cancelled bookings included, even with a cancellation fee?

No. Only bookings that are confirmed or modified are included in revenue and performance figures. A cancelled booking stays out even if you invoiced a cancellation fee. To see cancellation fees, download the Charges report for the period.

If a booking cancelled on an OTA still shows a payment in Amenitiz, open the booking, go to its payments and record a refund. This only corrects the record, it does not move any money.


Why do my figures show 0?

Check the period first. Revenue and occupancy are counted on the nights of the stay, not the day the booking was made. Then check that the bookings are confirmed or modified. If confirmed stays fall inside the period and the figures still show 0, contact us with the name of the report and the period you selected.


Why do unoccupied rooms never appear as negative?

If rooms sold are higher than rooms available, unoccupied rooms show 0.


Related articles

Did this answer your question?