All of your reporting features can be found on the metrics tab by clicking here. The Reservations & Financials export is one of the reports available to you here.
The reservations export has the full guest and financial details for every confirmed booking for Airbnb, Vrbo, Booking.com, and manual reservations, including base rates, taxes, fees, subtotals, deposits, payouts, subtotals, and total price for the guest.
All exports can be restricted to include the data for specific properties, hosts, or other key filters, and are downloaded as an easily edited excel file (.csv). You can then upload this file into most accounting software, such as Quickbooks.
Here is an example of all the data included in the export and what each data point represents:
| Example Data | Description |
uuid | 5fa560d6-Obf0-4f1e-90b362fd043c9937 | The reservation ID in Hospitable.com |
thread uuid | 11e13219-17dd-43cf-ac0502a2a6d9487f | The conversation ID on Hospitable.com |
checkin_date
| 2022-03-07 | Check-in date of the reservation |
checkin hour | 15:00:00 | Check-in hour of the reservation |
checkout_date | 2022-03-14 | Check-out date of the reservation |
checkout_hour | 11:30:00 | Check-out hour of the reservation |
booking_date | 2019-12-03 | The date the reservation was confirmed |
booking_hour | 10:46:54 | The time the reservation was confirmed |
code | HMAPT4MCWH | Reservation code on the booking platform |
platform | vrbo; airbnb | The booking platform |
listing_id | 6789900 | The ID of the listing on the booking platform |
listing_name | Luxury Starred Rock Villa | The name of the listing on the booking platform |
property_id | 546546 | The property ID on Hospitable.com |
property_name | Luxury123 | The property name on Hospitable.com |
property_timezone | Europe/Paris | The timezone of the property |
host_id | 34567890 | The host ID on the booking platform |
host_first_name | Adrian | The first name of the host |
host_last_name | Holloway | The last name of the host |
status | accepted; cancelled, etc... | The status of the reservation |
instant_booked | 0;1 | Indicator of instant booked booking (1=instant booked) |
initial_status | inquiry; accepted; pending; pending verification | The initial status of the conversation |
cancellation_policy | Moderate; relaxed, etc... | The cancellation policy of the booking |
guest_uuid | d5041438-4fab-11e9-86a6760668f10017 | The guest ID on Hospitable.com |
guest_first_name | Alexiane | The first name of the guest |
guest_last_name | Poitevin | The last name of the guest |
guest_locale | en-AU | The language locale of the guest (Airbnb only) |
guest_count | 6 | The total number of guests |
guests_children | 2 | The number of children |
guests_infants | 1 | The number of infants |
guests_pets | 0 | The number of pets |
guest_email | The email (or email proxy) of the guest | |
guest_phone | +1 (312) 772-8527 | The phone number of the guest |
guest_city | Tartu | The city on the guest profile |
guest_region | Tartumaa | The region on the guest profile |
guest_country | Estonia | The country on the guest profile |
review_id | 45678 | The review ID on Airbnb |
review_rating | 4 | The rating the guest gave on Airbnb for their stay |
review_comments | What an awesome place you have! | The review the guest left on Airbnb for their stay |
nights | 6 | The total number of nights for the stay |
currency | EUR | The payout currency |
base_amount | 35.86 | The base fee amount |
cleaning_fee | 35.86 | The cleaning fee amount |
subtotal_amount | 35.86 | The subtotal amount |
guest_fee | 35.86 | The fee the guest pays to the platform for the booking |
tax_amount | 35.86 | The host tax amount |
total_price | 35.86 | The total price for the guest |
security_price | 35.86 | The security deposit amount |
payout_amount | 5176.04 | The payout for the reservation *Unavailable for Booking.com reservations |
host_service_fee | 35.86 | The fee the host pays to the platform for the booking |