> ## 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.

# Open Balances Report

> 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 manual...

**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](https://manage.kwentra.com/reports/FrontDesk/Open%20Balances/)**

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.
