Skip to main content

Run and export reservation data

Little Hotelier provides two main ways to search for reservations:

  • Through Calendar using check-in or check-out dates

  • Through Reservations using filters like guest last name, booking reference, invoice number and booking status

Export reservation data

Note: To export, you need to be on a trusted device.

  1. Navigate to Reservations

  2. Set desired filters

  3. Click Search

  4. Click Export

  5. File exports in CSV format

Data included in the Reservations CSV

The exported CSV file provides reservation details including:

  • Booking details – booking reference, channel name, promotion code, and reservation status

  • Guest information – guest name, address, organisation, and any guest comments or internal notes

  • Stay information – check‑in and check‑out dates, length of stay, arrival time, room types, room rates, number of adults, children, infants, and number of rooms

  • Financial information – extras, discounts, surcharges, taxes, deposits, and any outstanding balance

  • Activity timestamps – when the reservation was booked and when it was cancelled (if applicable)

⚠️ Notes:

  • Guest phone numbers are not included as a column in the exported CSV file due to security reasons

  • Some fields (marked with an asterisk in the system) are only populated for direct bookings or manually created reservations.

Note about check−in and check−out timestamps: The Reservations export includes key timestamps such as when a reservation was booked and when it was cancelled., but it does not provide a full change history for each reservation (for example the exact time when you change a reservation’s status to Checked‑in or Checked‑out, or when pricing was changed).

💡 To export the total number of guests who stayed during a specific period, set Date type to Check-in or Checked-out, set Status to match, enter your date range, and export.

💡 How your columns appear in the CSV export: When you download your reservations as a CSV, the export matches your saved column layout and shows the visible columns, in the saved order.

Did this answer your question?