Table of contents
Booking information
Customer information
Additional booking information
Questions & Answers
Booking information
Id – booking number
Start time – when the booking starts.
End time – when the booking ends.
Created via – the channel the booking was created through.
Date created – when the booking was created.
Product ID – the product’s ID in BookSpot.
Product name – the name of the booked product.
Total – the booking’s total amount.
Total VAT – the booking’s total VAT.
Price / item – price per booked product.
VAT / pcs – VAT per booked product.
VAT % – the VAT rate.
Discount – discount on the booking.
Price category – the selected price category, for example adult or child.
Duration – minutes/hours/days/nights.
Approved email marketing – whether the customer has agreed to receive newsletters/email marketing.
Tracking tag – the tracking tag linked to the booking.
Agency – the agent who made the booking.
Payment status – whether the booking has been paid or not.
Quantity – how many of the product have been booked.
Customer information
Name – first and last name
First name – the customer’s first name
Last name – the customer’s last name
E-mail – the customer’s email address.
Phone – the customer’s phone number.
Comment – the customer’s comment on the booking.
Nationality - Customer nationality
Company name - only for company bookings.
Organization number – only for company bookings.
Street address – the customer’s address
City – the customer’s city
ZIP/Postal – the customer’s postcode
Country – the customer’s country
State/Province – the customer’s state
Additional booking information
You can also add the fields you have created under Settings > Additional booking information. In the export, the columns have exactly the same names as you gave the fields.
The customer must always provide their first name, last name, email address, and phone number when making a booking, as these fields are mandatory. Read more about how to add additional fields here.
Read more about how to export bookings here.
FAQs
Why aren’t the columns I chose in the manifest included in the export?
Why aren’t the columns I chose in the manifest included in the export?
The manifest columns and the export columns are set separately. The columns you show in the manifest only control what is displayed on screen. For the export, you choose columns directly in the Export bookings window. If you want a list that looks exactly like the manifest, you can print the manifest instead.
Do I have to choose columns every time I export?
Do I have to choose columns every time I export?
No. You can save your column selection as a template by clicking Save template in the export window. Next time, just select the template.
Can I change the order of the columns in the Excel file?
Can I change the order of the columns in the Excel file?
Yes, you can change the order by dragging the arrow icon to the left of the columns you’ve added.
How can I export my customers nationalities?
How can I export my customers nationalities?
You can see which country your customers are from by including the Country column in your report. However, this requires that the field was enabled for customers to fill in when making a booking. You can enable it by going to Settings (in the left-hand menu) > Bookings > Standard booking fields.
If the field wasn’t enabled, you can instead include the Phone number column in your report and sort by country code to get an idea of where your customers are from.