Table of Content

Guest

Label

Variable Name

Description

Check Out Time

LEAD_CHECKOUT_TIME

The official time of check out as specified by the property manager.

Flight Number

LEAD_FLIGHT_NUMBER

Guest First Name

GUEST_FIRST_NAME

Guest First Name

Will Have Party

LEAD_WILL_HAVE_PARTY

Number of Children

LEAD_CHILDREN_COUNT

Number of Children

Created on

LEAD_CREATION_DATE

Date lead was created

Departure Time

LEAD_DEPARTURE_TIME

The time the guest intends to depart. May be specified on pre-arrival form.

Number of Infants

LEAD_INFANT_COUNT

Number of Infants

Guest Last Name

GUEST_LAST_NAME

Guest Last Name

Guest Secondary Email

GUEST_SECONDARY_EMAIL

Guest Secondary Email Address

Number of Pets

LEAD_PET_COUNT

Number of Pets

Check In Time

LEAD_CHECKIN_TIME

The official time of check in as specified by the property manager.

Lead UID

LEAD_UID

Lead Unique ID

Will Have Visit

LEAD_WILL_HAVE_VISIT

Guest Phone Number

GUEST_PHONE_NUMBER

Guest Phone Number

Number of Adults

LEAD_ADULT_COUNT

Number of Adults

External ID

LEAD_EXTERNAL_ID

Reason for Trip

LEAD_REASON_FOR_TRIP

Check Out Date

LEAD_CHECKOUT

The official check out date as specified by the property manager. Date will be formatted according to the agency's locale.

Lead Notes

LEAD_EXTRA_NOTES

Notes

LEAD_NOTES

Lead Notes

Arrival Date

LEAD_ARRIVAL_DATE

The date of the guest arrival as reported by the guest on the pre-arrival form. Date will be formatted according to the agency's locale.

Check In Date

LEAD_CHECKIN

The official check in date as specified by the property manager.

Departure Date

LEAD_DEPARTURE_DATE

The date the guest intends to depart. May be specified on pre-arrival form.

Arrival Time

LEAD_ARRIVAL_TIME

The time (not the date) of the guest arrival as reported by the guest on the pre-arrival form.

Guest Email

GUEST_EMAIL

Guest Email Address

Guest Cell Phone Number

GUEST_CELL_PHONE_NUMBER

Guest Cell Phone Number

Affiliate Name

LEAD_AFFILIATE

The name of the Hostfully Affiliate associated with this lead, such as HomeToGo, Rentals United, Nextpax or VacayMyWay.

Guest Notes

GUEST_NOTES

Extra Notes field from Guest Information page

Guest Birth Date

GUEST_BIRTH_DATE

Guest Date of Birth

Guest Tags

GUEST_TAGS

Tags assigned to a Guest on Guest Information page.

Tag

HAS_GUEST_TAG

Boolean: 0 or 1 if tag is associated with a guest.

Booking

Label

Variable Name

Description

Security Deposit

SECURITY_DEPOSIT_AMOUNT

Res#

ORDER_UID

Unique Order ID associated with a reservation

Rental Amount

ORDER_BASE_AMOUNT

Order #

ORDER_ID

Reservation Status

RESERVATION_STATUS

Payments Received

ORDER_PAID_TO_DATE

Payments recorded for this order

Security Deposit Returned

SECURITY_DEPOSIT_RETURNED

Nights

LEAD_NIGHTS

Nights in Period

NIGHTS_IN_PERIOD

When a booking extends beyond the time frame for a report, this variable captures the number of nights that were within the time frame of the report. For example, for reservation beginning June 25 and ending July 15, NIGHTS_IN_PERIOD for a June report would be 6, and for July would be 14. This is used to recognize revenue in the period it is earned.

Security Deposit

SECURITY_DEPOSIT_CHARGE

Source

LEAD_SOURCE

Currency Code

ORDER_CURRENCY_CODE

