The Reservations & Financials export is one of the reports available within the Metrics section. It includes the full guest and financial details for all confirmed Airbnb, Vrbo, Booking.com, Direct, and manual reservations, including base rates, taxes, fees, subtotals, deposits, payouts, subtotals, and total price for each guest.
Each report consists of 2 files:
Full reservation details
KPI report
View the Reservations & Financials Export
To view the Reservations & Financials export, go to Metrics. The Reservations & Financials view is the default.
Select the data you wish to include by clicking on:
The date:
+Filter:
Select the columns you wish to include (all options/definitions are in the table at the end of this article).
(Optional) Click on Save to save the view. You can access this later by clicking on Views.
View the data, or select Export to email a .csv file, which you can save to your files and/or upload into most accounting software, such as Quickbooks.
These include the following data points (data points from legacy reports can be found and compared here):
Full Reservation Details Report
Column name | Shown by default | Example data | Description |
uuid | YES | 5fa560d6-Obf0-4f1e-90b362fd043c9937 | The reservation ID in Hospitable.com |
thread_uuid |
| 11e13219-17dd-43cf-ac0502a2a6d9487f | The conversation ID on Hospitable.com |
checkin_date | YES | 44627 | Check-in date of the reservation |
checkin_hour |
| 0.625 | Check-in hour of the reservation |
checkout_date | YES | 44634 | Check-out date of the reservation |
checkout_hour |
| 0.479166667 | Check-out hour of the reservation |
booking_date |
| 43802 | The date the reservation was confirmed |
booking_hour |
| 0.449236111 | The time the reservation was confirmed |
code | YES | HMAPT4MCWH | Reservation code on the booking platform |
platform | YES | 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 | YES | 546546 | The property ID on Hospitable.com |
property_name | YES | 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 | YES | 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 (Available only for bookings confirmed after connecting accounts to Hospitable.com.) |
- |
| 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 | YES | 6 | The total number of guests |
guests_adults |
| 5 | The number of adult guests |
guests_children |
| 2 | The number of children |
guests_infants |
| 1 | The number of infants |
guests_pets | YES | 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 |
- |
| What an awesome place you have! | The review the guest left on Airbnb for their stay |
nights | YES | 6 | The total number of nights for the stay |
currency | YES | EUR | The payout currency |
base_amount | YES | 35.86 | The base fee amount |
cleaning_fee | YES | 35.86 | The cleaning fee amount |
linen_fee | YES |
|
|
subtotal | YES | 35.86 | The subtotal amount |
guest_service_fee | YES | 35.86 | The fee the guest pays to the platform for the booking |
resort_fee | YES |
|
|
management_fee | YES |
|
|
community_fee | YES |
|
|
pet_fee | YES |
|
|
extra_guest_fee | YES |
|
|
remitted_taxes | YES | 35.86 | The host tax amount |
total_price | YES | 35.86 | The total price for the guest |
security_deposit | YES | 35.86 | The security deposit amount |
pass_through_taxes | YES |
|
|
host_service_fee | YES | 35.86 | The fee the host pays to the platform for the booking |
payout | YES | 5176.04 | The payout for the reservation *Unavailable for Booking.com reservations |
adjusted_amount | YES | 40 | Airbnb Resolution Adjustments and Direct adhoc charges/refunds |
revenue | YES | 1100 | Sum of the payout + adjusted_amount |
KPI Report
identifier | title | value_type | tooltip |
total-revenue | Total Revenue | currency | Total revenue for all reservations including past and expected payouts, pass-through taxes, and fees |
reservations | Reservations | number | All reservations |
average-revenue-per-reservation | Rev. per Reservation | currency | Average revenue per reservation, including any pass-through taxes and fees |
average-nightly-rate | Avg. Nightly Rate | currency | Average nightly rate across all reservations |
average-per-available-night | RevPAN | currency | Average revenue per night across all nights available for booking |
available-nights | Occupancy: Available nights | percentage | The average occupancy rate of all nights booked divided by total nights available to be booked across all properties |
all-nights | Occupancy: All nights | percentage | The average occupancy rate of all nights booked divided by the total nights selected across all properties |
unavailable-nights | Unavailable nights | percentage | Number of nights that are unavailable for booking |
booked-nights | Booked nights | number | Number of nights with an accepted booking |
average-length-of-stay | Avg. Length Of Stay | number | Average length of stay across all bookings |
Updates
You can view the list of changes made to the columns used in comparison with our old/legacy Metrics exports in the table below.
Mapping of Columns Between Old and New Metrics Export for Reservations
Legacy Metrics | New Metrics | Shown by default |
uuid | uuid | YES |
thread_uuid | thread_uuid |
|
checkin_date | checkin_date | YES |
checkin_hour | checkin_hour |
|
checkout_date | checkout_date | YES |
checkout_hour | checkout_hour |
|
booking_date | booking_date |
|
booking_hour | booking_hour |
|
code | code | YES |
platform | platform | YES |
listing_id | listing_id |
|
listing_name | listing_name |
|
property_id | property_id | YES |
property_name | property_name | YES |
property_timezone | property_timezone |
|
host_id | host_id |
|
host_first_name | host_first_name |
|
host_last_name | host_last_name |
|
status | status | YES |
instant_booked | instant_booked |
|
initial_status | initial_status |
|
cancellation_policy | - |
|
guest_uuid | guest_uuid |
|
guest_first_name | guest_first_name |
|
guest_last_name | guest_last_name |
|
guest_locale | guest_locale |
|
guest_count | guest_count | YES |
guests_adults | guests_adults |
|
guests_children | guests_children |
|
guests_infants | guests_infants |
|
guests_pets | guests_pets | YES |
guest_email | guest_email |
|
guest_phone | guest_phone |
|
guest_city | guest_city |
|
guest_region | guest_region |
|
guest_country | guest_country |
|
review_id | review_id |
|
review_rating | review_rating |
|
review_comments | - |
|
nights | nights | YES |
currency | currency | YES |
base_amount | base_amount | YES |
cleaning_fee | cleaning_fee | YES |
- | linen_fee | YES |
subtotal_amount | subtotal | YES |
guest_fee | guest_service_fee | YES |
- | resort_fee | YES |
- | management_fee | YES |
- | community_fee | YES |
- | pet_fee | YES |
- | extra_guest_fee | YES |
tax_amount | remitted_taxes | YES |
total_price | total_price | YES |
security_price | security_deposit | YES |
- | pass_through_taxes | YES |
host_service_fee | host_service_fee | YES |
payout_amount | payout | YES |
| adjusted_amount | YES |
| revenue | YES |