You can see reservations with outstanding balances using the Reservation report to assess which accounts still need to be settled.
To pull reservations with outstanding balances follow these steps:
- Access the Reservations report
- on the Dashboard, in the Reservations section, click on Reservation report
, or
- go to the Main menu
> Reservations > Reservation report.
- on the Dashboard, in the Reservations section, click on Reservation report
- Select the following filters (the rest of the filters are optional but can be used to further narrow your research, especially if you are anticipating a large number of reservation data):
-
- Service: Stay (or if you have multiple services, select the one you wish to research).
- Mode: Detailed.
- Filter: Arrival.
- Start: Any Date in the Future 00:00
- End: As far as possible in the Future 00:00
- Status: Confirmed
- Values: Net or Gross (depends on preference).
- Group by: Balance
Note: when the Reservation report is filtered by the "Group by: Balance" option, it pulls information from the Unpaid Items/Deposits section of the Billing Screen, so payments and balances might already be posted on the billing screen but on separate bills. In that case, move them to the same bill.
In the following screenshots you can find examples of negative, positive, and zero balances:
What does each balance group mean?
Positive: displays reservations with a balance and no payment present.
Negative: displays reservations with a payment and no balance present, or the balance is not sitting in the Unpaid Section with the payment.
Zero: displays a fully balanced reservation bill (both balance and payment sitting in the Unpaid section).
For more information on bill management, check the following guide: How to add, move, or remove items from open bills in Mews Operations
To view which payments failed, use The Reservation Report grouped by "Automatic Settlement".