3 letter ISO currency code used for this booking.

Discount Amount

DISCOUNT_AMOUNT

Security Deposit Received

SECURITY_DEPOSIT_RECEIVED

{SECURITY_DEPOSIT_AMOUNT}

Basic Total

ORDER_TOTAL_BASIC

{ORDER_BASE_AMOUNT} + {EXTRA_GUEST_FEE_AMOUNT} + {ORDER_FEE} + {ORDER_FEE_TAX} + {CLEANING_FEE_TAX} + {TAXES_ON_RENT} - {DISCOUNT_AMOUNT}

Fraction Earned

FRACTION_EARNED

For reports representing earned (recognizable) revenue, FRACTION_EARNED represents the fraction of time a unit was rented during the reporting period. For example, with a 10 night rental from June 26 to July 6, the FRACTION_EARNED for June would be 4/10 (40%), and for July would be 6/10 (60%). This is used in calculations to determine recognized (earned) income.
{NIGHTS_IN_PERIOD} / {LEAD_NIGHTS}

Balance Due

ORDER_BALANCE

{ORDER_TOTAL} - {ORDER_PAID_TO_DATE}

Total (Earned)

ORDER_TOTAL_EARNED

{ORDER_TOTAL} * {FRACTION_EARNED}

Rent*

ORDER_BASE_AMOUNT_EARNED

{ORDER_BASE_AMOUNT} * {FRACTION_EARNED}

Total

ORDER_TOTAL

Fees

Label

Variable Name

Description

Cleaning Fee

ORDER_CLEANING_FEE

Extra Guest Fee

EXTRA_GUEST_FEE_AMOUNT

Miscellaneous Fees

ORDER_FEES_MISC

Fees associated with a booking, excluding AirBnb Service fees VRBO taxes.

Custom Fee

CUSTOM_FEE

Service Fees

ORDER_SERVICE_FEES

Total of all services (cleaning, firewood, etc) that are associated with a booking.

Fees

ORDER_FEE

{ORDER_FEES_MISC} + {ORDER_CLEANING_FEE} + {SECURITY_DEPOSIT_CHARGE} + {SECURITY_DEPOSIT_RETURNED} + {ORDER_SERVICE_FEES}

Property

Label

Variable Name

Description

Property Image Url

PROPERTY_PICTURE

URL to the main image for your property

Base Rate

PROPERTY_BASE_DAILY_RATE

Nightly Base Price, as defined on the Main settings tab of the Property edit page

Property Internal Name

PROPERTY_INTERNAL_NAME

Name of the property, which may be different from the public property name

Property UID

PROPERTY_UID

Unique property id.

Property Public Name

PROPERTY_NAME

Public Name of the property, as specified on the Property Description page.

Agency

Label

Variable Name

Description

Agency will collect and remit rental tax

COLLECT_AND_REMIT_TAXES

Boolean field, true if the agency is responsible for collecting and remitting taxes.

Agent

AGENT_NAME

Booking agent associated with this lead.

Agency Commission

AGENCY_COMMISSION_PERCENTAGE

Agency Commission expressed as fractional value, (30% would be represented as 0.30)
(100.0 - {OWNER_COMMISSION_RATE}) / 100.0

Due Agency*

DUE_PROPERTY_MANAGER_EARNED

For bookings that span multiple reporting periods (i.e. several months), the _EARNED variable will show the amount that is relevant to the current reporting period.Thus, a booking that is split equally between two months would show half of the earnings in a report for one month, and the other half in the report for the other month.
{DUE_PROPERTY_MANAGER} * {FRACTION_EARNED}

Due Agency

DUE_PROPERTY_MANAGER

The amount owed to the property manager. By default, the full amount is displayed for the period in which the booking starts, irrespective of the duration of the booking. If the amounts need to be split according to the reporting period, use the DUE_PROPERTY_MANAGER_EARNED field instead.
({ORDER_BASE_AMOUNT} + {EXTRA_GUEST_FEE_AMOUNT}) * {AGENCY_COMMISSION_PERCENTAGE} + {AGENCY_COLLECTED_TAXES}

