This report is a crucial report for daily activities and should probably be run 2 - 3 times per day. This will assure that:
- No one checks out with a balance due
- No Shows and Cancelations get adjusted
- No one checks in without payment or a form of payment on file
2. Applying Filters
In order to generate the report you may apply certain filters:
- Filter by reservation #
- Select a type of balance.
- Positive = they owe you money,
- Negative = they paid too much or have paid for future charges,
- Zero = they have paid and balance is zero - Future transactions allows you to only filter for reservations in the past and present while excluding future reservations
- Reservation status will allow you to see only those reservations with status selected
- Sources allows you to filter by reservation sources
- Check-In Date filter allows you to filter by arrival date
- Check Out filter allows to display bookings by departure date
- You can also send the report by email or export into PDF / XLS
- Click Apply to generate the report
Filtering by CHECKED OUT reservations
This list should be empty and remain empty: if there are people who have checked out and have not paid you should try to adjust off the revenue or get payment
3. How to Use Account Balances Report
After applying the filters you will be able to see the report generated with the following data:
- Reservation #
- Guest Name
- Guest Surname
- Date Booked
- Check-In Date
- Check Out Date
- Credit Card on File (if the payment has been done, you will see the type of credit card used for the charge)
- Reservation Status
- Reservation Source
- Reservation Grand Total (the total price of the booking)
- Amount Paid
-
Balance
Negative Balance is marked red= guest has paid too much or have paid for future charge
Balance Due/Positive Balance is marked black= guest owes you money - Notes Section
- Total on this page only and also the grand total of all pages
After generating the report, you can arrange the list by clicking arrow-icon in front of the tabs

You can also access each reservation by clicking the Reservation #

Frequently Asked Questions
Account balances report does not take into consideration the reservation status. It only compares amount of credits and debits of the reservation.
Usually, when reservation gets cancelled, it means that there was no payment done, and it still has balance due. Important things to consider:
- the Balance Due will not be zeroed out when the reservation is cancelled

- this is a known system behaviour, and in this case, when there was no fee applied, the balance does not need any adjustments
- please, do not apply any adjustments to the balance and use the filter to see the report without cancelled reservations:
![[Demo] Mountain Resort & SPA - Account Balances - Google Chrome](https://media.screensteps.com/image_assets/assets/004/426/575/original/5dd5cba0-9ad8-41a5-a7f2-a165540c896f.png)
If you need to apply a cancellation fee to the reservation this article will guide you on the process: Room Revenue. How to Add and Use Room Revenue