Running reservations reports for financial data

Enhance your reservations report by including financial details, such as each reservation's payment status and a breakdown of applied fees and taxes. Refer to the table below for explanations of the terms that can added as columns or filters.

If a column has a tooltip in the column name, hover over it to view the column total. The tooltip information is not visible on shared reports.

Base pricing and adjustments

Accommodation fare	The sum of the price per night for the dates of the reservation. The price per night will be the listing's base price, or a "nightly rate" if it is adjusted by a pricing tool.
Accommodation fare adjustment	The adjustment value that was made to the accommodation fare.
Airbnb Resolution Center	The Airbnb Resolution Center value, as displayed in the guest folio.
Balance due	The reservation amount remains to be paid.
Meal plan	The meal plan of the applied rate plan. The value will be null if a rate plan isn't applied.
Net accommodation fare	The accommodation fare following adjustments, such as after applying monthly or weekly discounts, deducting fees, or a manual modification.
Rate plan name	The applied rate plan's name.
Subtotal price	The reservation total price before applying taxes.
Total payout	The reservation's total amount = [e.g. accommodation fare+ additional fees+ taxes - channel commission] Learn more. For Airbnb: The total amount will reflect price updates by the Airbnb Resolution Center.

Cancellations

Canceled accommodation fare	The accommodation fare of the canceled reservation.
Canceled total payout	The total price of the canceled reservation (calculated based on the cancellation fee).
Cancellation fee	The cancellation fee that is applied to the reservation, as defined in the listing's cancellation policy or applied rate plan.
Cancellation policy	The cancellation policy applied to the reservation.

Commission - channel

Channel commission	The commission value that is charged by the booking channel for the reservation.
Channel commission inc tax	The commission that is charged by the booking channel for the reservation including tax.
Channel commission tax	The tax value that is applied to the channel commission.
Host channel fee	The channel commission value.

Commission - PMC

Commission	Your PMC commission of the reservation, calculated based on the commission formula
Commission formula	The formula used to calculate your PMC commission from the net income value. For example: Net income0.25/Net income1, etc.
Commission incl tax	Your PMC commission of the reservation, including tax.
Commission tax	The value of the PMC commission tax.
Commission tax percentage	The tax percentage that is applied to your PMC commission. This is a fixed percentage amount, not based on the commission calculation formula.
Net income	The value of the "Net income formula" for the reservation.
Net income formula	The revenue basis for calculating your PMC commission. The formula is calculated based on your revenue share formula settings. For example, the net income formula can be equal to the reservation total payout/ the accommodation fare including cleaning fee, etc.
Owner net revenue (accounting)	The output of the owner's revenue formula, as defined in a Business model. The Owner net revenue value syncs with the commission banner on the reservation summary page.
Owner revenue	The output of the owner's revenue formula, as defined in the commission calculation. The owner revenue value syncs with the "commission" banner on the reservation summary page.

Discounts and coupons

Coupon applied	Is a coupon applied? (Yes/No value)
Coupon code	The coupon's code (will appear in uppercase) The value will be null if a coupon isn't applied.
Coupon discount	The coupon's discount amount. The value will be null if a coupon isn't applied.
Coupon internal name	The applied coupon's internal name (as it appears in the coupon settings) The value will be null if a coupon isn't applied.
Coupon percentage	The coupon's percentage amount applied to the reservation. The value will be null if a coupon isn't applied.
Generic channel discount	An unspecified discount applied to the reservation by the booking channel.
Length of stay discount	The weekly or monthly discount amount applied to the reservation. The value will be null if a discount isn't applied.
Promotion name	The applied promotion's name. The value will be null if a promotion isn't applied.

Fees and taxes

[Additional fee name]	For example: Management fee, Damage waiver, Guest service fee, etc. The additional fee amount applied to the reservation. If this fee is not applied, its value will be null. If the fee originated in a booking channel and is not yet mapped to a fee type supported in Guesty, it will appear as "Other”.
Cleaning fee	The reservation's cleaning fee. When adding columns to the reservations report, there are two related options: Cleaning Fare - This is the basic cleaning fee configured at the listing level. Most users utilize this column as it displays the standard cleaning charge shown when creating a reservation. Cleaning Fee - This represents an additional cleaning fee that can be configured at either the listing or account level. This column often displays as "$0.00" when no additional cleaning fees are configured. For standard cleaning charge reporting, we recommend using the "Cleaning Fare" column in your reservation reports.
Expedia AFE	Expedia's cleaning fee and additional fees.
Payment processing fee	Booking.com payment processing fee.
[Tax name]	For example: City tax, State tax, VAT, Goods and Services tax, etc. The tax amount applied to the reservation. If this tax is not applied, its value will be null. If the tax originated in a booking channel and doesn't exist in Guesty, it will appear as "Other".
Total fees	The sum of basic fees only - cleaning fee and pet fee. Does not include additional fees. See details further below specifically about cleaning fee data.
Total taxes	The sum of all applied taxes.