All Collections
Metrics
Exports
What does the reservations & financials export include?
What does the reservations & financials export include?

A description of the Metrics Reservation Export and all that it includes

Alyssa Ward avatar
Written by Alyssa Ward
Updated over a week ago

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
(Available only for bookings confirmed after connecting accounts to Hospitable.com.)

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

Did this answer your question?