How to Import Bookings into mr.alfred PMS via Excel Template

🔄 When to Use the Booking Import Feature

The Import Bookings function in the Bookings module allows you to bulk upload bookings using a structured Excel file. This is particularly useful for:

• Migrating bookings from another PMS
• Uploading historical OTA bookings not synced through a connected channel
• Manually creating multiple bookings at once

📋 Where to Find It

1. Go to the Bookings module in mr.alfred.
2. Click the Import Bookings button (top right).
3. Download the provided template file.

🧾 Required Fields and Format

Ensure that your file follows the format in the template. Each booking must be related to your selected business. Here are the required columns:

• Property
• Check-in / Check-out (valid dates only)
• Channel (must match the Code from the Channels List)
• Guest Name (must have at least 2 words: First Name and Last Name)
• Guest Email
• Total Guests
• Status: Provisional, Confirmed, or Cancelled
• Arrival Status: Upcoming, Online Checked-In, Checked-In, Checked-Out, No Show, Cancelled
• Payment Status: Pending, Paid, Returned
• Payment Method: Only required if Payment Status is Paid (must match a method Code from the Payment Methods list)
• Total Price: For OTA-linked bookings, use the OTA total (include any fees shown to the guest)

⚠️ Manual OTA bookings must reflect the correct OTA total.

 

⚠️ Important Rules

• Maximum 100 rows per import to reduce errors.
• Check-out must be after check-in.
• Channel and Payment Method must use the correct code from the system.
• Past bookings must be marked as Confirmed and Paid.
• Ongoing bookings must be marked as Confirmed.

Once imported, the system does not validate:

• Availability of dates
• Minimum stay restrictions
• Property guest limits

This means incorrect imports can cause overbookings, so please review data carefully before uploading.

✅ Tip: If you need to update any past or ongoing booking post-import, you must do it on the same day.

 

🧠 How the System Handles Pricing

• The price breakdown will be automatically calculated based on the property’s fee configured and each OTA breakdown formula.
• Make sure the total price provided matches exactly what was paid by the guest (especially for OTAs).

🖇️ Related Resources

• Channels Setup Guide
• Bookings Module Overview

🆘 Need Help?

If you’re unsure about how to format your data or are facing issues with overbookings after an import, contact our team at support@mralfred.io.