Uploading past reservations manually into Guesty

In Guesty, you can create manual reservations with present or future check-in dates, but not with past dates.

• Pilot users: You can now create also manual reservations with past check-in/check-out dates. 

If you need to add past reservations to Guesty (for your reservations reports’ integrity, for example), you can send us a file containing the data of the past reservations, and we will add them for you. We can only extract the data from the file as it’s provided so be sure to follow all the instructions below for the file to be uploaded correctly.

Guesty is not responsible for rectifying any inaccurate information in the file, nor will Guesty be held liable for any issues that may arise as a result of incorrect data in the file provided.

Before you begin

Note the following prerequisites and limitations:

• Including an existing reservation source in the CSV file will trigger any associated automations you configured for the source (for example, if you set up message automations or applied automatic additional fees for the selected reservation source). If you don't want to trigger these automations, use a different source name for the uploaded reservations or create a new source for them.
• Add your listing’s taxes and commissions on the account or listing level before sending the file. The taxes and commissions will apply automatically to your uploaded reservations. If you don’t want them to apply, you can temporarily modify the tax and commission settings, and revert the change once the upload is completed.

Sending a past reservation file to Guesty

Step by step:

1. Download this CSV file.
2. Fill in the file’s fields using the explanations and examples below. Then, send it to us.

Mandatory fields

• AccountId - Leave this field blank, it will be filled in by Guesty
• ListingId - Enter the Listing ID (ex: 59340fbed0140d1000c49f2f). See how to Locate your listing ID
• FirstName - Fill in the guest's first name (for example, “Lucy”)
• LastName - Fill in the guest's last name (for example, “Perricone”)
• NumberOfGuests - Enter the number of guests (for example, “7”)
• CheckIn - Check-in date. Use the date format of YYYY-MM-DD (ex: 2019-07-22). Errors in the date format may result in blocking the listing calendar dates indefinitely.
• CheckOut - Check-out date. Use the date format of YYYY-MM-DD (ex: 2019-07-22). Errors in the date format may result in blocking the listing calendar dates indefinitely.
• Status - Enter one of the following statuses:
  • Confirmed
  • Reserved
  • Inquiry
• Currency - Enter the reservation payment currency (ex: USD)
• Source - Insert the reservation’s source (for example: “ External”). For Vrbo, use "uploaded_VRBO".
• ConfirmationCode (this field is mandatory for Vrbo only)

Optional fields

• AccommodationFare - Fill in the accommodation fare (for example: “13828.2”). If you don’t fill in the price, it will be calculated according to the listing’s base price.
• CleaningFee - Fill in the cleaning fee. If not provided, the default settings will apply
• Additional Fees - If filling one of the fields below, it is mandatory to fill in all others. You can set up to 3 additional fees per reservation. To add more, add the following 3 columns for every additional fee you want to add in addition to the available columns in the template:
  • Additional fee type- You can use only the following fees. Use the exact spelling as written below.
    • ADDITIONAL_BED
    • AIR_CONDITIONING
    • EARLY_CHECK_IN
    • LATE_CHECK_IN
    • BABY_BED
    • CLEANING
    • CLUB_CARD
    • CONCIERGE
    • EARLY_CHECKOUT
    • LATE_CHECKOUT
    • DEPOSIT
    • ELECTRICITY
    • FOOD
    • HEATING
    • INTERNET
    • LAUNDRY
    • LINENS
    • TOWELS
    • MANAGEMENT
    • OIL
    • PARKING
    • PET
    • POOL
    • POOL_HEATING
    • RESORT
    • SERVICE
    • TOILETRIES
    • TOUR
    • TRANSPORTATION
    • CAR_RENTAL
    • WATER
    • WOOD
    • TRANSFER
    • HOUSEKEEPING
    • INSURANCE
    • COMMUNITY
    • CREDIT_CARD_PROCESSING_FE
    • EXPEDIA_AFE
    • DAMAGE_WAIVER
  • Additional fee name  (for example: “Additional bed”)
  • Additional fee amount (for example: “50”)
• Fully paid  - If you fill in this field, you must fill in "Payment method" as well. Use “TRUE” or “FALSE” (boolean value).
• Money.totalPaid - Fill this field only if the reservation was partly paid. If you fill in this field, you must fill in "Payment method" as well. Use a number (for example: “500”).
• Payment method - Type in one of the following
  • Cash
  • Credit card
  • Debit card
  • E-check
• Phone - Enter the guest’s phone number (for example: “16266883744”)
• Email - Enter the guest’s email address
• ConfirmedAt - Add a date. Use the date format of YYYY-MM-DD (ex: 2019-07-22). Errors in the date format may result in blocking the listing calendar dates indefinitely.