Knowledge Base
Learn about top features of our solutions. Get help whenever you need.
Why data in reports do not add up
In this article, we will look at reports that should not be compared and for reasons why data in some reports do not add up.
1. The difference between the Exely PMS reports and the Reports on Bookings
Reports from Exely PMS located in the “Property management” > “Reports” and reports from the “Reports” menu section > “Bookings” page cannot be matched for the following reason:
Metric compared | Exely | Exely PMS |
Revenue | Calculated the revenue for every booking | Most of the reports calculate the revenue for each room night |
Bookings | Contains all the bookings ever confirmed in Exely; it is impossible to delete such a booking | Bookings made on distribution channels can be removed from the Front desk; deleted bookings will be taken into account in the Exely PMS report |
Let’s take a look at the example from the booking details page of any booking.
Date | Cost |
November 14, 2023 | 40 euros |
November 15, 2023 | 40 euros |
November 16, 2023 | 40 euros |
November 17, 2023 | 40 euros |
November 18, 2023 | 40 euros |
The total amount in the invoice: 200 euros
The report on bookings will display the total amount in the invoice, no matter the selected period. The reports in Exely PMS will display the cost of stay during the selected period.
For example, let’s look at the period from November 14 to November 16, 2023. In the Report on Bookings, the amount is 200 euros. However, in the “Revenue and occupancy” report, the amount might be 120 euros.
2. Statistical and general reports in the Exely PMS reports
In the “Property management” > “Reports”, there are two types of reports: general and statistical.
In general reports, the data are updated simultaneously.
If a booking was made or canceled, the general report will recalculate the data based on the just received information.
If you remove a room/ room type, the general reports will automatically recalculate all the metrics that take rooms into account. Thus, past data will no longer be valid.
The statistical reports update once per 24 hours at 1 am. New bookings, cancellations, and information on booking modifications will be displayed in statistical reports on the next day.
If you remove a room/ room type, the statistical reports will not recalculate the past data. Thus, the statistical reports always keep valid historical information.