In Mews Operations, you can match the Order items (Accounting) and Reservation reports to the Manager report for reconciliation and troubleshooting. This allows you to check consistency across reports, find configuration or data issues, and reconcile financials. You can match these reports at any time.
In this article you can learn about:
- Matching the Order items (Accounting) report with the Manager report
- Matching the Reservation report with the Manager report
Matching the Order items (Accounting) report with the Manager report
Step 1: Open the Manager report and assign filters
- In Mews Operations, go to the main menu
> Finance > Manager report.
- In the Manager report, fill in the following details:
- Mode: Click to select Month overview.
- Start: Click to select the start date you want the report for.
- End: Click to select the end date you want the report for.
- Group by: Click to select Accounting Category.
- Status: Click to select Confirmed.
- Values: Click to select the option you want to view, for example, Gross value, Net value or Tax value. Note: All options are visible in the Order items (Accounting) report.
- Click View report.
Step 2: Open the Order items (Accounting) report and assign filters
- In a new tab, open Mews Operations, go to the main menu
> Finance > Order items report (Accounting report).
- In the Order items report, fill in the following details:
- Type: Click to select Consumed.
- Mode: Click to select Detailed.
- Start: Click to select the exact start date you chose in the Manager report for Step 1 and 00:00 time. Note: This should match your business day setting.
- End: Click to select the day after the end date you chose in the Manager report for Step 1 and 00.00 time.
- Group by: Click to select Accounting category.
- Profile type: Click to select Company and Customer.
- Click View report.
Step 3: Compare the reports
Once you view both reports, compare the following:
- The monthly value in the Manager report
- The total value and the transactions in the Order items report
Since the Transactions are payments related to future stays, Mews does not include them in the Manager report.
Matching the Reservation report with the Manager report
Step 1: Open the Manager report and assign filters
- In Mews Operations, go to the main menu
> Finance > Manager report.
- In the Manager report, fill in the following details:
- Mode: Click to select Month overview.
- Start: Click to select the start date you want the report for.
- End: Click to select the end date you want the report for.
- Group by: Click to select Accounting category if you have only one service. You can also click Service or Accounting category classification to view according to these settings.
- Status: Click to select Confirmed.
- Values: Click to select the option you want to view, for example, Gross value, Net value or Tax value.
- Click View report.
Step 2: Open the Reservation report in a separate tab, and assign filters
- In a new tab, open Mews Operations, go to the main menu
> Reservations > Reservation report.
- In the Reservation report, fill in the following details:
- Start: Click to select the start date and time you want the report for. The start time must match your occupancy period.
- End: Click to select the end date and time you want the report for. The end time must match the end of your occupancy time for the last night of the manager report.
- Service: Click to select all services.
- Reservation type: Click to select Overlapping.
- Status: Click to select Confirmed, Checked in, and Checked out.
- Options: Click to select Include space charges if you want to compare room revenue.
- Values: Click to select the value you chose in the Manager report for Step 1.
- Click View report.
- On the top left of the report, click Show totals to view a summary of your reservation details, including total reservations and total amount. Note: You can also click Export > Export to Excel to view more details.
Step 3: Compare the reports
The number of guests on the Reservation report does not match with the number on the Manager report. The Reservation report counts room nights, while the manager report counts occupied spaces, which counts early check-ins and late check-outs as additional room nights.
You can learn more about the discrepancy between the occupancy rates in Why does the occupancy of the Manager report not match the Reservation report? help article.
Note:
- Nights free of charge are not an active accounting item and therefore are not included in the Order items (Accounting) report.
- If a night was already closed on the bill/ invoice but after that, the night was canceled, it creates a rebate for that night in the Additional expenses. However, if you cancel the rebate item in the reservation module the figures do not match.