This report will track the fluctuation of transactions (services & payments) in bookings to help the hotel monitor bookings with unpaid balances.

Report data is sorted by priority: Room number > Invoice number > Transaction page, in ascending order.

Note that:

• Only display bookings that have checked in and bookings assigned to a Dummy room with a Total balance in the Folio not equal to 0.
• Do not display bookings that have transactions but have not checked in.
• Navigation: Report menu(1) > Cashier report group(2) > Guest balance report(3)

1. Filter section

• From date: The start date of the date range for filtering data.
• To date: The end date of the date range for filtering data.
• Group reservation: Displays a list of booking groups with booking dates within the search date range.
• Company, Travel agent: Displays a list of companies and travel agents configured in Config > Company, Agency > Agency tab.

2. Data section

• Reservation Code: Displays the booking code for bookings that are checked in and have a balance not equal to 0 within the filter period. On click will direct the user to the Detail screen of the booking.
• Group Reservation Code: Displays the group booking code corresponding to the booking code in the Reservation code column.
• Room Number: Displays the room number of the booking corresponding to the Reservation code.
• Guest Name: Displays the name of main guest added to the reservation corresponding to the Reservation code.
• Arrival Date: Displays the check-in date of the reservation corresponding to the Reservation code.
• Departure Date: Displays the check-out date of the reservation corresponding to the Reservation code.
• Company/TravelAgent: Displays the company name of the booking corresponding to the Reservation code.
• Invoice No: Displays the master invoice number of the booking corresponding to the Reservation code.
• Balance Page: Displays the transaction pages of the booking corresponding to the Reservation code. For example, A B C
• Opening: Displays the balance of each transaction page and Total invoice (if the invoice has many pages) before the filter date.
• Debit: Displays the amount posted for each transaction page and Total invoice (if the invoice has many pages) during the filter period (debit). Value is from the Room fee and Service fields showing the total service amount posted (manual charge + system charge) to the folio of each transaction page before the From date entered in the Search filter.
• Credit: Displays the amount paid for each transaction page and Total invoice (if the invoice has many pages) during the filter period (credit). Value is from the Had paid field showing the total payment amount displayed in the Detail reservation > Folio tab for each transaction page before the From date entered in the Search filter.
• Balance: Displays the unpaid balance of each transaction page and Total invoice (if the invoice has many pages) during the filter period. Calculated as the sum of payments and master_invoice_items for each transaction page, equivalent to the sum of Debit + Credit + Opening during the filter period.

<