Skip to main content
All CollectionsMetricsExports
Reservations & Financials Export
Reservations & Financials Export

A description of the Metrics Reservation Export and all that it includes, as well as a comparison to previous reports

Alyssa Ward avatar
Written by Alyssa Ward
Updated this week

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

  1. To view the Reservations & Financials export, go to Metrics. The Reservations & Financials view is the default.

  2. Select the data you wish to include by clicking on:

    1. The date:

    2. +Filter:

  3. Select the columns you wish to include (all options/definitions are in the table at the end of this article).

  4. (Optional) Click on Save to save the view. You can access this later by clicking on Views.

  5. 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

Did this answer your question?