I recently started using Mews and would like to better understand how the reporting feature works. For example, I need a report I can export periodically that shows in-house guests and deposit payments—specifically, which ones have been made and which are still pending. Is it possible to create something specific like that?
1 Like
Hello,
To show both in-house reservations and their outstanding payments, you can use the Guest Ledger:
Menu → Finance → Ledgers → Guest Ledger
I would recommend using the filters “Checked In” and “To Be Checked Out.”
To show a full list of in-house guests, I would recommend the Guest In-House Report.
We use the OLD Guest In-House Report with the following settings:
- Start date: Today 00:00
- End date: Tomorrow 00:00
- Status: Checked In
The reason we use the OLD report instead of the new one is that the new report does not show reservations that have checked in early. This is a serious concern in the event of an emergency, as it could result in guests currently in the hotel being omitted from the report.
You can also export a Reservation Report with the “Load Balances” option enabled. Depending on your filters, this report can show arriving, staying, confirmed reservations, and other reservation statuses.
Any report can also be scheduled for automatic export. See below guide: