Account Balances Report

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

1. Navigate to Account Balances Report

Login to your myfrontdesk account and go to Reports tab
Go to Daily Activity Reports
Click on Account Balances

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

Why do I see a cancelled reservation with a positive balance in the account balances report?

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

Slack | Threads | Cloudbeds - Google Chrome

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: