Reports Overview

Created by Alex Savchuk, Modified on Fri, Mar 15 at 7:06 PM by Alex Savchuk

Account Balance Report
An Account Balance Report is displayed based on the search criteria you provide for the effective date selected.
This report can show balances for past reservations that have not been properly cleared or whose payment has not yet been received.
To view the balances on past reservations, keep the selection to Guest Ledger and narrow to Past if for past due balances. Future will show balances owed to guests if they have paid a deposit for a future stay.
On the other hand, the City Ledger shows the due balances for accounts.

Ledger Balance Report
The Ledger Balance Report exports all transactions, revenues and expenses of the day or a given period.
The ledger balance is the total amount of funds in an account at the beginning of a business day. The deposits and debits that take place throughout the day determine an account's available balance.
By running this report, properties can audit all transactions and compare to inventory, processing statements, and bank statements.
It is often used as an end of day report, as it can show a list of all Room Charges, Incidental Charges, Taxes collected and Payments (made and received).
It can be run in Summary (total for each selected ledger) or detail (lists every single line item).
This report also allows to be pulled based on each user and as shift report (specific hours of the day) which makes it ideal for a shift change report too.

Merchant Transaction Report
A report that shows the credit card transactions that have been successfully processed for a given day or period.
Based on the criteria selected, it can limit the results to one user or all users and can also be specific to one of the types of transaction – Authorization Only, Capture, Credit or Cancel.
Note: Capture is the actual charge and Credit is the refund.

Daily Flash Report
The Daily Flash report shows the summary of the entire day in addition to the MTD (Month to date) and YTD (Year to date) numbers for revenues and receipts.
In addition, it also shows the Property Statistics and Daily Summary.
Hence it summarizes the revenue and operational data for a property on a given date.

Room Forecast
The Room Forecast report shows the status of rooms that are booked for the time period you select. The report is available for the past, present, or future.
Room Forecast report also include Group Blocks which will be included in the total estimated revenue.  

Net Sales
The Net Sales Report allows you to view revenue and financial statistics for a date range, reported by 21 different dimensions, such as demographic, inventory, and marketing among others.
The important Formulae that are used in the calculation of this report are listed below:

  • Revenue per available room (RevPAR) = Total Room Revenue / Total Rooms (excluding out of order rooms).
  • Average Daily Rate (ADR) = Net Revenue / Net Bookings.
  • Average Stay = Bookings Nights / Bookings Reservations.

Advanced Deposit Report
The Advanced Deposits Report gives you a running total of all Deposits or payment taken on folios for bookings before the check in date. 
Therefore, for a payment to appear on this report, it must have been applied to the folio of a future booking.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article