Knowledge Base

In the “Booking balance” report, you can monitor payment statuses, and accounts receivable, and find out the amounts on balances of each booking for the running period.

Data in the report is updated every 24 hours, at 5 am.

How to generate the report

To generate the report, do the following:

1. In the “For the period” fields, select dates in both calendars to set the reporting time period.

2. Set the following filters:

• For the “Generate” filter, select what date the data should apply to: check-in date, check-out date, or booking date.

• For the “Reservation status” filter, select what booking should be taken into account: active or cancelled.

• For the “Guarantee method” filter, select what payment methods should be taken into account.

• For the “Customer company” and “Agent company” filters, select companies if you want to study bookings made by one or several companies.

• For the “Balance” filter, select what kind of balance you want to display in the report: positive, zero, or negative.

3. Click the “View” button in the top right corner to select what columns you want to display in the report.

4. Click the “Apply filter” button above the filters.

The report contains the following data:

• Booking number

• Booking date

• Rate — information on the rate plan for the booking

• Customer company — information on the customer company that made the booking

• Agent company — information on the agent company that made the booking

• Customer’s full name — information on the person who made a booking (for example, for a group)

• Check-in date

• Departure date

• Booking status — active or cancelled booking

• Number of rooms — the number of rooms in a booking

• Number of persons — the number of guests by occupancy types (single, double)

• Adults — the number of adults indicated in the booking

• Children — the number of children indicated in the booking

• ADR — average daily rate (that does not include extra services)

• Cost — the total amount of the booking

• Paid — information on the amounts confirmed on the booking account (that include prepayments made in the Booking Engine on the hotel website)

• Balance — current account balance

To download the report to your computer, click the “Export to XLS” button.