To use this feature, you need to subscribe to AirHost HMS ONE (Pro Plan or Premium Plan).
Overview
This explains the feature that allows you to export a list of reservation details (such as check-in date, check-out date, OTA, and charges) in CSV format.
Detail
Note:
[10/1/2025]
The “Support Fee” item is calculated based on the commission rate set for the client user on the HMS (former AirHost) side.
This item is a temporary measure during the migration period from HMS to ONE. After the full migration to ONE is completed, please use the Owner Contract and Owner Statement features—rather than CSV reports—for the calculation and management of support fees.
Exporting Booking Data
You can download the data in CSV format via:
Dashboard → Import & Export → Export Bookings and Raw Data → Export Bookings
Select the date category to be used as the base and specify the date range.
You can narrow down the exported data by using filters such as Reservation Status, Check-in Status, Booking Channel (OTA), and Property.
* If you want to export reservations for only specific properties, please select “All Properties” at the top left of the dashboard first, then specify the target properties in the Property filter (multiple selections are possible).
* If none of these filters are selected, reservations for all properties will be included in the export.
*Important Notice*
You can export up to 2 months (62 days) of data at once, starting from the selected start date.
This limitation is in place to reduce server load.
However, if only one property is selected at the time of export, you can download up to 1 year of reservation data in a single export.
(e.g. January 1, 2025 – January 1, 2026)
If multiple properties are selected, please continue to download the data in 2-month intervals as before.
Items Exported to CSV
The following items are included in the CSV export:
CSV Export Items | Description |
Booking Site | Name of the site where the reservation was made (e.g., OTA name, manually created) |
Channel Booking ID | Reservation number on the OTA |
AirHost Booking ID | Reservation number in AirHost |
Check-in | Arrival date |
Check-out | Departure date |
Property Name | Name of the booked property or hotel |
Property Tags | Tags registered in property information  |
Room number | Assigned room number |
Guest Name | From guest information |
Phone | From guest information |
From guest information | |
Nationality | From guest information |
Guest Address | From guest information (address) |
Status | Reservation status |
Check-in | Status of check-in |
Paid | Payment status (paid/unpaid) |
Number of guests | Total number of guests staying |
Total days | Example: 1 night, 2 days = 1 day in total |
Confirm Date | Reservation confirmation date |
Currency | From property information |
Sales | Total reservation sales price |
Channel Fee | OTA service fee included in the sales price |
Receipt Fee | Sales minus OTA service fee |
Paid by Point | Coupons or points used at the time of OTA booking |
OTA Collect | Prepayment amount for OTA reservation |
Credit | On-site credit settlement amount |
Cash | On-site cash settlement amount |
Not Paid | Unpaid amout |
Cleaning Fee | Cleaning charges |
Settlement Commission | Operational service fee |
Rate Plan | Name of the rate plan |
Adult | Number of adults |
Children | Number of children |
Description | From guest information (guest comments) |
Payment fee | Payment processing fee based on payment method |
Cancel | Cancellation date |
Booking Engine Coupon | Coupon code from AirHost Booking Engine |
Guest Who Stays | From guest information |
Update Time | Date when reservation was updated or modified |
Infants | Number of infants |