Reports
Ace Hotel System
Reports
We have many reports in the PMS and they all get their data in different ways, sometimes you will wonder why the figures of one report won’t match to another.
This is usually because some reports are taking data from the bookings and some from daily figures.
We do recommend for you to open each report and play around with it to see for yourself what information each one does give.
All of our reports can be exported to an excel sheet
Payment Report
Description: This is a report to show you all payment transactions over a period of time
Filters:
Date: You can search between different dates
Time: You can search also for time
Created or Payment Date: You can search for payment date which can be altered by the user or created date which is the time when the payment was added.
Data: It is based on payment transactions which you can find inside each booking in the payment tab
Daily Checkout Report
Description: This is a report to show you all reservations that is checking out ir is checked out today.
Filters:
Date: You can search between different dates.
Data: It is based on all reservation that have a departure date on a chosen date.
Booking Report
Description: This report will show you all bookings depending on your search criteria, it also has a summary section at the top to give you some insights.
Filters:
Arrival: Will search for bookings matching arrival dates
Departure: Will search for bookings matching departure dates
Booking Date: Will search for bookings matching when booking was created
Staying: Will match bookings to any day in the booking
Booking Source: You can filter by source
Show Cancelled: By default we hide cancelled, you can select to show
Due Greater Than 0: You can filter to show bookings who have payments due
Data: This report is based on bookings
Cancellation Report
Description: This is a report to show you all reservations that have been cancelled on a specific date or a period,
Filters:
Date: You can search between different dates
Data: It is based on cancelled reservations
Housekeeping Report
Description: This is a simple report to print for the housekeeper for a single day, It will show what rooms are departing, arriving and staying.
Filter: Date only
Data: It is based on booking data
Channel Report
Description: This report will find all the bookings in the requested date range and summarise them in order of sales channel. You can click on each channel to see the bookings associated with the data.
Filters:
Arrival: Will search for bookings matching arrival dates
Departure: Will search for bookings matching departure dates
Booking Date: Will search for bookings matching when booking was created
Data: It is based on booking data
Extra Report
Description: This report will search for all extras that match the search criteria and show in a summarised way.
Data: This report is based on extras which is found in each booking in extras tab.
Note: Extras may have dates outside the room stay dates, You should be careful when using dates for extras so it makes sense.
Meal Report
Description: This is a Extra Report customised only to show meals, on each extra there is a checkbox to say if the extra is a meal or not.
This report is useful to have breakfast list or see all meals on a particular day
Occupancy Report
Description: This report is designed to give you insights for your property in terms of key statistics such as Average Revenue, Occupancy etc.
Data: This report is based on daily figures (Not Booking Data) daily figures is based on each individual date and not the whole booking.
Example: You have 10 night booking for Dec 1st for $100 per night
Booking Report with arrival filter for Dec 1st to Dec 1st will show the booking data and Revenue of $1000
Occupancy Report with date of 1st Dec to 1st Dec will show data on one night only so $100
Financial Report
Description: Similar to occupancy report in some ways but provides more details on financial data on a daily basis
Data: This report is based on daily figures (Not Booking Data) daily figures is based on each individual date and not the whole booking.
Example: You have 10 night booking for Dec 1st for $100 per night
Booking Report with arrival filter for Dec 1st to Dec 1st will show the booking data and Revenue of $1000
Financial Report with date of 1st Dec to 1st Dec will show data on one night only so $100
Debtor Report
Description: This report will search all historical bookings and show you a list of all bookings that have amount owing
Data: Based on booking data
In House Report
Description: This is a report for one day to show you all checked in bookings and some key statistics. This is useful to see who is in-house currently
Data: Based on checked in bookings
Reservation Report
Description: This report will summarise key data for a period of time sich as how many arrivals, departures or people are in house. This is useful information for housekeeping or F&B departments.
Data: Bookings and Daily
Manager Report
Description: A daily snapshot of property performance and you can see your performance vs the same day/month/year as last year.
Data: This report is based on daily figures (Not Booking Data) daily figures is based on each individual date and not the whole booking.
Example: You have 10 night booking for Dec 1st for $100 per night
Booking Report with arrival filter for Dec 1st to Dec 1st will show the booking data and Revenue of $1000
Manager Report with date of 1st Dec will show data on one night only so $100
Folio Report
Description: This report will get you all folios, invoices or receipts for a given date range. If you have an accounting system connected to The Booking Factory you will also see what receipt have been successfully sent to the accounting system and which haven’t along with the error code.
Data: Based on Folio dates, folio is found inside each booking in folio tab
Immigration Report
Description: This report will show you key data of all guests staying on the given date, this is useful if the local police required a report or information on guests.
Data: It is based on guest data of each booking. Guest details are found in guest tab of each booking
Country Report
Description: This report gives you insights about where your guests are from and is sorted by their country (if known).
Data: Booking data is used for this report
Statistical Report
This report is designed for the Icelandic market.
Deposit Report
Description: This report shows all future bookings that have payments, this is to help easily see how much you have collected but yet to provide the service.
Data: Based on payment data and future bookings
Rate Plan Report
Description: This report gives you details of what rate plans have been popular and their statistics, it is similar to the channel report but sorted around rate plans.
Data: Booking Data
Accounting Report
Description: This report gives you details on a day level of all income, payment, taxes and extras that have been sold, paid, unpaid etc.
It splits each item down to accounting categories.
Data: Booking data and payment data
End Of Day Report
Description: This report gives you details on products sold, net rate, taxes and total of each product.
You can select period so if you want to get details for an entire month.
The reports also show payment types of period selected and gives the detail list of the reservations.
This report only populates data from closed folios (when folios are turned into receipt)
Data: Booking data and payment data