Skip to main content

Add existing reservations to Little Hotelier

Upload reservations into Little Hotelier by using Import Reservations, a useful tool for migrating reservations from another platform.

Updated in the last hour

Why upload future reservations?

The Little Hotelier Calendar is the central hub for managing reservations from all booking sources. To maintain accurate inventory and availability, add all your future reservations before connecting any online booking channels (such as Booking.com) to prevent overbookings.

You can add future reservations in two ways:

  1. Manually input individual reservations

  2. Import multiple reservations using a CSV file

Note: Before adding reservations, confirm that the value you enter in the Room total column accurately reflects your property's tax policy. If your tax settings are inclusive, ensure your Room total includes taxes. If exclusive, the Room total should not include taxes.


Option 1: Input reservations manually

  1. Add a new reservation via:

    1. Calendar

      1. Click +Reservation

      2. Click and drag across reservation dates

      3. Click +Create Reservation

    2. Reservations

      1. Click +Reservation

    3. Setup

      1. Click Import Reservations

Option 2: Import reservations using a CSV file

Ensure you have set up your room types and room rates before importing reservations.

  1. Go to Front Desk > Setup > Import Reservations

  2. Click Download reservation template under More Information

  3. Click Continue

  4. Click Edit table settings to configure:

    1. Date input settings (date format for reservations)

    2. Select optional details

  5. Click Confirm to save table settings

  6. Open the CSV file and add all mandatory future reservation details

    1. Each row represents one reservation

    2. Ensure mandatory fields are completed correctly

  7. Click Import CSV to upload your file

  8. Click Import CSV

  9. Reservations from the CSV file will be imported into the Import reservations table

  10. Review the imported reservations in the table

    1. Ensure all mandatory details are complete

    2. Look for a green tick next to each reservation

  11. Click Upload reservations

  12. Click Add reservations

    1. A green banner indicates a successful import

Recommended optional fields

While not mandatory, we recommend entering the following fields:

  • Room number: Ensures correct room allocation. If left blank, any available room of the selected room type will be assigned.

  • Currency: Specify if you accept multiple currencies. The default currency applies if left blank.

  • Reservation ID:

    • If blank, an ID starting with 'LH' will be assigned

    • For online booking channels, the Reservation ID must match the booking channel reservation ID otherwise cancellations or modifications will not sync

    • Avoid duplicate Reservation ID’s unless adding multiple rooms in one reservation

Group bookings

To add a reservation with multiple rooms:

  1. Enter separate rows for each room

  2. Use the same Reservation ID across all rows

  3. Ensure the following details match across all rows:

    1. Guest Name

    2. Check-in date

    3. Check-out date

    4. Booked-on date

Frequently asked questions

Do I need to provide details for all guests when I book?

No, you only need to provide the primary guest's information during the booking process. You can add details for any additional guests after you’ve added the booking.

Can I add past reservations?

Past reservations cannot be added, only future bookings.

I’ve entered reservation details, but I'm seeing errors. What should I do?

Errors often happen if the information you entered in the drop-down menu columns (like Source of Reservation, Room Type etc.) doesn’t match the available options. Double-check that your entries match the choices in the drop-down lists.

Will reservation information be saved automatically?

Yes, reservation data is automatically saved as you enter it.

Can I enter prices that include cents or decimals?

Yes, you can enter prices with decimals. To enable this, go to Setup > Property & Room Settings > Property Details > General > Allow Decimals.

How do I know if my reservations were added correctly?

After you click the “Upload (number) reservations” button, a green banner will appear if reservations were successfully added. If any reservations failed to upload, the errors will be highlighted so you can fix them and try uploading again.

Can I use special characters in guest names?

Yes, you can use special characters in both the first and last names.

Did this answer your question?