Owner

Label

Variable Name

Description

Owner Email

OWNER_EMAIL

Owner First Name

OWNER_FIRST_NAME

Owner Commission Rate

OWNER_COMMISSION_RATE

OWNER_COMMISSION_RATE is the owner commission percentage, scaled up by 100. For a 20.5% commission, the OWNER_COMMISSION_RATE would be 20.5.

Owner Last Name

OWNER_LAST_NAME

Due Owner*

DUE_OWNER_EARNED

{DUE_OWNER} * {FRACTION_EARNED}

Owner Commission

OWNER_COMMISSION_PERCENTAGE

OWNER_COMMISSION_PERCENTAGE is a decimal representation of the percentage. For a 20.5% commission, the OWNER_COMMISSION_PERCENTAGE would be .205.
{OWNER_COMMISSION_RATE} / 100.0

Due Owner

DUE_OWNER

(({ORDER_BASE_AMOUNT} + {EXTRA_GUEST_FEE_AMOUNT}) * {OWNER_COMMISSION_PERCENTAGE}) + {OWNER_COLLECTED_TAXES}

Channel

Label

Variable Name

Description

Channel Commission

CHANNEL_COMMISSION

The Channel Commission that has been recorded in the database for an order's transaction. This includes the Airbnb Host Service Fee, Booking.com Commission and Homeaway Service Fee, aka, VRBO.

AirBnB Total

ORDER_TOTAL_AIRBNB_DIRECT

Channel Name

CHANNEL_NAME

VRBO Total

ORDER_TOTAL_VRBO_DIRECT

Automated Pricing Fee

AUTOMATED_PRICING_FEE

Hostfully's automated pricing partners may charge a fee on bookings for properties managed by their pricing tools. This field reports on that fee.

AirBnB Host Service Fee

AIRBNB_HOST_SERVICE_FEE

Hostfully Platform Fee

HOSTFULLY_PLATFORM_FEE

Payment Processing Fee

PAYMENT_PROCESSING_FEE

The payment processing fee associated with a Hostfully transaction. This includes Braintree, Stripe, Lynnbrook, and PayPal fees.

Taxes

Label

Variable Name

Description

Tax Rate

TAX_RATE

Cleaning Fee Tax Rate

CLEANING_FEE_TAX_RATE

Tax on Fees

ORDER_FEE_TAX

Tax Rate For Duration

TAX_RATE_FOR_DURATION

Rental Taxes

RENTAL_TAX

Taxes On Rent

TAXES_ON_RENT

({ORDER_BASE_AMOUNT} - {DISCOUNT_AMOUNT} + {EXTRA_GUEST_FEE_AMOUNT}) * ({TAX_RATE_FOR_DURATION}/100)

Owner Collected Tax

OWNER_COLLECTED_TAXES

{RENTAL_TAX} + {ORDER_FEE_TAX}

Agency Collected Tax

AGENCY_COLLECTED_TAXES

{RENTAL_TAX} + {ORDER_FEE_TAX}

Taxes

ORDER_TAXES_AMOUNT

{RENTAL_TAX} + {ORDER_FEE_TAX} + {CLEANING_FEE_TAX}

Cleaning Fee Tax

CLEANING_FEE_TAX

{ORDER_CLEANING_FEE} * ({CLEANING_FEE_TAX_RATE} / 100.0)

Report Specific

Label

Variable Name

Description

Guest

GUEST_INFO

Source

LEAD_SOURCE_INFO

Property

PROPERTY_PICTURE_ALT

Discount

DISCOUNT_INFO

Dons Formula

DONS_FORMULA

3 * 2 * {NIGHTS_IN_PERIOD}

Did this answer your question?