The discrepancy between the Reservation and Accounting reports is due to some of the items on the reservations being consumed on a day other than the day of arrival.
These are the filters you should apply for both reports to match:
In the Reservation Report, set the following filters:
- Mode: Totals.
- Filter: Overlapping.
- Start: Occupancy start date and time, for example, 01/10/2021 and 15:00.
- End: Occupancy end date and time, for example, 01/11/2021 and 11:00.
- Options: Include space charges.
In the Accounting Report, set the following filters:
- Type: Consumed.
- Mode: Detailed.
- Start: calendar start date and time (as per the above example, 01/10/2021 and 00:00).
- End: calendar end date and time (as per the above example, 01/11/2021 and 00:00).
- Group by: Service.
- Service: Stay.
Click on View report and look for the Nights section to see the matching amount.
Note:
- If an item has been rebated but the original charge has not been canceled, that revenue will still be in both the Accounting and the Reservation report.
- If an item has been rebated but the original charge has been canceled, that revenue will not be in the Reservation report but will still show on the Accounting report as rebated.