Use the UAE Reservations Detailed report to export the nights, rates, taxes, payments and balance of every reservation in house during a date range.
Overview
The UAE Reservations Detailed report shows, for every reservation in house during the selected date range, the guest, the stay, the base rate for the nights in the range, the Cleaning Fee, Value Added Tax (VAT) and Tourism Dirham amounts, travel agent commission, other revenue, payments received, the balance and any security deposit. It is an Accounting report designed for properties in the United Arab Emirates (UAE), and a user's Security Profile must include the UAE Reservations Detailed report function to run it. Run the UAE Reservations Detailed report at the end of each month, or before submitting tax figures, to see what each reservation earned and paid for that period.
The UAE Reservations Detailed report does not display an on-screen report. Selecting Export to CSV downloads a comma-separated values (CSV) file straight away.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
When to use the UAE Reservations Detailed report
Properties typically run the UAE Reservations Detailed report for these tasks:
- Month-end revenue breakdown - at the end of each month, the accounts team exports Last Month to see the base rate, Cleaning Fee, VAT and Tourism Dirham earned by each reservation for the nights in that month.
- Tax check - the accounts team totals the VAT and Tourism Dirham columns and compares them with the property's own tax records for the same period.
- Payments and balances review - the front office manager exports the current month to find reservations with an outstanding Balance As Of, a missing payment or a security deposit still held.
How to access the UAE Reservations Detailed report
In the side menu of RMS, go to Reports > Accounting > UAE Reservations Detailed.
Access to the UAE Reservations Detailed report is controlled by the UAE Reservations Detailed report function in the user's Security Profile, under Report Screens > Accounting Reports.
Choose the UAE Reservations Detailed report options
The UAE Reservations Detailed report options set the date range and limit which reservations are exported. Select Export to CSV to download the file, or Schedule to set up a Scheduled Report. The report has no More Options panel.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Any Part of Reservation Falls Between From and To Date | Date range | This Month | Includes every reservation in house for at least one night of the range. Also sets the period for the date-bound columns. |
| Property | Multi-select | All Selected | Limits the export to reservations in the selected properties. Shown on multi-property databases only. |
| Category | Multi-select | All Selected | Limits the export to reservations in the selected Categories. |
| Area | Multi-select | All Selected | Limits the export to reservations in the selected Areas. |
| Reservation Status | Multi-select | All Selected | Limits the export to reservations with the selected statuses. |
The date range can be a preset, such as Last Month or This Calendar Year, or a Custom Range. The Category, Area and Reservation Status labels follow the property's System Labels.
Tip! Every Reservation Status is selected by default, including Cancelled, No Show, Pencil and Quote. To export only stays that took place, select Arrived, Confirmed and Departed, or the statuses your property uses.
What the UAE Reservations Detailed column headers show
The UAE Reservations Detailed CSV file has 23 columns and always starts with a header row. Each row is one reservation, sorted by Res No. Dates are written as day-month-year, for example 05-Aug-2025, and amounts have two decimal places with no currency symbol. The file is named UAEReservationsDetailed_ followed by the From and To dates, for example UAEReservationsDetailed_20260901_20260930.csv. If no reservations match the report options, the file contains only the header row.
Some columns cover only the selected date range, and others cover the whole reservation. The Source / Calculation column says which, and the rules are explained under How the UAE Reservations Detailed report calculates its figures.
| Column | Description | Source / Calculation |
|---|---|---|
| Res No | Reservation number. | The reservation. |
| Guest Name | Primary guest's name. | Given name followed by surname, from the primary guest on the reservation. |
| Reservation status | Current status of the reservation. | The reservation's status, for example Arrived or Confirmed. |
| Resvation Made On | Date the reservation was made. | The reservation's date made. The header is spelled "Resvation" in the file. |
| Booking Source | Booking Source of the reservation. | The reservation's Booking Source. Blank if none is set. |
| Category | Category of the reservation. | The reservation's Category. |
| Area | Area assigned to the reservation. | The reservation's Area. |
| Check in Date | Arrival date. | The reservation's arrival date. |
| Checkout Date | Departure date. | The reservation's departure date. |
| Nights | Nights of the stay inside the date range. | Date range only. See How nights and rates are worked out. |
| Daily Rate | Average nightly rate for the whole stay. | The reservation's total rate divided by its total nights. See How nights and rates are worked out. |
| Total Base Rate | Accommodation revenue for the nights in the range. | Daily Rate × Nights, plus accommodation revenue charges dated in the range. See How nights and rates are worked out. |
| Cleaning Fee | Cleaning Fee amount. | Date range only. Taxes with the Grouping Cleaning Fee. See How the Tax Grouping columns are filled. |
| VAT | VAT amount. | Date range only. Taxes with the Grouping VAT. See How the Tax Grouping columns are filled. |
| Tourism Dirham | Tourism Dirham amount. | Date range only. Taxes with the Grouping Tourism Dirham. See How the Tax Grouping columns are filled. |
| Total Rate | Total charged for the nights in the range. | Total Base Rate + Cleaning Fee + VAT + Tourism Dirham. |
| OTA Commission | Online Travel Agent (OTA) or travel agent commission on the reservation. | See How OTA Commission is calculated. |
| Other Revenue | Charges that are not accommodation revenue. | Date range only. See What Other Revenue includes. |
| Other Revenue VAT | VAT on other revenue. | Date range only. Taxes with the Grouping Other VAT. See How the Tax Grouping columns are filled. |
| Payment Received | Total paid on the reservation. | Whole reservation. All receipts less all refunds. See How payments, balance and security deposit are calculated. |
| Balance As Of | Balance owing at the end of the range. | Posted transactions dated on or before the To date. See How payments, balance and security deposit are calculated. |
| Security Deposit | Security deposit received. | Whole reservation. Receipts on the Gas account. See How payments, balance and security deposit are calculated. |
| Receipt Note | Comments entered on receipts. | Whole reservation. Each receipt comment, separated by a comma. |
The Category, Area and Booking Source headers follow the property's System Labels, so they change when those labels are renamed.
How the UAE Reservations Detailed report calculates its figures
The following concepts each govern more than one column in the UAE Reservations Detailed report.
Which reservations the report includes
The UAE Reservations Detailed report includes every reservation that arrives on or before the To date and departs after the From date, so a reservation departing on the From date is left out. A same-day (day use) reservation counts as one night. A same-day reservation dated after the From date is always included. A same-day reservation dated on the From date is included only when Include Day Use in Used for Occupancy is ticked at Setup > Property Options > Property Information > Options, or when its Category is booked by day. The Property, Category, Area and Reservation Status options then limit which of these reservations are exported.
How nights and rates are worked out
The UAE Reservations Detailed report works out the base rate for the part of the stay inside the date range:
- Nights - the nights of the stay that fall inside the date range. For example, a reservation from 28 September to 3 October exported for October shows 2 nights.
- Daily Rate - the reservation's total rate, as shown on the reservation, divided by the total nights of the whole stay and rounded to two decimal places.
- Total Base Rate - Daily Rate multiplied by Nights, plus any charges dated in the range whose General Ledger Account Code (GL Acc Code) is set as Accommodation Revenue.
Because Daily Rate is an average that is rounded, Daily Rate and Total Base Rate can differ by a few cents from the nightly charges posted to the reservation account. Daily Rate is 0.00 when the reservation's total rate is zero, but Total Base Rate still includes any accommodation revenue charges posted in the range.
How the Tax Grouping columns are filled
The Cleaning Fee, VAT, Tourism Dirham and Other Revenue VAT columns are driven by the Grouping set on each tax record, at Setup > Accounting > Taxes > edit the tax > Details > Grouping. Each column adds two amounts for the date range:
- Posted amounts - charges and credit notes on the reservation, dated in the range, whose tax has the matching Grouping.
- Projected amounts - for dates in the range that have no posted amount yet, the tax the reservation's rate is expected to charge under a tax with the matching Grouping.
The Grouping names must match exactly, although capital letters do not matter: Cleaning Fee, VAT, Tourism Dirham and Other VAT. See Taxes - Tax Exclusive for how taxes are set up.
Important! If a tax uses a different Grouping name, such as "Value Added Tax" or "Tourism Dirham Fee", its amounts do not appear in any of these columns and Total Rate is understated.
How OTA Commission is calculated
The OTA Commission column is calculated with the same rules as the Travel Agent Commission report, for reservations with a Travel Agent or Wholesaler and the commission set up for that agent. The report takes the commission for the nights in the date range, works out the average commission per night, and multiplies it by the total nights of the whole stay. Reservations without a Travel Agent show 0.00.
What Other Revenue includes
The Other Revenue column adds every charge and credit note dated in the range whose GL Acc Code is not set as Accommodation Revenue. Charges already counted in Cleaning Fee, VAT, Tourism Dirham or Other Revenue VAT, and agent collect commission charges, are left out.
How payments, balance and security deposit are calculated
The payment columns look at every account on the reservation, not only the date range:
- Payment Received - all receipts on the reservation, whatever their date, less all refunds. Security deposit receipts are included.
- Balance As Of - the balance of all the reservation's accounts as at the To date: posted charges and refunds, less receipts, dated on or before the To date. Future-dated transactions and projected amounts are not included, so exporting a later range can show a different balance for the same reservation.
- Security Deposit - all receipts posted to the reservation's Gas account, whatever their date. The Gas account is one of the split accounts set up in Accounting Options - Account Screen Tab.
- Receipt Note - the comment from each receipt on the reservation, separated by commas.
Voided transactions are left out of all of these columns.
Related Reports
- UAE Govt Export - creates the guest data files UAE properties submit to the Department of Culture and Tourism.
- Travel Agent Commission report - shows the commission behind the OTA Commission column, per travel agent.
- In House Guest Balance report - lists every in-house reservation with an outstanding balance on the account.
Related Articles
Comments
0 comments
Please sign in to leave a comment.