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, which you can add as columns or filters to customize your report.
| Term | Details |
|---|---|
| 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. |
| Net accommodation fare | The accommodation fare following adjustments, such as after applying monthly or weekly discounts, deducting fees, or a manual modification. |
| Accommodation fare adjustment | The adjustment value that was made to the accommodation fare. |
| Balance due | The reservation amount remains to be paid. |
| Subtotal price | The reservation total price before applying taxes. |
| Channel commission | The commission value that is charged by the booking channel for the reservation. |
| Channel commission tax | The tax value that is applied to the channel commission. |
| Channel commission inc tax | The commission that is charged by the booking channel for the reservation including tax. |
| Total payout |
The reservation's total amount = [accommodation fare+ additional fees+ taxes - channel commission] For Airbnb: The total amount will reflect price updates by the Airbnb Resolution Center. |
| 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. |
| Net income | The value of the "Net income formula" for the reservation. |
| Commission formula | The formula used to calculate your PMC commission from the net income value. For example: Net income*0.25/Net income*1, etc. |
| Commission | Your PMC commission of the reservation, calculated based on the commission formula |
| 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. |
| Commission tax | The value of the PMC commission tax. |
| Commission incl tax | your PMC commission of the reservation, including tax. |
| 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. |
| 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. |
| Cancellation fee | The cancellation fee that is applied to the reservation, as defined in the listing's cancellation policy or applied rate plan. |
|
Additional fee For example: Management fee, Damage waiver, and Guest service fee. |
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 doesn't exist in Guesty, it will appear as "Other". |
|
Tax For example: City tax, State tax, VAT, and Goods and Services tax. |
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". |
| 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. |
| Generic channel discount | An unspecified discount applied to the reservation by the booking channel. |
| 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). |
| Total taxes | The sum of all applied taxes. |
| 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 code |
The coupon's code (will appear in uppercase) The value will be null if a coupon isn't applied. |
| Coupon applied | Is a coupon applied? (Yes/No value) |
| Coupon percentage |
The coupon's percentage amount applied to the reservation. 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. |
| Rate plan name | The applied rate plan's name. |
| Cancellation policy | The cancellation policy applied to the reservation. |
| Meal plan |
The meal plan of the applied rate plan. The value will be null if a rate plan isn't applied. |
| Promotion name |
The applied promotion's name. The value will be null if a promotion isn't applied. |
| Cleaning fee | The reservation's cleaning fee. |
| Expedia AFE | Expedia's cleaning fee and additional fees. |
| Host channel fee | The channel commission value. |
| Payment processing fee | Booking.com payment processing fee. |
| Airbnb Resolution Center | The Airbnb Resolution Center value, as displayed in the guest folio. |