Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.kwentra.com/llms.txt

Use this file to discover all available pages before exploring further.

Report Business Value: The Open Balances Report is an income report that shows the remaining balance for each reservation on the system.
  • Shows the room charges separated from extras posted manually.
  • Shows the payment separately.
  • Shows the remaining balance for the guest whether in positive or negative signs.
  • Shows payments made for reservations in advance as a deposit.
This report is divided into two sections:
  • Guest Ledger Section: this section returns the open balances for in-house guests and opened paymasters.
  • Deposit Ledger Section: this section returns the open balances and the payments made on reservations in advance as a deposit for their reservations.
The total of both sections should match the numbers appearing on the below reports:
  • Trial Balance 2 Report “front office income report”
  • Balance Sheet Report “back office report”
How it works? Reports → FO → FrontDesk → Open Balances
  1. Select the Type of reservations you would like to see, whether Reservations, Paymasters or All.
  2. Select the Reservation State you desire, whether Expected Departures or All Reservations.
  3. Select the Date you would like to see the open balances on.
  4. It is optional to choose to Display contact information or no.
  5. Choose to Preview the report or the Download option you desire i.e. Excel “XLS / XLSX / ODS” or PDF.
Report Column Outcome:
  • Room: returns the guest’s room number.
  • Guest name: returns the guest’s name.
  • Arrival/Departure: returns the dates of the guest’s reservation.
  • Room Charge: returns the total of all room charges that has been added on guests’ bills through the night turn or posting of daily charges.
  • Extras: returns the total of all extras enjoyed by the guest, whether added manually or automatically posted by the system.
  • Payment: returns the total payments of the guest, whether paid in advance or at the middle or end of the stay.
  • Balance: returns the difference between the total charges minus the payment ” (Room Charge + Extras) - Payment ”.
  • No. Of persons: returns the number of guests included in the room.
  • Rate: returns the nightly rate of the reservation.
  • Email/Address/Mobile: returns the primary guest’s information from their profile to the report.
This report has a total row at the end to show the total for each column “Room Charge / Extras / Payment / Balance” so that you can easily compary totals with other reports.