Reservation import data

When you switch to Booking Experts, an import function can transfer existing reservations from the old system. This helps preserve historical data and ensures that no data is lost during migration.

Group bookings cannot currently be imported. Consult with your Onboarding Specialist at Booking Experts on what the options are and enter bookings manually if necessary.

Below is an overview of the data that can be imported by Booking Experts, whether it is mandatory, and including a brief explanation if needed.


DataMandatoryNote
Reservation numberNoReservation numbers must be unique. If no reservation number is specified, Booking Experts will assign its own reservation number.
ArrivalYesDate of arrival of the reservation
DepartureYesDate of departure of the reservation
Created onNoDate the reservation was created. This data is used for statistics.
Confirmed onNoDate the reservation was confirmed. This data is used for statistics.
Checked inNoDate the guest checked in.
Checked outNoDate the guest checked out.
ObjectYesFor each unique object found in the import, a mapping can be made with the matching object in Booking Experts.
Preferred reservationNoFixes the Reservation to the booked object.
Late check-outNoThis will automatically extend the Reservation with a block on the last day.
ChannelYesHow was the Reservation created in your old system? For example, is it through your own website or an external channel?
External booking numberNoUsed in communication with relevant linked channel in case of changes regarding the relevant Reservation.
Reference codeNoUsed for bookings of (some) business guests
External reservation numberNoUsed in communication with relevant linked channel in case of changes regarding the respective Reservation (if external group booking).
Traffic sourceNoHow did the guest find you? Examples are: Google, Instagram etc.
RemarksNoIInternal notes regarding the Reservation.
Number of seniorsNo
Number of adultsYesAt least 1 adult must be present in the group composition per Reservation.
Number of young peopleNo
Number of childrenNo
Number of babiesNo
Number of petsNoIt is important here that the property allows pets as described here, Pets allowed/not allowed
SalutationNo
InitialsNo
First nameNo
Last nameNoCan be a merge of 'Insertion' and 'Surname' in the import strategy if supplied separately.
Company nameNo
Date of birthNo
Email addressNoEnter a maximum of 1 Email address per reservation if known.
Receive newsletter?NoDoes the guest want to receive non-reservation-related communication?
TelephoneNoEnter a maximum of 1 phone number per reservation if known.
LanguageYes
AddressNoCan be a merge of 'Insertion' and 'Surname' in the import strategy if supplied separately.
Postal codeNo
CityNo
LandYesThis often appears as 'Country' in most export files.
IBANNo
BICNo
Currencies of bookingYesThis currency must also be available in the Administration
Total amount in booking currencyYesThis is the total amount including VAT
Rental turnover in booking currencyNoThis is the total rental amount including VAT.
Total paid in booking currencyNoIf filled in, a payment will also be placed on the Reservation later in the import.
Total amount in Currencies of Administration excl.YesThis is the total amount excluding VAT.
Rental turnover in Currencies of Administration excluding VATYesThis is the total rental amount excluding VAT.
License platesNo

The data above returns in the same order when configuring an The reservations import strategy. It is advisable to first check the data for completeness before starting an import strategy.