Running reservations reports for financial data

The meal plan of the applied rate plan.

The value will be null if a rate plan isn't applied.

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.

The total amount the guest pays on the channel.  The calculation is Total payout (see definition above) + Total guest fee (received from channel)

Supported for Airbnb and VRBO only.

Note: This field is only populated for reservations created or updated after Feb 1, 2026.

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.

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.

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.

The coupon's code (will appear in uppercase)

The value will be null if a coupon isn't applied.

The coupon's discount amount.

The value will be null if a coupon isn't applied.

The applied coupon's internal name (as it appears in the coupon settings)

The value will be null if a coupon isn't applied.

The coupon's percentage amount applied to the reservation.

The value will be null if a coupon isn't applied.

The weekly or monthly discount amount applied to the reservation.

The value will be null if a discount isn't applied.

The applied promotion's name.

The value will be null if a promotion isn't applied.

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

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.

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

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.

The specific fee type calculated based on total payout. 

In addition to identifying reservations with the fee, options include total payout based fee "purchased", "purchased at", and "updated at".

See when the fee was purchased at confirmation vs added manually, and when the price was created or last updated.