Mews Reports and commonly used filters

 

ReportCase useSuggested filter
Reservation ReportTo see the guests that are arriving, departing, or staying over, any products they may have ordered, and any notes associated made for the reservation.
 
Start: Today’s date
End:  Tomorrow’s date
Note: Adjust exact time according to your property check-in/check-out settings.
Mode: Detailed
Filter: Arrival, Departure, Stayover
 
Reservation ReportTo see any important guests, special requests, and totals. Start and End: Adjust as necessary
Mode: detailed, Totals
Filter: Arrival, Departure, Stayover, Created
Group by: -, Rate, Reservation source, Segment
Reservation ReportTo see how many reservations were created, cancelled, inquired, and changed in a day, as well as filter by channel/origin.
 
Start and End: Adjust as necessary
Mode: Totals
Filter: Created, Cancelled, Inquired, Optional, Updated
Group by: -, Rate, Reservation source, Segment
Reservation ReportTo check that the system charged the cancellation fees where needed, and to see the reasons given for a reservation cancellation.

Start: Adjust as necessary. When running this report daily, select yesterday's date, 00:00h.
End: Adjust as necessary. When running this report daily, select yesterday's date, 23:59h.
Mode:  Detailed
Filter:  Canceled


To see the reasons for cancellation, select and apply the following filter:
Group by: Cancellation reason. 

Reservation ReportTo help housekeeping see the reservations that are arriving, staying over, and departing in a given time period, as well as any notes that were added to the reservation for special requests.
 
Start and End: Adjust as necessary
Mode: Detailed, Totals
Filter: Arrival, Stay over, Departure, overlapping
Group by: -, Space, Space Category
 
Reservation ReportTo see the reservations for the day.Start and End: Adjust as necessary
Mode: Detailed, Totals
Filter: Arrival, Stay over, Departure, Overlapping
Group by: -, Arrival date
Reservation ReportTo see the reservation pickup per day and find trends on the most popular booking periods and occupancy.
 
Start and End: Adjust as necessary
Mode: Totals
Filter: Created, Arrivals
Group by: -, Arrival Date, Rate, Reservation Source, Space Category, Segment
Rate: Filter through each for detailed daily pickup
 
Reservation ReportTo view a breakdown of travel agency performance in a given period of time.

Note: If commissions are set up for any travel agency contracts, it is possible to see the amount of owed commissions to each travel agency.
 
Start and End: Adjust as necessary
Mode: Totals
Group by: Travel agency.
 
Reservation ReportTo view the automatic charges linked to recently made reservations that the payment gateway may have rejected.Start and End: Adjust as necessary
Mode: Detailed.
Filter: Created.
Start: Needed date at 00:00
End: Needed date at 23:59
Group by: Automatic settlement.
Accounting ReportTo consolidate deposits in Mews.

Start and End: Adjust as necessary
Filters: Consumed
Group by: Bill assignee


Note: Deposits are under Transactions, and appear if the property has positive and negative deposits set up:

  • If 0: Guest paid a deposit and used it by staying.
  • If positive: Guest paid a deposit and has not used it.
  • If negative: Deposit is paid before the selected start date.
Accounting LedgerTo have a basic overview of the expected cashflow.Start and End: Adjust as necessary
Type: Guest Ledger
Group by: Customer, Consumption Date
 
Accounting LedgerTo keep track of unresolved bills and invoices (if receivable tracking is enabled) and to have an overview of what bills are to be actioned during the stay and upon departure.

 
Start and End: Adjust as necessary
Mode: Detailed, Grouped
Type: Guest Ledger
Group by: Customer, Accounting Category, Service

Note: Grouping by accounting category or service gives an overview of which sources of revenue are to be resolved or expected in the coming days/weeks/months.
Payment ReportTo reconcile the invoiced chargeback fees.
 

Start and End: Adjust as necessary
Mode: Settled
Status: Settled
Type: Chargeback


Note: The chargeback fee is invoiced in the month when the chargeback is settled in Mews, not the month it is created. 

Payment Report To have detailed data on the costs per transaction.
 
Start and End: Adjust as necessary
Mode: Created
Status: Charged, Settled are recommended
Type: All
Filter: Select needed payment method
Note: Bank transfers are included in the external payments
 
Payment Report To find the fees related to a specific month.
 

Start: The 1st of the needed month, at 00:00h.
End: The 1st  of the following month, at 00:00h.
Mode: Created
Status: Charged, Settled
Filters: Gateway CC payments, ApplePay, GooglePay, iDEAL (if enabled).


Note: Currently for Stripe it is possible to pull the interchange and scheme fees (IC++). This is not done automatically for Adyen Marketpay.

Posting JournalTo see which products have been cancelled and by whom.
 

Start and End: Adjust as necessary
Type: All
Status: Cancelled


Note: The selection of Gross or Net values depends on what information is needed.

Payment Card ReportTo reconcile the Payment Card Report with the monthly invoice charged by Mews for card protection and tokenization fees.
 
Start: The 1st of the needed month, at 00:00h.
End: The 1st of the following month, at 00:00h.
Options: Display payments cards
Origin: Gateway
Type: All
Format: All
Display cards: Cards charged for tokenization
Preauthorization: Make no selection
 
Mews Payments Balance ReportTo reconcile the Mews Payments Balance Report with Mews Payments case: view all settled payments for the selected time filter.
 
Start and End: Adjust as necessary
Mode: Created
Status: Settled
Mews Payments Balance ReportTo reconcile the Mews Payments Balance Report with Mews Payments case: view the transactions to be paid out in future, according to your payout schedule.
 

Start and End: Adjust as necessary
Mode: Created
Status: Unsettled


Note: ‘Settled’ column appears empty, showing only the transactions to be paid in the future.
 



For a complete view of all the reports available, check out the overview of Mews Reports and their uses. If you want to learn more about the individual filtering options, check out the individual reports for details. 
 

Was this article helpful?
00



Feedback