Exporting your data can be very useful. Smily provides exports of your bookings, clients, payments, rentals in many format so you can use it for different purpose.
Here is the list of the exports provided:
| Export / Format | CSV | TSV | Excel (XSLX) | public iCAL (ICS) |
| Bookings | YES |
YES |
YES |
YES |
| Bookings Fees | YES | YES | YES | |
| Clients |
YES |
YES |
YES |
|
| Inquiries |
YES |
YES |
YES |
|
| Payments ordered by payment dates |
YES |
YES |
YES |
|
| Payments ordered by booking dates |
YES |
YES |
YES |
|
|
Rentals |
YES |
YES |
YES |
All these exports can be made for all the rentals at the same time or per rental.
In this video, you will see how to export your bookings in Excel.
In this video, you will see how to export your bookings in Excel.
TIP: If you want other people to access these exports
- Get the link to the export you want to share by right-clicking in the export button and choose Copy the address of the link.
- Copy paste the link in a notepad for example
At the end of teh link, paste?account_id=ACCOUNT_ID&auth_token=AUTHENTICATION_TOKEN
, replacing
- ACCOUNT_ID by your BookingSync account ID. This ID can be found in the browser url when you click in the rental section. Example https://www.bookingsync.com/en/admin/v2/0000/rentals
- AUTHENTICATION_TOKEN by your personal BookingSync authentication token. This token can be found in your profile > Authentication token
List of data availabls when exporting bookings
Export of your bookings
|
Booking export format |
XLSX |
CSV |
TSV |
XML |
JSON |
|
Account ID |
NO |
NO |
NO |
YES |
YES |
|
Account Name |
YES |
YES |
YES |
NO |
NO |
|
Rental Name |
YES |
YES |
YES |
NO |
NO |
|
Rental ID |
YES |
NO |
NO |
YES |
YES |
|
Rental Location |
YES |
NO |
NO |
NO |
NO |
|
Rental Category |
YES |
NO |
NO |
NO |
NO |
|
Booking ID |
NO |
YES |
YES |
YES |
YES |
|
Arrival |
YES |
YES (Start At) |
YES (Start At) |
YES (Start At) |
YES (Start At) |
|
Departure |
YES |
YES (End At) |
YES (End At) |
YES (End At) |
YES (End At) |
|
Booked |
NO |
YES |
YES |
YES |
YES |
|
Expected Check-in Time |
YES |
NO |
NO |
NO |
NO |
|
Expected Check-out Time |
YES |
NO |
NO |
NO |
NO |
|
Nights Booked |
YES |
NO |
NO |
NO |
NO |
|
Unavailable |
YES |
YES |
YES |
YES |
YES |
|
Tentative |
YES |
YES (Tentative Expires At) |
YES (Tentative Expires At) |
YES (Tentative Expires At) |
YES (Tentative Expires At) |
|
Client ID |
NO |
NO |
NO |
YES |
YES |
|
Client Fullname |
YES |
YES |
YES |
NO |
NO |
|
Client Email |
YES |
NO |
NO |
NO |
NO |
|
Client Phone |
YES |
NO |
NO |
NO |
NO |
|
Client City |
YES |
NO |
NO |
NO |
NO |
|
Client State |
YES |
NO |
NO |
NO |
NO |
|
Client Country |
YES |
NO |
NO |
NO |
NO |
|
Adults |
YES |
YES |
YES |
YES |
YES |
|
Children |
YES |
YES |
YES |
YES |
YES |
|
Currency |
YES |
YES |
YES |
YES |
YES |
|
Initial Price |
YES |
YES |
YES |
YES |
YES |
|
Discount |
YES |
YES |
YES |
YES |
YES |
|
Channel Price |
YES |
NO |
NO |
NO |
NO |
|
Channel Commission |
YES |
NO |
NO |
NO |
NO |
|
Fees |
YES |
NO |
NO |
NO |
NO |
|
Total Price Included Taxes |
YES |
NO |
NO |
NO |
NO |
|
Total Price Not Included Taxes |
YES |
NO |
NO |
NO |
NO |
|
Total Price |
YES |
NO |
NO |
NO |
NO |
|
Final Price |
YES |
YES |
YES |
YES |
YES |
|
Final payback to Owner |
YES |
NO |
NO |
NO |
NO |
|
Downpayment |
YES |
YES |
YES |
YES |
YES |
|
Damage Deposit |
YES |
YES |
YES |
YES |
YES |
|
Notes |
YES |
YES |
YES |
YES |
YES |
|
Reference |
YES |
YES |
YES |
YES |
YES |
|
Source ID |
NO |
NO |
NO |
YES |
YES |
|
Source |
YES |
YES |
YES |
NO |
NO |
|
Created At |
YES |
YES |
YES |
YES |
YES |
|
Updated At |
YES |
YES |
YES |
YES |
YES |
|
Canceled At |
YES |
YES |
YES |
YES |
YES |
|
Bookings Tags |
YES |
YES |
YES |
YES |
YES |
|
Booking Comments |
YES |
NO |
NO |
NO |
NO |
|
Payment amount |
YES |
YES |
NO |
NO |
NO |
Comments
0 comments
Please sign in to leave a comment.