Calculate and Review the Commercial Margin by Accommodation and Reservation
With this report, you can see, by reservation and by accommodation, the commercial margin your agency generates. Knowing this helps you keep your accounting up to date, identify less profitable accommodations, and plan commercial actions wisely. It's straightforward: open the report, apply the filters you're interested in, and get the detailed data ready for export.
What is this report?
The "Commercial Margin by Accommodation and Reservation" report shows, for each reservation, the detailed amounts — rental without VAT, rental with discounts and supplements, extras, total reservation — and the payments made (to the owner and intermediary). Based on these amounts, the system presents the commercial margin attributed to your agency.
Benefits
Facilitates accounting reconciliation by owner and accommodation
Allows you to identify low or negative margins to make commercial decisions
Simplifies data export for tax or internal reports
Configuration
Access the menu "Reports" → "Management" → "Commercial Margin by Accommodation and Reservation."
The system will display a list by accommodation with the detailed amounts and the commercial margin.
You can customize the view with the available filters: owner, year, accommodation, reservation status, and settlement status.
Export the results in Excel, CSV, or PDF, or print them for your internal statistics.
What fields will you see in the report?
Rental without VAT
Rental with discounts and supplements
Total extras
Total reservation
Payment to the owner
Payment to the intermediary
Agency's commercial margin
How to interpret the margin
The commercial margin appears alongside the detailed amounts. In practice, review the amounts paid to the owner and intermediary against the total reservation to understand what is generating that margin. According to the usual configuration, the margin is obtained by comparing the total reservation with the payments made to the owner and intermediary.
Step by Step — Common Use
Access "Reports" → "Management" → "Commercial Margin by Accommodation and Reservation"
Apply filter by year and by owner if you need a specific analysis
Sort by accommodation or by margin to quickly locate deviations
Open a specific reservation to see the exact breakdown of amounts
Export in Excel/CSV for reconciliation or in PDF to share with the team
Notes
All data can be exported in Excel/CSV/PDF format or printed for your internal statistics.
Frequently Asked Questions
What exactly does this report show? It shows, by reservation and by accommodation, the detailed amounts (rental without VAT, discounts, supplements, extras), payments to the owner and intermediary, and the corresponding commercial margin.
Can I filter by owner or by year? Yes. The report allows filtering by owner, year, accommodation, reservation status, and settlement status.
Can I export the data for accounting? Yes. The data can be exported in Excel, CSV, or PDF, or printed for internal statistics.
Does the margin include taxes? Check the columns "rental without VAT" and "rental with discounts and supplements" to understand how the amounts are displayed. The tax treatment depends on how the rates are configured in each case.
What should I do if I detect a negative or unexpected margin? Verify the discounts applied, the payments to the owner and intermediary, and check if there are any cancellations or refunds that have not been considered.